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 LedgerFor 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 (fromFSI_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.