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