Using an Import Pre-Mapped Transactions (TM) Job Type

Use the Import Pre-Mapped Transactions (TM) job type to import pre-mapped transactions for a particular period from a CSV file in the Account Reconciliation repository and return the success or failure status.

Import Pre-Mapped Transactions (TM) job type parameters:

Note:

For parameters that are common to all job types, see Pipeline Process Description.

Table 12-26 Import Pre-Mapped Transactions (TM) Job Type Parameters and Descriptions

Import Pre-Mapped Transactions (TM) Job Type Parameters	Description
Match Type	Select a Match Type from the list where the transaction file will be imported to. This list will contain Match Types with the status: Approved. Available options: BEX for loading Balance Explanations SRC for loading Source System Adjustments SUB for loading Subsystem Adjustments VEX for loading Variance Analysis Explanation If the Match Type ID is changed in Account Reconciliation after Account Reconciliation pipelines have been created in Data Integration, you must re-select the Match Type LOV option in the pipelines and save the changes. This step is necessary to ensure the pipelines run successfully.
Data Source	Specify the text ID of the data source where the transaction will be imported to.
File	Select the name of the CSV file from which data is to be imported.
Date Format	Select the data format. The date format is a parameter that includes the format of the date fields in the transactions import file. The default is dd-MMM-yy. Other supported date formats are MM/dd/yyyy, dd/MM/yyyy, MM-dd-yyyy, d-M-yyyy, and MMM d,yyyy MMM d,yyyy .