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 |