EUID
|
VARCHAR2(20)
Varchar(20)
|
The EUID associated with system record (the associated system and local
ID are 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.
|
CREATESYSTEM
|
VARCHAR2(20)
Varchar(20)
|
The system in which the system record was created.
|
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 object 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 object was last updated.
|
STATUS
|
VARCHAR2(15)
Varchar(15)
|
The status of the enterprise record. The status can be one of these
values:
|
REVISIONNUMBER
|
NUMBER(38)
numeric(38, 0)
|
The revision number of the SBR. This is used for version control.
|