Hello.

I'm new to Infor and I'm trying to extract data out of the database. I found the Text table without any trouble. Now I'd like to find where I can find the TextID for the inventory transactions. When I'm in session whinr1510m000, I can select a transaction and click on the text icon to see what has been entered by the user.

I'm extracting data out of the whinr110 table for the inventory movements but can't find the way to get the textid so I can relate it to the text table.

Any help would be appreciated. Thank you.

Cheers,
D.

Hi,

The texts are picked up from individual orders from their respective sessions.

e.g. For a Transaction related to Adjustment Order, the text will be shown from session whinh5120m100 i.e. table whinh520.

So, I guess you can go ahead from here.

Hi,

The texts are picked up from individual orders from their respective sessions.

e.g. For a Transaction related to Adjustment Order, the text will be shown from session whinh5120m100 i.e. table whinh520.

So, I guess you can go ahead from here.

Perfect, this is exactly what I was looking for.
Thanks a lot!