Maintaining Field Mappings for Incoming Messages

Transaction DBISWH

This transaction is used to maintain field mappings for incoming messages.

This transaction allows fields in an incoming electronic message to be assigned to fields in the application. The field definition enables incoming messages to be mapped automatically to the fields in the related business transaction.

Note: If a message type cannot be mapped to a target transaction, the transaction “Routing of Pending Items” (SPTROU) is specified as target transaction. If a target transaction can be determined, but no mapping has been stored, all fields for the incoming message are displayed in the target transaction under “Unmapped”. If the mapping is unsuccessful because a codetable entry is missing, the fields that have not been mapped are also moved to “Unmapped”.

The following transactions can be started by clicking the icons in the list below for:

After selecting the source format (via the “Source” combobox) and the message type, message tags (Tag) mappings with the application fields (Destination Field) are displayed in the table at the bottom of the panel. The associated transaction in each case is displayed in the field with the same name.

The “transaction” can be entered or searched using the icon which will display all the transaction mappings of the entered message type.

Note on SWIFT Score messages: Score messages are MT798, where 77E contains an embedded customer-to-bank or bank-to-customer message. The mapping must be created for the embedded message. Both the MT798 and the embedded message each contain a tag :20:. For tag :20: of the embedded message, REF.2 has to be entered in the subtype for the mapping.

Alternative Mapping

To support especially the testing of incoming messages due to regulatory changes such as SWIFT 2018/2020 with different character sets (‘X’, ‘Z’) or mapping requirements for the same message type, it is possible to handle one alternative mapping per message type and target transaction.

The checkbox “Alternative mapping” will display the alternative mappings and allows the user to apply any changes if required. Depending on the SWIFT activation date (defined in Maintaining System Configuration), the application will use the correct mapping in the “Manager for Incoming Messages”.

With the introduction of New Sequences in Guarantees, many field tags have been used in both the sequences with the same name. To identify the same field tag in different sequence, Sequence (B, C) is added as a suffix to the Sub ID in the mapping.

Adding a New Field Mapping

In addition, an option is provided to copy an existing mapping from the database, or to copy a definition from an external file .

Modifying an Existing Field Mapping

Select the existing field mapping you want to modify, then click the icon. It is possible to modify or delete existing field descriptions, or to add new field descriptions by using “-/+” buttons.


“Overwrite” must be checked if any existing field content in the target field is to be replaced by the field content of the current message.


“Transformation” describes how the tag content is to be transferred to the application. It is possible, for example, to transform a BIC directly into an address, a code into long text, etc..


The most frequently used transformation is 'Codetable'. If an 'embedded Codetable' has been defined for the target field that is to be used, then the “Argument” column must be left empty; otherwise the codetable to be used must be entered there. Doing so causes the codetable entries used in the message to be displayed correctly in the application (e.g.: MT 700 mapping of 'Type of LC' (LCRTYP) to LETOPN).

If the values in the message that are available for a field are identical with the longtexts in the application, then the transformation 'Codetable' is selected together with the table that is also assigned to the application field. In this context it is irrelevant, in which language the longtext is known in the system.

If there are other values available that can unambiguously be assigned to the values known or stored in the application, a transformation table has to be defined. This table has to include the value known or stored in the application as a key and the longtext as the message value. This is handled differently if the message contains several different values that are to be assigned to the same key: in this case, a transformation table is defined whose key is at least one digit longer than the key of the field in the application. The longtexts are then assigned to the desired key, and an additional sequential number (or language flag) is assigned also.
This makes the keys of the transformation table formally unique once again. When a value is copied to an application field, the attached part is removed again, however, so that only the part known in the application remains.

However, it must borne in mind that the resulting values may have to be returned again by the application (e.g. in the execution confirmations back to TradeConnect). If the mapping is not unique, it has to be determined which unique value needs to be returned (for example, from the constellation of several field contents) when sending back the data.

Check Key in Codetable

During this transformation, a check is run to see if the field content exists in the form of a code in the codetable nominated in the “Argument” column (empty = embedded Codetable of the target field). If not, nothing is transferred. An example would be currency details that can be checked against the CURTXT codetable.

Codetable for 'Unmapped'

This transformation resolves the field content from the incoming message against the codetable indicated in the “Argument”' column and the code, including its long text from the codetable, is made available in “Unmapped”. The result is that fields that cannot be transferred automatically and only contain a code are displayed to the user in a comprehensible form. The user can then decide what needs to be done on the basis of this information. To define such a transformation, a codetable with the codes from the field in the incoming message needs to created first. The text that is to be displayed in Unmapped together with the code needs to be entered in the “Text” column.

