Prev
Next
Forums Integration / Customization IPA/ProcessFlow

L_HRQH and "Requesition Header Display Only Comments"

 2 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Joe Haveman
Advanced Member
Posts: 31
Advanced Member
12/18/2009 11:43 AM

    I'm working with the ReqHeader, RQ10 and RSS.  I've got a request to update our recsum.htm and I need to find this particular data.  The data is entered on the RQ10 by clicking the "Add Comment" button in the middle of the page or using comment codes in RSS (req self service).

    I've been told that the comments are here:

    Comments are stored in the product line in what is referred to as the "L_index".   The convention is L_HXXX or L_DXXX where the "H" stands for header record and the "D" for detail record.  XXX represents the 3-character table abbreviation, e.g. table REQHEADER = RQH;  REQLINE = RLN;  PURCHORDER (p.o. header table) = PCR, POLINE = PLI, etc.  So a reqheader comment should be stored in L_HRQH.

    I have no idea where to find such a ?table?, L_HRQH.  Do I want to do a DME query?  What do I want to use to access this data in a pflow?

    Does anyone have any experience with this?

    Gary Davies
    Veteran Member
    Posts: 248
    Veteran Member
    12/18/2009 12:05 PM
      Req comments are in what are called "attachments" There are api's to read and write to them for both COBOL and from the web (getattach.exe and writeattachrec.exe). The data is stored in a BLOB so it can be difficult to read them using just SQL,
      David Williams
      Veteran Member
      Posts: 1127
      Veteran Member
      12/18/2009 12:28 PM
        Please see my blog posting which explains how to do this. My example shows how to get comments for a PO but the process is the same. This only picks up the last comment entered but I've also looped through the XML returned to pick up all comments.

        http://consultdavidw.blog...chrecexe-cgi-to.html
        David Williams