Table 'Production.WorkOrderRouting', Work order details.

Table 'Production.WorkOrderRouting', Work order details.

Property NameProperty Value
Records67131
Fields12
Record size (bytes) w/o BLOBs145

Field statistics for 'WorkOrderID' int

Field propertyProperty Value
Minimum value13
Maximum value72587
Average value38394.300129597352
Values variance418473076.70509434
Unique values42625

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value514
Maximum value999
Average value798.92957054118062
Values variance17473.10661417431
Unique values149

Field statistics for 'OperationSequence' smallint

Field propertyProperty Value
Minimum value1
Maximum value7
Average value5.1099641000431992
Values variance4.7172090721507676
Unique values7

Field statistics for 'LocationID' smallint

Field propertyProperty Value
Minimum value10
Maximum value60
Average value43.800777584126557
Values variance306.98468046194102
Unique values7

Field statistics for 'ScheduledStartDate' datetime

Field propertyProperty Value
Minimum value2001-07-04 00:00:00.000
Maximum value2004-07-03 00:00:00.000
Unique values1093

Field statistics for 'ScheduledEndDate' datetime

Field propertyProperty Value
Minimum value2001-07-15 00:00:00.000
Maximum value2004-07-14 00:00:00.000
Unique values1093

Field statistics for 'ActualStartDate' datetime

Field propertyProperty Value
Minimum value2001-07-04 00:00:00.000
Maximum value2004-07-18 00:00:00.000
Unique values671

Field statistics for 'ActualEndDate' datetime

Field propertyProperty Value
Minimum value2001-07-16 00:00:00.000
Maximum value2004-07-29 00:00:00.000
Unique values714

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

Field propertyProperty Value
Minimum value1.0000
Maximum value4.1000
Average value3.4106776303054547
Values variance0.41320968679442971
Unique values6

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

Field propertyProperty Value
Minimum value14.5000
Maximum value92.2500
Average value51.957657416096886
Values variance487.75516186809551
Unique values7

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

Field propertyProperty Value
Minimum value14.5000
Maximum value92.2500
Average value51.957657416096886
Values variance487.75516186809551
Unique values7

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2001-07-16 00:00:00.000
Maximum value2004-07-29 00:00:00.000
Unique values714