Define mapping tables for jobs

The mapping table defines the default UDBR, allocation or advanced formula calculation job for different consolidation types.

This information is necessary when running consolidation by status. You can include a specific actuality for the consolidation type, or include all actualities.

For UDBR jobs, you also have to specify where in the consolidation process the calculations should take place, since you can execute UDBR calculations anywhere before or after the other consolidation steps.

Follow the steps below to define mapping tables for UDBR, allocations and advanced formula calculations jobs.

Procedure

  1. On the Maintain menu, click Jobs > Mapping Table.
  2. Click Add row.
  3. Select Consolidation type.
  4. Select either a specific Actuality, or All Actualities.
  5. In Step, select Allocations or Advanced Formula Calculations or User-defined Business Rules If you select User-defined Business Rules you must also specify where in the consolidation process that the job should take place, when running Consolidation with Status.
  6. In Job Code, select the Job that you want to include in the consolidation for this consolidation type.
  7. Click Save.