IMI I/M Transaction Entry Tier Dist. Detail (IMI_TransTierDistribution) Level: 4.40 Record Type: 1 Transaction Entry Tier Dist. Detail 08/28/2009 File Type: Mkeyed Key Size: 31 Rec Len: 48 Min Len: 32 Define: Y
Main Key (KNO=0)TransactionType(1,1)+RefNumber(2,10)+LineIndexNumber(12,5)+FifoLifoLotSerNumber(17,15) 2nd Key (KNO=1) FifoLifoLotSerNumber(17,15)+Recordtype(32,1)+TransactionType(1,1)+RefNumber(2,10)+LineInd
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Trans Type (12468=Sl,Iss,Trf,Adj,Rccpt) TransactionType . . . . . . . String *(1,1) Reference Number. . . . . . . . . . . . RefNumber . . . . . . . . . . Uppercase *(2,10) Line Index #. . . . . . . . . . . . . . LineIndexNumber . . . . . . . Zero-Filled *(12,5) Fifo/Lifo/Lot/Ser # . . . . . . . . . . FifoLifoLotSerNumber. . . . . Uppercase *(17,15) Rec Type (1-4 = Fif/Lif/Lot/Ser). . . . Recordtype. . . . . . . . . . String (32,1) Keep this file. It is needed. . . . . . . . . . . . . . . . . . . . Memo for 4.30 and earlier conversion.. . . . . . . . . . . . . . . . . . Memo Qty Received. . . . . . . . . . . . . . QtyReceived . . . . . . . . . Number [0] 8.3 ________ Total Bytes 48