Negative Amount

'Neg. Amount' is used to provide a tag that in terms of content represents a negative amount, with a 'minus' sign in the application, i.e., to display a negative amount (e.g.: MT707 to LETAME. Tag 33B contains 'Decrease Amount'; however, in messages it is passed on without the leading minus sign. In the application, this tag is entered in the field “Increase Amount” by setting the transformation as a negative amount.)

Numeric Value (number)

A 'Numeric Value' is used for fields that use the Sub-ID 'NBR' to specify that this is a numeric field.

BIC Resolution

'BIC Resolution' is used to resolve a BIC (Bank Identifier Code) contained in an incoming message into an address stored in the application.

BIC Trimming

As with BIC Resolution, but for BICs represented by a 12-digit terminal code. The terminal code is removed. If the branch code is 'XXX', this is also removed prior to the resolution.

Address Resolution (PTM)

The resolution of an address by means of a key contained in the incoming message, which is used to authenticate the address. The address is resolved for a specific channel using the values stored in PTM table.


Fields that are not to be used can be skipped by selecting 'Ignore'. As a result, they will not appear in the “Unmapped” list in the transaction.


This transformation method makes it possible to include fields in the mapping rules yet still display them under “Unmapped” in the transaction. Unlike the situation in 'Codetable for Unmapped', content will not be transformed. The field content for the incoming message is displayed one-to-one in “Unmapped”. Technically, such mapping entries are not necessary, but they can enhance the documentation of the use of tags in incoming messages.

Text to Date

'Text to date' converts a 6-digit (YYMMTT) or 8-digit (YYYYMMTT) date in text format to a date field of type 'Date'.

TradeConnect ID

The 'TradeConnect-ID' is used for the mapping of TradeConnect messages.

'Text up to /' and 'Text after the first/'

Tags in a message in which 2 parts of variable length separated by '/' can be mapped accordingly using this function. TX1 then takes the field contents before the '/', and TX2 takes the field contents after the first '/'.

Purpose Code (22A)

Transformation logic based on the Purpose code (tag 22A of a SWIFT MT760) is available if the same tag of the same sequence needs to be mapped to different destination fields based on the purpose codes.

Purpose codes as arguments can be defined either for Transformation as ‘Purpose code (22A)’ or for ‘BIC Resolution’.

Allowed purpose codes are ISSU, ISCO and ICCO. Internally the logic is designed in such a way that all other purpose codes (such as the ones for the amendment) adapt accordingly.

Purpose codes ADVI, ACNF, ISAB, ISAW, ADVA, ACNA, ISUA will pick the same mapping defined for ISSU.
Purpose code ISCA will pick the same mapping defined for ISCO.
Purpose code ICCA will pick the same mapping defined for ICCO.

Deleting an existing Field Mapping

Select the field mapping to be deleted and then click the icon. After confirmation of the deletion, the selected field mapping is deleted from the database.

Importing and exporting Field Mappings

Field mappings (also: field maps) can be imported or exported via the and buttons. The transaction “Export Field Mapping for Incoming Messages” is used for exporting, and the transaction “Import Field Mapping for Incoming Messages” is used for importing.

Transaction Panels

Field Mapping


Datafield Description
Msg Type Description This field contains the descriptive long name of the selected message type.
Message Format and Source cf Appendix A, Table SWH field FMT
Message Type cf Appendix A, Table SWH field MT
Transaction This field contains the business transaction to which the message is to be
cf Appendix A, Table ATP field COD
Alternative Mapping cf Appendix A, Table SWH field ALTMAPFLG
Message Field TAG cf Appendix A, Table SWM field TAG
Message TAG Sub ID cf Appendix A, Table SWM field SUBTAG
Group This field contains the field group in relation to the selected transaction.
Available fields for the selected field group are then displayed in the
'possible data fields' box.
cf Appendix A, Table SWM field DSTGRP
Destination Field cf Appendix A, Table SWM field DST
Overwrite Flag cf Appendix A, Table SWM field OVWFLG
Additional Mapping Method cf Appendix A, Table SWM field MET
Instruction cf Appendix A, Table SWM field INS

en/app/020cor/080cfg/070swm/0100dbiswh.txt · Last modified: 2022/09/23 13:01 by bp