DebtorBalances


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorID int 4 ((0))
DebtorStudentID int 4 ((0))
BalanceDate datetime 16,3 (getdate())
Balance money 21,4 ((0))
UnallocatedBalance money 21,4 ((0))
Overdue money 21,4 ((0))
PostingNumber int 4 ((0))
PostingNumberOverdue int 4 ((0))
StatementGroup varchar 10 √ null
Opening money 21,4 √ null
Aged1 money 21,4 √ null
Aged2 money 21,4 √ null
Aged3 money 21,4 √ null
Aged4 money 21,4 √ null
Aged5 money 21,4 √ null
Owing money 21,4 √ null
InstalmentsNotCharged money 21,4 √ null
Prepaid money 21,4 √ null
CurrentNotYetNotified money 21,4 √ null
CurrentNotified money 21,4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorBalances Primary key Asc/Asc/Asc DebtorID + DebtorStudentID + BalanceDate
AK_DebtorBalances_BalanceDate Performance Asc BalanceDate
AK_DebtorBalances_PostingNumber Performance Asc PostingNumber