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
Name | Type | Constraints | Description
journal_entry_distribution_KEY | int (4) | NOT NULL | Primary key
tax_code_KEY | int (4) | NOT NULL | a foreign key to Tax_Code table
tax_code_unit | int (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_code | bit (1) | NOT NULL | A indicator if the journal entry distribution is for an incoming statement tax code
exclude_from_tax_export | bit (1) | NOT NULL | A indicator if the journal entry distribution is exclude from tax export

Primary key
Name | Columns | Description
PK_Tax_Reconciliation_N_Journal_Entry_Distribution$journal_entry_distribution_KEY | journal_entry_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Journal_Entry_Distribution__journal_entry_distribution_KEY | journal_entry_distribution_KEY | Journal_Entry_Distribution (journal_entry_distribution_KEY) |
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Tax_Code__tax_code_KEY | tax_code_KEY | Tax_Code (tax_code_KEY) |