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 in Dimension Details.

Dimension names must match exactly with attribute names in Account Reconciliation. If the dimension is for a standard attribute, 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 3-3 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 3-4 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 3-5 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:

1. On the Setup tab, under Register, select Target Application.

2. In the Target Application summary grid, select the Reconciliation Compliance Transactions target application.

3. Select the Dimension Details tab.

4. Select the Target Dimension Class or click , select the Target Dimension Class for each dimension that you need to change, and then specify the target dimension class from the drop-down.

5. Click Save.