Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

Message text on MA66.2 - where is it stored?

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
George Graham
Veteran Member
Posts: 201
Veteran Member
3/28/2011 5:02 PM
    Anyone know where the comment text from the "Has Message" button on MA66.2 is stored? I can't seem to find it anywhere.
    Ragu Raghavan
    Veteran Member
    Posts: 476
    Veteran Member
    3/28/2011 5:35 PM
      Looks like it is controlled in the PD logic.

      SET CMTMAG-KFIND TO TRUE.
      PERFORM 900-FIND-BEGRNG-CMT-MAINVMSG.
      IF (CMTMAG-KFOUND)
      002880 MOVE "Has Message" TO MA66F2-MAG-MESSAGES
      ELSE
      MOVE "Add Message" TO MA66F2-MAG-MESSAGES
      END-IF.
      George Graham
      Veteran Member
      Posts: 201
      Veteran Member
      3/28/2011 8:01 PM
        Sorry - I misled with my question. I'm actually looking for the comment text that gets entered on the form **behind** the button once it is clicked. I can't find which table that is stored in. It has to be related to MAINVMSG in some way, but the ERD I have does not show anything.
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
        3/28/2011 8:56 PM
          Try L_HMAG and L_DMAG

          KB Article# 73079

          Where are attachments stored?


          Description:
          Several forms within Lawson allow attachments. Where is this data stored?


          Resolution:
          Most comments were changed from a separate table to be part of attachment logic and are handled by cobol routines within the programs. Attachments tables are named as L_HXXX (for headers) and L_XXX (for details), where XXX is the prefix of the table where the comment is attached. For example, comments attached to EMPLOYEE would be in L_HEMP or L_DEMP . Comments that do not exceed 500 characters will be stored in the header table; comments longer than 500 characters may overflow into the detail records.


          Additional Information:
          See the Applications Program Interfaces Environment manual for more information.

          Keywords:
          PA59 HR11