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