Application Mappings

You can define application mappings in cases where you want to define a special period mapping for a specific target application. The mappings that you create here applies to an individual target application. If no application mappings are selected for the export target application, the system uses the global mappings defined for periods in global mappings.

To create period mappings for an application:

1. From the Data Integration home page, and then from the Actions menu, select Period Mapping.
2. Select the Application Mappings tab.
3. Click .
4. In Target Application, select the target application for which to add or modify an application period mapping.
5. In Period Key, specify the last day of the month for the current fiscal year mapped from the source system.

   Specify the date in MM/dd/yyyy format.

   You can also select the Period Key by clicking and selecting the date.

   Note:

   The Prior Period Key does not apply to Account Reconciliation integrations.

   Note:

   The integration uses the Period Key and Prior Period Key defined in Data Integration to determine the source General Ledger periods mapped to each Data Integration period when the integration is run.

6. In Prior Period Key, specify the prior date for the last day of the month of the current fiscal mapped from the source system.

   Specify the date in MM/dd/yyyy format.

   You can also select the Prior Period Key by clicking and selecting the date.

   

7. In Target Year, specify the year value in the target application that you are mapping the period key to.
8. In the following target periods, specify the target period value to which to load data.
   Target period value options include:
   1. Target Period Month; for example, August.
   2. Target Period Quarter
   3. Target Period Year
   4. Target Period Day
   The target period options use the Frequency values defined in Category Mappings.

   When running an integration, the system looks at the frequency value in Category Mapping and then uses that value to query the period mapping for the target period value.

   For example, if you selected "Monthly" as the frequency value in Category Mapping, the system uses the value that is entered for Target Period – Month when deciding where to load the data. If "Quarterly" was selected as the frequency value, the system uses the value entered in Target Period – Quarter, and so on.

9. Click Save.