Column | Data Type | Nullable | Default | 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 | | 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. |
ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
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.
|