Is there easy way to identify fields/tables

We are working on setting up our LSF9 security and looking for everywhere pay-related information is stored at. I can get the simple ones - EMPLOYEE.PAY-RATE, etc. But there are others out there that may not go by PAY-RATE name in other tables.

Seems I've done this before but it's been many years. Might want to take a look at PADICT/PADICT2 tables, but also might be help to search the Lawson metadata in your RDBMS.

Sorry I can't be of more help.

If you are finding the information from Employee/Manager Self Service, you can use the Fiddler tool, it will catch which table it is accessing.

You can explore database ERD's!!!!!!

tHats an excellent place where you can find Data dictionary related stuff!!!!!!!

https://www.lawsonguru.co...%20Field%20Names.pdf

Thanks VJ

Thanks, all! Know about fiddler. Hadn't thought about searching the metadata. All good suggestions.

Was really looking for some sort of a report, or easier way to find them all. Seems like there is no real good way other than digging in and searching.
Thanks again, all.