Table 'Purchasing.PurchaseOrderHeader', General purchase order information. See PurchaseOrderDetail.

Table 'Purchasing.PurchaseOrderHeader', General purchase order information. See PurchaseOrderDetail.

Property Name	Property Value
Records	4000
Fields	13
Record size (bytes) w/o BLOBs	150

Field statistics for 'PurchaseOrderID' int identity

Field property	Property Value
Minimum value	1
Maximum value	4000
Average value	2000.5
Values variance	1333666.6666666667
Unique values	4000

Field statistics for 'RevisionNumber' tinyint

Field property	Property Value
Minimum value	0
Maximum value	5
Average value	6.6000000000000003E-2
Values variance	0.11367241810452614
Unique values	6

Field statistics for 'Status' tinyint

Field property	Property Value
Minimum value	1
Maximum value	4
Average value	3.8097500000000002
Values variance	0.49167785696424021
Unique values	3

Field statistics for 'EmployeeID' int

Field property	Property Value
Minimum value	164
Maximum value	274
Average value	236.62
Values variance	827.04236059014897
Unique values	12

Field statistics for 'VendorID' int

Field property	Property Value
Minimum value	1
Maximum value	104
Average value	51.496749999999999
Values variance	831.38283514628654
Unique values	79

Field statistics for 'ShipMethodID' int

Field property	Property Value
Minimum value	1
Maximum value	5
Average value	3.5745
Values variance	2.2175041260315078
Unique values	5

Field statistics for 'OrderDate' datetime

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

Field statistics for 'ShipDate' datetime

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

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

Field property	Property Value
Minimum value	37.0755
Maximum value	152581.2750
Average value	15406.913980750012
Values variance	443546704.04062027
Unique values	339

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

Field property	Property Value
Minimum value	2.9660
Maximum value	12206.5020
Average value	1232.5531151999905
Values variance	2838698.913010933
Unique values	339

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

Field property	Property Value
Minimum value	.9269
Maximum value	3814.5319
Average value	385.17286200000001
Values variance	277216.69461488142
Unique values	339

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

Field property	Property Value
Minimum value	40.9684
Maximum value	168602.3089
Average value	17024.639957949857
Values variance	541581614.6028378
Unique values	339

Field statistics for 'ModifiedDate' datetime

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