D.8 Selecting Rows from Management Ledger Table

When reading rows from the Management Ledger table, the allocation engine decides whether or not it needs to translate the Entered_Balance column value based on the “Column Property” characteristic of each row's Financial Element ID. This decision process applies to Sources and Drivers and is made on a row-by-row basis (one decision point for each distinct Financial Element found). OFSAA Infrastructure supports four Column Properties for Financial Elements: Balance, Balance Weighted Object, Statistic, and Standard Rate.

• If the Column Property of an input row's Financial Element is Balance or Balance Weighted Object then the value is translated to the Functional Currency.
• If the Column Property of an input row's Financial Element is Statistic or Standard Rate then the value is NOT translated (that is, the value has no currency-specific basis).

You may execute the following query to see the Column Property for each Financial Element.

SELECT A.FINANCIAL_ELEM_ID, 
C.FINANCIAL_ELEM_NAME, 
B.COLUMN_PROPERTY
FROM DIM_FINANCIAL_ELEMENTS_ATTR A, REV_COLUMN_PROPERTY_DSC B, 
DIM_FINANCIAL_ELEMENTS_TL C 
WHERE A.ATTRIBUTE_ID = 5004 
AND C.LANGUAGE = <Specify your language here or simply use 'US'>
AND A.DIM_ATTRIBUTE_NUMERIC_MEMBER = B.COLUMN_PROPERTY_CD
AND A.FINANCIAL_ELEM_ID = C.FINANCIAL_ELEM_ID 
ORDER BY 1;

Note:

When you generate a user-defined Financial Element, you must assign a Column Property attribute value.