DebtorFeesHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorFeesHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
DebtorFeesSeq int 4 √ null
FeeCode varchar 15 √ null
AutoTuitionCode varchar 5 √ null
Campus varchar 3 √ null
YearLevel smallint 2 √ null
SiblingCount tinyint 1 √ null
FamilyPosition tinyint 1 √ null
Boarder varchar 3 √ null
TuitionVariationType varchar 3 √ null
Description varchar 80 √ null
Amount money 21,4 √ null
NormallyCreditFlag bit 1 √ null
DiscountPercentage decimal 9,4 √ null
DiscountBasedOn varchar 5 √ null
DiscountAltersNettBaseFlag bit 1 √ null
InstalmentFlag bit 1 √ null
AutoTuitionPeriodNumber smallint 2 √ null
AutoTuitionPeriodIncludeFlag bit 1 √ null
DescriptionStyle varchar 3 √ null
AllowZeroAmountFlag bit 1 √ null
FeeUnits decimal 11,4 √ null
FeeRate money 21,4 √ null
PrintStudentNameFlag bit 1 √ null
BoarderType varchar 1 √ null
FeeCategoryCode varchar 15 √ null
YearLevelTo int 4 √ null
ActiveFlag bit 1 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorFeesHistory Primary key Asc DebtorFeesHistorySeq
AK_DebtorFeesHistory_DebtorFeesSeq Performance Asc DebtorFeesSeq
AK_DebtorFeesHistory_FeeCode Performance Asc FeeCode