Table: dbo.Ach_Company_Batch_Header_Record
Columns
NameTypeConstraintsDescription
service_class_codenvarchar (6)NOT NULLService class code - see ACH specifications
company_namenvarchar (100)NOT NULLCompany name - see ACH specification
company_descretionary_datanvarchar (100)NOT NULLData entered by user - see ACH specification
company_idnvarchar (20)NOT NULLCompany EIN - see ACH specification
standard_entry_class_codenvarchar (6)NOT NULLStandard entry class code - see ACH specification
company_entry_descriptionnvarchar (20)NOT NULLEntry description - depending on transactions - see ACH specification
company_descriptive_datenvarchar (12)NOT NULLUser entered descriptive date - see ACH specification
effective_entry_datenvarchar (12)NOT NULLEffective date for entries in YYMMDD format - see ACH specification
originating_dfi_identificationnvarchar (20)NOT NULLOriginating dfi identification - see ACH specification
batch_numbernvarchar (12)NOT NULLBatch number - see ACH specification
client_bank_account_bank_namenvarchar (100)NOT NULLBank name of client account - used in processing ui not in ACH file creation
client_bank_account_numbernvarchar (34)NOT NULLAccount number of client bank account - used in processing ui not in ACH creation
client_bank_routing_numbernvarchar (30)NOT NULLRouting number of client account bank - used in processing ui not in ACH file creation
client_bank_account_typenvarchar (22)NOT NULLClient bank account type. Used in processing UI.
client_idnvarchar (22)NOT NULLClient ID - used in processing ui not in ACH file creation
is_balancedbit (1)NOT NULLIndicates balanced file requested at processing time. - Used for record reprocessing and reversal.
exclude_control_recordbit (1)NOT NULLIndicates company batch control record exclusion was requested at processing time. - Used for record reprocessing and reversal.
foreign_exchange_indicatornvarchar (4)NOT NULLForeign exchange indicator.
iso_destination_country_codenvarchar (4)NOT NULLISO country code for destination DFI.
iso_originating_currency_codenvarchar (6)NOT NULLISO currency code for originating transaction.
iso_destination_currency_codenvarchar (6)NOT NULLISO currency code for destination transaction.
ach_file_header_record_KEYint (4)NOT NULL
ach_company_batch_header_record_KEYint (4)NOT NULL
display_company_entry_descriptionnvarchar (20)NOT NULLHolds the value to be displayed on the ACH file - required to support for CT ERSUI tax payment files.
ach_company_batch_header_record_guiduniqueidentifier (16)NOT NULLA unique identifer for each ACH company batch header record row.
create_separate_ccd_batch_for_ppd_balancing_entrybit (1)NOT NULLWhen true we will create a separate CCD batch for the balancing entry of a PPD transaction. Only ever true for balanced PPD transactions.
Primary key
NameColumnsDescription
PK_Ach_Company_Batch_Header_Recordach_company_batch_header_record_KEY
Unique constraints
NameColumnsDescription
UK_Ach_Company_Batch_Header_Record$ach_company_batch_header_record_guidach_company_batch_header_record_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Ach_Company_Batch_Header_Record__Ach_File_Header_Record__ach_file_header_record_KEYach_file_header_record_KEYAch_File_Header_Record (ach_file_header_record_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ach_Entry_Detail_Record__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEYach_company_batch_header_record_KEYAch_Entry_Detail_Record
FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEYach_company_batch_header_record_KEYDirect_Deposit_Bank_Transaction_Allocation

Schema diagram