Table: dbo.Ach_Entry_Detail_Record
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Ach_Entry_Detail_Record | ach_entry_detail_record_KEY |
Unique constraints
Name | Columns | Description
UK_Ach_Entry_Detail_Record$ach_entry_detail_record_guid | ach_entry_detail_record_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ach_Entry_Detail_Record__Ach_Company_Batch_Header_Record__ach_company_batch_header_record_KEY | ach_company_batch_header_record_KEY | Ach_Company_Batch_Header_Record (ach_company_batch_header_record_KEY) |
FK_Ach_Entry_Detail_Record__Bank_Transaction__bank_rec_funded_deposit_detail__bank_transaction_KEY | bank_rec_funded_deposit_detail__bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Ach_Entry_Detail_Record__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ach_Entry_Addenda_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEY | ach_entry_detail_record_KEY | Ach_Entry_Addenda_Record |
FK_Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEY | ach_entry_detail_record_KEY | Manual_Funding_Bank_Transaction_N_Ach_Entry_Detail_Record |
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEY | ach_entry_detail_record_KEY | Payable_Transaction_N_Ach_Entry_Detail_Record |