Purchasing ProductVendor (table)

wikibot

TablePurchasing.ProductVendor
DescriptionCross-reference table mapping vendors with the products they supply.

Columns

ColumnData TypeNullableDefaultDescription
ProductIDintnot null Primary key. Foreign key to Product.ProductID.
VendorIDintnot null Primary key. Foreign key to Vendor.VendorID.
AverageLeadTimeintnot null The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
StandardPricemoneynot null The vendor's usual selling price.
LastReceiptCostmoneynull The selling price when last purchased.
LastReceiptDatedatetimenull Date the product was last received by the vendor.
MinOrderQtyintnot null The maximum quantity that should be ordered.
MaxOrderQtyintnot null The minimum quantity that should be ordered.
OnOrderQtyintnull The quantity currently on order.
UnitMeasureCodenchar(3)not null The product's unit of measure.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_ProductVendor_ProductID_VendorIDProductID, VendorID

Indexes

IndexTypeColumns
IX_ProductVendor_UnitMeasureCode UnitMeasureCode
IX_ProductVendor_VendorID VendorID

Check Constraints

Check ConstraintExpressionDescription
CK_ProductVendor_AverageLeadTime(AverageLeadTime>=(1))Check constraint AverageLeadTime >= (1)
CK_ProductVendor_LastReceiptCost(LastReceiptCost>(0.00))Check constraint LastReceiptCost > (0.00)
CK_ProductVendor_MaxOrderQty(MaxOrderQty>=(1))Check constraint MaxOrderQty >= (1)
CK_ProductVendor_MinOrderQty(MinOrderQty>=(1))Check constraint MinOrderQty >= (1)
CK_ProductVendor_OnOrderQty(OnOrderQty>=(0))Check constraint OnOrderQty >= (0)
CK_ProductVendor_StandardPrice(StandardPrice>(0.00))Check constraint StandardPrice > (0.00)

Foreign Keys

RelationColumnReferenced Column
Production.ProductProductIDProductID
Production.UnitMeasureUnitMeasureCodeUnitMeasureCode
Purchasing.VendorVendorIDVendorID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaPurchasing