Who's On?

	Membership:
	Latest: JVENGLEy
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5209

	People Online:
	Visitors: 406
	Members: 0
	Total: 406

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

PO Audit Rule Field Names Table

2 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Jeremy

Veteran Member

Posts: 129

New Poster

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: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

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

New Poster

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!