Table: dbo.Ach_File_Header_Record
Columns
NameTypeConstraintsDescription
immediate_destinationnvarchar (20)NOT NULLRTN of immediate destination dfi - see ACH specification
immediate_originnvarchar (20)NOT NULLRTN of immediate origin dfi - see ACH specification
file_creation_datenvarchar (12)NOT NULLFile creation date in YYMMDD format - see ACH specification
file_creation_timenvarchar (8)NOT NULLFile creation time in HHMM format - see ACH specification
file_id_modifiernvarchar (2)NOT NULLFile ID modifier - user entered - see ACH specification
immediate_destination_namenvarchar (100)NOT NULLName of immediate destination dfi - see ACH specification
immediate_origin_namenvarchar (100)NOT NULLName of immediate origin dfi - see ACH specification
reference_codenvarchar (16)NOT NULLReference code entered by user - see ACH specification
physical_file_namenvarchar (510)NOT NULLName of physical ACH file - no path information
intercept_reference_codenvarchar (50)NOT NULLAssigned reference code for Intercept processed ACH files - empty for standard ACH processed files.
ach_file_header_record_KEYint (4)NOT NULL
origin__accounting_application_KEYint (4)The application that was running when the journal entry was created.
staff_KEYint (4)Holds key to staff that created this file in client access - if null the file was created by firm.
ach_file_header_record_guiduniqueidentifier (16)NOT NULLA unique identifer for each ACH file header record row.
nat_pay_client_account_numbernvarchar (16)NOT NULLA NatPay client account number, used only if this File Header Record is associated with NatPay
Primary key
NameColumnsDescription
PK_Ach_File_Header_Recordach_file_header_record_KEY
Unique constraints
NameColumnsDescription
UK_Ach_File_Header_Record$ach_file_header_record_guidach_file_header_record_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Ach_File_Header_Record__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Ach_File_Header_Record__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Processed_Direct_Deposit_Fileheader__Ach_File_Header_Record__ach_file_header_record_KEYach_file_header_record_KEYProcessed_Direct_Deposit_Fileheader
FK_Ach_Company_Batch_Header_Record__Ach_File_Header_Record__ach_file_header_record_KEYach_file_header_record_KEYAch_Company_Batch_Header_Record
FK_Bank_Reconciliation_Statement_Import__Ach_File_Header_Record__ach_file_header_record_KEYach_file_header_record_KEYBank_Reconciliation_Statement_Import

Schema diagram