Table: dbo.Receivable_Transaction_Detail
Columns
NameTypeConstraintsDescription
receivable_transaction_detail_KEYint (4)NOT NULLPrimary key
receivable_transaction_KEYint (4)NOT NULLForeign key to parent
receivable_detail_type_KEYint (4)NOT NULLDefines which kind of detail item the record is - a fee, a discount, a sales tax, etc.
descriptionnvarchar (500)A user-friendly description of the detail record displayed in the UI and on reports.
amountdecimal (9, 2)NOT NULLThe amount the detail record is contributing to the receivable's total.
amount_overridedecimal (9, 2)An override of the original often calculated amount. If NULL, then the detail record's amount hasn't been overridden.
sequence_numberint (4)NOT NULLSequence number that determines the order within the receivable transaction details.
gl_account_KEYint (4)NOT NULLThe GL account number pointed to by this foreign key is the revenue (income) account this receivable detail applies to.
receivable__gl_account_KEYint (4)NOT NULLThe GL account number pointed to by this foreign key is the receivable account that offsets this receivable details revenue.
Primary key
NameColumnsDescription
PK_Receivable_Transaction_Detailreceivable_transaction_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction_Detail__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Receivable_Transaction_Detail__GL_Account__receivable__gl_account_KEYreceivable__gl_account_KEYGL_Account (gl_account_KEY)
FK_Receivable_Transaction_Detail__Receivable_Detail_Type__receivable_detail_type_KEYreceivable_detail_type_KEYReceivable_Detail_Type (receivable_detail_type_KEY)
FK_Receivable_Transaction_Detail__Receivable_Transaction__receivable_transaction_KEYreceivable_transaction_KEYReceivable_Transaction (receivable_transaction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__sales_tax__receivable_transaction_detail_KEYsales_tax__receivable_transaction_detail_KEYReceivable_Transaction_Sales_Tax_Taxable_Item
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__taxable_item__receivable_transaction_detail_KEYtaxable_item__receivable_transaction_detail_KEYReceivable_Transaction_Sales_Tax_Taxable_Item
FK_Print_Receivable_Transaction_Detail_Selection__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYPrint_Receivable_Transaction_Detail_Selection
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYReceivable_Transaction_Fee_Detail
FK_Receivable_Transaction_Fee__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYReceivable_Transaction_Fee

Schema diagram