WO5    W/O Template Master File (WO5_TemplateMasterHeader)                      Level: 4.40
        Record Type: 1    W/O Template Header Record                             08/28/2009
 
 File Type: Mkeyed   Key Size: 7    Rec Len: 470     Min Len: 396    Define: Y

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

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

 Template Number  (T000000). . . . . . . TemplateNumber. . . . . . . . Uppercase   *(1,7)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (8,20)
 Item Description. . . . . . . . . . . . ItemDescription . . . . . . . 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 Work Order Number . . . . . . CopyFromWorkOrder . . . . . . Zero-Filled (154,7)
 Print Labels. . . . . . . . . . . . . . PrntLabels. . . . . . . . . . Yes/No      (161,1)
 Explode Sub-Assemblies. . . . . . . . . ExplodeSubs . . . . . . . . . Yes/No      (162,1)
 Cost Completion Method (A/P/L). . . . . CostCmplMthd. . . . . . . . . Uppercase   (163,1)
   A=Actual,  P=Planned. . . . . . . . . . . . . . . . . . . . . . . . Memo
   L=Lower of Actual or Planned. . . . . . . . . . . . . . . . . . . . Memo
 Auto Issue Material Trans (Y/N/A) . . . AutoIssueMatlTran . . . . . . Uppercase   (164,1)
   Y=Yes, N=No, A=Available. . . . . . . . . . . . . . . . . . . . . . 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,150)
 Item/Bill Number. . . . . . . . . . . . ItemBillNumber. . . . . . . . Uppercase   (317,30)
 Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . 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
 Quantity Planned. . . . . . . . . . . . QtyPlanned. . . . . . . . . . Number      [4]       6.4
 Pieces Per Label. . . . . . . . . . . . PiecesPerLabel. . . . . . . . Number      [5]       6.4
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [6]       0.
                                                                                   ________
                                                                      Total Bytes  469