Ledgers Used by ADB

There are two ledgers involved in ADB processing: the ADB ledger and the target ADB ledger.

• The source ADB ledger (also known as the ADB ledger) stores the daily ledger activity that is used by the ADB process to calculate the average daily balances.

• The target ADB ledger stores the calculated averages from the ADB process.

You can have as many target ADB ledgers as you need.

This design has several advantages:

• Flexibility to maintain the average balances in different ledger tables:

  • Partition your averages to different target ledger tables, such as period type (MTD—month-to-date, YTD—year-to-date, and QTD—quarter-to-date), which can improve processing performance.

  • You can maintain all the averages in a single table.

• Flexibility to define a calendar ID to maintain the calculated average daily balance history:

  • To maintain month-end balances, use only the monthly calendar ID, which represents the current day's averages.

  • To maintain daily balances, use the daily calendar ID.