Since I have an option to build indices for all tables, I suppose when the file was placed in data environment, the index went with it (nothing else on my part).
When the table is opened in the command window and set order to the tag, it moves the record to the appropriate location.
Thanks again