| 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 | ||