Audit Trail File Sizes (ttaud3135m000)

Use this session to determine the size of the audit trail files ( sequence files).

The system can store a maximum of 999 sequence files for each table/company combination. When you exceed this number, you must purge the existing sequence files with the Purge Audit Files (ttaad4261m000) session.

To define a good file size, keep in mind the following considerations:

  • The audit data is stored per transaction. If a single transaction generates too much data to be stored in a sequence file, the transaction is aborted. Therefore, the sequence file size must enable you to store transactions that involve many changes in a table, for example, an update of all fields in several columns.
  • If the file size is too small, you reach the number of 999 too quick, and you may be required to purge files you still want to keep.
  • If the file size is too big, you are unable to delete a part of the audit trail, because you cannot purge the current sequence file.
All Companies

If this check box is selected, the sequence file size applies for all companies in the selected package(s), module(s), and table(s).

All Modules

If this check box is selected, the sequence file size applies for all modules in the selected package.

Note: If this check box is selected, the All Tables check box is also automatically selected and cannot be cleared.
All Packages

If this check box is selected, the sequence file size applies for all packages, modules, tables, and companies.

Note: 
  • Only one record can have this check box selected.
  • If this check box is selected, other records define exceptions.
All Tables

If this check box is selected, the sequence file size applies for all tables in the selected module.

Company Group

The company group you defined in the Company Groups (ttaud3140m000) session.

Module

A part of a package consisting of a number of related software components, such as sessions, tables, program scripts, reports, forms and menus. For example, the General Ledger module in Financials.

A module code consists of three characters. For example, the General Ledger has the code "gld".

Package

A set of related modules that implements a complete part of the functionality, for example, Enterprise Planning, Financials, or Warehouse Management. Packages are designed to function as independent as possible, to enable a customer to implement only particular packages.

A package code consists of two characters. For example, tt is the code of the Tools package.

Each package has a unique version structure, the VRC structure.

File Size

The number that, together with the unit you select, defines the sequence file size.

Size

The unit in which the size is measured, which is either Bytes, Kilobytes or Megabytes.

Table

A data structure that is used to store data that consists of a list of records, each entry being identified by a unique key and containing a set of related values. A table contains a number of table fields that belong to a specific domain.

A table code consists of a package code, module code, and three digits.

Example

Table: tc mcs010 Countries

Code Label Length Data Type
ccty Country 3 String
dsca Description 30 Multibyte String
meec EU Member State 5 Enumerated
...