Table 'Production.WorkOrderRouting', Work order details.

Table 'Production.WorkOrderRouting', Work order details.

Property Name	Property Value
Records	67131
Fields	12
Record size (bytes) w/o BLOBs	145

Field statistics for 'WorkOrderID' int

Field property	Property Value
Minimum value	13
Maximum value	72587
Average value	38394.300129597352
Values variance	418473076.70509434
Unique values	42625

Field statistics for 'ProductID' int

Field property	Property Value
Minimum value	514
Maximum value	999
Average value	798.92957054118062
Values variance	17473.10661417431
Unique values	149

Field statistics for 'OperationSequence' smallint

Field property	Property Value
Minimum value	1
Maximum value	7
Average value	5.1099641000431992
Values variance	4.7172090721507676
Unique values	7

Field statistics for 'LocationID' smallint

Field property	Property Value
Minimum value	10
Maximum value	60
Average value	43.800777584126557
Values variance	306.98468046194102
Unique values	7

Field statistics for 'ScheduledStartDate' datetime

Field property	Property Value
Minimum value	2001-07-04 00:00:00.000
Maximum value	2004-07-03 00:00:00.000
Unique values	1093

Field statistics for 'ScheduledEndDate' datetime

Field property	Property Value
Minimum value	2001-07-15 00:00:00.000
Maximum value	2004-07-14 00:00:00.000
Unique values	1093

Field statistics for 'ActualStartDate' datetime

Field property	Property Value
Minimum value	2001-07-04 00:00:00.000
Maximum value	2004-07-18 00:00:00.000
Unique values	671

Field statistics for 'ActualEndDate' datetime

Field property	Property Value
Minimum value	2001-07-16 00:00:00.000
Maximum value	2004-07-29 00:00:00.000
Unique values	714

Field statistics for 'ActualResourceHrs' decimal(9,4)

Field property	Property Value
Minimum value	1.0000
Maximum value	4.1000
Average value	3.4106776303054547
Values variance	0.41320968679442971
Unique values	6

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

Field property	Property Value
Minimum value	14.5000
Maximum value	92.2500
Average value	51.957657416096886
Values variance	487.75516186809551
Unique values	7

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

Field property	Property Value
Minimum value	14.5000
Maximum value	92.2500
Average value	51.957657416096886
Values variance	487.75516186809551
Unique values	7

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-07-16 00:00:00.000
Maximum value	2004-07-29 00:00:00.000
Unique values	714