IC11 Header Comments

Sort:
You are not authorized to post a reply.
Author
Messages
Me
Veteran Member
Posts: 96
Veteran Member
    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

      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
        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: 468
        Veteran Member
          did you try l_hite?
          You are not authorized to post a reply.