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 |
|
OBJECT_TYPE |
NVARCHAR2 |
128 |
No |
Stores Object type. For example: |
||
FIELD_NAME |
NVARCHAR2 |
128 |
No |
Stores field name/ For example, |
||
MODIFICATION_TYPE |
NVARCHAR2 |
128 |
No |
Enumerations for type of modifications. |
||
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, |
||
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. |