Purchasing ProductVendor (table)

wikibot ¶

Table	Purchasing.ProductVendor
Description	Cross-reference table mapping vendors with the products they supply.

Columns ¶

Column	Data Type	Nullable	Default	Description
ProductID	int	not null		Primary key. Foreign key to Product.ProductID.
VendorID	int	not null		Primary key. Foreign key to Vendor.VendorID.
AverageLeadTime	int	not null		The average span of time (in days) between placing an order with the vendor and receiving the purchased product.
StandardPrice	money	not null		The vendor's usual selling price.
LastReceiptCost	money	null		The selling price when last purchased.
LastReceiptDate	datetime	null		Date the product was last received by the vendor.
MinOrderQty	int	not null		The maximum quantity that should be ordered.
MaxOrderQty	int	not null		The minimum quantity that should be ordered.
OnOrderQty	int	null		The quantity currently on order.
UnitMeasureCode	nchar(3)	not null		The product's unit of measure.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_ProductVendor_ProductID_VendorID	ProductID, VendorID

Indexes ¶

Index	Type	Columns
IX_ProductVendor_UnitMeasureCode		UnitMeasureCode
IX_ProductVendor_VendorID		VendorID

Check Constraints ¶

Check Constraint	Expression	Description
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 ¶

Relation	Column	Referenced Column
Production.Product	ProductID	ProductID
Production.UnitMeasure	UnitMeasureCode	UnitMeasureCode
Purchasing.Vendor	VendorID	VendorID

References ¶

Dependency Type	Object Type	Referenced Object
Schema	Schema	Purchasing