Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

IC11 Header Comments

 3 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Me
Veteran Member
Posts: 96
Veteran Member
3/20/2019 4:06 PM
    Does anyone know what tables are associated with the header comments in IC11?  I've found the tables for the detail comments but not for the header comments.
    NatalieD
    Veteran Member
    Posts: 53
    Veteran Member
    3/21/2019 10:43 AM

      Are you referring to the IC18 comments? Below is a report we have run to find comments that weren't coded correctly and were showing up on POs...

       

       

      SELECT

      "ITCOMMENT"."ITEM_GROUP",

      "ITEMGROUP"."DESCRIPTION",

      "ITCOMMENT"."ITEM",

      "ITEMMAST"."DESCRIPTION",

      "ITEMMAST"."DESCRIPTION2",

      "ITCOMMENT"."R_COMMENT",

      "ITCOMMENT"."COM_TYPE",

      "ITCOMMENT"."BEGIN_DATE",

      "ITCOMMENT"."END_DATE",

      "ITEMMAST"."ACTIVE_STATUS"

       

       FROM   ("LAWSON"."ITCOMMENT" "ITCOMMENT" INNER JOIN "LAWSON"."ITEMGROUP" "ITEMGROUP" ON "ITCOMMENT"."ITEM_GROUP"="ITEMGROUP"."ITEM_GROUP") INNER JOIN "LAWSON"."ITEMMAST" "ITEMMAST" ON ("ITCOMMENT"."ITEM_GROUP"="ITEMMAST"."ITEM_GROUP") AND ("ITCOMMENT"."ITEM"="ITEMMAST"."ITEM")

       

      ORDER BY "ITCOMMENT"."ITEM"


      Me
      Veteran Member
      Posts: 96
      Veteran Member
      4/9/2019 6:02 PM
        Thank you Natalie.  I'm actually referencing the IC11 Header Comments.  I think they're also listed as Item Master Attachments.  Not sure where these are stored.  There's the option to store URLs for images and then there's a selection for item master attachments.  I can't seem to find the table where this data is stored.
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
        4/9/2019 6:49 PM
          did you try l_hite?