PO20 comments

Legacy Contributor

what table are the comments stored in when adding a comment to the line item detail?  Thank you.

Jim Norbut

if you have access to SQL Mgmt Studio....here's a trick.



Asuming your looking for POLINE here.

so navigate to POLINE in the sql management studio application and click on the plus sign next to POLINE

then click on Indexes.



NOTICE that in front of the index sets is a 3 character code

in this case PLI (this is the prefix you need to know)



you can also get this from either dbdoc if you have access to lid and lookup how to use the dbdoc command

or if you have access to the Lawson Data File Text documentation from the support site...you can also look up a prefix for a table there by system code (in this case Purchase Order)



now....having said all that.



you then need to look at the L_ tables in sql

so find L_HPLI



then you'll need to take find the records your interested in POLINE

and match them up to the associated records in L_PHI by the L_INDEX field



SOMETHING LIKE THIS will at least give you a general idea of a starting point :



select TOP 500 COMPANY,

PO_NUMBER,

PO_RELEASE,

PO_CODE,

LINE_NBR,

POLINE.L_INDEX,

ATCHNBR,

NAME,

TYPE,

[OBJECT] FROM ls_apps.POLINE

join

ls_apps.L_HPLI ON

POLINE.L_INDEX = L_HPLI.L_INDEX

ORDER BY L_INDEX





the OBJECT field is what you will care about....and have to parse out the needed information.