WOU W/O Transaction Entry Tier Distribution (WOU_TransEntryTierDistribut) Level: 4.40 Record Type: 1 W/O Transaction Entry Tier Dist Detail 08/28/2009 File Type: Mkeyed Key Size: 28 Rec Len: 60 Min Len: 30 Define: Y
Main Key (KNO=0)WorkOrderTransNumber(1,7)+LineIndex(8,6)+LotSerialNumber(14,15) 2nd Key (KNO=1) LotSerialNumber(14,15)+ItemType(29,1)+WorkOrderTransNumber(1,7)+LineIndex(8,6)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Work Order Transaction Number . . . . . WorkOrderTransNumber. . . . . Uppercase *(1,7) Line Index (From WOS) . . . . . . . . . LineIndex . . . . . . . . . . Zero-Filled *(8,6) Lot/Serial Number . . . . . . . . . . . LotSerialNumber . . . . . . . Uppercase *(14,15) Item Type (3=Lot, 4=Serial) . . . . . . ItemType. . . . . . . . . . . Uppercase (29,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (30,1) Qty Issued. . . . . . . . . . . . . . . QtyIssued . . . . . . . . . . Number [0] 6.4 Tier Unit Cost. . . . . . . . . . . . . TierUnitCost. . . . . . . . . Number [1] 8.4 ________ Total Bytes 60