Mapping Reconciliation Compliance Transactions Attributes to Dimensions

When you map a Reconciliation Compliance Transactions target application, the dimension details of the application are populated automatically on the Map Dimensions page

Dimension names must match exactly with attribute names in Account Reconciliation. If the dimension is for a standard and custom attributes, its name should be exactly as specified here and should not be changed.

By default "Profile" is mapped to the "Account" (Reconciliation Account ID) target dimension class and "Period" is mapped to the "Period" target dimension class.

The following dimensions are assigned to the Attribute target dimension class and are mapped to the ATTR1 to ATTR4 columns respectively. If mappings rules are needed for these dimensions, change them to Lookup dimension types and map them to UD (user-defined) columns. Attribute dimensions can have no mapping rules.

Table 17-5 Default List of Dimensions

Dimension Name	Target Dimension Class	DB Table Column
Short Description	Attribute	ATTR1
Long Description	Attribute	ATTR2
Transaction Date	Attribute	ATTR3
Close Date	Attribute	ATTR4

For more information about Lookup dimensions, see Adding Lookup Dimensions.

The following are standard dimensions and the names should not be changed. Dimensions for unused currency buckets can be deleted.

Table 17-6 Standard Dimension Details

Dimension Name	Target Dimension Class	DB Table Column
Amount (Entered)	Attribute	ATTR5
Currency (Entered)	Attribute	ATTR6
Amount (Functional)	Attribute	ATTR7
Currency (Functional)	Attribute	ATTR8
Amount (Reporting)	Attribute	ATTR9
Currency (Reporting)	Attribute	ATTR10

Other standard dimensions are shown below. These can either be Lookup or attribute dimensions. Because Reconciliation Compliance Transactions allow the same custom attributes to be assigned to the transaction itself and its action plan, the system differentiates between custom attributes for the transaction and custom attributes for the action plan. In this case, the system prefixes Action Plan at the beginning of dimension names for action plan attributes.

Table 17-7 Other Standard Dimensions

Dimension Name	Target Dimension Class	DB Table Column
Child Account ID—The child account ID for child transactions of a summary reconciliation.	LOOKUP or Attribute	Select any UD columns or ATTR columns.
<sub-segment name>—Sub-segments for transactions of a group reconciliation. The dimension name should match the sub-segment name in Account Reconciliation, for example, Store, Entity.	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization Method	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization Half Month Convention	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization Periods	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization Start Period	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization End Date	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Amortization Original Amount<index>	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Action Plan	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Action Plan Closed	LOOKUP or Attribute	Select any UD columns or ATTR columns.
Action Plan Close Date	LOOKUP or Attribute	Select any UD columns or ATTR columns.

To define dimension details for a Reconciliation Compliance Transactions application:

1. From the Data Integration home page, click to the right of the Reconciliation Compliance Transactions target integration, and then select Map Dimensions.
2. From Import Format, select the name of the import format to use for the integration.

   You can also add a user defined import format name.

3. From Type, select Delimited-All Data Type.

   The Delimited–All Data Type load all data types from a delimited file format.

4. From Delimiter, select the character to use for delimiting columns in the output file.

   A delimited file contains one or more records set off from each other by a specified delimiter.

   Available options:

   • Comma (,)

   • Pipe (|)

   • Exclamation (!)

   • Semicolon (;)

   • Colon (:)

   • Tab

   • Tilde (~)

5. In the mappings grid, map the source columns in the source data-load file to the dimensions in the target application.

   The dimensions from the Reconciliation Compliance Transactions target application are populated automatically.

   If the import format has already been defined for the file, then the source and target columns are mapped automatically.

6. Click Save.