Reason Descriptions in PA52

Sort:
You are not authorized to post a reply.
Author
Messages
Dave Williams
Advanced Member
Posts: 27
Advanced Member
    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
    Senior Member
    Posts: 3348
    Senior Member
      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
      Posts: 89
      Veteran Member
        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
        Posts: 27
        Advanced Member
          Thanks John!
          John Henley
          Senior Member
          Posts: 3348
          Senior Member
            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
            You are not authorized to post a reply.