Table: dbo.Receivable_Transaction_Fee_Detail
Columns
Name | Type | Constraints | Description
receivable_transaction_fee_detail_KEY | int (4) | NOT NULL | Primary key.
receivable_transaction_detail_KEY | int (4) | NOT NULL | Foreign key to parent.
rate | decimal (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).
amount | decimal (9, 2) | NOT NULL | The amount the detail record is contributing to the fee's total.
amount_override | decimal (9, 2) |  | An override of the original often calculated amount. If NULL, then the fee detail record's amount hasn't been overridden.
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the fee details.
item_value | decimal (9, 2) | NOT NULL | Either a count of billable items or dollar value related to the fee
receivable_transaction_fee_detail_type_KEY | int (4) |  | Foreign key to indicate what kind of billable item the detail represents.
item_count | int (4) | NOT NULL | Count of billable items. Used for reporting purposes.

Primary key
Name | Columns | Description
PK_Receivable_Transaction_Fee_Detail | receivable_transaction_fee_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Fee_Detail_Type__receivable_transaction_fee_detail_type_KEY | receivable_transaction_fee_detail_type_KEY | Receivable_Transaction_Fee_Detail_Type (receivable_transaction_fee_detail_type_KEY) |
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Detail__receivable_transaction_detail_KEY | receivable_transaction_detail_KEY | Receivable_Transaction_Detail (receivable_transaction_detail_KEY) |