| 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.
|