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:
-
On the Setup tab, under Register, select Target Application.
-
In the Target Application summary grid, select the Reconciliation Compliance Transactions target application.
-
Select the Dimension Details tab.
-
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.
-
Click Save.