vDebtorPrepaidSchoolFeesCurrentYear


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorID int 4 null
DebtorSubLedgerCode varchar 15 null
DebtorSubLedgerCodeDisplay varchar 15 null
DebtorMailName varchar 100 null
DebtorSurname varchar 30 null
DebtorGiven1 varchar 20 null
DebtorGiven2 varchar 50 null
TransactionDateCharge datetime 16,3 null
TransactionAmountCharge money 21,4 null
TransactionFeeCodeCharge varchar 15 null
TransactionDateReceipt datetime 16,3 null
TransactionAmountReceipt money 21,4 null
DebtorCashPrepaidCode varchar 15 null
DebtorCashPrepaidCodeSortOrder int 4 null
DebtorCashPrepaidDescription varchar 50 null
DebtorFeeCategorySynergyMeaning varchar 30 null
DebtorFeeSynergyMeaningCategory varchar 3 null

Table contained 0 rows