Table: dbo.Ach_Company_Batch_Header_Record
Columns
Name | Type | Constraints | Description
service_class_code | nvarchar (6) | NOT NULL | Service class code - see ACH specifications
company_name | nvarchar (100) | NOT NULL | Company name - see ACH specification
company_descretionary_data | nvarchar (100) | NOT NULL | Data entered by user - see ACH specification
company_id | nvarchar (20) | NOT NULL | Company EIN - see ACH specification
standard_entry_class_code | nvarchar (6) | NOT NULL | Standard entry class code - see ACH specification
company_entry_description | nvarchar (20) | NOT NULL | Entry description - depending on transactions - see ACH specification
company_descriptive_date | nvarchar (12) | NOT NULL | User entered descriptive date - see ACH specification
effective_entry_date | nvarchar (12) | NOT NULL | Effective date for entries in YYMMDD format - see ACH specification
originating_dfi_identification | nvarchar (20) | NOT NULL | Originating dfi identification - see ACH specification
batch_number | nvarchar (12) | NOT NULL | Batch number - see ACH specification
client_bank_account_bank_name | nvarchar (100) | NOT NULL | Bank name of client account - used in processing ui not in ACH file creation
client_bank_account_number | nvarchar (34) | NOT NULL | Account number of client bank account - used in processing ui not in ACH creation
client_bank_routing_number | nvarchar (30) | NOT NULL | Routing number of client account bank - used in processing ui not in ACH file creation
client_bank_account_type | nvarchar (22) | NOT NULL | Client bank account type. Used in processing UI.
client_id | nvarchar (22) | NOT NULL | Client ID - used in processing ui not in ACH file creation
is_balanced | bit (1) | NOT NULL | Indicates balanced file requested at processing time. - Used for record reprocessing and reversal.
exclude_control_record | bit (1) | NOT NULL | Indicates company batch control record exclusion was requested at processing time. - Used for record reprocessing and reversal.
foreign_exchange_indicator | nvarchar (4) | NOT NULL | Foreign exchange indicator.
iso_destination_country_code | nvarchar (4) | NOT NULL | ISO country code for destination DFI.
iso_originating_currency_code | nvarchar (6) | NOT NULL | ISO currency code for originating transaction.
iso_destination_currency_code | nvarchar (6) | NOT NULL | ISO currency code for destination transaction.
ach_file_header_record_KEY | int (4) | NOT NULL |
ach_company_batch_header_record_KEY | int (4) | NOT NULL |
display_company_entry_description | nvarchar (20) | NOT NULL | Holds the value to be displayed on the ACH file - required to support for CT ERSUI tax payment files.
ach_company_batch_header_record_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each ACH company batch header record row.
create_separate_ccd_batch_for_ppd_balancing_entry | bit (1) | NOT NULL | When 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
Name | Columns | Description
PK_Ach_Company_Batch_Header_Record | ach_company_batch_header_record_KEY |
Unique constraints
Name | Columns | Description
UK_Ach_Company_Batch_Header_Record$ach_company_batch_header_record_guid | ach_company_batch_header_record_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ach_Company_Batch_Header_Record__Ach_File_Header_Record__ach_file_header_record_KEY | ach_file_header_record_KEY | Ach_File_Header_Record (ach_file_header_record_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ach_Entry_Detail_Record__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY | ach_company_batch_header_record_KEY | Ach_Entry_Detail_Record |
FK_Direct_Deposit_Bank_Transaction_Allocation__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY | ach_company_batch_header_record_KEY | Direct_Deposit_Bank_Transaction_Allocation |