Menu Code: AUD System - Maintenance

The Audit Viewer displays field-level changes for tables that are enabled for auditing.  Each audit entry records the field name, who made the change, when it happened and the old and new value.  When a record is deleted the last value for each field is audited.

Auditable Tables

Address Cash Entry Cash Entry Lines Currencies Customers Employees Item Master Logins Price Books

Price Details Purchase Order Lines Purchase Orders Quote Lines Quotes Receipt Lines Receipts Sales Invoice Lines Sales Invoices

Sales Leads Sales Order Lines Sales Orders Scheduled Events Suppliers Warehouses

Columns

Index	Visible	Field Name	Caption	Usage / Description
0	Yes	AuditID	ID	Audit ID (Systemic)
1	Yes	AuditType	Type	Audit Type: (U)Update, (D)Delete
2	Yes	AuditUser	User	User who changed the record (FOURA User ID)
3	No	UserName	UserName	Full name of AuditUser
4	Yes	AuditDate	Date	Date and time of change
5	Yes	FieldName	FieldName	Name of field changed
6	Yes	OldValue	Old Value	Original value
7	Yes	NewValue	New Value	New value
8	Yes	PKID	PKID	Primary key of changed record (int)
9	Yes	AltKey	AltKey	Alternate key of changed record (text)
10	Yes	PKName	PK Name	Descriptive text to help identify changed record
11	No	ParentPKID	ParentPKID	Primary key of parent record (line audits only)
12	No	ParentKey	ParentKey	Alternate key of parent record (line audits only)
13	Yes	ParentPKName	ParentPKName	Descriptive text for parent record (line audits only)

Security

The following default roles can use this form:

Role	Allowed Actions
rl_Setup	View
rl_AuditViewer	View