This table stores a history of changes made to each record in the master index application, allowing you to view a transaction history and to undo certain actions, such as merging two object profiles. The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.
Table 21 SBYN_TRANSACTION Table Description
Column Name |
Data Type |
Description |
---|---|---|
VARCHAR2(20) |
The unique number of the transaction. |
|
VARCHAR2(25) |
This column is reserved for future use. |
|
VARCHAR2(25) |
The local ID of the second system record involved in the transaction. |
|
VARCHAR2(20) |
This column is reserved for future use. |
|
VARCHAR2(20) |
The EUID of the second object profile involved in the transaction. |
|
OPERATION (SQL Server) |
VARCHAR2(20) |
The type of transaction that occurred, such as update, add, merge, and so on. |
VARCHAR2(30) |
The logon ID of the user who performed the transaction. |
|
TIMESTAMP |
The date and time the transaction occurred. |
|
BLOB |
A list of the changes that occurred to system records as a result of the transaction. |
|
VARCHAR2(20) |
The processing code of the source system in which the transaction originated. |
|
VARCHAR2(25) |
The local ID of the system record involved in the transaction. |
|
VARCHAR2(20) |
The EUID of the enterprise record involved in the transaction. |