Field Audit Trail

1. Field Audit Trail Lawson Learning education@lawson.com

2. OCUSMA Database trigger program If an audited field is updated, a trigger program writes an extra record into a separate audit file Audit File in FAT Database Schema Lawson M3 Java Audit Trail Lawson M3 Java Audit Trail A user is maintaining customer master data xxxx xxxx xxxxxx xxxx xxxx xxxxxx xxxx xxxx xxxxxx ‘’ ‘’ ‘’ ‘’ ‘’ ‘’ ‘’ ‘’ ‘’ Customer Master File A user can review audit data on an individual field

3. Lawson M3 Java Audit Trail Viewing field changes Example with Credit Limit 1 being audited Press F9 with the cursor in the audited field Pop-up screen shows previous values

4. Lawson M3 Java Audit Trail Lawson M3 Java Audit Trail Overview • Used to display changes that are made in a field • update, write, and delete operations can be trailed • Primarily an interactive facility, not a reporting base • F9 key shows recent changes • Shows information on • the changes made • the user who made the changes • the date/time the changes were made • Audit trail is available on all fields in any file with • a unique key • a field xxCHID (“Changed By”) that contains the ID of the user who last changed the record

5. Lawson M3 Java Audit Trail Lawson M3 Java Audit Trail Overview • Field auditing begins in the FAT Manager with the creation of an Audit • specify the file and fields to be audited • specify the events to be audited - add, change, delete • The FAT Manager creates the necessary system objects that control auditing • audit files, stored in a separate database schema, containing • the audited fields (the before image) • unique identification of the updated record (key fields) • a unique counter for the update • the date- & time-stamp of the update • the type of update operation (add, change, delete) • the name of the user who updated the record

6. Lawson M3 Java Audit Trail Lawson M3 Java Audit Trail Overview • Audit trail data can be viewed in M3 by positioning the cursor in a field and pressing F9 • a pop-up list of recent changes is displayed, in most recent first sequence • before and after values of the field are shown • only the before value is stored in the audit table • Audit trail data can also be viewed in the FAT Viewer • available only to system administrators • iBrix implemented in Workplace • used only for exceptional cases • difficult to search/sequence the data

7. M3 BE MVXLIVE MVXTEST MVXCONF FAT Server FAT Server FAT Server FATTEST FATCONF FATLIVE 2 1 2 1 1 2 Audit Data Audit Data Audit Data A A A A A A B B B B B B C C C C C C FAT Manager Lawson M3 Java Audit Trail Java Audit Trail Components Life Cycle Manager or M3 Workplace Port 8095 Port 18095 • The FAT Manager provides a user interface • The FAT Server controls • the creation of audit files • the creation of database triggers • managing queries on audit data Port 28095

8. Lawson M3 Java Audit Trail • Process

9. Lawson M3 Java Audit Trail Starting the FAT Server Ensure the FAT server is started for the environment whose fields are to be audited One FAT server job per M3 environment

10. 3 1 2 Lawson M3 Java Audit Trail Using FAT Manager to Create a New Audit Choose the System Configuration List of audits Click New List of M3 files Choose the file to be audited

11. Lawson M3 Java Audit Trail Selecting Fields to be Audited

12. Audit Status Lawson M3 Java Audit Trail Audits can be activated or deactivated • the status is shown in the list of current audits • Green – active • Red - inactive

13. Lawson M3 Java Audit Trail • Managing Partitions

14. MVXCONF MVXTEST MVXLIVE FAT Server FAT Server FAT Server FATCONF FATTEST FATLIVE 2 1 2 1 2 1 Audit Data Audit Data Audit Data A A A A A A B B B B B B C C C C C C FAT Manager Lawson M3 Java Audit Trail Java Audit Trail Partitions M3 BE M3 Workplace FAT audit files reside in the separate database schemas

15. Lawson M3 Java Audit Trail Java Audit Trail Partitions M3 Workplace A partition is a separate table containing audit data Each audit file can be separately partitioned manually - when audit information becomes too old automatically – if the audit information changes Old partitions can be deleted manually FATCONF Customer Credit Limits (OCUSMA) Price List Details (OPRICL) Item Class Details (MITMAS)

16. Select the Partitions tab Lawson M3 Java Audit Trail Java Audit Trail Partitions M3 Workplace Select the audit file to be partitioned, then click Modify

17. Lawson M3 Java Audit Trail Java Audit Trail Partitions M3 Workplace Click Manual break New partition (table) is created Size column shows no. of rows in old partition Current partition always shows -1