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
NameTypeConstraintsDescription
vendor_KEYint (4)NOT NULLThis 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_KEYint (4)NOT NULLThe primary key of this table, and the key of a payable transaction that is part of the Vendor's beginning balance.
Primary key
NameColumnsDescription
PK_Vendor_AP_Beginning_Balance$payable_transaction_KEYpayable_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Vendor_AP_Beginning_Balance__Payable_Transaction__payable_transaction_KEYpayable_transaction_KEYPayable_Transaction (payable_transaction_KEY)
FK_Vendor_AP_Beginning_Balance__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram