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. |