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