IC11 Header Comments

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"

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.

did you try l_hite?