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

Foreign Keys:

Name Local References Foreign References

Return to the Index File