Table: dbo.Payable_Transaction_N_Ach_Entry_Detail_Record
Maps payable transactions to the ACH entry detail record associated with that transaction - for firm vendor funding
Columns
Name | Type | Constraints | Description
payable_transaction_KEY | int (4) | NOT NULL | Key to the source payable transaction
ach_entry_detail_record_KEY | int (4) | NOT NULL | Key to the associated ach detail record

Primary key
Name | Columns | Description
PK_Payable_Transaction_N_Ach_Entry_Detail_Record$payable_transaction_KEY | payable_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEY | ach_entry_detail_record_KEY | Ach_Entry_Detail_Record (ach_entry_detail_record_KEY) |
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |