3.6.1 Super-class Entities

Profitability processing mandates the Ledger class table to have a certain set of columns. These columns have been put together in super-class entities.

The following are the seeded super-class entities:

  • BASIC_LEDGER_CLASS_REQ: Contains the columns required for Ledger Class tables.
  • The FSI_D_MANAGEMENT_LEDGER.ENTERED_BALANCE column stores entered or transacted balances that correspond to the local currency in which the transactions were booked in your General Ledger.
  • The FSI_D_MANAGEMENT_LEDGER.FUNCTIONAL_BALANCE column stores balances in the Functional currency of your General Ledger

Note:

When Initially loading data from Staging fo Management Ledger, Entered and Functional currency balances should correspond to the values originally booked into your General Ledger

For a mono-currency implementation:

  • The Entered balance should equal the Functional balance on each Management Ledger row
  • The ISO_CURRENCY_CD for each Management Ledger row should match your Functional Currency (from FSI_DB_INFO).

For multi-currency implementations:

  • When a Management Ledger row's ISO_CURRENCY_CD is the same as your Functional Currency, the Entered balance will equal the Functional balance
  • The Entered balance will equal the Functional balance for all statistical rows (ISO_CURRENCY_CD = 002)
  • Generally, the Entered balance will NOT equal the Functional balance for Management Ledger rows where ISO_CURRENCY_CD is different than your Functional Currency
  • The ratio of Entered balance to Functional balance - the observed exchange rate for the row -- is determined within your source General Ledger. Typically, ending balances will match end-of-month exchange rates while P&L balances may reflect weighted monthly average exchange rates.

Note:

For more information on how Entered & Functional balances are used with applications, see the Multicurrency in the OFS Profitability Management User Guide.