I have the following SQL statement:

SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
FROM price!pricelist;
GROUP BY pricelist.ITEM;
INTO TABLE temp.DBF

The results do not show an item number:

T97000-503

but it will show an item number:

T97000-503R

What may I be doing wrong?