     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