DebtorStudentConcessionsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorStudentConcessionsHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
DebtorStudentConcessionsSeq int 4 √ null
ID int 4 √ null
FeeCode varchar 15 √ null
AutoTuitionCode varchar 5 √ null
EffectiveFromDate datetime 16,3 √ null
EffectiveToDate datetime 16,3 √ null
OverrideAmountFlag bit 1 √ null
OverrideAmount money 21,4 √ null
OverridePercentage decimal 9,4 √ null
Comment varchar 2147483647 √ null
ConcessionTypeCode varchar 15 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorStudentConcessionsHistory Primary key Asc DebtorStudentConcessionsHistorySeq
AK_DebtorStudentConcessionsHistory_DebtorStudentConcessionsSeq Performance Asc DebtorStudentConcessionsSeq
AK_DebtorStudentConcessionsHistory_ID Performance Asc ID