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