Assigning Ledger Tables
Each ledger is assigned to a database table, but different ledgers might not be stored in the same table. Some ledgers need different amount formats (for example, number of decimal places) or a different field configuration than others. Summary ledgers must be stored in different tables than their corresponding detail ledgers.
Because each installation of PeopleSoft General Ledger has different ChartFields and reporting requirements, each installation must assign ledger tables and indexes to meet its requirements and ensure good reporting performance.