WO_24 Crystal Picking Sheet Printing (WO_24CRWPickingSheet) Level: 4.40 Record Type: 1 W/O Label Selection Record 08/28/2009 File Type: Direct Key Size: 18 Rec Len: 574 Min Len: 425 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) Bill Revision Number. . . . . . . . . . RevisionNumber. . . . . . . . Uppercase (40,3) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (43,4) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase (47,4) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (51,30) Warehouse Number. . . . . . . . . . . . Warehouse . . . . . . . . . . Account (81,3) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (84,15) Extended Description ( Item Number ). . ExtendedDescription . . . . . Yes/No (99,1) Option Codes. . . . . . . . . . . . . . OptionCodes . . . . . . . . . String (100,27) User Defined 1 Date . . . . . . . . . . UserDefined1Date. . . . . . . Date (127,6) User Defined 1 Text . . . . . . . . . . UserDefined1Text. . . . . . . String (133,10) User Defined 2 Date . . . . . . . . . . UserDefined2Date. . . . . . . Date (143,6) User Defined 2 Text . . . . . . . . . . UserDefined2Text. . . . . . . String (149,10) User Defined 3 Date . . . . . . . . . . UserDefined3Date. . . . . . . Date (159,6) User Defined 3 Text . . . . . . . . . . UserDefined3Text. . . . . . . String (165,10) User Defined 4 Date . . . . . . . . . . UserDefined4Date. . . . . . . Date (175,6) User Defined 4 Text . . . . . . . . . . UserDefined4Text. . . . . . . String (181,10) Bin Location. . . . . . . . . . . . . . BinLocation . . . . . . . . . String (191,15) Comment 1 . . . . . . . . . . . . . . . Comment1. . . . . . . . . . . String (206,50) Comment 2 . . . . . . . . . . . . . . . Comment2. . . . . . . . . . . String (256,50) Sub-Step Prefix . . . . . . . . . . . . SubStepPrefix . . . . . . . . Uppercase (306,1) Sub-Step Suffix . . . . . . . . . . . . SubStepSuffix . . . . . . . . Zero-Filled (307,4) Work Center . . . . . . . . . . . . . . WorkCenter. . . . . . . . . . Uppercase (311,5) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase (316,30) Item Number . . . . . . . . . . . . . . IM1ItemNumber . . . . . . . . Uppercase (346,30) Operation Code. . . . . . . . . . . . . OperationCode . . . . . . . . Uppercase (376,5) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (381,45) Quantity Per Parent . . . . . . . . . . QuantityPerParent . . . . . . Number [0] 6.4 UM Conversion . . . . . . . . . . . . . UnitOfMeasureConversion . . . Number [1] 6.4 Specials Unit Cost. . . . . . . . . . . UnitCostSpecialItems. . . . . Number [2] 5.4 Scrap Percent . . . . . . . . . . . . . ScrapPercent. . . . . . . . . Number [3] 3.4 Extended Quantity Required. . . . . . . ExtendedQuantityRequired. . . Number [4] 6.4 Quantity Issued . . . . . . . . . . . . QuantityIssued. . . . . . . . Number [5] 6.4 Quantity Committed. . . . . . . . . . . QuantityCommitted . . . . . . Number [6] 6.4 Direct Costs Incurred . . . . . . . . . DirectCostsIncurred . . . . . Number [7] 7.2 Fixed Overhead Costs Incurred . . . . . FixedOverheadCostsIncurred. . Number [8] 7.2 Variable Overhead Costs Incurred. . . . VariableOverheadCostsIncurred Number [9] 7.2 Standard Fixed Overhead Amount. . . . . StandardFixedOverheadAmount . Number [10] 7.2 Standard Variable Overhead Amount . . . StandardVariableOverheadAmountNumber [11] 7.2 ________ Total Bytes 574