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