WO_28  Crystal Traveler Sheet Printing (WO_28CRWTraveler)                       Level: 4.40
        Record Type: 1    W/O Label Selection Record                             08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 500     Min Len: 450    Define: Y

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

 Workstation Fid & Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type . . . . . . . . . . . . . . . LineType. . . . . . . . . . . Uppercase   (19,1)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (20,20)
 Revision Number . . . . . . . . . . . . Revision. . . . . . . . . . . Uppercase   (40,3)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (43,4)
 Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase   (47,4)
 Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String      (51,30)
 Reserved for WO6 Changes. . . . . . . . ReservedForWO6. . . . . . . . String      (81,19)
 Warehouse Number. . . . . . . . . . . . Warehouse . . . . . . . . . . Account     (100,3)
 Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (103,15)
 Extended Description ( Item Number ). . IM1Extended . . . . . . . . . Yes/No      (118,1)
 Open String . . . . . . . . . . . . . . _S4 . . . . . . . . . . . . . Open String (119,17)
 Option Codes. . . . . . . . . . . . . . OptionCodes . . . . . . . . . String      (136,27)
 User Defined Date 1 . . . . . . . . . . UserDefined1Date. . . . . . . Date        (163,6)
 User Defined Text 1 . . . . . . . . . . UserDefined1Text. . . . . . . String      (169,10)
 User Defined Date 2 . . . . . . . . . . UserDefined2Date. . . . . . . Date        (179,6)
 User Defined Text 2 . . . . . . . . . . UserDefined2Text. . . . . . . String      (185,10)
 User Defined Date 3 . . . . . . . . . . UserDefined3Date. . . . . . . Date        (195,6)
 User Defined Text 3 . . . . . . . . . . UserDefined3Text. . . . . . . String      (201,10)
 User Defined Date 4 . . . . . . . . . . UserDefined4Date. . . . . . . Date        (211,6)
 User Defined Text 4 . . . . . . . . . . UserDefined4Text. . . . . . . String      (217,10)
 Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (227,4)
 Open String . . . . . . . . . . . . . . _S5 . . . . . . . . . . . . . Open String (231,5)
 Item Description 1. . . . . . . . . . . ItemDescription1. . . . . . . String      (236,30)
 Open String . . . . . . . . . . . . . . _S6 . . . . . . . . . . . . . Open String (266,10)
 Status Comment. . . . . . . . . . . . . StatusComment . . . . . . . . String      (276,10)
 Make For. . . . . . . . . . . . . . . . MakeFor . . . . . . . . . . . String      (286,3)
 Item Description 2. . . . . . . . . . . ItemDescription2. . . . . . . String      (289,30)
 Make For Customer Division. . . . . . . MakeForCustomerDivision . . . String      (319,2)
 Make For Customer . . . . . . . . . . . MakeForCustomer . . . . . . . Account     (321,20)
 Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase   (341,30)
 Item Number . . . . . . . . . . . . . . IM1ItemNumber . . . . . . . . Uppercase   (371,30)
 Open String . . . . . . . . . . . . . . _S7 . . . . . . . . . . . . . Open String (401,50)
 Qty Per Parent. . . . . . . . . . . . . QtyPerParent. . . . . . . . . Number      [0]       6.4
 Unit Cost (Specials Only) . . . . . . . UnitCostSpecialsOnly. . . . . Number      [1]       5.4
 Scrap Percent . . . . . . . . . . . . . ScrapPercent. . . . . . . . . Number      [2]       3.4
 Extended Qty Required . . . . . . . . . ExtendedQtyRequired . . . . . Number      [3]       6.4
                                                                                   ________
                                                                      Total Bytes  500
 

 WO_28  Crystal Traveler Sheet Printing (WO_28CRWTraveler)                       Level: 4.40
        Record Type: 2    W/O Operation (Step) Detail Record                     08/28/2009
 
 File Type: Direct   Key Size: 18   Rec Len: 500     Min Len: 450    Define: Y

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

 Workstation Fid & Session Id. . . . . . UserFid . . . . . . . . . . . Zero-Filled *(1,6)
 Work Order Number . . . . . . . . . . . WorkOrderNumber . . . . . . . Uppercase   *(7,7)
 Line Number . . . . . . . . . . . . . . LineNumber. . . . . . . . . . Zero-Filled *(14,5)
 Line Type . . . . . . . . . . . . . . . LineType. . . . . . . . . . . Uppercase   (19,1)
 Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase   (20,5)
 Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase   (25,5)
 Step Description. . . . . . . . . . . . StepDescription . . . . . . . String      (30,30)
 Extended Description. . . . . . . . . . ExtendedDescription . . . . . Yes/No      (60,1)
 Ignore Queue Time?. . . . . . . . . . . IgnoreQueueTime . . . . . . . Yes/No      (61,1)
 Std Run Time Type (L/O/H) . . . . . . . StdRunTimeType. . . . . . . . Uppercase   (62,1)
   Lot, Operations/hr, Hrs/operation . . . . . . . . . . . . . . . . . Memo
 Parent Item Type  (O/P) . . . . . . . . ParentItemType. . . . . . . . Uppercase   (63,1)
   Operations/parent, Parents/operation. . . . . . . . . . . . . . . . Memo
 Tooling Number. . . . . . . . . . . . . ToolingNumber . . . . . . . . Uppercase   (64,20)
 Reserved for WO7 Changes. . . . . . . . ReservedForWO7. . . . . . . . String      (84,20)
 Scheduled Start Date (Run). . . . . . . ScheduledStartDateRun . . . . Date        (104,6)
 Scheduled Completion Date . . . . . . . ScheduledCompletionDate . . . Date        (110,6)
 Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date        (116,6)
 Last Activity Date. . . . . . . . . . . LastActivityDate. . . . . . . Date        (122,6)
 Step Complete?. . . . . . . . . . . . . StepComplete. . . . . . . . . Yes/No      (128,1)
 Scheduled Start Date (Queue). . . . . . ScheduledStartDate. . . . . . Date        (129,6)
 Outside Processing? . . . . . . . . . . OutsideProcessing . . . . . . Yes/No      (135,1)
 Option Codes. . . . . . . . . . . . . . OptionCodes . . . . . . . . . String      (136,27)
 User Defined Field 1 Date . . . . . . . UserDefined1Date. . . . . . . Date        (163,6)
 User Defined Field 1 Text . . . . . . . UserDefined1Text. . . . . . . String      (169,10)
 User Defined Field 2 Date . . . . . . . UserDefined2Date. . . . . . . Date        (179,6)
 User Defined Field 2 Text . . . . . . . UserDefined2Text. . . . . . . String      (185,10)
 User Defined Field 3 Date . . . . . . . UserDefined3Date. . . . . . . Date        (195,6)
 User Defined Field 3 Text . . . . . . . UserDefined3Text. . . . . . . String      (201,10)
 User Defined Field 4 Date . . . . . . . UserDefined4Date. . . . . . . Date        (211,6)
 User Defined Field 4 Text . . . . . . . UserDefined4Text. . . . . . . String      (217,10)
 Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (227,4)
 Sub Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase   (231,1)
 Sub Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (232,4)
 Item Description 1. . . . . . . . . . . ItemDescription1. . . . . . . String      (236,30)
 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (266,10)
 Status Comment. . . . . . . . . . . . . StatusComment . . . . . . . . String      (276,10)
 Make For Module . . . . . . . . . . . . MakeForModule . . . . . . . . String      (286,3)
 Item Description 2. . . . . . . . . . . ItemDescription2. . . . . . . String      (289,30)
 Make for Customer Division. . . . . . . MakeForCustomerDivision . . . String      (319,2)
 Make For Customer Number. . . . . . . . MakeForCustomer . . . . . . . Account     (321,20)
 Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (341,110)
 Extended Standard Time. . . . . . . . . ExtendedStandardTime. . . . . Number      [0]       6.3
 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [1]       0.
 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [2]       0.
 Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                   ________
                                                                      Total Bytes  467