What table has field SKI_DATE_LST_USED

Try this from a LID prompt Donna:


This should give you a listing of all of your tables and their 3-digit prefix code. Then just look for the one that you want.

Greg,

Thank you. As usual, I looked up the table in the Lawson documentation and did not find the prefix.

We also, do not have that table here. What version of Lawson are you at? And what was the table name if I can ask?

Greg,

I am not sure where to look. I found the other fields I needed in EMPCODES and /or PCODES.

We are Lawson 9.0.1.9.153. I know this probably should be simple but I have not figured it out and it is creating an issue with a report. The legacy report does not have the field in it so I don't have a point fo reference. All my ancient docs on tables are at home so I may have to dust them off to find this field.

Thank you for being willing to help.

Donna

NB: https://www.lawsonguru.co...0-and-complete-date/
SKI-DATE-LST-USED is the COBOL field name on the form. While that *usually* corresponds to the correct table, in some cases it doesn't.
To find the *real* answer, you have to delve into the COBOL.
SKI-DATE-LST-USED is actually stored in the EPC-RENEW-DATE field in the EMPCODES table (EPC is the prefix).
EPC-COMPANY = employee's company, EPC-TYPE = "SK", EPC-EMP-APP = 0, EPC-EMPLOYEE = employee number, EPC-CODE = "SK", etc. .
And who said understanding COBOL was a dying skill???

John,

Thank you very much.

Donna