I'm writing a report off the PO Audit table, POAUDIT, DBPOPAU on the AS400. There are field numbers in the table that refer to PO fields, which are in a dictionary table that I can't seem to locate. In the HR system, that table is called PADICT, DBHRPAD on the AS400. It's indexed on field number, and provides item names, headings and other attributes for each field in the HR application.

Anyone know what the corresponding table is for the PO application? I thought I was onto something with ICDICT, DBICIDI on the AS400, but that table is empty.

Thanks,

Mike
.

More info: I found that IC180 must be run to load DBICIDI, so I did that. This doesn't appear to be the PO dictionary table. Also, duh, the PO66.1 was already showing field names from the dictionary before the load. Arrg.

Try running 'dbdoc' against PO66 - it SHOULD tell you all the tables read or updated...