Message warehouse

The FTM SWIFT message warehouse services are:

A node to insert new entries in the message warehouse
A node to update existing message warehouse entries

If the message body is to be stored in the message warehouse and is not already in XML format, and if the structure of the message is defined in the message repository manager (MRM), each of these nodes first converts the message body to XML format before storing it in the message warehouse.

The message warehouse comprises a set of database tables in which you can store index and status information about messages and, if required, a copy of the message itself. The index and status information can be used to search for specific messages, or to calculate statistics about a set of messages. For example, information from the message warehouse can be used to locate messages in the message audit table, or messages that require special attention.

Each OU has its own set of the following message warehouse tables and views (in each table name, ou represents the name of the OU):

DNIV_MWH_ou: This is a view of the main message warehouse table. It contains one entry for each message, regardless of which service (SIPN FIN or FMT FIN) processed that message. Some of its fields apply only to FIN messages, and remain blank for other messages.
DNF_MWHFN_ou: This is a view of the adjunct message warehouse table DNFMWHFIN_ou. It contains additional fields that apply only to FIN messages processed by the SIPN FIN or FMT FIN services.
DNF_MWHEFA_ou: This is a view of the adjunct message warehouse table DNFMWHOFA_ou. It contains fields that apply only to file transfers processed by the MSIF service.
DNF_MWHENI_ou: This is a view of the adjunct message warehouse table DNFMWHENI_ou. It contains fields that apply only to Exceptions and Investigations messages.