DebtorStatementBalancesArch


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorID int 4 null
DebtorStudentID int 4 null
StatementNumber int 4 null
StatementBalance money 21,4 ((0))
InstalmentsTotal money 21,4 ((0))
InstalmentsNotYetCharged money 21,4 ((0))
FullYearDiscountAmount money 21,4 ((0))
FullYearDiscountPayment money 21,4 ((0))
DiscountAmount money 21,4 ((0))
DiscountPayment money 21,4 ((0))
Contribution1Amount money 21,4 ((0))
Contribution2Amount money 21,4 ((0))
DebtorReference varchar 200 √ null
OpeningBalance money 21,4 √ null
CurrentBalance money 21,4 √ null
OverduePeriod1 money 21,4 √ null
OverduePeriod2 money 21,4 √ null
OverduePeriod3 money 21,4 √ null
OverduePeriod4 money 21,4 √ null
OverduePeriod5 money 21,4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorStatementBalancesArch Primary key Asc/Asc/Asc DebtorID + DebtorStudentID + StatementNumber