SalesOrderHeader Table (AdventureWorks)
Contains the general, or parent, sales order information. The specific products associated with the sales order are stored in SalesOrderDetail Table.
SalesOrderHeader Table Definition
The SalesOrderHeader table is contained in the Sales schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
SalesOrderID |
int |
Not null |
Primary key. |
RevisionNumber |
tinyint |
Not null |
Incremental number to track changes to the sales order over time. |
OrderDate |
datetime |
Not null |
Dates the sales order was created. |
DueDate |
datetime |
Not null |
Date the order is due to the customer. |
ShipDate |
datetime |
Null |
Date the order was shipped to the customer. |
Status |
tinyint |
Not null |
Order current status. 1 = In process 2 = Approved 3 = Back ordered 4 = Rejected 5 = Shipped 6 = Canceled |
OnlineOrderFlag |
Flag (user-defined type) bit |
Not null |
0 = Order placed by sales person. 1 = Order placed online by customer. |
SalesOrderNumber |
nvarchar(25) |
Not null |
Unique sales order identification number. |
PurchaseOrderNumber |
OrderNumber (user-defined type) nvarchar(25) |
Null |
Customer purchase order number reference. |
AccountNumber |
AccountNumber (user-defined type) nvarchar(15) |
Null |
Financial accounting number reference. |
CustomerID |
int |
Not null |
Customer identification number. Foreign key to Customer.CustomerID. |
ContactID |
int |
Not null |
Customer contact identification number. Foreign key to Contact.ContactID. |
SalesPersonID |
int |
Null |
Sales person who created the sales order. Foreign key to SalesPerson.SalePersonID. |
TerritoryID |
int |
Null |
Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID. |
BillToAddressID |
int |
Not null |
Customer billing address. Foreign key to Address.AddressID. |
ShipToAddressID |
int |
Not null |
Customer shipping address. Foreign key to Address.AddressID. |
ShipMethodID |
int |
Not null |
Shipping method. Foreign key to ShipMethod.ShipMethodID. |
CreditCardID |
int |
Null |
Credit card identification number. Foreign key to CreditCard.CreditCardID. |
CreditCardApprovalCode |
varchar(15) |
Null |
Approval code provided by the credit card company. |
CurrencyRateID |
int |
Null |
Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID. |
SubTotal |
money |
Not null |
Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal) for the SalesOrderID. |
TaxAmt |
money |
Not null |
Tax amount. |
Freight |
money |
Not null |
Shipping cost. |
TotalDue |
Computed as SubTotal + TaxAmt + Freight |
Not null |
Total due from customer. |
Comment |
nvarchar(128) |
Null |
Comments made by the sales representative. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Address Table (AdventureWorks)
CreditCard Table (AdventureWorks)
CurrencyRate Table (AdventureWorks)
Customer Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesOrderDetail Table (AdventureWorks)
SalesOrderHeaderSalesReason Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary