ProductVendor Table (AdventureWorks)

Is a cross-reference table that maps vendors with the products they supply to Adventure Works Cycles.

ProductVendor Table Definition

The ProductVendor table is contained in the Purchasing schema.

Column	Data type	Nullability	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	Average span of time in days between placing an order with the vendor and receiving the purchased product.
StandardPrice	money	Not null	Vendor's usual selling price.
LastReceiptCost	money	Null	Selling price when last purchased.
LastReceiptDate	datetime	Null	Date the product was last received by the vendor.
MinOrderQty	int	Not null	Mminimum quantity that should be ordered.
MaxOrderQty	int	Not null	Maximum quantity that should be ordered.
OnOrderQty	int	Null	Quantity currently on order.
UnitMeasureCode	nchar(3)	Not null	Product unit of measure.
ModifiedDate	datetime	Not null	Date and time the row was last updated.