WO2 Work Order Material Detail (WO2_WorkOrderMaterialDetail) Level: 4.40 Record Type: 1 Work Order Material Line Detail 08/28/2009 File Type: Indexed Key Size: Rec Len: 356 Min Len: 0 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Number (Tag Field) . . . . . WorkOrder . . . . . . . . . . Uppercase (1,7) Link To Prev Line (0=First) . . . . . . PreviousIndexNumber . . . . . Number [0] 5.0 Link To Next Line (0=Last). . . . . . . LinkToNextLine. . . . . . . . Number [1] 5.0 Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (1,20) Revision. . . . . . . . . . . . . . . . Revision. . . . . . . . . . . Uppercase (21,3) Step Number . . . . . . . . . . . . . . StepNumber. . . . . . . . . . Zero-Filled (24,4) U/M . . . . . . . . . . . . . . . . . . UM. . . . . . . . . . . . . . Uppercase (28,4) Item Description. . . . . . . . . . . . ItemDescription . . . . . . . String (32,30) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (62,19) Warehouse . . . . . . . . . . . . . . . Whse. . . . . . . . . . . . . Account (81,3) Component Item Number . . . . . . . . . ComponentItemNumber . . . . . Uppercase (84,30) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (114,50) Qty/Parent. . . . . . . . . . . . . . . QtyParent . . . . . . . . . . Number [0] 6.4 U/M Conversion Factor . . . . . . . . . UMconversion. . . . . . . . . Number [1] 6.4 Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [2] 5.4 Scrap Percent . . . . . . . . . . . . . ScrapPercent. . . . . . . . . Number [3] 3.4 Extended Qty Required . . . . . . . . . ExtdQtyRequired . . . . . . . Number [4] 6.4 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [5] 0. Qty Issued. . . . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [6] 6.4 Qty Committed (In Im2 - Entry U/M). . . QtyCommitted. . . . . . . . . Number [7] 6.4 Direct Costs Incurred . . . . . . . . . DirectCosts . . . . . . . . . Number [8] 7.2 Fixed Overhead Costs Incurred . . . . . FixedOvhdCosts. . . . . . . . Number [9] 7.2 Variable Overhead Costs Incurred. . . . VariableOvhdCosts . . . . . . Number [10] 7.2 Std Fixed Overhead Amount . . . . . . . StdFixedOverheadAmount. . . . Number [11] 7.2 Std Var Overhead Amount . . . . . . . . StdVarOverheadAmount. . . . . Number [12] 7.2 Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [13] 0. ________ Total Bytes 338