Table: dbo.Journal_Entry_Distribution
Table for journal entry distributions
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Journal_Entry_Distribution | journal_entry_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Journal_Entry_Distribution__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry (journal_entry_KEY) |
FK_Journal_Entry_Distribution__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distribution_KEY | journal_entry_distribution_KEY | Tax_Reconciliation_N_Journal_Entry_Distribution |
FK_Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distributio | journal_entry_distribution_KEY | Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution |