1. User Guide
  2. Modification and Mapping of Reporting Lines
  3. Map Reporting Line Items
  4. Map Income Statement Leaf Nodes to Financial Elements

6.3.1 Map Income Statement Leaf Nodes to Financial Elements

IS reporting lines are seeded into the application and a default mapping is provided between Financial Element (FE) and Reporting Lines. The mapping of FE and IS reporting lines are present in the DIM_REPORTING_LINE_ATTR table. This mapping can be enhanced based on the requirements and the data need to be created as tabulated below:

Columns: REPORTING_LINE_ID and FINANCIAL_ELEM_ID

Table 6-1 DIM_REPORTING_LINE_ATTR

V_COMPONENT_CODE V_COMPONENT_DESC V_COMPONENT_VALUE
REPORTING_LINE_ID Column to stores Reporting Line Identifiers
ATTRIBUTE_ID Column to store the type of attribute used for Mapping

1-Financial Element

2-Signage
DIM_ATTRIBUTE_NUMERIC_MEMBER Column to store the actual attribute, that is. Financial Element or Signage
  1. Actual Financial Element Code is used in this column in case the ATTRIBUTE_ID = 1
  2. Signage value 1 or 2 is used in this column to signify positive signage or negative signage. Signage is applicable only when ATTRIBUTE_ID=2
  • It is not required to process the mapping of financial elements 140 and 100 to reporting lines (Average Bal and End Bal).
  • A single reporting line should be mapped only to one financial element.
  • IS reporting lines are applicable for allocated data from OFS PFT.
  • Management Reporting - Income Statement: The Identity Codes available in the FSI_D_MANAGEMENT_LEDGER table, having source_type as 100 are considered for populating Income Statement reporting lines in the FCT_MGMT_REPORTING table.

    Select identity_code from FSI_DATA_IDENTITY where source_type = 100;