Table: dbo.Export_Journal_Entry_To_Csa_Information
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key for this table
payroll__export_journal_entry_to_csa_format_KEYint (4)NOT NULLExport the payroll journal entries in detail or summary format.
payroll_check_referencenvarchar (18)NOT NULLThe default reference number used for payroll check journal entries.
include_payoll_check_journal_entries_in_exportbit (1)NOT NULLInclude payroll check journal entries in export?
include_vendor_check_journal_entries_in_exportbit (1)NOT NULLInclude vendor check journal entries in export?
include_impound_liability_journal_entries_in_exportbit (1)NOT NULLInclude impounded liability journal entries in export?
impound_tax_agent_liability_referencenvarchar (18)NOT NULLThe default reference number used for impounded tax agent liability entries.
impound_payroll_agent_liability_referencenvarchar (18)NOT NULLThe default reference number used for impounded payroll agent liability entries.
impound_firm_vendor_liability_referencenvarchar (18)NOT NULLThe default reference number used for impounded firm vendor liability entries.
impound__export_journal_entry_to_csa_format_KEYint (4)NOT NULLExport the impounded liabilities in detail or summary format.
export_destination_KEYint (4)NOT NULLthe destination of the data we are exporting: CSA, quickbooks, or something else. Can also be set to None
include_bank_account_reconciliation_adjustmentsbit (1)NOT NULLWhen this is true, then we want to include bank reconciliation adjustments with the exported transactions.
Primary key
NameColumnsDescription
PK_Export_Journal_Entry_To_Csa_Information$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Export_Journal_Entry_To_Csa_Information__Client__client_KEYclient_KEYClient (client_KEY)
FK_Export_Journal_Entry_To_Csa_Information__Export_Destination__export_destination_KEYexport_destination_KEYExport_Destination (export_destination_KEY)
FK_Export_Journal_Entry_To_Csa_Information__Export_Journal_Entry_To_Csa_Format__impound__export_journal_entry_to_csa_format_KEYimpound__export_journal_entry_to_csa_format_KEYExport_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_KEYpayroll__export_journal_entry_to_csa_format_KEYExport_Journal_Entry_To_Csa_Format (export_journal_entry_to_csa_format_KEY)

Schema diagram