en:app:020cor:090tn:030ord:0410ore

ORE - Event for ORD

Module ORE


Datafields

Name Helptext Description Data Type Len Codetable
ORDINR INR of Holding Order Text 8
SSNINR INR of SSN where Event was Written Text 8
BEGDATTIM Start of Processing Datetime 15
ENDDATTIM End of Processing Datetime 15
PRCDUR Processing Duration (in Seconds) Numeric 10
WAIDUR Wait Time (in Seconds) Numeric 10
USR User ID Text 8
TYP Type of Event Text 3 <fixed-length>
FRM Transaction Text 8
OBJTYP Object Type Text 6
OBJINR Object INR Text 8
ETYEXTKEY Entity Text 8

Datafield Description and Properties


Datafield ORDINR INR of Holding Order

Internal unique ID of the order to which this ORE record belongs.


Datafield SSNINR INR of SSN where Event was Written

Unique ID of the session in which this ORE was written. Allows server and client machine used to be identified .


Datafield BEGDATTIM Start of Processing

The date and time when the FRM transaction (the name of the transaction handling the order) picked up the order.


Datafield ENDDATTIM End of Processing

The date and time when the transaction updated the order.


Datafield PRCDUR Processing Duration (in Seconds)

The number of seconds the transaction took to process the order (allowing performance statistics). This is the difference between the beginning and end timestamps.


Datafield WAIDUR Wait Time (in Seconds)

Total time (in seconds) the status level for this entry was 'W'aiting


Datafield USR User ID

The ID of the user who performed the transaction.


Datafield TYP Type of Event

The embedded ORDSTA codetable is used for this field, as status of ORD is set by ORETYP of the last ORE record.

REL is created when the last required signature is set.

SIG is created when a signature is applied but signatures are not yet sufficient for release.


Datafield FRM Transaction

Name of the transaction that handled the order.


Datafield OBJTYP Object Type

SPT or TRN or SMH record handled.

Referenced object can become invalid/deleted at any time.


Datafield OBJINR Object INR

(Can become invalid at any time).


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.

en/app/020cor/090tn/030ord/0410ore.txt · Last modified: 2022/03/14 14:01 (external edit)