Table: dbo.Receivable_Transaction_Fee
Columns
NameTypeConstraintsDescription
receivable_transaction_detail_KEYint (4)NOT NULLPrimary key and foreign key of the parent record.
billable_item_KEYint (4)A foreign key to the billiable item used in the calculation of the transaction fee.
is_waivedbit (1)NOT NULLIf true, the fee does not contribute to the invoice total; it is waived and the client is not charged for it.
is_fee_on_invoicebit (1)NOT NULLIf true, this fee is being or has been invoiced. Being invoiced means the fee in included on a receivable transaction (invoice).
include_detail_on_invoicebit (1)NOT NULLFlag to denote that detail information should be displayed on the invoice.
is_exemptbit (1)NOT NULLFlag to denote if the client is exempt from this fee.
Primary key
NameColumnsDescription
PK_Receivable_Transaction_Fee$receivable_transaction_detail_KEYreceivable_transaction_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Receivable_Transaction_Fee__Billable_Item__billable_item_KEYbillable_item_KEYBillable_Item (billable_item_KEY)
FK_Receivable_Transaction_Fee__Receivable_Transaction_Detail__receivable_transaction_detail_KEYreceivable_transaction_detail_KEYReceivable_Transaction_Detail (receivable_transaction_detail_KEY)

Schema diagram