Table: dbo.Processed_Direct_Deposit_Fileheader
Table to hold file header data for processed ACH files.
Columns
NameTypeConstraintsDescription
processed_direct_deposit_fileheader_KEYint (4)NOT NULLPrimary key
sequence_numberint (4)NOT NULLOrder of header lines.
fileheader_linenvarchar (130)NOT NULLLine of text to be used for the file header.
ach_file_header_record_KEYint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Processed_Direct_Deposit_Fileheaderprocessed_direct_deposit_fileheader_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Processed_Direct_Deposit_Fileheader__Ach_File_Header_Record__ach_file_header_record_KEYach_file_header_record_KEYAch_File_Header_Record (ach_file_header_record_KEY)

Schema diagram