Signature
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Signatures for Transaction | Text | 8 | 1 | Edit | Yes | Public | ||
| SSNINR | INR of Session | Text | 8 | 1 | Edit | Yes | Public | ||
| DATTIM | Timestamp | Datetime | 15 | 0 | Unknown | Yes | Public | ||
| FLG | Action Flag | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| USR | User ID (Duplicate from SSN) | Text | 8 | 1 | Edit | Yes | Public | ||
| OBJTYP | Table Used to Store Object | Text | 6 | 1 | Edit | Yes | Public | ||
| OBJINR | INR of Object | Text | 8 | 1 | Edit | Yes | Public | ||
| SIGIDX | Index of signature | Text | 5 | 1 | Edit | Yes | Public | ||
| ETYEXTKEY | Entity of user when event happened | Text | 8 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| TRS_ETYEXTKEY | ETYEXTKEY | |
| TRS_INR | INR | Unique |
| TRS_SIG | OBJINR, OBJTYP, SIGIDX | |
| TRS_SSNINR | SSNINR, INR |
/
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 TRS. 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.
The INR of the session to which this notify message is sent. If the field is empty, the USR field has to be specified. If this field is filled, it specifies the session which should process this notify message.
The INR of the session to which this notify message is sent. If the field is empty, the USR field has to be specified. If this field is filled, it specifies the session which should process this notify message.
This field holds the date and time at which the entry was issued. The date and time of the application server is taken.
This field holds the date and time at which the entry was issued. The date and time of the application server is taken.
When written into TRN.EVTTXT theses values are mapped as follows O = 1 R = 2 C = 3 S = 4 E = 5 G = 6 for mapping in TRNP via embedded codetable of field WFETRSSTA
When written into TRN.EVTTXT, these values are mapped as follows O = 1 R = 2 C = 3 S = 4 E = 5 G = 6 for mapping in TRNP via embedded codetable of field WFETRSSTA
| Code | Text |
|---|---|
| O | Released |
| R | Reject |
| C | Correction required |
| S | Signed at creation |
| E | External confirmation |
| G | Created |
The user to whom this notify message is to be sent. If this field is empty, the SSNINR has to be specified. If this field is filled, any session of the specified user will process the notify message, if the user is logged in until this notify message expires.
The user to whom this notify message is to be sent. If this field is empty, the SSNINR has to be specified. If this field is filled, any session of the specified user will process the notify message, if the user is logged in until this notify message expires.
Type of object the pending entry refers to. Usually this is the table TRN.
Type of object the pending entry refers to. Usually this is the table transaction (TRN).
INR of the object within the table, defined in OBJTYP. Usually, it is TRN\INR
Internal unique ID of the object within the table, defined in the Object Type field.
Index means release or creation event for signature x and contains values “SGx” and “CRE”.
The index refers to the release or creation event for signature x.
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.