Understanding Sun Master Index Processing (Repository)

SBYN_ENTERPRISE

This table stores a list of all the system and local ID pairs assigned to the enterprise records in the database, along with the associated EUID for each pair. This table is linked to sbyn_systemobject by the systemcode and lid columns, and is linked to sbyn_systemsbr by the euid column. This table maintains links between the SBR and its associated system objects. None of the columns in this table can be null.

The differences in data types between Oracle and SQL Server are noted in Table 13. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 13 SBYN_ENTERPRISE Table Description

Column Name 

Data Type 

Description 

SYSTEMCODE

VARCHAR2(20) 

Varchar(20) 

The processing code of the system associated with the local ID. 

LID

VARCHAR2(25) 

Varchar(25) 

The local ID associated with the system and EUID. 

EUID

VARCHAR2(20) 

Varchar(20) 

The EUID associated with the local ID and system.