Table 'Production.WorkOrder', Manufacturing work orders.

Table 'Production.WorkOrder', Manufacturing work orders.

Property NameProperty Value
Records72591
Fields10
Record size (bytes) w/o BLOBs84

Field statistics for 'WorkOrderID' int identity

Field propertyProperty Value
Minimum value1
Maximum value72591
Average value36296.0
Values variance439127156.0
Unique values72591

Field statistics for 'ProductID' int

Field propertyProperty Value
Minimum value3
Maximum value999
Average value704.32783678417434
Values variance49655.052653811996
Unique values238

Field statistics for 'OrderQty' int

Field propertyProperty Value
Minimum value1
Maximum value39570
Average value62.097518976181618
Values variance468514.9963447192
Unique values903

Field statistics for 'StockedQty' int

Field propertyProperty Value
Minimum value1
Maximum value39570
Average value61.95079279800526
Values variance466917.14291544113
Unique values1013

Field statistics for 'ScrappedQty' smallint

Field propertyProperty Value
Minimum value0
Maximum value673
Average value0.14672617817635794
Values variance23.10478329627006
Unique values87

Field statistics for 'StartDate' 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 'EndDate' datetime

Field propertyProperty Value
Minimum value2001-07-14 00:00:00.000
Maximum value2004-07-18 00:00:00.000
Unique values1098

Field statistics for 'DueDate' 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 'ScrapReasonID' smallint

Field propertyProperty Value
Minimum value1
Maximum value16
Average value8.7242798353909468
Values variance22.43348935015602
Unique values16

Field statistics for 'ModifiedDate' datetime

Field propertyProperty Value
Minimum value2001-07-14 00:00:00.000
Maximum value2004-07-18 00:00:00.000
Unique values1098