Storing messages

FTM SWIFT provides the following database tables for storing messages:

Message audit table: The Message Audit service stores messages in this table as binary data for auditing purposes. Auditors use the contents of this table to check what the exact contents of a message were at a particular time during its processing. For more information, see Auditing.
Message warehouse tables: The message warehouse service stores, in these tables, index and status information about each message processed by FTM SWIFT services. You can use the index data to search for specific messages, or to calculate business statistics about a set of message, for example, the total number of messages that were sent to a particular receiver. If required, you can configure the message warehouse to store also a copy of each message as a character large-object (CLOB). For more information, see Message warehouse.

In addition to the message contents, both tables also store additional information such as the message ID (MsgId), business group, message group, and status. This information can be used to correlate a message in one table with the same message in the other table. For example, if you identify a message in the message warehouse and want to see its original, binary form, you can use the message ID to locate the message in the audit table.

Whereas the message audit table can store several versions of a message, and thereby can be used to record its history, the message warehouse stores only the latest version of a message. To retrieve all available information about a message, you need to correlate the information stored in the audit table and the message warehouse.