SBYN_SYSTEMOBJECT
This table
stores information about the system records in the database, including their
local ID and source system pairs. It also stores transactional information,
such as the create or update date and function. The differences in data types
between Oracle and SQL Server are noted in Table 19. The Oracle type is on the first line, and the SQL Server type is
on the second.
Table 19 SBYN_SYSTEMOBJECT Table Description
|
Column Name
|
Data Type
|
Description
|
|
SYSTEMCODE
|
VARCHAR2(20)
Varchar(20)
|
The processing code of the system associated with the local ID. This
column cannot be null.
|
|
LID
|
VARCHAR2(25)
Varchar(25)
|
The local ID associated with the system and EUID (the associated EUID
is found in sbyn_enterprise). This column cannot be null.
|
|
CHILDTYPE
|
VARCHAR2(20)
Varchar(20)
|
The type of object being processed (currently only the name of the parent
object). This column is reserved for future use.
|
|
CREATEUSER
|
VARCHAR2(30)
Varchar(30)
|
The user ID of the person who created the system record.
|
|
CREATEFUNCTION
|
VARCHAR2(20)
Varchar(20)
|
The type of transaction that created the system record.
|
|
CREATEDATE
|
DATE
datetime
|
The date the system record was created.
|
|
UPDATEUSER
|
VARCHAR2(30)
Varchar(30)
|
The user ID of the person who last updated the system record.
|
|
UPDATEFUNCTION
|
VARCHAR2(20)
Varchar(20)
|
The type of transaction that last updated the system record.
|
|
UPDATEDATE
|
DATE
datetime
|
The date the system record was last updated.
|
|
STATUS
|
VARCHAR2(15)
Varchar(15)
|
The status of the system record. The status can be one of these values:
|
