DebtorTransactionsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorTransactionsHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
TransactionSeq int 4 √ null
DebtorID int 4 √ null
DebtorStudentID int 4 √ null
StudentID int 4 √ null
PostingNumber int 4 √ null
PostingSource varchar 10 √ null
InstalmentSeq int 4 √ null
InstalmentsRemaining smallint 2 √ null
StatementNumber int 4 √ null
ReceiptNumber int 4 √ null
FeeCode varchar 15 √ null
TransactionDate datetime 16,3 √ null
TransactionAmount money 21,4 √ null
TransactionDescription varchar 80 √ null
AllocatedAmount money 21,4 √ null
FeeUnits decimal 11,4 √ null
FeeRate money 21,4 √ null
SaleInvoiceNumber int 4 √ null
CreditorPostingNumber int 4 √ null
CreditorTransactionSeq int 4 √ null
CreditorGLJournalSeq int 4 √ null
StudentCourseChargesSeq int 4 √ null
ObjectLoansSeqOverdueCharge int 4 √ null
ObjectLoansSeqOverdueReversal int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorTransactionsHistory Primary key Asc DebtorTransactionsHistorySeq
AK_DebtorTransactionsHistory_DebtorID Performance Asc/Asc DebtorID + DebtorStudentID
AK_DebtorTransactionsHistory_TransactionSeq Performance Asc TransactionSeq