AdventureWorks Database : Purchasing Schema |
Table | Description |
---|---|
Purchasing.ProductVendor | Cross-reference table mapping vendors with the products they supply. |
Purchasing.PurchaseOrderDetail | Individual products associated with a specific purchase order. See PurchaseOrderHeader. |
Purchasing.PurchaseOrderHeader | General purchase order information. See PurchaseOrderDetail. |
Purchasing.ShipMethod | Shipping company lookup table. |
Purchasing.Vendor | Companies from whom Adventure Works Cycles purchases parts or other goods. |
Purchasing.VendorAddress | Cross-reference mapping vendors and addresses. |
Purchasing.VendorContact | Cross-reference table mapping vendors and their employees. |
View | Description |
---|---|
Purchasing.vVendor | Vendor (company) names and addresses and the names of vendor employees to contact. |