WO1    Work Order Master File (WO1_WorkOrderMaster)                             Level: 4.40
        Record Type: 1    Work Order Header Record                               08/28/2009
 
 File Type: Mkeyed   Key Size: 7    Rec Len: 680     Min Len: 396    Define: Y

 Main Key (KNO=0)WorkOrder(1,7)
 2nd Key (KNO=1) ItemBillDescription(28,30)+WorkOrder(1,7)
 3rd Key (KNO=2) ItemBillNumber(317,30)+WorkOrder(1,7)
 4th Key (KNO=3) UserDefinedField1(111,10)+WorkOrder(1,7)
 5th Key (KNO=4) UserDefinedField2(121,10)+WorkOrder(1,7)
 6th Key (KNO=5) UserDefinedField3(131,10)+WorkOrder(1,7)
 7th Key (KNO=6) UserDefinedField4(141,10)+WorkOrder(1,7)

 Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

 Work Order Number . . . . . . . . . . . WorkOrder . . . . . . . . . . Uppercase   *(1,7)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,20)
 Item Description. . . . . . . . . . . . ItemBillDescription . . . . . String      (28,30)
 U/M . . . . . . . . . . . . . . . . . . ItemUM. . . . . . . . . . . . Uppercase   (58,4)
 Bill Revision Code. . . . . . . . . . . BillRevision. . . . . . . . . Uppercase   (62,3)
 Bill Options. . . . . . . . . . . . . . BillOptions . . . . . . . . . Uppercase   (65,18)
 Effective Date. . . . . . . . . . . . . EffectiveDate . . . . . . . . Date        (83,6)
 Routing Number. . . . . . . . . . . . . RoutingNumber . . . . . . . . Uppercase   (89,20)
 Issue Method (A/B/M). . . . . . . . . . IssueMethod . . . . . . . . . Uppercase   (109,1)
   Auto, Backflush, Manual . . . . . . . . . . . . . . . . . . . . . . Memo
 Print Pick List . . . . . . . . . . . . PrntPickList. . . . . . . . . Yes/No      (110,1)
 User Defined Field 1. . . . . . . . . . UserDefinedField1 . . . . . . String      (111,10)
 User Defined Field 2. . . . . . . . . . UserDefinedField2 . . . . . . String      (121,10)
 User Defined Field 3. . . . . . . . . . UserDefinedField3 . . . . . . String      (131,10)
 User Defined Field 4. . . . . . . . . . UserDefinedField4 . . . . . . String      (141,10)
 Planner Code. . . . . . . . . . . . . . PlannerCode . . . . . . . . . Uppercase   (151,3)
 Copy From Template Number . . . . . . . CopyFromTemplate. . . . . . . Zero-Filled (154,7)
 Print Labels. . . . . . . . . . . . . . PrntLabels. . . . . . . . . . Yes/No      (161,1)
 Explode Sub-Assemblies. . . . . . . . . ExplodeSubassemblies. . . . . Yes/No      (162,1)
 Cost Completion Method. . . . . . . . . CostCmplMthd. . . . . . . . . Uppercase   (163,1)
   A=Actual,  P=Planned. . . . . . . . . . . . . . . . . . . . . . . . Memo
   L=Lower of actual or planned. . . . . . . . . . . . . . . . . . . . Memo
 Auto Issue Material Tran (Y, N, A). . . AutoIssueMatlTran . . . . . . Uppercase   (164,1)
   Y=Yes, N=No, A=Avail. . . . . . . . . . . . . . . . . . . . . . . . Memo
   No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
   Avail issues no more than QOH . . . . . . . . . . . . . . . . . . . Memo
 Auto Gen Labor Tran . . . . . . . . . . AutoGenLabTran. . . . . . . . Yes/No      (165,1)
   No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
 Auto Gen Outside Proc Tran. . . . . . . AutoGenOutsProcTran . . . . . Yes/No      (166,1)
   No if Issue Method is Manual. . . . . . . . . . . . . . . . . . . . Memo
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (167,14)
   Duplication Of Changes To WO5 . . . . . . . . . . . . . . . . . . . Memo
 Date Closed . . . . . . . . . . . . . . DateClosed. . . . . . . . . . Date        (181,6)
 Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (187,1)
 Make For (IM, WO, SO) . . . . . . . . . MakeFor . . . . . . . . . . . Uppercase   (188,1)
 Make For Order Number . . . . . . . . . MakeForOrderNumber. . . . . . Uppercase   (189,7)
 S/O Line Index. . . . . . . . . . . . . SOLineIndex . . . . . . . . . String      (196,6)
   (Or W/O Step # + 2 Blanks). . . . . . . . . . . . . . . . . . . . . Memo
 Parent Warehouse. . . . . . . . . . . . ParentWhse. . . . . . . . . . Account     (202,3)
 Component Warehouse . . . . . . . . . . DefaultComponentWhse. . . . . Account     (205,3)
 Status (Firm, Release, Close, Est). . . Status. . . . . . . . . . . . Uppercase   (208,1)
 W/O Date. . . . . . . . . . . . . . . . WODate. . . . . . . . . . . . Date        (209,6)
 W/O Due Date. . . . . . . . . . . . . . WODueDate . . . . . . . . . . Date        (215,6)
 Scheduled Release Date. . . . . . . . . SchedRelDate. . . . . . . . . Date        (221,6)
 Actual Production Start Date. . . . . . ActualProdStartDate . . . . . Date        (227,6)
 Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date        (233,6)
 Last Reschedule Date. . . . . . . . . . LastReschedDate . . . . . . . Date        (239,6)
 Prior Due Date (B/4 Last Resched) . . . PriorDueDate. . . . . . . . . Date        (245,6)
 User Who Performed Last Reschedule. . . UserWhoLastResched. . . . . . Uppercase   (251,3)
 On Hold . . . . . . . . . . . . . . . . OnHold. . . . . . . . . . . . Yes/No      (254,1)
 Status Comment Field. . . . . . . . . . StatusComment . . . . . . . . String      (255,30)
 W/O Traveler Printed. . . . . . . . . . TravelerPrinted . . . . . . . Yes/No      (285,1)
 Last Step Complete. . . . . . . . . . . LastStepComplete. . . . . . . Zero-Filled (286,4)
 Sub-Step Prefix . . . . . . . . . . . . SubstepPrefix . . . . . . . . Uppercase   (290,1)
 Sub-Step Suffix . . . . . . . . . . . . SubstepSuffix . . . . . . . . Zero-Filled (291,4)
 S/O Customer Division . . . . . . . . . CustomerDivision. . . . . . . String      (295,2)
 S/O Customer Number . . . . . . . . . . SOCustNumber. . . . . . . . . Account     (297,20)
 Item/Bill Number. . . . . . . . . . . . ItemBillNumber. . . . . . . . Uppercase   (317,30)
 Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (347,50)
 Link To First Detail Record . . . . . . LinkToFirstDetailRecord . . . Number      [0]       6.0
 U/M Conversion  Factor. . . . . . . . . UMConversion. . . . . . . . . Number      [1]       6.4
 Qty Ordered . . . . . . . . . . . . . . QtyOrdered. . . . . . . . . . Number      [2]       6.4
 Yield Percentage. . . . . . . . . . . . YieldPercentage . . . . . . . Number      [3]       3.3
 Qty Planned . . . . . . . . . . . . . . QtyPlanned. . . . . . . . . . Number      [4]       6.4
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5]       0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [6]       0.
 Qty Complete. . . . . . . . . . . . . . QtyComplete . . . . . . . . . Number      [7]       6.4
 Qty Transfered To Another W/O . . . . . QtyTransferred. . . . . . . . Number      [8]       6.4
 Qty Scrapped. . . . . . . . . . . . . . QtyScrapped . . . . . . . . . Number      [9]       6.4
 Calculated Lead Time. . . . . . . . . . CalcLeadTime. . . . . . . . . Number      [10]      4.0
 Qty Completed Today . . . . . . . . . . QtyCompletedToday . . . . . . Number      [11]      5.4
 Standard Labor Cost . . . . . . . . . . StdLaborCost. . . . . . . . . Number      [12]      7.2
 Actual Labor Cost (JTD) . . . . . . . . ActualLaborCost . . . . . . . Number      [13]      7.2
 Standard Material Cost. . . . . . . . . StdMaterialCost . . . . . . . Number      [14]      5.4
 Actual Material Cost (JTD). . . . . . . ActualMaterialCost. . . . . . Number      [15]      5.4
 Standard Outside Process Cost . . . . . StdOutsideProcessCost . . . . Number      [16]      7.2
 Actual Outside Process Cost (JTD) . . . ActualOutsideProcessCost. . . Number      [17]      7.2
 Standard Fixed Overhead Cost. . . . . . StdFixedOverheadCost. . . . . Number      [18]      7.2
 Actual Fixed Overhead Cost (JTD). . . . ActualFixedOverheadCost . . . Number      [19]      7.2
 Standard Variable Overhead Cost . . . . StdVariableOverheadCost . . . Number      [20]      7.2
 Actual Variable Ovhd Cost (JTD) . . . . ActualVariableOvhdCost. . . . Number      [21]      7.2
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [22]      0.
 Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [23]      0.
                                                                                   ________
                                                                      Total Bytes  637