Purchasing.ProductVendor (table)

wikibot

Table

Purchasing.ProductVendor

Column	Data Type	Nullable	Default	PK	Index
ProductID	int	not null		PK_ProductVendor_ProductID_VendorID
VendorID	int	not null		PK_ProductVendor_ProductID_VendorID	IX_ProductVendor_VendorID
AverageLeadTime	int	not null
StandardPrice	money	not null
LastReceiptCost	money	null
LastReceiptDate	datetime	null
MinOrderQty	int	not null
MaxOrderQty	int	not null
OnOrderQty	int	null
UnitMeasureCode	nchar(3)	not null			IX_ProductVendor_UnitMeasureCode
ModifiedDate	datetime	not null	(getdate())

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

automatically generated

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

Column	Data Type	Nullable	Default	Description / PK / Index
ProductID	int	not null		Primary key. Foreign key to Product.ProductID. PK_ProductVendor_ProductID_VendorID
VendorID	int	not null		Primary key. Foreign key to Vendor.VendorID. PK_ProductVendor_ProductID_VendorIDIX_ProductVendor_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. IX_ProductVendor_UnitMeasureCode
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Purchasing