wkDebtorTransactionAllocations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkDebtorTransactionAllocationsSeq int identity 4 √ null
UserName varchar 50 √ null
SourceTransactionSeq int 4 √ null
TransactionSeq int 4 √ null
PayAmount money 21,4 √ null
HoldPayAmount money 21,4 √ null
TransactionXRefSeq int 4 √ null
CreatedDate datetime 16,3 √ (getdate())
TransactionAmount money 21,4 √ null
AllocatedAmount money 21,4 √ null
TransactionDate datetime 16,3 √ null
PostingSource varchar 10 √ null
PostingNumber int 4 √ null
FeeCode varchar 15 √ null
FeeDescription varchar 100 √ null
TransactionDescription varchar 100 √ null
StudentID int 4 √ null
DebtorCashPrepaidCode varchar 15 √ null
SourceDebtorCashPrepaidCode varchar 15 √ null
DebtorCashPrepaidSortOrder smallint 2 √ null
GLCode varchar 15 √ null
GLCodeSameFlag bit 1 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_wkDebtorTransactionAllocations Primary key Asc wkDebtorTransactionAllocationsSeq