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

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

Property Name	Property Value
Records	31465
Fields	27
Record size (bytes) w/o BLOBs	608

Field statistics for 'SalesOrderID' int identity

Field property	Property Value
Minimum value	43659
Maximum value	75123
Average value	59391.0
Values variance	82506474.166666672
Unique values	31465

Field statistics for 'RevisionNumber' tinyint

Field property	Property Value
Minimum value	1
Maximum value	2
Average value	1.000953440330526
Values variance	9.5256155574887204E-4
Unique values	2

Field statistics for 'OrderDate' datetime

Field property	Property Value
Minimum value	2001-07-01 00:00:00.000
Maximum value	2004-07-31 00:00:00.000
Unique values	1124

Field statistics for 'DueDate' datetime

Field property	Property Value
Minimum value	2001-07-13 00:00:00.000
Maximum value	2004-08-12 00:00:00.000
Unique values	1124

Field statistics for 'ShipDate' datetime

Field property	Property Value
Minimum value	2001-07-08 00:00:00.000
Maximum value	2004-08-07 00:00:00.000
Unique values	1124

Field statistics for 'Status' tinyint

Field property	Property Value
Minimum value	5
Maximum value	5
Average value	5.0
Values variance	0.0
Unique values	1

Field statistics for 'OnlineOrderFlag' Flag

Field property	Property Value
Unique values	2

Field statistics for 'SalesOrderNumber' nvarchar(25)

Field property	Property Value
Minimum value	SO43659
Maximum value	SO75123
Unique values	31465

Field statistics for 'PurchaseOrderNumber' OrderNumber

Field property	Property Value
Minimum value	PO10005144378
Maximum value	PO9976195169
Unique values	3806

Field statistics for 'AccountNumber' AccountNumber

Field property	Property Value
Minimum value	10-4020-000001
Maximum value	10-4030-029483
Unique values	19119

Field statistics for 'CustomerID' int

Field property	Property Value
Minimum value	1
Maximum value	29483
Average value	16608.138280629271
Values variance	62851530.150818102
Unique values	19119

Field statistics for 'ContactID' int

Field property	Property Value
Minimum value	1
Maximum value	19977
Average value	9503.6692833306843
Values variance	36796104.881278999
Unique values	19119

Field statistics for 'SalesPersonID' int

Field property	Property Value
Minimum value	268
Maximum value	290
Average value	280.22359432475042
Values variance	20.564184291619664
Unique values	17

Field statistics for 'TerritoryID' int

Field property	Property Value
Minimum value	1
Maximum value	10
Average value	6.0907675194660733
Values variance	8.7504693606790305
Unique values	10

Field statistics for 'BillToAddressID' int

Field property	Property Value
Minimum value	405
Maximum value	29883
Average value	18263.154425552202
Values variance	67405235.575726047
Unique values	19119

Field statistics for 'ShipToAddressID' int

Field property	Property Value
Minimum value	9
Maximum value	29883
Average value	18249.192563165423
Values variance	67542579.547936052
Unique values	19119

Field statistics for 'ShipMethodID' int

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	1.4838391863975846
Values variance	1.7013104572299509
Unique values	2

Field statistics for 'CreditCardID' int

Field property	Property Value
Minimum value	1
Maximum value	19237
Average value	9684.1004483417946
Values variance	30983691.140241127
Unique values	18384

Field statistics for 'CreditCardApprovalCode' varchar(15)

Field property	Property Value
Minimum value	1016006Vi91301
Maximum value	98795Vi7192
Unique values	30334

Field statistics for 'CurrencyRateID' int

Field property	Property Value
Minimum value	2
Maximum value	12431
Average value	9191.4995706926165
Values variance	8674026.8907332607
Unique values	2514

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

Field property	Property Value
Minimum value	1.3740
Maximum value	224356.4831
Average value	4046.9467698264893
Values variance	183959777.13600615
Unique values	4745

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

Field property	Property Value
Minimum value	.1099
Maximum value	17948.5186
Average value	323.75574321309989
Values variance	1177342.572774014
Unique values	4745

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

Field property	Property Value
Minimum value	.0344
Maximum value	5608.9121
Average value	101.17369304940361
Values variance	114974.85761773505
Unique values	4744

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

Field property	Property Value
Minimum value	1.5183
Maximum value	247913.9138
Average value	4471.8762060892377
Values variance	224619486.72842091
Unique values	4745

Field statistics for 'Comment' nvarchar(128)

Field property	Property Value
Unique values	0

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	31465

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-07-08 00:00:00.000
Maximum value	2004-08-07 00:00:00.000
Unique values	1124