Table 'Sales.SalesOrderDetail', Individual products associated with a specific sales order. See SalesOrderHeader.

Table 'Sales.SalesOrderDetail', Individual products associated with a specific sales order. See SalesOrderHeader.

Property Name	Property Value
Records	121317
Fields	11
Record size (bytes) w/o BLOBs	182

Field statistics for 'SalesOrderID' int

Field property	Property Value
Minimum value	43659
Maximum value	75123
Average value	57827.363782487206
Values variance	81164745.912791282
Unique values	31465

Field statistics for 'SalesOrderDetailID' int identity

Field property	Property Value
Minimum value	1
Maximum value	121317
Average value	60659.0
Values variance	1226494650.5
Unique values	121317

Field statistics for 'CarrierTrackingNumber' nvarchar(25)

Field property	Property Value
Minimum value	000A-434D-BC
Maximum value	FFF9-4C3E-A9
Unique values	3806

Field statistics for 'OrderQty' smallint

Field property	Property Value
Minimum value	1
Maximum value	44
Average value	2.2660797744751355
Values variance	6.2066911609346054
Unique values	41

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	707
Maximum value	999
Average value	841.68083615651562
Values variance	7473.9696987700108
Unique values	266

Field statistics for 'SpecialOfferID' int

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	1.1625411113034447
Values variance	1.4849966354496305
Unique values	12

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

Field property	Property Value
Minimum value	1.3282
Maximum value	3578.2700
Average value	465.09349567471924
Values variance	565331.17468895088
Unique values	287

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

Field property	Property Value
Minimum value	.0000
Maximum value	.4000
Average value	2.8260672453159497E-3
Values variance	6.1556252138993757E-4
Unique values	9

Field statistics for 'LineTotal' numeric(38,6)

Field property	Property Value
Minimum value	1.374000
Maximum value	27893.619000
Average value	905.44920662152208
Values variance	2867662.4532727217
Unique values	1488

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	121317

Field statistics for 'ModifiedDate' 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