Table: dbo.Vendor_Bank_Transaction
Columns
Name | Type | Constraints | Description
bank_transaction_KEY | int (4) | NOT NULL | Primary key and foreign key to the parent bank transaction
vendor_KEY | int (4) | NOT NULL | Vendor the payment is for
vendor_amortization_schedule_entry_KEY | int (4) |  | Foreign key to Vendor_Amortization_Schedule_Entry - optional when transaction is not associated with an amortization payment.

Primary key
Name | Columns | Description
PK_Vendor_Bank_Transaction$bank_transaction_KEY | bank_transaction_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_Bank_Transaction__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |
FK_Vendor_Bank_Transaction__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |
FK_Vendor_Bank_Transaction__Vendor_Amortization_Schedule_Entry__vendor_amortization_schedule_entry_KEY | vendor_amortization_schedule_entry_KEY | Vendor_Amortization_Schedule_Entry (vendor_amortization_schedule_entry_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payable_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payable_Transaction |
FK_Online_Bill_Pay_Bank_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Online_Bill_Pay_Bank_Transaction |
FK_Eftps_Transaction__Vendor_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Eftps_Transaction |