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