Sequence files

The audit-data is stored in a set of files called sequence files. Multiple sequence files can exist for each table and for each company number.

In addition to storing audit-data and transaction information, a sequence file also stores information about audited columns of the table and the audit-data dictionary.

The name of the sequence file is built using the table name and company number. The format of the sequence file name, where the prefix a indicates an audit file, just as t indicates a table itself, is:

a<mmmnnn><company number>.<sequence file number>

• mmm represents the module code
• nnn represents the file number

For example, for table ttadv999 and company 000, the sequence files are:

aadv999000.000
aadv999000.001
aadv999000.002
aadv999000.003
..........

For detailed information on the sequence file, see Format of audit files.