PO9 P/O Receipt Entry Tier Dist Detail (PO9_RecptEntryTierDistDetail) Level: 4.40 Record Type: 1 Receipt Of Goods D.E. Tier Dist Detail 08/28/2009 File Type: Mkeyed Key Size: 27 Rec Len: 56 Min Len: 28 Define: Y
Main Key (KNO=0)ReceiptType(1,1)+ReceiptNumber(2,6)+LineIndex(8,5)+LotSerialNumber(13,15) 2nd Key (KNO=1) LotSerialNumber(13,15)+ItemType(28,1)+ReceiptType(1,1)+ReceiptNumber(2,6)+LineIndex(8,5)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Receipt Type (Goods,Invoice). . . . . . ReceiptType . . . . . . . . . Uppercase *(1,1) Receipt Number. . . . . . . . . . . . . ReceiptNumber . . . . . . . . Zero-Filled *(2,6) Line Index. . . . . . . . . . . . . . . LineIndex . . . . . . . . . . String *(8,5) Lot/Serial Number . . . . . . . . . . . LotSerialNumber . . . . . . . Uppercase *(13,15) Item Type (3=Lot, 4=Serial) . . . . . . ItemType. . . . . . . . . . . String (28,1) Keep this file. It is needed . . . . . . . . . . . . . . . . . . . Memo for 4.30 and earlier conversion.. . . . . . . . . . . . . . . . . . Memo Qty Shipped . . . . . . . . . . . . . . QtyShipped. . . . . . . . . . Number [0] 5.3 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [1] 0. ________ Total Bytes 42