Purchasing.ProductVendor
Documentation | AdventureWorks |
Schema | Purchasing |
Name | ProductVendor |
Module | Purchasing |
Cross-reference table mapping vendors with the products they supply.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | ProductID | int | Production.Product | Primary key. Foreign key to Product.ProductID. | ||||
Primary key. Foreign key to Product.ProductID. References: Production.Product |
||||||||
2 | BusinessEntityID | int | Purchasing.Vendor | Primary key. Foreign key to Vendor.BusinessEntityID. | ||||
Primary key. Foreign key to Vendor.BusinessEntityID. References: Purchasing.Vendor |
||||||||
3 | AverageLeadTime | int | The average span of time (in days) between placing an order with the vendor and receiving the purchased product. | |||||
The average span of time (in days) between placing an order with the vendor and receiving the purchased product. |
||||||||
4 | StandardPrice | money | The vendor's usual selling price. | |||||
The vendor's usual selling price. |
||||||||
5 | LastReceiptCost | money | The selling price when last purchased. | |||||
The selling price when last purchased. |
||||||||
6 | LastReceiptDate | datetime | Date the product was last received by the vendor. | |||||
Date the product was last received by the vendor. |
||||||||
7 | MinOrderQty | int | The maximum quantity that should be ordered. | |||||
The maximum quantity that should be ordered. |
||||||||
8 | MaxOrderQty | int | The minimum quantity that should be ordered. | |||||
The minimum quantity that should be ordered. |
||||||||
9 | OnOrderQty | int | The quantity currently on order. | |||||
The quantity currently on order. |
||||||||
10 | UnitMeasureCode | nchar(3) | Production.UnitMeasure | The product's unit of measure. | ||||
The product's unit of measure. References: Production.UnitMeasure |
||||||||
11 | ModifiedDate | datetime | Default: getdate() | Date and time the record was last updated. | ||||
Date and time the record was last updated. Default: getdate() |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
Purchasing.ProductVendor | Production.Product | Purchasing.ProductVendor.ProductID = Production.Product.ProductID | FK_ProductVendor_Product_ProductID Foreign key constraint referencing Product.ProductID. |
|
Purchasing.ProductVendor.ProductID = Production.Product.ProductID Name: FK_ProductVendor_Product_ProductIDForeign key constraint referencing Product.ProductID. |
||||
Purchasing.ProductVendor | Production.UnitMeasure | Purchasing.ProductVendor.UnitMeasureCode = Production.UnitMeasure.UnitMeasureCode | FK_ProductVendor_UnitMeasure_UnitMeasureCode Foreign key constraint referencing UnitMeasure.UnitMeasureCode. |
|
Purchasing.ProductVendor.UnitMeasureCode = Production.UnitMeasure.UnitMeasureCode Name: FK_ProductVendor_UnitMeasure_UnitMeasureCodeForeign key constraint referencing UnitMeasure.UnitMeasureCode. |
||||
Purchasing.ProductVendor | Purchasing.Vendor | Purchasing.ProductVendor.BusinessEntityID = Purchasing.Vendor.BusinessEntityID | FK_ProductVendor_Vendor_BusinessEntityID Foreign key constraint referencing Vendor.BusinessEntityID. |
|
Purchasing.ProductVendor.BusinessEntityID = Purchasing.Vendor.BusinessEntityID Name: FK_ProductVendor_Vendor_BusinessEntityIDForeign key constraint referencing Vendor.BusinessEntityID. |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_ProductVendor_ProductID_BusinessEntityID | ProductID, BusinessEntityID | Primary key (clustered) constraint | |
Primary key (clustered) constraint |
Uses
Name |
---|
Purchasing.ProductVendor
|
Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56