vDebtorChargesXRefReceipts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorID int 4 null
DebtorStudentID int 4 null
DebtorSubLedgerCode varchar 15 √ null
DebtorSubLedgerCodeDisplay varchar 15 √ null
DebtorAddressFull varchar 200 √ null
DebtorNameInternal varchar 100 null
DebtorNameExternal varchar 100 null
DebtorLegalFullName varchar 150 null
DebtorPreferredFormal varchar 20 null
DebtorSurname varchar 30 null
DebtorGiven1 varchar 20 null
DebtorGiven2 varchar 50 null
DebtorMailName varchar 100 √ null
DebtorMailSalutation varchar 100 √ null
TransactionSeq int 4 null
PostingNumber int 4 null
PostingDate datetime 16,3 √ null
PostingSource varchar 10 null
TransactionDate datetime 16,3 √ null
TransactionDescription varchar 80 null
FeeCode varchar 15 null
Description varchar 80 √ null
ReceiptNumber int 4 null
FeeCodeOriginal varchar 15 null
TransactionSeqOriginal int 4 null
TransactionDateOriginal datetime 16,3 √ null
TransactionAmountOriginal money 21,4 null
TransactionAllocatedAmountOriginal money 21,4 null
TransactionXrefAmount money 21,4 √ null
StudentID int 4 null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentSurname varchar 30 √ null
TransactionAmount money 21,4 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views