Table of Contents

EVT - Event Log

Module EVT


Datafields

Name Helptext Description Data Type Len Codetable
INR Internal Unique ID Text 8
SSNINR INR of Session Text 8
OBJTYP Object Type Text 6 Embedded
OBJINR Object INR Text 8
DATTIM Timestamp Datetime 17
RTN Return Code of Function Text 1 RTNTXT
TXT Textual Event Description Block 80
ARCFLG Archived Flag ('A', 'N') Text 1 Embedded
USR User ID (Duplicate from SSN) Text 8
FRM Frame Creating the Event Text 6
ETYEXTKEY Entity Text 8
EXTSTA Status External Reporting Text 1 Embedded

Datafield Description and Properties


Datafield INR Internal Unique ID

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.


Datafield SSNINR INR of Session

This field identifies the session entry responsible for issuing this event.


Datafield OBJTYP Object Type

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.

Codetable
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)

Datafield OBJINR Object INR

If the Object Type field identifies a database table, the identification number of the object the event refers to is stored in this field.


Datafield DATTIM Timestamp

Date and time of the event.


Datafield RTN Return Code of Function

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.


Datafield TXT Textual Event Description

Description of the event in a way that is readable to the user.


Datafield ARCFLG Archived Flag ('A', 'N')

Obsolete field.

Codetable
Code Text
N Not handled
X Handled

Datafield USR User ID (Duplicate from SSN)

To facilitate access to the table, the ID for the user of the session is stored in the table.


Datafield FRM Frame Creating the Event

This field identifies the transaction which issued the event.


Datafield ETYEXTKEY Entity

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.


Datafield EXTSTA Status External Reporting

Codetable
Code Text
Not Handled
I Ignore
A as Audit
W as Alert
E as Fatal