Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
XAO_Idnr int NUMBER(38,0) int int false Identifer for XAO
XAO_TimeStamp1 datetime DATE timestamp timestamp true Time of activation
XAO_Client smallint NUMBER(38,0) smallint smallint true UC4 client
XAO_Type varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Record types - type identifier (start, modification, ...) readable
XAO_USR_Idnr int NUMBER(38,0) int int true Reference to User
XAO_OH_Idnr int NUMBER(38,0) int int true Idnr of affected object
XAO_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Object type
XAO_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Objekt name
XAO_OH_IdnrOld int NUMBER(38,0) int int true Old OH_Idnr
XAO_AH_Idnr int NUMBER(38,0) int int true Run number, session id
XAO_ParentAct int NUMBER(38,0) int int true Activator (Run#)
XAO_MsgNr int NUMBER(38,0) int int true Depending on record type: message number
XAO_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Depending on record type: message insert
XAO_Level smallint NUMBER(38,0) smallint smallint true Level of revision for this record
XAO_ArchiveFlag smallint NUMBER(38,0) smallint smallint true Flag if already evaluated (not used)
XAO_DeleteFlag smallint NUMBER(38,0) smallint smallint true Flag for reorganisation

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_XAO_Reorg XAO_ArchiveFlag, XAO_DeleteFlag, XAO_OH_IdnrOld, XAO_Idnr false false false false
PK_XAO XAO_Idnr true true true false
NK_XAO_GetChLog XAO_Client, XAO_USR_Idnr, XAO_Type, XAO_OType, XAO_TimeStamp1, XAO_Idnr false false false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File