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 following
table lists Oracle data types. For information about the differences
in data types between database vendors, see Table 3.
Table 18 SBYN_SYSTEMOBJECT Table Description
Column Name
|
Data Type
|
Description
|
SYSTEMCODE
|
VARCHAR2(20)
|
The processing code of the system associated with the local
ID. This column cannot be null.
|
LID
|
VARCHAR2(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)
|
The type of object being processed (currently only the name
of the parent object). This column is reserved for future use.
|
CREATEUSER
|
VARCHAR2(30)
|
The user ID of the person who created the system record.
|
CREATEFUNCTION
|
VARCHAR2(20)
|
The type of transaction that created the system record.
|
CREATEDATE
|
DATE
|
The date the system record was created.
|
UPDATEUSER
|
VARCHAR2(30)
|
The user ID of the person who last updated the system record.
|
UPDATEFUNCTION
|
VARCHAR2(20)
|
The type of transaction that last updated the system record.
|
UPDATEDATE
|
DATE
|
The date the system record was last updated.
|
STATUS
|
VARCHAR2(15)
|
The status of the system record. The status can be one of these
values:
|