Data Audit Configuration (DAC)

Select Data Audit Configuration (DAC) from SunSystems to open the Business Unit Group Selection form.

This lists the domain and all live business unit groups, including those that are offline. However, if you select a business unit group that is offline a warning message is displayed.

Note: Store and Archive business unit groups are not listed as they cannot be audited.

Select the required Business Unit Group to display the Data Audit Configuration Setup.

All available tables are displayed from which you can filter to make selection more manageable.

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

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.

Save your changes.