ETP is the data table for the additional transaction profile data by entity group.
This table holds configuration information about all transactions of
the installation.
| Name | Description | Data Type | Len | Dec. | View lines | View type | Inst. | Visible | Codetable |
|---|---|---|---|---|---|---|---|---|---|
| INR | Internal Unique ID of Application Transaction | Text | 8 | 1 | Edit | Yes | Public | ||
| COD | Transaction ID | Text | 6 | 1 | Edit | Yes | Public | ATPTXT | |
| SEPFLG | Temporary Settlement Allowed | Text | 1 | 1 | Edit | Yes | Public | ||
| CCSTYP | Compliance Check Type | Text | 3 | 1 | Edit | Yes | Public | Embedded | |
| VER | Version Counter | Text | 4 | 1 | Edit | Yes | Public | ||
| RELAMT | Relevant Amount for Release | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| RELTYP | Method of Release | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| REDAMTTYP | Reduction amount | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| ATPINR | INR of Releated ATP record | Text | 8 | 1 | Edit | Yes | Public | ||
| SETTYP | Type of Settlement | Text | 2 | 1 | Edit | Yes | Public | Embedded | |
| SETACT | Settlement Type Active | Text | 1 | 1 | Edit | Yes | Public | ||
| TRNCLS | SLA Duration Class | Text | 3 | 1 | Edit | Yes | Public | TRNCLS | |
| EXCCONROL | List of parties to be excluded from compliance check | Block | 3 | 5 | 5 | Block | Yes | Public | |
| EXCSETROL | List of parties to be excluded from compliance check | Block | 6 | 5 | 5 | Block | Yes | Public | |
| PRI | Prio | Text | 1 | 1 | Edit | Yes | Public | Embedded | |
| SIHINR | Internal Unique ID of the linked SIH record | Text | 8 | 1 | Edit | Yes | Public | ||
| ETGEXTKEY | Entity Group of ETP | Text | 8 | 1 | Edit | Yes | Public | ||
| GETFLDNRM | Field holding the normalized search fields | Text | 10 | 1 | Edit | Yes | Public |
| Name | Fields | Properties |
|---|---|---|
| ETP_COD | COD | Unique |
| ETP_COD | COD, ETGEXTKEY | Unique |
| ETP_INR | INR | Unique |
| ETP_SIHINR | SIHINR |
/
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 ETP. 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.
Technical short name of the application transaction. This name is made up of the base name of the name of the file of the transaction file(s).
Technical short name of the application transaction. This name is made up of the base name of the name of the file of the transaction file(s).
If this flag is set to a non-blank value it marks this transaction as being able to handle temporary settlement.
If this flag is set to a non-empty value it marks this transaction as being able to handle temporary settlements.
Any non-empty value triggers generation of compliance check by SRVCCS. Standard values are SMH Check all generated external Messages TRN Check contract/transaction data (generically generated from TRNDATA File.
Other values can be added in customization.
Any non-empty value triggers the generation of a compliance check via the service module SRVCCS - Service CCS.
When the 'Alternative Compliance is activated in the transaction Maintaining System Configuration Transaction (DBxSYS), possible values are None Always or Only if transaction sends a message.
When the built in compliance functionality is used, standard values are: SMH - checks all generated external messages TRN - checks contract/transaction data.
Other values can be added when customizing the system.
| Code | Text |
|---|---|
| None | |
| SMH | per Message |
| TRN | per Transaction |
| WM | Always |
| YM | Only if trn. sends messages |
This field holds the version counter to keep track of the version history of an ETP entry. The individual versions are controlled by entries in the SLG table.
This field holds the version counter used to keep track of the history of an entry of this table. The individual versions are managed by entries in the SLG table.
This field holds the relevant amount for release. It is not a sum, it is for example MAXAMT of transaction.
This field holds the relevant amount for release. This may be the maximum amount of the transaction, for example.
| Code | Text |
|---|---|
| M | Maximum Amount |
| O | Open Amount |
| N | Nominal Amount |
| A | Max Amount with add Amount |
| P | Open Amount with add Amount |
| C | Confirmation Amount |
| T | No Amount |
| S | Amount Settled |
| L | Liability Amount |
Method of release, which is used. 1 = Standardrule - Set_Wfs_Release of transaction is used 2 = Signature required - TRN\RELREQ is set to “A”
This field defines the release rule to be used. The release rule determines the number of signatures necessary to release the business transaction.
| Code | Text |
|---|---|
| 1 | Source in Transaction |
| 2 | Single Signature required |
| 3 | No Release required |
| M | Multi Signature required |
Using this flag, a reduction amount can be allowed to be set within the settlement settings. The type of amount reduction may be: 'Active', Non-active', 'Source in transaction'
| Code | Text |
|---|---|
| Source in Transaction | |
| N | Not Active |
| A | Active |
INR of the relevant ATP record
The type of settlement determines whether a settlement is temporary, final or according to source in the transaction in the Settlement register.
| Code | Text |
|---|---|
| Source in Transaction | |
| C | Temporary |
| CG | Final |
If this flag is set to a non-blank value the settlement type is enabled
If this flag has a non-blank value, then the settlement type (final or temporary) can be changed.
This table is defined on entity group level with separate entries for each entity group. This field holds the EXTKEY of the entity group which is 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 entity group of the currently active entity are visible to the user.
This field holds the external key of the owning entity group 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 group are visible to the user.
Service Level Agreements are defined per group of transactions as i.e. opening / amendment / other. These classes are defined in the external codetable TRNCLS. Each business transaction should be connected to one TRNCLS if Service Level Agreements are used.
Each business transaction should be connected to one transaction class if Service Level Agreements (SLA) are used. The allowed duration time for a SLA relevant customer order can be defined in the SLA static data transaction per group of transactions e.g. “Opening”, “Amendment”, “Document/ Claim Presentation” or “Other”. These classes are defined in the external codetable TRNCLS.
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.
This block contains the list of parties for which no compliance is checked.
This block contains the list of parties for which no compliance is checked.
This block contains the list of parties for which no compliance is checked.
This block contains the list of parties for which no compliance is checked.
This field describes the priority of compliance check.
The field can be set to Normal or Urgent. The priority is intended for an external compliance system and will be included in the output XML in the header tag <MessagePriority>.
| Code | Text |
|---|---|
| U | Urgent |
| N | Normal |
Unique internal ID of the linked SIH Record. A SIH record is linked in case Method of Release is “Multisignature”
Unique internal ID of the linked SIH Record. A SIH record is linked in case Method of Release is “Multisignature”