5.11.2.7 Tables Related to LEDGER_STAT Load Procedure

LEDGER_STAT Loader utility uses the following tables:

  • FSI_FISCAL_YEAR_INFO: The table contains the fiscal year information. This is a setup table.
  • FSI_LS_LOAD_BATCH: The table contains the parameters for the load batch that needs to be executed for loading ledger data from staging or load table into LEDGER_STAT. This is a setup table.
  • STG_GL_DATA: The staging table contains the ledger data for various as-of-dates.
  • LEDGER_STAT: The processing table contains the ledger data for various fiscal months. This is loaded from staging table.