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