test

Understanding Sun Master Index Processing (Repository)

SBYN_TRANSACTION

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 records. The differences in data types between Oracle and SQL Server are noted in Table 22. The Oracle type is on the first line and the SQL Server type is on the second. This table also includes one column that has a different name for Oracle and for SQL Server.

Table 22 SBYN_TRANSACTION Table Description

Column Name 

Data Type 

Description 

TRANSACTIONNUMBER

VARCHAR2(20) 

Varchar(20) 

The unique number of the transaction. 

LID1

VARCHAR2(25) 

Varchar(25) 

This column is reserved for future use. 

LID2

VARCHAR2(25) 

Varchar(25) 

The local ID of the second system record involved in the transaction. 

EUID1

VARCHAR2(20) 

Varchar(20) 

This column is reserved for future use. 

EUID2

VARCHAR2(20) 

Varchar(20) 

The EUID of the second object record involved in the transaction. 

FUNCTION (Oracle)

OPERATION (SQL Server) 

VARCHAR2(20) 

Varchar(20) 

The type of transaction that occurred, such as update, add, merge, and so on. 

SYSTEMUSER

VARCHAR2(30) 

Varchar(30) 

The logon ID of the user who performed the transaction. 

TIMESTAMP

TIMESTAMP 

datetime 

The date and time the transaction occurred. 

DELTA

BLOB 

varbinary(MAX) 

A list of the changes that occurred to system records as a result of the transaction. 

SYSTEMCODE

VARCHAR2(20) 

Varchar(20) 

The processing code of the source system in which the transaction originated. 

LID

VARCHAR2(25) 

Varchar(25) 

The local ID of the system record involved in the transaction. 

EUID

VARCHAR2(20) 

Varchar(20) 

The EUID of the enterprise record involved in the transaction.