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-24 Import Pre-Mapped Transactions (TM) Job Type Parameters and Descriptions

Import Pre-Mapped Transactions (TM) Job Type Parameters Description
Match Type

Select the text ID of the reconciliation type where the transaction file will be imported to.

Available options:

  • BEX for loading Balance Explanations
  • SRC for loading Source System Adjustments
  • SUB for loading Subsystem Adjustments
  • VEX for loading Variance Analysis Explanation
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
.