Table: dbo.Ach_File_Header_Record
Columns
Name | Type | Constraints | Description
immediate_destination | nvarchar (20) | NOT NULL | RTN of immediate destination dfi - see ACH specification
immediate_origin | nvarchar (20) | NOT NULL | RTN of immediate origin dfi - see ACH specification
file_creation_date | nvarchar (12) | NOT NULL | File creation date in YYMMDD format - see ACH specification
file_creation_time | nvarchar (8) | NOT NULL | File creation time in HHMM format - see ACH specification
file_id_modifier | nvarchar (2) | NOT NULL | File ID modifier - user entered - see ACH specification
immediate_destination_name | nvarchar (100) | NOT NULL | Name of immediate destination dfi - see ACH specification
immediate_origin_name | nvarchar (100) | NOT NULL | Name of immediate origin dfi - see ACH specification
reference_code | nvarchar (16) | NOT NULL | Reference code entered by user - see ACH specification
physical_file_name | nvarchar (510) | NOT NULL | Name of physical ACH file - no path information
intercept_reference_code | nvarchar (50) | NOT NULL | Assigned reference code for Intercept processed ACH files - empty for standard ACH processed files.
ach_file_header_record_KEY | int (4) | NOT NULL |
origin__accounting_application_KEY | int (4) |  | The application that was running when the journal entry was created.
staff_KEY | int (4) |  | Holds key to staff that created this file in client access - if null the file was created by firm.
ach_file_header_record_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each ACH file header record row.
nat_pay_client_account_number | nvarchar (16) | NOT NULL | A NatPay client account number, used only if this File Header Record is associated with NatPay

Primary key
Name | Columns | Description
PK_Ach_File_Header_Record | ach_file_header_record_KEY |
Unique constraints
Name | Columns | Description
UK_Ach_File_Header_Record$ach_file_header_record_guid | ach_file_header_record_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ach_File_Header_Record__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Ach_File_Header_Record__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Processed_Direct_Deposit_Fileheader__Ach_File_Header_Record__ach_file_header_record_KEY | ach_file_header_record_KEY | Processed_Direct_Deposit_Fileheader |
FK_Ach_Company_Batch_Header_Record__Ach_File_Header_Record__ach_file_header_record_KEY | ach_file_header_record_KEY | Ach_Company_Batch_Header_Record |
FK_Bank_Reconciliation_Statement_Import__Ach_File_Header_Record__ach_file_header_record_KEY | ach_file_header_record_KEY | Bank_Reconciliation_Statement_Import |