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
NameTypeConstraintsDescription
payable_transaction_KEYint (4)NOT NULLKey to the source payable transaction
ach_entry_detail_record_KEYint (4)NOT NULLKey to the associated ach detail record
Primary key
NameColumnsDescription
PK_Payable_Transaction_N_Ach_Entry_Detail_Record$payable_transaction_KEYpayable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Ach_Entry_Detail_Record__ach_entry_detail_record_KEYach_entry_detail_record_KEYAch_Entry_Detail_Record (ach_entry_detail_record_KEY)
FK_Payable_Transaction_N_Ach_Entry_Detail_Record__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)

Schema diagram