• Article

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.