TM_AUDIT_TRAIL

This table stores history details of unmatched transactions in Transaction Matching.

Details

Object type: TABLE

Primary Key

Name	Columns
TM_AUDIT_TRAIL_PK	TM_AUDIT_TRAIL_ID

Columns

Name	Data Type	Length	Precision	Scale	Null Allowed	Comments
AUDIT_TRAIL_ID	NUMBER		18	0	No	Primary key for the audit record.
OBJECT_ID	NUMBER		18	0	No	Primary key value of the modified object. For example, it will be trans_id for transactions or match_rule_id for a match rule.
OBJECT_TYPE	NVARCHAR2	128			No	Stores Object type. For example: TRANSACTION_2001 for Transaction where 2001 is the data source ID, RECONCILIATION for TM Profile.
FIELD_NAME	NVARCHAR2	128			No	Stores field name/ For example, ATTRIBUTE_20001 for Transaction Attribute where 20001 is the Attribute ID, TEXTID for TM Recon text id.
MODIFICATION_TYPE	NVARCHAR2	128			No	Enumerations for type of modifications. CREATED for new, CHANGED for any update, and DELETED for deletion.
MODIFIED_BY	NVARCHAR2	200			No	User who modified the value..
MODIFIED_DATE	TIMESTAMP (6)				No	Timestamp when the underlying object was modified.
SERVICE	NVARCHAR2	128			Yes	Stores source from where this operation is triggered. For example, AUTOMATCH for an Automatch job, MANUAL_EDIT for an Unmatched dialog edit transaction, MANUAL_MATCH for a manual match from the Unmatched dialog.
OLD_VALUE	NVARCHAR2	300			Yes	Prior value of the field
NEW_VALUE	NVARCHAR2	300			Yes	New value of the field
MATCH_ID	NUMBER		18	0	Yes	Reference object for the modified object. Primarily used for Matching process and refers to Match ID of the transaction when it gets matched.