Table: dbo.Receivable_Transaction_Fee_Detail
Columns
NameTypeConstraintsDescription
receivable_transaction_fee_detail_KEYint (4)NOT NULLPrimary key.
receivable_transaction_detail_KEYint (4)NOT NULLForeign key to parent.
ratedecimal (9, 6)Rate, either in dollars or percentage, used in the calculation of the billing item detail. Field precision and scale allow us to support both standard dollar amounts (17,2) and taxing authority rates (7,6).
amountdecimal (9, 2)NOT NULLThe amount the detail record is contributing to the fee's total.
amount_overridedecimal (9, 2)An override of the original often calculated amount. If NULL, then the fee detail record's amount hasn't been overridden.
sequence_numberint (4)NOT NULLSequence number that determines the order within the fee details.
item_valuedecimal (9, 2)NOT NULLEither a count of billable items or dollar value related to the fee
receivable_transaction_fee_detail_type_KEYint (4)Foreign key to indicate what kind of billable item the detail represents.
item_countint (4)NOT NULLCount of billable items. Used for reporting purposes.
Primary key
NameColumnsDescription
PK_Receivable_Transaction_Fee_Detailreceivable_transaction_fee_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Fee_Detail_Type__receivable_transaction_fee_detail_type_KEYreceivable_transaction_fee_detail_type_KEYReceivable_Transaction_Fee_Detail_Type (receivable_transaction_fee_detail_type_KEY)
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYReceivable_Transaction_Detail (receivable_transaction_detail_KEY)

Schema diagram