DebtorTransactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TransactionSeq int identity 4 √ null
DebtorTransactionGeneralLedger.TransactionSeq FK_DebtorTransactionGeneralLedger_DebtorTransactions R
DebtorTransactionsXref.TransactionSeqReceipt FK_DebtorTransactionsXref_DebtorTransactionsTo R
DebtorID int 4 null
Debtors.DebtorID FK_DebtorTransactions_Debtors R
DebtorStudentID int 4 null
Debtors.DebtorStudentID FK_DebtorTransactions_Debtors R
StudentID int 4 ((0))
PostingNumber int 4 ((0))
GeneralLedgerPostingControl.PostingNumber FK_DebtorTransactions_GeneralLedgerPostingControl R
PostingSource varchar 10 ('')
InstalmentSeq int 4 ((0))
InstalmentsRemaining smallint 2 ((0))
StatementNumber int 4 ((0))
ReceiptNumber int 4 ((0))
FeeCode varchar 15 ('')
DebtorFees.FeeCode FK_DebtorTransactions_DebtorFees R
TransactionDate datetime 16,3 √ (getdate())
TransactionAmount money 21,4 ((0))
TransactionDescription varchar 80 ('')
AllocatedAmount money 21,4 ((0))
FeeUnits decimal 11,4 ((0))
FeeRate money 21,4 ((0))
SaleInvoiceNumber int 4 ((0))
CreditorPostingNumber int 4 √ null
GeneralLedgerPostingControl.PostingNumber FK_DebtorTransactions_GeneralLedgerPostingControl_CreditorPostingNumber R
CreditorTransactionSeq int 4 √ null
CreditorTransactions.TransactionSeq FK_DebtorTransactions_CreditorTransactions_CreditorTransactionSeq R
CreditorGLJournalSeq int 4 √ null
GeneralLedgerJournals.GLJournalSeq FK_DebtorTransactions_GeneralLedgerJournals_CreditorGLJournalSeq R
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__DebtorTransactio__174363E2 Primary key Asc TransactionSeq
AK_DebtorTransactions_IDStuID Performance Asc/Asc DebtorID + DebtorStudentID
AK_DebtorTransactions_InstalmentSeq Performance Asc InstalmentSeq
AK_DebtorTransactions_InvoiceNumber Performance Asc SaleInvoiceNumber
AK_DebtorTransactions_PostNum Performance Asc PostingNumber
AK_DebtorTransactions_RcptNo Performance Asc ReceiptNumber
AK_DebtorTransactions_StudentCourseChargesSeq Performance Asc StudentCourseChargesSeq

Relationships

Close relationships within degrees of separation