Ledger Tables

Ledgers are stored in tables within a database. The key fields in a ledger table are Business Unit, Ledger, ChartFields, Fiscal Year, and Accounting Period; Net Period Activity is not a key field.

Before posting, General Ledger validates data posted to the ledger table against other tables in the system. You set up the tables used for validation to enable the system to post transactions to the ledger. Remember:

• When you post journal entries, the system stores net period activity (debits and credits combined) for each ChartField combination.

• The system does not store year-to-date balances, but calculates these balances for reports.

• The calendar for a ledger determines whether the amount of time in an accounting period is a week, a month, a quarter, or other period.

• You can store multiple ledgers (such as actuals, budgets, or statistics) with identical ChartFields on a single table.

• You can balance debits and credits for ledgers at the ledger level, business unit, or at the ChartField level.