This table holds a central table of all important events which occur
within the application. The events
are subdivided into different groups by the issuing object, which
might be located in a different table
(e.g. TRN, SMH) or which might be a logical area (e.g. SYS, SRV).
These events are kept in the system for a longer period and might be
used to trace what has happened at a specific time.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Event | Text | 8 | 1 | Edit | Yes | Public | ||
| SSNINR | INR of Session | Text | 8 | 1 | Edit | Yes | Public | ||
| OBJTYP | Table Used to Store Associated Object or Type of Event | Text | 6 | 1 | Edit | Yes | Public | Embedded | |
| OBJINR | INR of Object | Text | 8 | 1 | Edit | Yes | Public | ||
| DATTIM | Timestamp | Datetime | 17 | 2 | Unknown | Yes | Public | ||
| RTN | Return Code of Function | Text | 1 | 1 | Edit | Yes | Public | RTNTXT | |
| TXT | Textual Event Description | Block | 80 | 4 | 4 | Block | Yes | Public | |
| ARCFLG | Handled Flag ('N', 'X') | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| USR | User ID (Duplicate from SSN) | Text | 8 | 1 | Edit | Yes | Public | ||
| FRM | Frame by which the Event is Created | Text | 6 | 1 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity of User when Event happened | Text | 8 | 1 | Edit | Yes | Public | ||
| EXTSTA | Status External Reporting | Text | 1 | 1 | Edit | Yes | Public | Embedded |
| Name | Fields | Properties |
|---|---|---|
| EVT_ETYEXTKEY | ETYEXTKEY | |
| EVT_INR | INR | Unique |
| EVT_OBJ | OBJTYP, OBJINR | |
| EVT_RTN | RTN, DATTIM | |
| EVT_SSNINR | SSNINR |
/
INR
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter EVT. The field INR is used to maintain links from other tables into this table.
Unique internal ID of a record within the table. The INR is a text field, which is created by retrieving the next valid entry from the counter of this table. The field INR is used to enable links from other tables to this table.
For contractdata the INR also links the two tables xxD and xxT as associated entries hold the same INR.
This field identifies the session entry in the table SSN, responsible for issuing this event.
This field identifies the session entry responsible for issuing this event.
When filled with a table ID (e.g. TRN or SMH), the OBJINR represents the standard form of an INR link. When filled with other values, the OBJINR has no meaning.
When filled with a table ID (e.g. Transaction 'TRN', or Structured Message Header 'SMH'), the Object INR represents the standard form of an INR link. The Object INR has no meaning if it is filled with other values.
| Code | Text |
|---|---|
| TRN | Transaction (table) |
| SRV | Service |
| DWN | Download |
| FIL | Incoming Messages |
| SMH | Messages (table) |
| SYS | System |
| SPT | Pending Item (table) |
| BOL | Bolero |
| SPQ | Local Print Request |
| JOB | Job (table) |
If the OBJTYP identifies a database table, the INR of the object the event refers to is stored in this field.
If the Object Type field identifies a database table, the identification number of the object the event refers to is stored in this field.
Date and time of the event.
Date and time of the event.
Returncode of the function issuing the event (Blank or Zero = Successful) Longer lasting events might initially set the field to S (as in Started) until the result of the event is available.
This field identifies the return code of the function issuing the event (Blank or Zero = Successful) Longer lasting events might initially set the field to S (for Started) until the result of the event is available.
Description of the event in user readable text. Language is SYSUIL.
Description of the event in a way that is readable to the user.
Obsolete field.
Obsolete field.
| Code | Text |
|---|---|
| N | Not handled |
| X | Handled |
For facilitating the access to the table, the user ID of the user of the session is stored in the table.
To facilitate access to the table, the ID for the user of the session is stored in the table.
This field identifies the transaction which issued the event.
This field identifies the transaction which issued the event.
This table is defined on entity level with separate entries for each entity. This field holds the EXTKEY of the owning entity to identify the logical owner of this entry. This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
This field holds the external key of the owning entity to identify the logical owner of this entry.
This field is filled automatically during insert and is used as filter when accessing the database. Without special implementation only entries of the currently active entity are visible to the user.
| Code | Text |
|---|---|
| Not Handled | |
| I | Ignore |
| A | as Audit |
| W | as Alert |
| E | as Fatal |