DebtorStatementBalances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorID int 4 ((0))
Debtors.DebtorID FK_DebtorStatementBalances_Debtors R
DebtorStudentID int 4 ((0))
Debtors.DebtorStudentID FK_DebtorStatementBalances_Debtors R
StatementNumber int 4 ((0))
DebtorStatementControl.StatementNumber FK_DebtorStatementBalances_DebtorStatementControl R
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_DebtorStmntBal Primary key Asc/Asc/Asc DebtorID + DebtorStudentID + StatementNumber

Relationships

Close relationships within degrees of separation