Table: dbo.Ach_Entry_Detail_Record
Columns
NameTypeConstraintsDescription
transaction_codenvarchar (4)NOT NULLTransaction code - see ACH specification
receiving_dfi_idnvarchar (20)NOT NULLReceiving dfi identification - see ACH specification
check_digitnvarchar (2)NOT NULLCheck digit from receiving dfi ID - see ACH specification
dfi_account_numbernvarchar (70)NOT NULLAccount number of receiving dfi - see ACH specification
amountnvarchar (20)NOT NULLTransaction amount - no decimal point - see ACH specification
individual_id_numbernvarchar (30)NOT NULLID of individual involved in this transaction - see ACH specification
individual_namenvarchar (200)NOT NULLName of individual involved in this transaction - see ACH specification
discretionary_datanvarchar (4)NOT NULLData entered by user - see ACH specification
addenda_record_indicatornvarchar (2)NOT NULLIndicates an addenda record is associated - see ACH specification
trace_numbernvarchar (40)NOT NULLTrace number for entry - see ACH specification
transaction_datesmalldatetime (4)NOT NULLTransaction date - used for processing ui not ACH file creation
transaction_referencenvarchar (30)NOT NULLReference of transaction - depends on transaction type - used in processing ui not ACH file creation
transaction_typenvarchar (60)NOT NULLTransaction type - used in processing ui not ACH file creation
effective_datesmalldatetime (4)NOT NULLEffective date of transaction - used on processing ui not ACH file creation
bank_account_typenvarchar (22)NOT NULLBank account type - used in processing ui not ACH file creation
payee_bank_namenvarchar (100)NOT NULLName of payee bank - used in processing ui not ACH file creation
direct_deposit_allocation_KEYint (4)NOT NULLKey into direct deposit allocation used to create this entry - used in processing ui not ACH file creation - can not be constrained due to use.
display__individual_namenvarchar (200)NOT NULLHolds display value for individual name - actual individual name may be modified per state rules.
ach_company_batch_header_record_KEYint (4)NOT NULL
ach_entry_detail_record_KEYint (4)NOT NULL
client_KEYint (4)Client key if available that is associated with this entry. Used for client security filtering and client backup and restore.
ach_entry_detail_record_guiduniqueidentifier (16)NOT NULLA unique identifer for each ACH entry detail record row.
bank_rec_funded_deposit_detail__bank_transaction_KEYint (4)Bank transaction key for funding deposits that is associated with this ach entry detail record.["BR"] It must be null if the transaction is not a funded deposit (when direct_deposit_allocation_KEY is 0 and for all existing records) otherwize["BR"] it must have a value. It is used to link Ach data back to bank transactions for Impound bank reconciliation so that deposit["BR"] records in impound bank reconciliation can be grouped by their ach file.
Primary key
NameColumnsDescription
PK_Ach_Entry_Detail_Recordach_entry_detail_record_KEY
Unique constraints
NameColumnsDescription
UK_Ach_Entry_Detail_Record$ach_entry_detail_record_guidach_entry_detail_record_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Ach_Entry_Detail_Record__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEYach_company_batch_header_record_KEYAch_Company_Batch_Header_Record (ach_company_batch_header_record_KEY)
FK_Ach_Entry_Detail_Record__Bank_Transaction__bank_rec_funded_deposit_detail__bank_transaction_KEYbank_rec_funded_deposit_detail__bank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Ach_Entry_Detail_Record__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ach_Entry_Addenda_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEYach_entry_detail_record_KEYAch_Entry_Addenda_Record
FK_Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEYach_entry_detail_record_KEYManual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEYach_entry_detail_record_KEYPayable_Transaction_N_Ach_Entry_Detail_Record

Schema diagram