15.6.1.3.10 Adjustment Attributes
Here is an example that briefly explains the Adjustment Attributes functionality.
Sample data has dimensions lv code, ccy code, and gaap code. The ownership type attribute is used as an Adjustment Attribute.
v_account_number | v_lv_code | v_ccy_code | v_gaap_code | n_eop_bal | v_ownership_type | v_default_1 |
---|---|---|---|---|---|---|
Acc01 | LE1 | USD | USGAAP | 4000 | IND | A |
Acc02 | LE1 | USD | USGAAP | 2000 | JOINT | B |
Acc03 | LE1 | USD | USGAAP | 3000 | JOINT | C |
Assuming the source balance is 9300, the following are the differences created are as follows.
Source Balance | Target Balance | Difference |
---|---|---|
9300 | 9000 | 300 |
The following adjustments are posted considering the ownership type column into the granularity.
Two unique values, IND and JOINT are used to split the differences and create adjustments.
For Adjustment 1, ownership type is IND and the balance is (4000/9000)*300.
For Adjustment 2, ownership type is JOINT and the balance is ((2000+3000)/9000)*300.
v_account_number | v_lv_code | v_ccy_code | _gaap_code | n_eop_bal (diff) | v_ownership_type | v_default_1 |
---|---|---|---|---|---|---|
GL_01 | LE1 | USD | USGAAP | 133.33 | IND |
A
|
GL_02 | LE1 | USD | USGAAP | 166.66 | JOINT | A |