IC191

We will be undertaking a large conversion in the coming month or so. We are converting back to a vendor/items that were once in our system, but had the item information updated to our current supplier. I'd like to be able to pull all of our old descriptions that we had in the system prior to the first conversion. Does anyone know the table where all of the audit history is stored ie. IC191, IC192, etc.? Any insight would be helpful.
Thanks,
Kyle

Wichtige Hinweise zur PROFILE Donglelizenzierung.pdf

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

Hey,

There is an ICAUDIT table that stores a lot of the historical information for the IC screens. If you're looking for the old descriptions, that field number is 515. You should see a date for when the change was made, and a before image (original value) and an after image (current value). Hope that helps.

unknown

Thanks John. I'll take a look at that.

unknown

John,
Do you have a spreadsheet with the field number and associated field name? If not, do you happen to know where I could get this? I'd like to link the two so that I can reference the field name in my database.
Thanks,
Kyle

unknown

Hey, unfortunately I do not have a comprehensive spreadsheet. I'm working on defining that now. I have not been able to find anything out there that lists these field names so it's taking awhile. I'd be more than happy to share it when I have more info. But right now, I only have a few fields identified.

dechevar

The ICDICT table holds the field numbers and names.

unknown

You can also access the field numbers in portal by going to IC330, select the Change Field tab, then click on the drop down in Change Field.

unknown

THANKS! This is awesome! Could not find this in documentation anywhere!

unknown

All,
Thank you!! This is great. Much easier working with field names than field numbers.

Copyright © 2025 Infor. All rights reserved.