The module INFTRNR holds a subset of the fields of the TRN table
for gridhandling purpose.
Any modifications to fields in the table TRN should be redone in
INFTRNR, if the fields are listed there aswell.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Transaction Control Record | Text | 8 | 1 | Edit | Yes | Public | ||
| INIDATTIM | Timestamp of Entry of Transaction | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| INIFRM | Frame Used to Create the Transaction | Text | 6 | 1 | 20 | Edit | Yes | Public | ATPTXT |
| INIUSR | User Creating the Transaction | Text | 8 | 1 | Edit | Yes | Public | ||
| ININAM | Transaction Name of Storing Transaction | Text | 40 | 1 | Edit | Yes | Public | ||
| OWNREF | Own Reference | Text | 16 | 1 | Edit | Yes | Public | ||
| OBJTYP | Object Type of Associated Contract (Optional) | Text | 6 | 1 | Edit | Yes | Public | ||
| OBJINR | Object INR of Associated Contract (Optional) | Text | 8 | 1 | Edit | Yes | Public | ||
| OBJNAM | External Readable Object Identification | Text | 80 | 1 | Edit | Yes | Public | ||
| SSNINR | INR of SSN where transaction was created | Text | 8 | 1 | Edit | Yes | Public | ||
| SMHNXT | Next Counter for SMH within TRN | Numeric | 3 | 0 | Edit | Yes | Public | ||
| USG | Responsible Group | Text | 6 | 1 | Edit | Yes | Public | USGTXT | |
| USR | Responsible User | Text | 8 | 1 | Edit | Yes | Public | ||
| CPLDATTIM | Timestamp of Completion (Execution of Last Service) | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| INFDSP | Infoflag | Text | 1 | 1 | Edit | Yes | Public | INFDSP | |
| INFTXT | Infotext | Block | 65 | 20 | 4 | Block | Yes | Public | |
| RELFLG | Release Status | Text | 1 | 1 | Edit | Yes | Public | RELSTA | |
| COMFLG | Committed ('C' if Committed) | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| COMDAT | Date of Commit | Date | 12 | 0 | Date | Yes | Public | ||
| CORTRNINR | INR of preceding TRN | Text | 8 | 1 | Edit | Yes | Public | ||
| XREFLG | Status of Recalculation | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| XRECURBLK | Currencies Handled by Transaction | Block | 3 | 10 | Block | Yes | Public | ||
| RELCUR | Currency of Relevant Amount for Release | Text | 3 | 1 | Edit | Yes | Public | CURTXT | |
| RELAMT | Relevant Amount for Release | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RELORICUR | Currency of Relevant Amount for Release in Original Currency | Text | 3 | 1 | Edit | Yes | Public | ||
| RELORIAMT | Relevant Amount for Release in Original Currency | Numeric | 18 | 3 | Edit | Yes | Public | ||
| RELREQ | Required Signatures | Text | 10 | 3 | Edit | Yes | Public | ||
| RELRES | Applied Signatures | Text | 10 | 3 | Edit | Yes | Public | ||
| CNFFLG | Flag, if External Confirmation Necessary | Text | 1 | 1 | Edit | Yes | Public | TRNCNF | |
| EVTTXT | Events | Stream | 80 | 50 | Source | Yes | Public | ||
| RPRUSR | Sent for Repair to | Text | 8 | 1 | 20 | Edit | Yes | Public | <fixed-length> |
| ORDINR | INR of Triggering Order | Text | 8 | 1 | Edit | Yes | Public | ||
| EXEDAT | Execution Date | Date | 12 | 0 | Date | Yes | Public | ||
| PDXDAT | Execution Date for Service PDX | Date | 12 | 0 | Date | Yes | Public | ||
| PRCMOD | Mode of Entry (Batch or interactive Entry) | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| RELUSR | Sent for Release to | Text | 8 | 1 | Edit | Yes | Public | <fixed-length> | |
| RELUSG | Release To Group | Text | 6 | 1 | Edit | Yes | Public | USGTXT | |
| CLSDONFLG | Flag for transaction which closed the contract. | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| EMBSTA | Compliance status | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| ACCEMBFLG | Compliance False Positive accepted | Text | 1 | 1 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity holding Transaction | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 120 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| TRN_CPLDAT | CPLDATTIM, RELFLG | |
| TRN_ETYEXTKEY | ETYEXTKEY | |
| TRN_GETFLDNRM | GETFLDNRM | |
| TRN_INIDATTIM | INIDATTIM, RELFLG | |
| TRN_INR | INR | Unique |
| TRN_OBJINR | OBJTYP, OBJINR | |
| TRN_ORDINR | ORDINR | |
| TRN_OWNREF | OWNREF | |
| TRN_RELFLG | RELFLG, USG, USR | |
| TRN_USG | USG | |
| TRN_USR | USR |
/
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 TRN. 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.
Date and time when this transaction has been stored in the system.
Date and time when this transaction was stored in the system.
Frame Used to Create the Transaction
Frame Used to Create the Transaction
User who created the contract of the selected transaction
User who created the contract of the selected transaction
Full name of the transaction selected
Full name of the transaction selected
This field contains the reference number of the Transaction Control Record.
Type of contract the TRN entry refers to. This is the table the contract is stored in.
Type of contract the TRN entry refers to. This is the table the contract is stored in.
INR of the contract within the table, defined in OBJTYP.
Unique ID of the object within the table, defined in the Object Type field.
This field identifies the pending entry in a way that is readable to the user.
This field identifies the pending entry in a way that is readable to the user.
This field holds the INR of session in which a transaction was created. It is filled in TRNMOD.TrnSetFromContract from \SYSMOD\SSN\INR.
This field holds the ID of the session creating a transaction.
This field holds the next to be used counter for multiple SMH's per transaction.
This field holds the next counter to be used should there be multiple SMHs per transaction.
User group responsible for picking up the entry.
User group responsible for picking up the entry.
User responsible for picking up the entry.
User responsible for picking up the entry.
Date and time when this transaction has been completed. Set from SRVCLN.
Date and time when this transaction was completed.
Flag to indicate whether the contents of an infotext should be displayed when using the contract. If content is blank the automatic display is switched off.
This field is used to store any relevant information about this object.This information is displayed to the user during daily processing, if the display info flag is activated.
The RELFLG describes the signature status of the transaction.
'E' Entered. Temporary status of transaction during creation of transaction. Transaction is incomplete and cannot be used in this status. RELSTA remains 'E' only if saving of a transaction fails for technical reasons in phase 2 or 3, e.g. when saving TRNDATA or .DSP file.
'W' Waiting for release, i.e. not all requested signatures (RELREQ) are yet applied (RELRES)
'R' Released, i.e. requested signatures (RELREQ) and applied signatures (RELRES) are identic. This status is set by either the businesstransaction (if autosigned or no signature required) or TRNREL (when the last missing signature is applied)
'F'inal Transaction was released and has passed SRVCOM so that it can no longer be rolled back
'C' Sent to correction in TRNREL.
'B' Transaction is waiting to pass SRVREL.
'N' Rejected. Transaction was deleted in TRNREL.
'P' Picked Up, i.e. the transaction was sent to correction or rejected and later picked up for a new transaction. This status is set when the SPT is picked up and the new transaction saved or interrupted via 'break'
'X' Waiting for external confirmation. Now obsolete. Was used to wait for an external confirmation (like a special signature)
'M' Closed by SRVCLN. 'M' is set only by SRVCLN to remove TRN from 'Waiting' queue in TRNREL if a transaction reaches (e.g. due to manual workflow manipulation) service SRVCLN but still has RELSTA='W' or RELSTA ='X'.
Status 'R','C' or 'N' are set when signatures are applied (i.e. in business transactions or TRNREL), not in service SRVPDS.
Attention: for TRS\FLG different flag values are used. Mapping of flags is done in DoRexxInternal
The RELFLG describes the signature status of the transaction.
Entered ('E'): Temporary status of transaction during creation of transaction. Transaction is incomplete and cannot be used in this status. Status remains 'entered' only if saving of a transaction fails for technical reasons.
Waiting ('W'): Waiting for release, i.e. not all requested signatures are yet applied.
Released ('R'): The count of requested signatures and applied? signatures are identical. This status is set by either the business transaction (if autosigned or no signature required) or by releasing the transaction when the last missing signature is applied.
Final ('F'): The transaction was released, has passed the workflow and? can no longer be rolled back.
Correct ('C'): The transaction is sent to correction.
Rejected ('N'): The transaction is deleted.
Picked Up ('P'): this status is set when the pending transaction is picked up and the new transaction saved or paused.
External ('X'): The transaction waits for external confirmation.
Closed ('M'): This status is exlusively set by the housekeeping transaction which cleans up historic data.
Exactly if COMFLG contains 'C', the transaction has a permanent effect on the relevant contract. Otherwise the transaction was either rolled back (COMFLG='D') or its final status is not yet determined ( COMFLG=' ').
Only if this flag is set to 'C', SRVPDP running for other transactions depending on this transaction is passed.
If COMFLG is not space, the transaction can no longer be rolled back.
Is set in SRVCOM to 'C' (apart from setting the WFE entry to 'D'one, this is the only action of SRVCOM) When COMFLG is set to 'C' RELFLG is set to 'F'inal.
Is set in SRVPDS or SRVPDP to 'D'eleted if the transaction was rejected or sent to repair in order to flag that this transaction will never pass 'COMMIT'
Only if the External Confirmation Flag field contains a 'C', will the transaction have a permanent effect on the relevant contract. Otherwise the transaction was either rolled back ('D') or its final status is not yet determined (' ').
Only if this flag is set to 'C', will the service pass to other transactions that depend on this transaction.
| Code | Text |
|---|---|
| C | Committed |
| Uncommitted | |
| D | Deleted |
Holds the date when the transaction was committed (i.e. field COMFLG set) by SRVCOM.
Holds the date when the transaction was committed.
In case the transaction was initially loaded from a corrected or deleted transaction, the INR of that transaction is stored here. In case of transactions created to resent messages as in DBXTRN the INR of the original transaction is stored the same way.
If the transaction was initially loaded from a corrected or deleted transaction, the ID of that transaction is stored here.
This flag shows the actual state of recalculation for this transaction. It is empty, if no recalculation is needed (i.e. because transaction contains no settlement).
1: waiting for actual rates, SRVPDX cannot be executed now 2: SRVPDX created XRE-SPT, transaction is waiting for recalculation by SPTTSK/TRN 3: Recalculation successful done e: Error occurred
This shows the current status of the recalculation for the transaction. It is empty if no recalculation is needed (i.e. because transaction does not lead to a settlement).
1: waiting for current rates, SRVPDX cannot be executed now 2: SRVPDX created XRE-SPT, transaction is waiting for recalculation by SPTTSK/TRN 3: Recalculation successful E: Error occurred
| Code | Text |
|---|---|
| not needed | |
| 1 | waiting for new rates |
| 2 | waiting for recalc |
| 3 | recalc done |
| e | error |
| T | waiting for recalc of predecessor |
Block of currencies handled by transaction.
Set by settlement to currencies available in settlement.
The field shows the block of currencies handled by the transaction.
This field contains the currency for the amount to be released.
This field contains the currency for the amount to be released.
This field contains the maximum amount the user is allowed to release transactions.
This field contains the maximum amount the user is allowed to release transactions.
Currency of Relevant Amount for Release in Original Currency
Currency of Relevant Amount for Release in Original Currency
Relevant Amount for Release in Original Currency
Relevant Amount for Release in Original Currency
Required Signatures This field is set upon transaction creation and holds a list of up to 10 signatures that are required to sign the transaction. Each character represends one required signature. If multisignature is activated for a transaction in ETP, the list of required signatures is determined based on the transactions relevant amount matching the signature matrix from SIH
Required Signatures This field is set upon transaction creation and holds a list of up to 10 signatures that are required to sign the transaction. Each character represends one required signature. If multisignature is activated for a transaction in ETP, the list of required signatures is determined based on the transactions relevant amount matching the signature matrix from SIH
Applied Signatures If a required signature has been applied, the same character as in RELREQ is inserted at the same position as in RELREQ. If RELREQ = RELRES the transaction is determined as being fully signed
e.g. If RELREQ = “ ABC” and RELRES = “A C” the signatures with level A and C have been applied and the signature with Level B has not yet been given.
Applied Signatures If a required signature has been applied, the same character as in RELREQ is inserted at the same position as in RELREQ. If RELREQ = RELRES the transaction is determined as being fully signed
e.g. If RELREQ = “ ABC” and RELRES = “A C” the signatures with level A and C have been applied and the signature with Level B has not yet been given.
Flag to determine if external confirmation is necessary or not
Flag to determine if external confirmation is necessary or not
The originally passed textual description of the event. This Text concatenated with the filename of the Logfile will be stored in the Event.
The originally passed textual description of the event. This Text concatenated with the filename of the Logfile will be stored in the Event.
This field holds the user ID of the user this transaction was sent for repair to.
This field holds the ID of the user this transaction was sent to for repair.
Empty if TRN was not triggered by an ORD. Otherwise the INR of the ORD entry which triggered this transaction.
Empty if the transaction was not triggered by an ORD.
If the Execution Date is set, the Transaction wont be processed before this date.
If the Execution Date has been set, the transaction will not be processed before this date.
If the Execution Date is set, the Service PDX wont be processed before this date.
If the execution date is set, the service recalculation won't be processed before this date.
Mode of entry of transaction. This flag shows whether a user has manually entered the data or the system has automatically generated the transaction without user interaction. Additionally this flag shows whether a reevaluation has taken place.
This field shows whether a transaction was generated either automatically by a batch process, or interactively by the user.
| Code | Text |
|---|---|
| I | Interactive Entry |
| B | Batch Generation |
| P | Reevaluation of Interactive Entry |
| X | Reevaluation of Batch Generation |
| W | WebService generation |
| Y | Reevaluation of WebService |
This field holds the user ID of the user this transaction was sent for release to.
This field holds the user ID of the user this transaction was sent for release to.
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.
Release of the transaction shall be excecuted in the designated group.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Field holding the concatenated and normalized sum of all search fields used by quick search. This is one of the fields set in a SdbSetNRMFields method defined in the table definition module.
Flag for closing the contract
Flag for closing the contract
1 = WFE EMB was created, waiting for MGRTSK sending XML file 2 = WFE EMB is done, waiting for Smaragd TCM reply from QA interface (received in MQITSK/SWITSK) A = Ack received from TCM N = Nack received from TCM
1 = WFE EMB was created, waiting for MGRTSK sending XML file 2 = WFE EMB is done, waiting for Smaragd TCM reply from QA interface (received in MQITSK/SWITSK) A = Ack received from TCM N = Nack received from TCM
| Code | Text |
|---|---|
| 1 | Waiting for EMB send |
| 2 | Waiting for EMB reply |
| A | Accepted |
| N | Denied |
The flag is only enabled if a transaction was rejected by the compliance check and picked up for correction.
If ticked the compliance check service is not added to the workflow for current transaction.