Table of Contents

TRO - Transaction Dependencies

Module TRO

Description

This table keeps track of all dependencies between transactions
and contracts.
In case multiple transactions are depending on the same contract
this chain of dependency is reflected as multiple entries within this
table.
The entries are associated to a contract (OBJTYP and
OBJINR) and a processing transaction (TRNINR).
One transaction might be dependent on multiple contracts.


Datafields

Name Description Data Type Len Dec. View lines View type Inst. Visible Codetable
INR Internal Unique ID of Transaction Dependency Text 8 1 Edit Yes Public
TRNINR INR of Contract Changing Transaction Text 8 1 Edit Yes Public
PRVINR INR of a Previous Transaction the Current Transaction is Depending on Text 8 1 Edit Yes Public
OBJTYP Object Type of Contract Text 6 1 Edit Yes Public
OBJINR Object INR (= Contract INR) Text 8 1 Edit Yes Public
LSTFLG Flag to Mark Last TRO for Contract Text 1 1 Edit Yes Public Embedded

Indices

Name Fields Properties
TRO_INR INR Unique
TRO_OBJ OBJTYP, OBJINR
TRO_PRVINR PRVINR
TRO_TRNINR TRNINR

/


Lock

INR

Datafield Description and Properties


Datafield INR Internal Unique ID

Description

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 TRO.

Helpinformation

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 TRNINR INR of Contract Changing Transaction

Description

INR of the transaction which created or processed the contract.

Helpinformation

Unique ID of the transaction that created or processed the contract.


Datafield PRVINR INR of Preceding Transaction

Description

This field holds the TRNINR of the directly preceding transaction depending on the same contract.

Helpinformation

This field holds the transaction ID of the preceding transaction that is dependent on the same contract.


Datafield OBJTYP Object Type

Description

Object type of the owning contract. (e.g. LID, GID). Used together with OBJINR.

Helpinformation

Object type of the holing contract. (e.g. LID, GID). Used together with the internal unique ID of the object.


Datafield OBJINR Object INR

Description

INR of the owning contract. Used together with OBJTYP.

Helpinformation

The unique ID of the holding contract; used together with the Object Type field.


Datafield LSTFLG Flag to Mark Last TRO for Contract

Description

The most recently added transaction is marked with an 'X' to identify those entries where new dependencies have to be linked to. When linking a new entry to an existing TRO record, the 'X' in LSTFLG of that existing record is cleared and the new record is flagged with LSTFLG = 'X'.

Helpinformation

The most recently added transaction is marked with an 'X' to identify those entries where new dependencies have to be linked.

Codetable
Code Text
R Transaction TRNINR was rejected
X Transaction TRNINR is last open TRN for OBJTYP/OBJINR
D Transaction TRNINR has been committed and cannot be rolled back
Normal entry