Table: dbo.Vendor_AP_Beginning_Balance
This table may hold a link between a vendor and a carry over payable transaction if they have one.
Columns
Name | Type | Constraints | Description
vendor_KEY | int (4) | NOT NULL | This is the foreign key back to the Vendor the related beginning balance payable transaction belongs to. A Vendor may have zero to many beginning balance transactions.
payable_transaction_KEY | int (4) | NOT NULL | The primary key of this table, and the key of a payable transaction that is part of the Vendor's beginning balance.

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Vendor_AP_Beginning_Balance__Payable_Transaction__payable_transaction_KEY | payable_transaction_KEY | Payable_Transaction (payable_transaction_KEY) |
FK_Vendor_AP_Beginning_Balance__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |