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