IC14 - Table information

Hi the table in Lawson query (addins) is icmanfcode.

Fun trick : click on a field on the screen with the data you want (not the item group or FC) and hit CTRL-SHIFT-O. In the bottom left corner, you'll see some data appear on the grey task bar.

It tells you the table code, field name, how long the field as well as other stuff.

The table code is IMC for IC14.

Then, I went into addins and there is a table prefix translation that appears when you are starting a new query (botton left of query screen). I typed IMC in the refix and it told me that the table name is ICMANFCODE (IC).

Michelle - Thanks a MILLION!! What a great piece of information! I've used the CTL+Shft+O before to locate the field ID, but never knew what the code was or that you could use it on the Add in form.

This is great! I'll be sharing this one!!

Thanks to you to Sheri!!