| 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 |
| 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 |
| Name | Local References | Foreign References |
|---|
Return to the Index File