WO1_WorkOrderMaster Work Order Master File Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/WO"+%C$+"/WO1"+%C$+".soa"
Fld Column Name M/L TUR Description/Notes Class
1 WorkOrder . . . . . . . . . . 7 SYN Work Order Number . . . . . . . 2 _S4 . . . . . . . . . . . . . 20 SNN Open String . . . . . . . . . . 3 ItemBillDescription . . . . . 30 SNN Item Description. . . . . . . . 4 ItemUM. . . . . . . . . . . . 4 SYN U/M . . . . . . . . . . . . . . 5 BillRevision. . . . . . . . . 3 SYN Bill Revision Code. . . . . . . 6 BillOptions . . . . . . . . . 18 SYN Bill Options. . . . . . . . . . 7 EffectiveDate . . . . . . . . 6 SNN Effective Date. . . . . . . . .DATE*MAS90 8 RoutingNumber . . . . . . . . 20 SYN Routing Number. . . . . . . . . 9 IssueMethod . . . . . . . . . 1 SYN Issue Method (A/B/M). . . . . . Notes: Auto, Backflush, Manual 10 PrntPickList. . . . . . . . . 1 SYN Print Pick List . . . . . . . .YesNo 11 UserDefinedField1 . . . . . . 10 SNN User Defined Field 1. . . . . . 12 UserDefinedField2 . . . . . . 10 SNN User Defined Field 2. . . . . . 13 UserDefinedField3 . . . . . . 10 SNN User Defined Field 3. . . . . . 14 UserDefinedField4 . . . . . . 10 SNN User Defined Field 4. . . . . . 15 PlannerCode . . . . . . . . . 3 SYN Planner Code. . . . . . . . . . 16 CopyFromTemplate. . . . . . . 7 SNN Copy From Template Number . . . Mask:0000000 17 PrntLabels. . . . . . . . . . 1 SYN Print Labels. . . . . . . . . .YesNo 18 ExplodeSubassemblies. . . . . 1 SYN Explode Sub-Assemblies. . . . .YesNo 19 CostCmplMthd. . . . . . . . . 1 SYN Cost Completion Method. . . . . Notes: A=Actual, P=PlannedL =Lower of actual or planned 20 AutoIssueMatlTran . . . . . . 1 SYN Auto Issue Material Tran (Y, N, Notes: Y=Yes, N=No, A=AvailNo if Issue Method is ManualAvail issues no more than QOH 21 AutoGenLabTran. . . . . . . . 1 SYN Auto Gen Labor Tran . . . . . .YesNo Notes: No if Issue Method is Manual 22 AutoGenOutsProcTran . . . . . 1 SYN Auto Gen Outside Proc Tran. . .YesNo Notes: No if Issue Method is Manual 23 _S1 . . . . . . . . . . . . . 14 SNN Open String . . . . . . . . . . Notes: Duplication Of Changes To WO5 24 DateClosed. . . . . . . . . . 6 SNN Date Closed . . . . . . . . . .DATE*MAS90 25 _S2 . . . . . . . . . . . . . 1 SNN Open String . . . . . . . . . . 26 MakeFor . . . . . . . . . . . 1 SYN Make For (IM, WO, SO) . . . . . 27 MakeForOrderNumber. . . . . . 7 SYN Make For Order Number . . . . . 28 SOLineIndex . . . . . . . . . 6 SNN S/O Line Index. . . . . . . . . Notes: (Or W/O Step # + 2 Blanks) 29 ParentWhse. . . . . . . . . . 3 SNN Parent Warehouse. . . . . . . .Accnt 30 DefaultComponentWhse. . . . . 3 SNN Component Warehouse . . . . . .Accnt 31 Status. . . . . . . . . . . . 1 SYN Status (Firm, Release, Close, E 32 WODate. . . . . . . . . . . . 6 SNN W/O Date. . . . . . . . . . . .DATE*MAS90 33 WODueDate . . . . . . . . . . 6 SNN W/O Due Date. . . . . . . . . .DATE*MAS90 34 SchedRelDate. . . . . . . . . 6 SNN Scheduled Release Date. . . . .DATE*MAS90 35 ActualProdStartDate . . . . . 6 SNN Actual Production Start Date. .DATE*MAS90 36 LastActivityDate. . . . . . . 6 SNN Last Activity Date. . . . . . .DATE*MAS90 37 LastReschedDate . . . . . . . 6 SNN Last Reschedule Date. . . . . .DATE*MAS90 38 PriorDueDate. . . . . . . . . 6 SNN Prior Due Date (B/4 Last RescheDATE*MAS90 39 UserWhoLastResched. . . . . . 3 SYN User Who Performed Last Resched 40 OnHold. . . . . . . . . . . . 1 SYN On Hold . . . . . . . . . . . .YesNo 41 StatusComment . . . . . . . . 30 SNN Status Comment Field. . . . . . 42 TravelerPrinted . . . . . . . 1 SYN W/O Traveler Printed. . . . . .YesNo 43 LastStepComplete. . . . . . . 4 SNN Last Step Complete. . . . . . . Mask:0000 44 SubstepPrefix . . . . . . . . 1 SYN Sub-Step Prefix . . . . . . . . 45 SubstepSuffix . . . . . . . . 4 SNN Sub-Step Suffix . . . . . . . . Mask:0000 46 CustomerDivision. . . . . . . 2 SNN S/O Customer Division . . . . . 47 SOCustNumber. . . . . . . . . 20 SNN S/O Customer Number . . . . . .Accnt 48 ItemBillNumber. . . . . . . . 30 SYN Item/Bill Number. . . . . . . . 49 _S3 . . . . . . . . . . . . . 50 SNN Open String . . . . . . . . . . 50 LinkToFirstDetailRecord . . . 8.0 NNN Link To First Detail Record . . Mask:#####0 51 UMConversion. . . . . . . . . 12.4 NNN U/M Conversion Factor. . . . . Mask:#####0.0000 52 QtyOrdered. . . . . . . . . . 11.3 NNN Qty Ordered . . . . . . . . . . Mask:#####0.000 53 YieldPercentage . . . . . . . 8.3 NNN Yield Percentage. . . . . . . . Mask:##0.000 54 QtyPlanned. . . . . . . . . . 11.3 NNN Qty Planned . . . . . . . . . . Mask:#####0.000 55 _N1 . . . . . . . . . . . . . 1.0 NNN Open Number . . . . . . . . . . 56 _N2 . . . . . . . . . . . . . 1.0 NNN Open Number . . . . . . . . . . 57 QtyComplete . . . . . . . . . 11.3 NNN Qty Complete. . . . . . . . . . Mask:#####0.000 58 QtyTransferred. . . . . . . . 11.3 NNN Qty Transfered To Another W/O . Mask:#####0.000 59 QtyScrapped . . . . . . . . . 11.3 NNN Qty Scrapped. . . . . . . . . . Mask:#####0.000 60 CalcLeadTime. . . . . . . . . 6.0 NNN Calculated Lead Time. . . . . . Mask:###0 61 QtyCompletedToday . . . . . . 11.4 NNN Qty Completed Today . . . . . . Mask:####0.0000 62 StdLaborCost. . . . . . . . . 11.2 NNN Standard Labor Cost . . . . . . Mask:######0.00 63 ActualLaborCost . . . . . . . 11.2 NNN Actual Labor Cost (JTD) . . . . Mask:######0.00 64 StdMaterialCost . . . . . . . 11.4 NNN Standard Material Cost. . . . . Mask:####0.0000 65 ActualMaterialCost. . . . . . 11.4 NNN Actual Material Cost (JTD). . . Mask:####0.0000 66 StdOutsideProcessCost . . . . 11.2 NNN Standard Outside Process Cost . Mask:######0.00 67 ActualOutsideProcessCost. . . 11.2 NNN Actual Outside Process Cost (JT Mask:######0.00 68 StdFixedOverheadCost. . . . . 11.2 NNN Standard Fixed Overhead Cost. . Mask:######0.00 69 ActualFixedOverheadCost . . . 11.2 NNN Actual Fixed Overhead Cost (JTD Mask:######0.00 70 StdVariableOverheadCost . . . 11.2 NNN Standard Variable Overhead Cost Mask:######0.00 71 ActualVariableOvhdCost. . . . 11.2 NNN Actual Variable Ovhd Cost (JTD) Mask:######0.00 72 _N3 . . . . . . . . . . . . . 1.0 NNN Open Number . . . . . . . . . . 73 _N4 . . . . . . . . . . . . . 1.0 NNN Open Number . . . . . . . . . .