vDebtorTransactionsProjectedInstalments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransactionSeq int 4 √ null
InstalmentSeq int 4 null
DebtorID int 4 null
DebtorStudentID int 4 null
DebtorIDFull varchar 15 √ null
DebtorMailName varchar 100 √ null
DebtorSurname varchar 30 null
DebtorStatementGroup varchar 10 null
DebtorStatementGroupDescription varchar 30 null
DebtorSubLedgerCode varchar 15 √ null
StudentID int 4 null
StudentPreferred varchar 20 null
PostingNumber int 4 null
PostingSource varchar 10 null
StatementNumber int 4 null
StatementDate datetime 16,3 √ null
StatementDueDate datetime 16,3 √ null
ReceiptNumber int 4 null
FeeCode varchar 15 null
FeeDescription varchar 80 null
FeeCategoryCode varchar 15 null
FeeCategoryDescription varchar 30 null
TransactionDate datetime 16,3 √ null
TransactionAmount money 21,4 √ null
TransactionDescription varchar 80 null
GLCode varchar 15 √ null
GLDescription varchar 50 null
GLSubAllocationCode varchar 15 √ null
GLCostCentreCode varchar 15 null
GLCOACode varchar 10 null
GLDivisionCode varchar 15 null
GLSubAllocationDescription varchar 50 null
TaxCode varchar 5 √ null
GLAmount money 21,4 √ null
TaxAmount money 21,4 √ null
InstalmentDate datetime 16,3 √ null
InstalmentTotalAmount money 21,4 √ null
InstalmentTotalCharged money 21,4 √ null
InstalmentNextAmount money 21,4 √ null
InstalmentPostingNumber int 4 √ null
InstalmentsStoppedFlag bit 1 √ null
InstalmentFrequency varchar 15 null
InstalmentFrequencyDescription varchar 50 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views