transaction_code | nvarchar (4) | NOT NULL | Transaction code - see ACH specification |
receiving_dfi_id | nvarchar (20) | NOT NULL | Receiving dfi identification - see ACH specification |
check_digit | nvarchar (2) | NOT NULL | Check digit from receiving dfi ID - see ACH specification |
dfi_account_number | nvarchar (70) | NOT NULL | Account number of receiving dfi - see ACH specification |
amount | nvarchar (20) | NOT NULL | Transaction amount - no decimal point - see ACH specification |
individual_id_number | nvarchar (30) | NOT NULL | ID of individual involved in this transaction - see ACH specification |
individual_name | nvarchar (200) | NOT NULL | Name of individual involved in this transaction - see ACH specification |
discretionary_data | nvarchar (4) | NOT NULL | Data entered by user - see ACH specification |
addenda_record_indicator | nvarchar (2) | NOT NULL | Indicates an addenda record is associated - see ACH specification |
trace_number | nvarchar (40) | NOT NULL | Trace number for entry - see ACH specification |
transaction_date | smalldatetime (4) | NOT NULL | Transaction date - used for processing ui not ACH file creation |
transaction_reference | nvarchar (30) | NOT NULL | Reference of transaction - depends on transaction type - used in processing ui not ACH file creation |
transaction_type | nvarchar (60) | NOT NULL | Transaction type - used in processing ui not ACH file creation |
effective_date | smalldatetime (4) | NOT NULL | Effective date of transaction - used on processing ui not ACH file creation |
bank_account_type | nvarchar (22) | NOT NULL | Bank account type - used in processing ui not ACH file creation |
payee_bank_name | nvarchar (100) | NOT NULL | Name of payee bank - used in processing ui not ACH file creation |
direct_deposit_allocation_KEY | int (4) | NOT NULL | Key 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_name | nvarchar (200) | NOT NULL | Holds display value for individual name - actual individual name may be modified per state rules. |
ach_company_batch_header_record_KEY | int (4) | NOT NULL | |
ach_entry_detail_record_KEY | int (4) | NOT NULL | |
client_KEY | int (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_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each ACH entry detail record row. |
bank_rec_funded_deposit_detail__bank_transaction_KEY | int (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. |