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