DebtorTransactionsArchive


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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 150 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
CreatedDate datetime 16,3 √ null
CreatedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
ObjectLoansSeqOverdueCharge int 4 √ null
ObjectLoansSeqOverdueReversal int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorTransactionsArchive Primary key Asc TransactionSeq
AK_DebtorTransactionsArchive_DebtorID Performance Asc/Asc DebtorID + DebtorStudentID
AK_DebtorTransactionsArchive_TransactionSeq_InstalmentSeq_includes Performance Asc/Asc TransactionSeq + InstalmentSeq