receivable_transaction_detail_KEY | int (4) | NOT NULL | Primary key |
receivable_transaction_KEY | int (4) | NOT NULL | Foreign key to parent |
receivable_detail_type_KEY | int (4) | NOT NULL | Defines which kind of detail item the record is - a fee, a discount, a sales tax, etc. |
description | nvarchar (500) | | A user-friendly description of the detail record displayed in the UI and on reports. |
amount | decimal (9, 2) | NOT NULL | The amount the detail record is contributing to the receivable's total. |
amount_override | decimal (9, 2) | | An override of the original often calculated amount. If NULL, then the detail record's amount hasn't been overridden. |
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the receivable transaction details. |
gl_account_KEY | int (4) | NOT NULL | The GL account number pointed to by this foreign key is the revenue (income) account this receivable detail applies to. |
receivable__gl_account_KEY | int (4) | NOT NULL | The GL account number pointed to by this foreign key is the receivable account that offsets this receivable details revenue. |