Attachment Database Files

Attachments, such as comments or URLs, are connected to data fields, records, or forms. When users add comments, the system stores the information in two attachment files that are related to the attachment-enabled data file and are named as follows:

  • L_H<Prefix>

  • L_D<Prefix>

where <Prefix> is the prefix of the data file to which the attachments are related; L_H indicates a header attachment file (the first 512 bytes of the attachment), and L_D indicates the detail attachment file (the remaining bytes, up to 32,000, of the attachment).

Attachment file uses the L_INDEX to link its records to the records in the data files. L_INDEX contains unique combinations of 4 alphanumeric and special characters. The maximum number of records each attachment file can contain is 74,805,200.