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) |