Table: dbo.Receivable_Transaction_Detail
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Receivable_Transaction_Detail | receivable_transaction_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Receivable_Transaction_Detail__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Receivable_Transaction_Detail__GL_Account__receivable__gl_account_KEY | receivable__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Receivable_Transaction_Detail__Receivable_Detail_Type__receivable_detail_type_KEY | receivable_detail_type_KEY | Receivable_Detail_Type (receivable_detail_type_KEY) |
FK_Receivable_Transaction_Detail__Receivable_Transaction__receivable_transaction_KEY | receivable_transaction_KEY | Receivable_Transaction (receivable_transaction_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__sales_tax__receivable_transaction_detail_KEY | sales_tax__receivable_transaction_detail_KEY | Receivable_Transaction_Sales_Tax_Taxable_Item |
FK_Receivable_Transaction_Sales_Tax_Taxable_Item__Receivable_Transaction_Detail__taxable_item__receivable_transaction_detail_KEY | taxable_item__receivable_transaction_detail_KEY | Receivable_Transaction_Sales_Tax_Taxable_Item |
FK_Print_Receivable_Transaction_Detail_Selection__Receivable_Transaction_Detail__receivable_transaction_detail_KEY | receivable_transaction_detail_KEY | Print_Receivable_Transaction_Detail_Selection |
FK_Receivable_Transaction_Fee_Detail__Receivable_Transaction_Detail__receivable_transaction_detail_KEY | receivable_transaction_detail_KEY | Receivable_Transaction_Fee_Detail |
FK_Receivable_Transaction_Fee__Receivable_Transaction_Detail__receivable_transaction_detail_KEY | receivable_transaction_detail_KEY | Receivable_Transaction_Fee |