Table: dbo.Journal_Entry_Distribution
Table for journal entry distributions
Columns
NameTypeConstraintsDescription
journal_entry_distribution_KEYint (4)NOT NULLPrimary key
journal_entry_KEYint (4)NOT NULLForeign key to the parent journal entry
gl_account_KEYint (4)Foreign key to the general ledger account
descriptionnvarchar (240)NOT NULLDescription of the distribution, left blank if the account description is to be used
amountdecimal (9, 2)NOT NULLDistribution amount
sequence_numberint (4)NOT NULLSequence number that determines the order within the journal entry distributions
workpaper_referencenvarchar (50)NOT NULLRelated workpaper reference for this journal entry distribution
is_subsidiary_client_summarybit (1)NOT NULLThis 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_KEYint (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
NameColumnsDescription
PK_Journal_Entry_Distributionjournal_entry_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Journal_Entry_Distribution__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry (journal_entry_KEY)
FK_Journal_Entry_Distribution__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distribution_KEYjournal_entry_distribution_KEYTax_Reconciliation_N_Journal_Entry_Distribution
FK_Bank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distributiojournal_entry_distribution_KEYBank_Transaction_Accounting_Source_Override_Journal_Entry_Distribution

Schema diagram