Table for journal entry distributions |
journal_entry_distribution_KEY | int (4) | NOT NULL | Primary key |
journal_entry_KEY | int (4) | NOT NULL | Foreign key to the parent journal entry |
gl_account_KEY | int (4) | | Foreign key to the general ledger account |
description | nvarchar (240) | NOT NULL | Description of the distribution, left blank if the account description is to be used |
amount | decimal (9, 2) | NOT NULL | Distribution amount |
sequence_number | int (4) | NOT NULL | Sequence number that determines the order within the journal entry distributions |
workpaper_reference | nvarchar (50) | NOT NULL | Related workpaper reference for this journal entry distribution |
is_subsidiary_client_summary | bit (1) | NOT NULL | This column tracks when a master client's distribution was created from summarized subsidiary client transactions during a consolidation (value of 1) or was simply entered via data entry for the master client (value of 0). This column is not used (will be 0) for client's that are not master (consolidating) clients. |
workpaper_KEY | int (4) | | Column that specifies the referenced workpaper key in the workpaper_reference column of the same table. ["BR"] Since, there can be workpapers with the same reference value in different binders.We use the key value to eliminate the redundancy. |