Adding a Transaction Matching Target Application

Any file, including a Bank file, can easily be exported to a Transaction Matching target application. In this case, you create a local application, which uses a Transaction Matching data source as the application type, and then you select the application name.

To add a Transaction Matching target application:

1. From the Home page, click (Navigator icon) and then from the Integration category, select Data Management.
2. Select the Setup tab, and then under Register, select Target Application.
3. In Target Application, in the summary grid, click Add, and then from Type, select Local.
4. From Select Application, and then from the Type drop-down, select Transaction Matching Data Sources.
5. In Application Name, enter the target application name for the Transaction Matching data source.
6. In Prefix, optionally specify a prefix to make the application name unique.

   The prefix supports up to a maximum of 10 chars max. The combination of the reconciliation type and transaction matching data source name is auto generated.

   For example, if the bank file import is for a Transaction Matching data source named "BOA" and the reconciliation type text id is "BAI_LOAD_RT," you might add the prefix "TM_" followed by "BAI_LOAD_RT" and then "BANK." In this case, the application name would be "TM_ BAI_LOAD_RT:BANK."

   In another example, if this a MT940 bank file import is for a transaction data source named "SWIFT_MT940_MT" and the reconciliation type text id is "BANK", then the target application name would start with a prefix (such as DEMO_), followed by "SWIFT_MT940_MT", and then "BANK". In this case, the name is "DEMO_SWIFT_MT940_MT:BANK. "

7. Click OK.

   

8. Select the Dimension Detail tab.

   When you a Transaction Matching target application, the dimension details of the application are populated automatically on the Dimension Detail tab.

9. Select the Target Dimension Class or click to select the target dimension class for each dimension that is not defined in the application.

   The dimension class is a property that is defined by the dimension type.

   

10. Set up the source and target mapping between the source system and the Transaction Matching target application by building an import format.

    See Working with Import Formats.

    The following shows the import format for a Bank file.

    

    The following shows the import format for a MT940 file.

    

11. Define the location used to associate the import format.

    See Defining Locations.

12. Create category mappings to map currency buckets.

    For information on Account Reconciliation currency buckets, see Defining Currency in the Setting Up and Configuring Account Reconciliation.

13. Define the data load mapping to map the members from the source to target.

    The SWIFT MT940 import format requires that you map the Reconciliation Id dimension to the corresponding Transaction Matching reconciliations. You can map other dimensions as needed.

    See Creating Member Mappings.

14. In the Data Load Workbench, test and validate the data by executing the data load rule to ensure that the data load rule is running properly, and your data looks correct. Data Management transforms the data and stages it for Account Reconciliation to use.

    See Using the Data Load Workbench.