How are comment attachments stored?

Answer: Comment attachments reside in the same product line as the data they are attached to. They are used to associate comments with a specific row in a database table used by a Lawson Application. In addition to the database table that stores your data, two additional tables will be created to store your attachments: the header table and the detail table.

The header table will contain information about who created/modified the attachment, along with date information on when the attachment was created/modified. The header table also contains the first 512 bytes of the actual attachment information.

If there is more than 512 bytes of attachment data, the overflow is placed in the detail table. The naming convention is L_HXXX and L_DXXX, where XXX is the prefix of the parent table. If the prefix name of the parent data table is GRN, the header table will be L_HGRN and the detail table name will be L_DGRN.

For more information comment attachments search the refer to the Lawson online user help or search the Infor Knowledge base.