Purchasing.ProductVendor (table)

wikibot

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.

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.

Dependency Type	Object Type	Referenced Object
Schema	Schema	Purchasing