Skip to content
logo Knowledgebase

Where is my text comment stored?

Created on  | Last modified on 

Summary

Where can I find text entered by Users for certain transactions such as Sales Orders?

Description

I'm writing a Report or Requester to list text entries relating to Sales Orders. This could apply to other Transactions such as Purchase Receipts, and I'm having problems finding the actual data.

Resolution

The text is held in one of two tables, depending on where the User entered the text.

If you enter the text in the "Line text entry" action on a Sales Order Line, then it will be held in the TEXCLOB table. The lookup is between SORDERQ.SOQTEX_0 and TEXCLOB.CODE_0, and the content is in TEXTE_0.

If you're looking for text entered in the "Comment" action on the right-hand pane, then this is held in the ACLOB table. It has ACLOB.CODLIB_0 based on the abbreviation of the Object's name, the ACLOB.IDENT1_0 is the Transaction's Number and the content is in ACLOB.CLOB_0. For example, the CODLIB_0 is "CO_SOH" for a Sales Order and the IDENT1_0 is the same as the SORDER.SOHNUM_0.

Similarly, for Purchase Receipt Line text, the lookup is between PRECEIPTD.LINTEX_0 and TEXCLOB.CODE_0, and the content is in TEXTE_0. 

For a Purchase Receipt comment, the ACLOB.CODLIB_0 is "CO_PTH".