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