I am looking for the table name the AP20.2 Comments write to. I am wanting to pull these comments into queries. In AP20.2 there is an "Add Comment" button on the screen. Within the comments you can add Report, Note or Check commnets. I need to know where all 3 different comment codes are stored. Can anyone help me out?

Not sure where the "comment codes" are stored, but I believe AP invoice comments are stored in the L_HAPI table, which joins to APINVOICE on the L_INDEX field.

Could you give some tech background, especially what application level you're on? If I try looking up the files in our 8.0.3 ESP9 applications, I may send you in the wrong direction.

cjmart is right. Assuming you're at least on 8.0.3 apps/env, comments are now stored in special 'attachment' tables. While you can not see these tables in dbdef, you can see them when you do a count (e.g. prompt> count prod | lashow. The table(s) you'll be looking for are L_HAPI and L_DAPI. I have not personally explored these tables in depth, but they are the 'header' and 'detail' comments for the invoice itself. AP Payment (check) comments would be stored in L_HAPP & L_DAPP.

Try looking at the Lawson API guide for predefined routines to access these comments. Chapter 8 deals with these. (document EAPI-803W-02 on support.lawson.com)

I had a former client try to pull these via Crystal with limited success. There were some comments that came out OK and others that were garbled with control chars. Something to do with the overall length of the comment and how Oracle stored the varchar string. A custom 4GL report may be the way to go using Lawson defined APIs.

A rngdbdump of the data would give you a quick looksee:

rngdbdump -c prod L_HAPI | lashow

Keith