wkDebtorStatementTransactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkDebtorStatementTransactionsSeq int identity 4 √ null
UserIdentifier varchar 128 null
StatementNumber int 4 null
DebtorID int 4 null
DebtorStudentID int 4 null
DebtorIDFull varchar 15 √ null
DebtorName varchar 120 √ null
DebtorSurname varchar 30 √ null
DebtorPreferred varchar 15 √ null
DebtorAddressFull varchar 602 √ null
DebtorReference varchar 200 √ null
OpeningBalance money 21,4 √ null
Owing 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
TransactionSeq int 4 √ null
TransactionDate datetime 16,3 √ null
TransactionDescription varchar 80 √ null
TransactionDescriptionFull varchar 240 √ null
TransactionAmount money 21,4 √ null
FeeCode varchar 15 √ null
FeeDescription varchar 80 √ null
InstalmentSeq int 4 √ null
PostingNumber int 4 √ null
StudentID int 4 √ null
SaleInvoiceNumber int 4 √ null
TaxAmount money 21,4 √ null
UpdateTransactionDescriptionFlag bit 1 √ null
AllocatedAmount money 21,4 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
CreatedDate datetime 16,3 √ (getdate())
CreatedBy varchar 128 √ null

Table contained -1 rows

Indexes

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