WO_WorkOrder Work Order Master File Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/WO"+%C$+"/WO_WorkOrder.M4T"
KPRIMARY: WorkOrderNo
Fld Column Name M/L TUR Description/Notes Class
1 WorkOrderNo . . . . . . . . . 7 SYY Work Order Number . . . . . . .WORKORDERNO Notes: WO1$(1,7) 2 ItemCodeBillNo. . . . . . . . 30 SYN Item/Bill Number. . . . . . . .ITEMCODE Notes: WO1$(317,30) 3 ItemBillDesc. . . . . . . . . 30 SNN Item/Bill Description . . . . .DESCRIPTION Notes: WO1$(28,30) 4 UnitOfMeasure . . . . . . . . 4 SYN Unit Of Measure . . . . . . . .UNITOFMEASURE Notes: WO1$(58,4) 5 Revision. . . . . . . . . . . 3 SYN Revision Number . . . . . . . .REVISION Notes: WO1$(62,3) 6 BillOption1 . . . . . . . . . 2 SYN Bill Option 1 . . . . . . . . .BILLOPTION Notes: WO1$(65,2) 7 BillOption2 . . . . . . . . . 2 SYN Bill Option 2 . . . . . . . . .BILLOPTION Notes: WO1$(67,2) 8 BillOption3 . . . . . . . . . 2 SYN Bill Option 3 . . . . . . . . .BILLOPTION Notes: WO1$(69,2) 9 BillOption4 . . . . . . . . . 2 SYN Bill Option 4 . . . . . . . . .BILLOPTION Notes: WO1$(71,2) 10 BillOption5 . . . . . . . . . 2 SYN Bill Option 5 . . . . . . . . .BILLOPTION Notes: WO1$(73,2) 11 BillOption6 . . . . . . . . . 2 SYN Bill Option 6 . . . . . . . . .BILLOPTION Notes: WO1$(75,2) 12 BillOption7 . . . . . . . . . 2 SYN Bill Option 7 . . . . . . . . .BILLOPTION Notes: WO1$(77,2) 13 BillOption8 . . . . . . . . . 2 SYN Bill Option 8 . . . . . . . . .BILLOPTION Notes: WO1$(79,2) 14 BillOption9 . . . . . . . . . 2 SYN Bill Option 9 . . . . . . . . .BILLOPTION Notes: WO1$(81,2) 15 EffectiveDate . . . . . . . . 8 SNN Effective Date. . . . . . . . .DATE Notes: WO1$(83,6) 16 RoutingNo . . . . . . . . . . 20 SYN Routing Number. . . . . . . . . Notes: WO1$(89,20) 17 IssueMethod . . . . . . . . . 1 SYN Issue Method. . . . . . . . . . Valid:A,B,M Notes: WO1$(109, 1) 18 PrintPickingSheets. . . . . . 1 SYN Print Picking Sheet . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(110,1) 19 UserDefinedField1 . . . . . . 10 SNN User Defined Field 1. . . . . . Notes: WO1$(111,10) 20 UserDefinedField2 . . . . . . 10 SNN User Defined Field 2. . . . . . Notes: WO1$(121,10) 21 UserDefinedField3 . . . . . . 10 SNN User Defined Field 3. . . . . . Notes: WO1$(131,10) 22 UserDefinedField4 . . . . . . 10 SNN User Defined Field 4. . . . . . Notes: WO1$(141,10) 23 PlannerCode . . . . . . . . . 3 SYN Buyer Planner Code. . . . . . .BUYERPLANNERCODE Notes: WO1$(151,3) 24 CopyFromTemplateNo. . . . . . 7 SNN Copy From Template Number . . . Mask:0000000 Notes: WO1$(154, 7) 25 PrintWorkOrderLabels. . . . . 1 SYN Print Work Order Labels . . . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(161,1) 26 ExplodeSubAssemblies. . . . . 1 SYN Explode Sub Assemblies. . . . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(162,1) 27 CostCompletionMethod. . . . . 1 SYN Cost Completion Method. . . . . DfltVal:A Valid:A,P,L Notes: WO1$(163,1) 28 AutoIssueMaterial . . . . . . 1 SYN Auto Issue Material . . . . . . DfltVal:N Valid:Y,N,A Notes: WO1$(164,1) 29 AutoGenerateLabor . . . . . . 1 SYN Auto Generate Labor . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(165,1) 30 AutoGenerateOutsideProcess. . 1 SYN Auto Generate Outside Process .YESNO DfltVal:N Valid:Y,N Notes: WO1$(166,1) 31 DateClosed. . . . . . . . . . 8 SNN Date Closed . . . . . . . . . .DATE Notes: WO1$(181,6) 32 MakeFor . . . . . . . . . . . 1 SYN Make For. . . . . . . . . . . . Notes: WO1$(188,1) 33 MakeForOrderNo. . . . . . . . 7 SYN Make For Order Number . . . . . Notes: WO1$(189,7) 34 SalesOrderLineKey . . . . . . 6 SNN Sales Order Line Key. . . . . . Mask:000000 Notes: WO1$(196, 6) 35 ParentWarehouseCode . . . . . 3 SNN Parent Warehouse Code . . . . .WAREHOUSE FmtType:CHARNUM Notes: WO1$(202,3) 36 ComponentWarehouseCode. . . . 3 SNN Component Warehouse Code. . . .WAREHOUSE FmtType:CHARNUM Notes: WO1$(205,3) 37 OrderStatus . . . . . . . . . 1 SYN Order Status. . . . . . . . . . Valid:F,R,C,E Notes: WO1$(208,1) 38 WorkOrderDate . . . . . . . . 8 SNN Work Order Date . . . . . . . .DATE Notes: WO1$(209,6) 39 WorkOrderDueDate. . . . . . . 8 SNN Work Order Due Date . . . . . .DATE Notes: WO1$(215,6) 40 ScheduledReleaseDate. . . . . 8 SNN Scheduled Release Date. . . . .DATE Notes: WO1$(221,6) 41 ActualProductionStartDate . . 8 SNN Actual Production Start Date. .DATE Notes: WO1$(227,6) 42 LastActivityDate. . . . . . . 8 SNN Last Activity Date. . . . . . .DATE Notes: WO1$(233,6) 43 LastRescheduleDate. . . . . . 8 SNN Last Reschedule Date. . . . . .DATE Notes: WO1$(239,6) 44 PriorDueDate. . . . . . . . . 8 SNN Prior Due Date. . . . . . . . .DATE Notes: WO1$(245,6) 45 LastRescheduledUserCode . . . 3 SNN User Who Performed Last Resched Notes: WO1$(251,3) 46 OnHold. . . . . . . . . . . . 1 SYN On Hold . . . . . . . . . . . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(254,1) 47 StatusComment . . . . . . . . 30 SNN Status Comment. . . . . . . . . Notes: WO1$(255,30) 48 WorkOrderTravelerPrinted. . . 1 SYN Work Order Traveler Printed . .YESNO DfltVal:N Valid:Y,N Notes: WO1$(285,1) 49 LastStepCompleted . . . . . . 4 SNN Last Step Completed . . . . . . Mask:0000 Notes: WO1$(286,4) 50 SubStepPrefix . . . . . . . . 1 SYN Sub Step Prefix . . . . . . . . Notes: WO1$(290,1) 51 SubStepSuffix . . . . . . . . 4 SNN Sub Step Suffix . . . . . . . . Mask:0000 Notes: WO1$(291,4) 52 SalesOrderARDivisionNo. . . . 2 SNN Sales Order AR Division Number.ARDIVISION Mask:00 Notes: WO1$(295,2) 53 SalesOrderCustomerNo. . . . . 20 SYN Customer Number . . . . . . . .CUSTOMERNO Notes: WO1$(297,20) 54 UnitOfMeasureConvFactor . . . 12.4 NNN Unit Of Measure Conversion FactUMCONVFACTOR Mask:#####0.0000 Notes: WO1$[1] 55 QuantityOrdered . . . . . . . 16.6 NNN Quantity Ordered. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[2] 56 YieldPercent. . . . . . . . . 10.2 NNN Yield Percentage. . . . . . . .PERCENTAGE Mask:###,###.00- Notes: WO1$[3] 57 QuantityPlanned . . . . . . . 16.6 NNN Quantity Planned. . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[4] 58 QuantityCompleted . . . . . . 16.6 NNN Quantity Completed. . . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[7] 59 QuantityTransferred . . . . . 16.6 NNN Quantity Transferred. . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[8] 60 QuantityScrapped. . . . . . . 16.6 NNN Quantity Scrapped . . . . . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[9] 61 CalculatedLeadTime. . . . . . 4.0 NNN Calculated Lead Time. . . . . . Mask:###0 Notes: WO1$[10] 62 QuantityCompletedToday. . . . 16.6 NNN Quantity Completed Today. . . .QUANTITY Mask:##,###,###.000000- Notes: WO1$[11] 63 StandardLaborCost . . . . . . 16.6 NNN Standard Labor Cost . . . . . .COST Mask:##,###,###.000000- Notes: WO1$[12] 64 ActualLaborCost . . . . . . . 16.6 NNN Actual Labor Cost . . . . . . .COST Mask:##,###,###.000000- Notes: WO1$[13] 65 StandardMaterialCost. . . . . 16.6 NNN Standard Material Cost. . . . .COST Mask:##,###,###.000000- Notes: WO1$[14] 66 ActualMaterialCost. . . . . . 16.6 NNN Actual Material Cost. . . . . .COST Mask:##,###,###.000000- Notes: WO1$[15] 67 StandardOutsideProcessCost. . 16.6 NNN Standard Outside Process Cost .COST Mask:##,###,###.000000- Notes: WO1$[16] 68 ActualOutsideProcessCost. . . 16.6 NNN Actual Outside Process Cost . .COST Mask:##,###,###.000000- Notes: WO1$[17] 69 StandardFixedOverheadCost . . 16.6 NNN Standard Fixed Overhead Cost. .COST Mask:##,###,###.000000- Notes: WO1$[18] 70 ActualFixedOverheadCost . . . 16.6 NNN Actual Fixed Overhead Cost. . .COST Mask:##,###,###.000000- Notes: WO1$[19] 71 StandardVariableOverheadCost. 16.6 NNN Standard Variable Overhead CostCOST Mask:##,###,###.000000- Notes: WO1$[20] 72 ActualVariableOverheadCost. . 16.6 NNN Actual Variable Overhead Cost .COST Mask:##,###,###.000000- Notes: WO1$[21] 73 DateCreated . . . . . . . . . 8 SNN Date Created. . . . . . . . . .DATE 74 TimeCreated . . . . . . . . . 8 SNN Time Created. . . . . . . . . .TIME 75 UserCreatedKey. . . . . . . . 10 SNN User Created Key. . . . . . . .USER Mask:0000000000 76 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE 77 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .TIME 78 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER Mask:0000000000