Audit Table

This table stores the audit information. When auditing is turned on for a particular table, the system creates an audit table that contains the primary keys of the audited table, audited columns, recorded columns, and these default columns:

Data Item Name	Alias	System	Type	Size	Populated By	Value
CFR GUID	CFRGUID	H95	String	36	Trigger	Actual GUID if auditing is on with OK or Delete event. "OW Without GUID" (events other than OK or Delete) Hard-coded with "Third Party" for third party.
Primary Key Columns of Audited Table	N/A	N/A	N/A	N/A	JD Edwards EnterpriseOne or third-party	Primary key value
Before or After	B4ORAFTR	H95	Character	1	Trigger	A for after image. B for before image.
Action	CFRACTION	H95	Character	1	Trigger	1 for insert 2 for update 3 for delete
Audited Columns	N/A	N/A	N/A	N/A	JD Edwards EnterpriseOne or 3rd party	Data being audited
User ID	CFRUSER	H95	String	10	JD Edwards EnterpriseOne or Trigger	UserID
Machine Key	CRFMKEY	H95	String	15	JD Edwards EnterpriseOne or Trigger	MachineID
Date/Time	DATETIME	H95	String	26	Trigger	Actual date/time
Program ID	CFRID	H95	String	10	JD Edwards EnterpriseOne or Trigger	Program ID
Audit Type	AUDITTYPE	H95	Character	1	Trigger	1 for JD Edwards EnterpriseOne with GUID 2 for "OW without GUID" 3 for third-party

The audit table must be in the same data source as the parent table.

Note: If an application or business function (BSFN) runs in a transaction boundary, and the transaction gets rolled back, the audit table may not contain any changes that are rolled back. Because the Audit Header and Audit Detail tables are not included in the scope of the transaction, records written to these two tables are not rolled back.