Table: dbo.Vendor_Bank_Transaction
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLPrimary key and foreign key to the parent bank transaction
vendor_KEYint (4)NOT NULLVendor the payment is for
vendor_amortization_schedule_entry_KEYint (4)Foreign key to Vendor_Amortization_Schedule_Entry - optional when transaction is not associated with an amortization payment.
Primary key
NameColumnsDescription
PK_Vendor_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Vendor_Bank_Transaction__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
FK_Vendor_Bank_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEYvendor_amortization_schedule_entry_KEYVendor_Amortization_Schedule_Entry (vendor_amortization_schedule_entry_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payable_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayable_Transaction
FK_Online_Bill_Pay_Bank_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYOnline_Bill_Pay_Bank_Transaction
FK_Eftps_Transaction__Vendor_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYEftps_Transaction

Schema diagram