The database for a Financials business unit comprises a number of tables. When you define a new business unit, the mandatory database tables are initialized.
Optional Ledger Tables (OLT) is used to initialize the following optional files that may be required to hold additional financial information for a business unit:
Click here to see the screenshot.
Select Action >> Create or click Create to initiate the process.
Business Unit Code
The code identifying an existing business unit for which you want to create new tables.
Ledger BalanceThis is used to create a balance table for a selected ledger, for the business unit. Choose A to create a balance table for the actuals ledger. Choose B to K to create a balance table for the associated budget ledger.
You cannot create a balance table for a ledger that doesn't exist. For example, you can not create a balance table for a budget ledger if you have not first created the budget ledger itself.
The balance table remains empty until you create the balances and update the table using Ledger Balances Update or Ledger Balances Rebuild.
Journal HoldSelect Yes to create a journal hold table for the business unit. This is used to store unposted journals. See What are Held Journals?.
BudgetA budget table must be created to contain the budget ledger values. You must select the budget ledger you want to create which is identified by the ledger code B to K. A description should be created in
Budget Labels (
BUL).
Balance Table Analysis Code Consolidation
If you choose to create a balance table for an existing database, with analysis dimensions and codes defined, the Balance Table Analysis Code Consolidation form appears. This lists each of the analysis dimensions defined for the ledger and allows you to specify the ledger analysis dimension consolidation you require.
Click the Consolidate box alongside the dimensions you want to be consolidated, if any. Consolidated codes are not held on the balance table so cannot be used for reporting using balances.