Sage 50 UK CLEAR_AUDIT_TRAIL_EVENT Columns

Name	Type	Length	Precision	Notes	Example
CATE_ID	INTEGER	4	10	Unique ID Number
DATE	DATE	2	10	Event Date
USER_NAME	VARCHAR	32	32	User Name
LOCATION_TYPE	VARCHAR	1	1	Location Type
LOCATION	VARCHAR	259	259	Location (data path)
RECORD_CREATE_DATE		16	0	Date and time when the record was created.
RECORD_MODIFY_DATE		16	0	Date and time when the record was modified.
RECORD_DELETED	TINYINT	2	3	Flag denoting if the record has been deleted or not.