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