Table 'Purchasing.PurchaseOrderDetail', Individual products associated with a specific purchase order. See PurchaseOrderHeader.

Table 'Purchasing.PurchaseOrderDetail', Individual products associated with a specific purchase order. See PurchaseOrderHeader.

Property Name	Property Value
Records	8788
Fields	11
Record size (bytes) w/o BLOBs	119

Field statistics for 'PurchaseOrderID' int

Field property	Property Value
Minimum value	1
Maximum value	4000
Average value	1979.2522758306782
Values variance	1334891.1457499128
Unique values	4000

Field statistics for 'PurchaseOrderDetailID' int identity

Field property	Property Value
Minimum value	1
Maximum value	8788
Average value	4394.5
Values variance	6436477.666666667
Unique values	8788

Field statistics for 'DueDate' datetime

Field property	Property Value
Minimum value	2001-05-31 00:00:00.000
Maximum value	2004-09-17 00:00:00.000
Unique values	296

Field statistics for 'OrderQty' smallint

Field property	Property Value
Minimum value	3
Maximum value	1250
Average value	256.30200273099683
Values variance	81819.269657989295
Unique values	5

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	1
Maximum value	952
Average value	525.50557578516157
Values variance	51700.220408192399
Unique values	211

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

Field property	Property Value
Minimum value	.2100
Maximum value	82.8345
Average value	34.829381543013469
Values variance	265.42634998796854
Unique values	146

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

Field property	Property Value
Minimum value	37.0755
Maximum value	45558.9750
Average value	7012.7054987483662
Values variance	101021793.38931186
Unique values	148

Field statistics for 'ReceivedQty' decimal(8,2)

Field property	Property Value
Minimum value	2.00
Maximum value	1250.00
Average value	253.90691852526172
Values variance	80420.550342477945
Unique values	11

Field statistics for 'RejectedQty' decimal(8,2)

Field property	Property Value
Minimum value	.00
Maximum value	1250.00
Average value	8.2726445152480661
Values variance	3422.3262482919613
Unique values	13

Field statistics for 'StockedQty' decimal(9,2)

Field property	Property Value
Minimum value	.00
Maximum value	1250.00
Average value	245.63427401001366
Values variance	78098.276380638228
Unique values	15

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-24 00:00:00.000
Maximum value	2004-09-10 00:00:00.000
Unique values	296