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