Table 'Sales.SalesOrderHeader', General sales order information.

Table 'Sales.SalesOrderHeader', General sales order information.

Property NameProperty Value
Records31465
Fields27
Record size (bytes) w/o BLOBs608

Field statistics for 'SalesOrderID' int identity

Field propertyProperty Value
Minimum value43659
Maximum value75123
Average value59391.0
Values variance82506474.166666672
Unique values31465

Field statistics for 'RevisionNumber' tinyint

Field propertyProperty Value
Minimum value1
Maximum value2
Average value1.000953440330526
Values variance9.5256155574887204E-4
Unique values2

Field statistics for 'OrderDate' datetime

Field propertyProperty Value
Minimum value2001-07-01 00:00:00.000
Maximum value2004-07-31 00:00:00.000
Unique values1124

Field statistics for 'DueDate' datetime

Field propertyProperty Value
Minimum value2001-07-13 00:00:00.000
Maximum value2004-08-12 00:00:00.000
Unique values1124

Field statistics for 'ShipDate' datetime

Field propertyProperty Value
Minimum value2001-07-08 00:00:00.000
Maximum value2004-08-07 00:00:00.000
Unique values1124

Field statistics for 'Status' tinyint

Field propertyProperty Value
Minimum value5
Maximum value5
Average value5.0
Values variance0.0
Unique values1

Field statistics for 'OnlineOrderFlag' Flag

Field propertyProperty Value
Unique values2

Field statistics for 'SalesOrderNumber' nvarchar(25)

Field propertyProperty Value
Minimum valueSO43659
Maximum valueSO75123
Unique values31465

Field statistics for 'PurchaseOrderNumber' OrderNumber

Field propertyProperty Value
Minimum valuePO10005144378
Maximum valuePO9976195169
Unique values3806

Field statistics for 'AccountNumber' AccountNumber

Field propertyProperty Value
Minimum value10-4020-000001
Maximum value10-4030-029483
Unique values19119

Field statistics for 'CustomerID' int

Field propertyProperty Value
Minimum value1
Maximum value29483
Average value16608.138280629271
Values variance62851530.150818102
Unique values19119

Field statistics for 'ContactID' int

Field propertyProperty Value
Minimum value1
Maximum value19977
Average value9503.6692833306843
Values variance36796104.881278999
Unique values19119

Field statistics for 'SalesPersonID' int

Field propertyProperty Value
Minimum value268
Maximum value290
Average value280.22359432475042
Values variance20.564184291619664
Unique values17

Field statistics for 'TerritoryID' int

Field propertyProperty Value
Minimum value1
Maximum value10
Average value6.0907675194660733
Values variance8.7504693606790305
Unique values10

Field statistics for 'BillToAddressID' int

Field propertyProperty Value
Minimum value405
Maximum value29883
Average value18263.154425552202
Values variance67405235.575726047
Unique values19119

Field statistics for 'ShipToAddressID' int

Field propertyProperty Value
Minimum value9
Maximum value29883
Average value18249.192563165423
Values variance67542579.547936052
Unique values19119

Field statistics for 'ShipMethodID' int

Field propertyProperty Value
Minimum value1
Maximum value5
Average value1.4838391863975846
Values variance1.7013104572299509
Unique values2

Field statistics for 'CreditCardID' int

Field propertyProperty Value
Minimum value1
Maximum value19237
Average value9684.1004483417946
Values variance30983691.140241127
Unique values18384

Field statistics for 'CreditCardApprovalCode' varchar(15)

Field propertyProperty Value
Minimum value1016006Vi91301
Maximum value98795Vi7192
Unique values30334

Field statistics for 'CurrencyRateID' int

Field propertyProperty Value
Minimum value2
Maximum value12431
Average value9191.4995706926165
Values variance8674026.8907332607
Unique values2514

Field statistics for 'SubTotal' money(19,4)

Field propertyProperty Value
Minimum value1.3740
Maximum value224356.4831
Average value4046.9467698264893
Values variance183959777.13600615
Unique values4745

Field statistics for 'TaxAmt' money(19,4)

Field propertyProperty Value
Minimum value.1099
Maximum value17948.5186
Average value323.75574321309989
Values variance1177342.572774014
Unique values4745

Field statistics for 'Freight' money(19,4)

Field propertyProperty Value
Minimum value.0344
Maximum value5608.9121
Average value101.17369304940361
Values variance114974.85761773505
Unique values4744

Field statistics for 'TotalDue' money(19,4)

Field propertyProperty Value
Minimum value1.5183
Maximum value247913.9138
Average value4471.8762060892377
Values variance224619486.72842091
Unique values4745

Field statistics for 'Comment' nvarchar(128)

Field propertyProperty Value
Unique values0

Field statistics for 'rowguid' uniqueidentifier

Field propertyProperty Value
Unique values31465

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2001-07-08 00:00:00.000
Maximum value2004-08-07 00:00:00.000
Unique values1124