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.