← All tables and views
AdventureWorks OLTP table
Sales.SalesOrderHeader
General sales order information.
31,465rows
26 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
SalesOrderID | INTEGER | no | PK | — |
RevisionNumber | INTEGER | no | — | — |
OrderDate | TEXT | no | — | — |
DueDate | TEXT | no | — | — |
ShipDate | TEXT | yes | — | — |
Status | INTEGER | no | — | — |
OnlineOrderFlag | INTEGER | no | — | — |
SalesOrderNumber | TEXT | yes | — | — |
PurchaseOrderNumber | TEXT | yes | — | — |
AccountNumber | TEXT | yes | — | — |
CustomerID | INTEGER | no | — | Sales.Customer.CustomerID |
SalesPersonID | INTEGER | yes | — | Sales.SalesPerson.BusinessEntityID |
TerritoryID | INTEGER | yes | — | Sales.SalesTerritory.TerritoryID |
BillToAddressID | INTEGER | no | — | Person.Address.AddressID |
ShipToAddressID | INTEGER | no | — | Person.Address.AddressID |
ShipMethodID | INTEGER | no | — | Purchasing.ShipMethod.ShipMethodID |
CreditCardID | INTEGER | yes | — | Sales.CreditCard.CreditCardID |
CreditCardApprovalCode | TEXT | yes | — | — |
CurrencyRateID | INTEGER | yes | — | Sales.CurrencyRate.CurrencyRateID |
SubTotal | NUMERIC | no | — | — |
TaxAmt | NUMERIC | no | — | — |
Freight | NUMERIC | no | — | — |
TotalDue | NUMERIC | yes | — | — |
Comment | TEXT | yes | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
Sales_SalesOrderHeader_AK_SalesOrderHeader_SalesOrderNumberSalesOrderNumberSales_SalesOrderHeader_AK_SalesOrderHeader_rowguidrowguid2 unique indexes inspected
Sales_SalesOrderHeader_AK_SalesOrderHeader_SalesOrderNumberSalesOrderNumberCREATE UNIQUE INDEX "Sales_SalesOrderHeader_AK_SalesOrderHeader_SalesOrderNumber" ON "Sales.SalesOrderHeader" ("SalesOrderNumber")Sales_SalesOrderHeader_AK_SalesOrderHeader_rowguidrowguidCREATE UNIQUE INDEX "Sales_SalesOrderHeader_AK_SalesOrderHeader_rowguid" ON "Sales.SalesOrderHeader" ("rowguid")Data preview
Sample records
| SalesOrderID | RevisionNumber | OrderDate | DueDate | ShipDate | Status | OnlineOrderFlag |
|---|---|---|---|---|---|---|
| 43659 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43660 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43661 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43662 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43663 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43664 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43665 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
| 43666 | 10 | 2022-05-30 00:00:00.000 | 2022-06-11 00:00:00.000 | 2022-06-06 00:00:00.000 | 5 | 0 |
Interactive explorer