I worked with major product that came from AS/400. If it was a "program" it started with a P. If it was a table it started with an F. The 400 had its own database engine which got incorporated into DB2. Tables were files, hence the F. The next 4 digits (yup, digits) of the table name was the major function area. If the table was header information then it ended in 001. Details were in 010. So F4201001 was purchase order headers I think. There was even a set of tables that I found that could be used as a dictionary so I wrote a table documenter.

I spend quite a bit of time writing data imports from legacy back end systems into our sales force / field force mobile systems. There is a big player that has a pricing table the the key column is customer number, followed by a space, followed the item number. Well most of the time. Sometimes there is a modifier stuck in between the two. But not always.

M<y current hobby is Quantum Mechanics. Soething simple and relaxing.