Prev
Next
Forums Lawson S3 Procurement

PO Audit Rule Field Names Table

Sort:
You are not authorized to post a reply.
Author
Messages
Jeremy
Veteran Member
Posts: 129
Veteran Member
5/13/2020 2:55 PM

    I am attempting to download via add-ins, or even a SQL query, our PO Audit Rule Maintenance settings from PO01.2 in preparation for creating them in CSF.  However, I cannot find the table that houses the field names!

    POAUDRULES has the actual rules, but they use fiend NUMBERS.   I need to cross reference to the table that has the fieldn number and NAMES.  Does anyone know what this table may be named?

    Ragu Raghavan
    Veteran Member
    Posts: 468
    Veteran Member
    5/14/2020 2:49 PM
      I see this in the documentation related to the table POAUDRULES -

      This file contains rules for auditing PO source records. The descriptions for
      each field are contained in the following message categories under the
      associated field number:

      PO Header - POAHD
      PO Line - POALN
      PO AOC - POALA
      PO Spread - POAHA

      So looks like you need to go to msgmnt POAHD or POALN etc. to get the field desc based on the field nbr. Or if you have access to the GEN tables, lookup CRTERRMAP, I think.
      Jeremy
      Veteran Member
      Posts: 129
      Veteran Member
      5/15/2020 5:29 PM

        Thank you. I can confirm what you suggested works.  One of our developers found this, too, and pulled the messages for me.  What a pain!

        You are not authorized to post a reply.