     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