     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 . . . . . . . . . .