PurchaseOrderHeader Table (AdventureWorks)
Contains the general, or parent, purchase order information. The specific products associated with the purchase order are stored in PurchaseOrderDetail Table.
PurchaseOrderHeader Table Definition
The PurchasesOrderHeader table is contained in the Purchasing schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
PurchaseOrderID |
int |
Not null |
Primary key. |
RevisionNumber |
tinyint |
Not null |
Incremental number to track changes to the purchase order over time. |
Status |
tinyint |
Not null |
Order current status. 1 = Pending 2 = Approved 3 = Rejected 4 = Complete |
EmployeeID |
int |
Not null |
Employee who created the purchase order. Foreign key to Employee.EmployeeID. |
VendorID |
int |
Not null |
Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID. |
ShipMethodID |
int |
Not null |
Shipping method. Foreign key to ShipMethod.ShipMethodID. |
OrderDate |
datetime |
Not null |
Purchase order creation date. |
ShipDate |
datetime |
Not null |
Estimated shipment date from the vendor. |
SubTotal |
money |
Not null |
Purchase order subtotal. |
TaxAmt |
money |
Not null |
Tax amount. |
Freight |
money |
Not null |
Shipping cost. |
TotalDue |
Computed as SubTotal + TaxAmt + Freight |
Not null |
Total due to vendor. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Address Table (AdventureWorks)
Employee Table (AdventureWorks)
ShipMethod Table (AdventureWorks)
Vendor Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary