Individual products associated with a specific purchase order. datetime PurchaseOrderDetail Table Purchasing.PurchaseOrderDetail nchar(3) References UnitMeasure ( UnitMeasureCode ) ModifiedDate ModifiedDateĭate and time the record was last updated. int IX_ProductVendor_UnitMeasureCode ( UnitMeasureCode ) The minimum quantity that should be ordered. The maximum quantity that should be ordered. money LastReceiptDate LastReceiptDateĭate the product was last received by the vendor. The average span of time (in days) between placing an order with the vendor and receiving the purchased product. int References Vendor ( BusinessEntityID ) AverageLeadTime AverageLeadTime
int References Product ( ProductID ) Pk PK_ProductVendor_ProductID_BusinessEntityID ( ProductID, BusinessEntityID )Ĭlustered index created by a primary key constraint.IX_ProductVendor_BusinessEntityID ( BusinessEntityID ) Pk PK_ProductVendor_ProductID_BusinessEntityID ( ProductID, BusinessEntityID )Ĭlustered index created by a primary key constraint. PurchaseOrderHeader ref Vendor ( VendorID -> BusinessEntityID ) ProductVendor Table Purchasing.ProductVendorĬross-reference table mapping vendors with the products they supply. PurchaseOrderHeader ref Vendor ( VendorID -> BusinessEntityID ) Fk FK_PurchaseOrderHeader_Vendor_VendorID PurchaseOrderHeader ref ShipMethod ( ShipMethodID ) Fk FK_PurchaseOrderHeader_Vendor_VendorID PurchaseOrderHeader ref ShipMethod ( ShipMethodID ) Fk FK_PurchaseOrderHeader_ShipMethod_ShipMethodID PurchaseOrderDetail ref PurchaseOrderHeader ( PurchaseOrderID ) Fk FK_PurchaseOrderHeader_ShipMethod_ShipMethodID PurchaseOrderDetail ref PurchaseOrderHeader ( PurchaseOrderID ) Fk FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID ProductVendor ref Vendor ( BusinessEntityID ) Fk FK_PurchaseOrderDetail_PurchaseOrderHeader_PurchaseOrderID ProductVendor ref Vendor ( BusinessEntityID ) Fk FK_ProductVendor_Vendor_BusinessEntityID Purchasing Fk FK_ProductVendor_Vendor_BusinessEntityID Purchasing 1 AdventureWorks.Purchasing © Matthias Wolf wolf online training Hover columns to read comments.