Data Audit Configuration (DAC)

These fields can be used to define the selection of tables to activate or deactivate for auditing:

  1. Complete this information:
    Table Name
    Click on the Query button to display the list of auditable tables. Most SunSystems tables are auditable which should cater for your auditing requirements. Tables that are not auditable are primarily system and work tables.
    Business Unit Code
    This allows for a specific business unit to be displayed. It is normally used in conjunction with the Table Name field. Alternatively, you can enter a business unit code and select Action > Next to display all tables in the business unit. If you are auditing the Domain tables you cannot specify a business unit code.
    Column Name
    Click on the Query button to display a full list of table columns that are auditable by table. If a column description is selected, click OK on the Find Column Names form, then OK on the Data Audit Configuration form, to display all auditable tables containing that column on the grid, ready to be Audit Activated. This means you can be certain that all tables containing a specific column/field have been selected. For example, every table containing Account Code or Warehouse Code.
    Note:  - If column names vary on different tables then not all the required tables will be returned. For example, Fourth Currency and 4th Currency. - All the columns in the selected table are recorded in the audit record, not just the specific column selected in the Column Name field. - This field does not work in conjunction with Table Name and Business Unit Code selections, but does work with Hide Business Unit Tables and Audit Activated Only flags, if appropriate.
    Hide Business Unit Tables
    Check this box to display only non-business unit tables. This option is disabled when auditing Domain tables.
    Audit Activated Only
    If this box is ticked, only those tables which have been made auditable are shown in the grid.
  2. Save your changes.