Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

PO Audit Rule Field Names Table

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Jeremy
Veteran Member Send Private Message
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 Send Private Message
Posts: 477
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 Send Private Message
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!