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