Table: dbo.Tax_Reconciliation_N_Journal_Entry_Distribution
This table links journal entry distributons of Tax Journal Entries to their tax reconciliation schedule line
Columns
NameTypeConstraintsDescription
journal_entry_distribution_KEYint (4)NOT NULLPrimary key
tax_code_KEYint (4)NOT NULLa foreign key to Tax_Code table
tax_code_unitint (4)The tax code unit associated with the journal entry distribution, It should be either null or a int between 1 to 99
is_income_statement_tax_codebit (1)NOT NULLA indicator if the journal entry distribution is for an incoming statement tax code
exclude_from_tax_exportbit (1)NOT NULLA indicator if the journal entry distribution is exclude from tax export
Primary key
NameColumnsDescription
PK_Tax_Reconciliation_N_Journal_Entry_Distribution$journal_entry_distribution_KEYjournal_entry_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distribution_KEYjournal_entry_distribution_KEYJournal_Entry_Distribution (journal_entry_distribution_KEY)
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Tax_Code__tax_code_KEYtax_code_KEYTax_Code (tax_code_KEY)

Schema diagram