Automatic Adjustments Detail

The automatic adjustments detail table defines the details of the automatic adjustment rules and their behavior. These rules control the association of each automatic adjustment rule with the existing ACCOUNTS and, among other things, controls the ID of the ACCOUNTS into which a given account is transformed.

Field Name	Description
Adjustment ID	The identifier for the adjustment rule.
Source account	This field may contain the following values: A valid base level or parent member ID from the `ACCOUNT` dimension A list of members of the `ACCOUNT` dimension, as defined filtering the members using a value of the `DIMLIST` property (or any property whose name begins with `DIMLIST`) in such dimension. A list of members of the `ACCOUNT` dimension, as defined filtering the members using a value of the `TYPELIM` property (or any property whose name begins with `TYPELIM`) in such dimension.
Reverse sign	If “Y” the value of the `SIGNEDDATA` amount is reversed.
Destination All account	This field defines the ID of the first of four possible destination accounts. It is linked to the ALL formula field of the Consolidation Rules Formulas table, which defines how the amount is generated. This field may contain the following values: Blank (the destination Account is equal to the source Account) A valid base level or parent member ID of the `ACCOUNT` dimension A list of members of the `ACCOUNT` dimension, as defined by filtering the members using a value of the `DIMLIST` or the `TYPELIM` property (or any property whose name begins with `DIMLIST` or `TYPELIM`) in the dimension. A list of members of the `ACCOUNT` dimension, as defined by filtering the members using a value of the `DIMLIST` property (or any property whose name begins with `DIMLIST`) in the dimension. The expression `PROP(PropertyName)`, where `PropertyName` is the name of a valid PROPERTY in the ACCOUNT dimension. In this case, the destination account is the value of the property for the current source ACCOUNT. Use caution when the destination represents a list of accounts, as multiple records is generated.
Destination Group account	This field defines the ID of the second of four possible destination accounts. It is linked to the Group formula field from the Consolidation Rules Formulas table, which defines how the amount is generated. This field may contain the same elements as defined in the Destination All account field. However, if left blank, it does not default to the source account, but generates no record.
Destination Minority account	This field defines the ID of the third of four possible destination accounts. It is linked to the Minority formula field from the Consolidation Rules Formulas table, which defines how the amount is generated. This field may contain the same elements as defined in the Destination All account field. However, if left blank, it does not default to the source account, but generates no record.
Destination Equity account	This field defines the ID of the fourth of four possible destination accounts, and has a behavior of its own. The value is linked to the ALL formula field of the Consolidation Rules Formulas table, which defines how the amount is generated. However, it applies only to the Equity methods. The account defined in this field replaces the value of the Destination All account field, in case the current `ENTITY` is being consolidated using a `METHOD` of type E (Equity). This field may contain the same elements as defined in the Destination "All account field. If left blank, the definitions of the ALL formula field apply.
Rule ID	This field must contain the name of a valid Rule ID from the Consolidation Rules table. This rule is used to define how to calculate the amount of the different destination accounts.
Source flow	This field may be used to restrict the applicability of the current Elimination to some members of the `FLOW` dimension. It may contain: Blank (any `FLOW` members) A valid base level or parent member ID from the `FLOW` dimension A list of members of the `FLOW` dimension, as defined filtering the members using a value of the `DIMLIST` property (or any property whose name begins with `DIMLIST`) in such dimension.
Destination flow	This field can be used to enforce the ID of the member of the `FLOW` dimension. It only supports an explicit `FLOW` ID or can be left blank to leave the member unchanged.
Force closing	This field can be set to Y to force the generation of an additional record where the member of the destination `FLOW` is the closing balance. The closing balance member of the `FLOW` dimension is identified as the member with the property `FLOW_TYPE = CLOSING`.
Forced Intco member	This field can be used to enforce the ID of the member of the `INTCO` dimension. It only supports an explicit `INTCO` ID or can be left blank to leave the member unchanged.
Swap Entity - Intco	This field may contain the following values: Blank or N: Nothing should be changed Y: The ID of the Entity dimension member is swapped with the ID of the `INTCO` dimension member.
Apply to periodic	This field should only be used in a YTD application for the cases in which the ownership percentage should be applied on the PERIODIC values and not on the YTD values. If this field is set to Y, the engine calculates the difference between current period and prior period amounts. The engine applies to the field the Ownership percentage specified in the ALL formula, Group formula, and Minority formula fields of the Consolidation Rules table. At the end, the result is added back to prior period’s value as written in current period. For more information, see SAP Note: 1365003.
Remark	A description of the rule.