Table: dbo.Export_Journal_Entry_To_Csa_Information
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary key for this table
payroll__export_journal_entry_to_csa_format_KEY | int (4) | NOT NULL | Export the payroll journal entries in detail or summary format.
payroll_check_reference | nvarchar (18) | NOT NULL | The default reference number used for payroll check journal entries.
include_payoll_check_journal_entries_in_export | bit (1) | NOT NULL | Include payroll check journal entries in export?
include_vendor_check_journal_entries_in_export | bit (1) | NOT NULL | Include vendor check journal entries in export?
include_impound_liability_journal_entries_in_export | bit (1) | NOT NULL | Include impounded liability journal entries in export?
impound_tax_agent_liability_reference | nvarchar (18) | NOT NULL | The default reference number used for impounded tax agent liability entries.
impound_payroll_agent_liability_reference | nvarchar (18) | NOT NULL | The default reference number used for impounded payroll agent liability entries.
impound_firm_vendor_liability_reference | nvarchar (18) | NOT NULL | The default reference number used for impounded firm vendor liability entries.
impound__export_journal_entry_to_csa_format_KEY | int (4) | NOT NULL | Export the impounded liabilities in detail or summary format.
export_destination_KEY | int (4) | NOT NULL | the destination of the data we are exporting: CSA, quickbooks, or something else. Can also be set to None
include_bank_account_reconciliation_adjustments | bit (1) | NOT NULL | When this is true, then we want to include bank reconciliation adjustments with the exported transactions.

Primary key
Name | Columns | Description
PK_Export_Journal_Entry_To_Csa_Information$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Export_Journal_Entry_To_Csa_Information__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Export_Journal_Entry_To_Csa_Information__Export_Destination__export_destination_KEY | export_destination_KEY | Export_Destination (export_destination_KEY) |
FK_Export_Journal_Entry_To_Csa_Information__Export_Journal_Entry_To_Csa_Format__impound__export_journal_entry_to_csa_format_KEY | impound__export_journal_entry_to_csa_format_KEY | Export_Journal_Entry_To_Csa_Format (export_journal_entry_to_csa_format_KEY) |
FK_Export_Journal_Entry_To_Csa_Information__Export_Journal_Entry_To_Csa_Format__payroll__export_journal_entry_to_csa_format_KEY | payroll__export_journal_entry_to_csa_format_KEY | Export_Journal_Entry_To_Csa_Format (export_journal_entry_to_csa_format_KEY) |