• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Human Capital Management Lawson S3 HR/Payroll/Benefits

Reason Descriptions in PA52

 4 Replies
 0 Subscribed to this topic
 68 Subscribed to this forum
Sort:
Author
Messages
Dave Williams
Advanced Member Send Private Message
Posts: 27
Advanced Member
6/30/2014 7:27 PM
I can not find the Table and Field that stores the Reason Description on PA52.1 or 52.5.
When I do a Ctrl-Sht-O, LAWSON tells me it is "PCT-Reason1"  I believe this is referring to Table PERSACTION (which does have a "Reason_01" field in it BUT, I don't want the CODE, I want the Description that is linked to the CODE.  I have looked in PADICT and PADICT2 but don't see it there either.

Anyone know where I can find the Descriptions?

Thanks,

Dave Williams
John Henley
Send Private Message
Posts: 3351
6/30/2014 7:38 PM
Table is PCODES (PCO)
WHERE PCO.TYPE = 'RA' AND PCO.CODE = PCT.REASON
Thanks for using the LawsonGuru.com forums!
John
The.Sam.Groves
Veteran Member Send Private Message
Posts: 89
Veteran Member
6/30/2014 8:13 PM
Would this be version dependent? On my system they aren't in PCODE but PAACTREAS. At least database-wise they aren't.
Dave Williams
Advanced Member Send Private Message
Posts: 27
Advanced Member
6/30/2014 8:16 PM
Thanks John!
John Henley
Send Private Message
Posts: 3351
6/30/2014 8:27 PM
Posted By The.Sam.Groves on 06/30/2014 04:13 PM
Would this be version dependent? On my system they aren't in PCODE but PAACTREAS. At least database-wise they aren't.


Good catch. They were moved to PAACTREAS in 9.0.1.
Thanks for using the LawsonGuru.com forums!
John