Parameter Tables

The Housekeeping option clears data from specific SQL tables.

Number of Months to Retain Ledger Details
Ledger detail rows are cleared only if the source transaction is complete and the value POSTED_TO_LI_IND is 1, 3 or 8. These tables are cleared:
  • ZZZ_LDG_DETAIL_LI_XREF
  • ZZZ_LDG_DETAIL_LAD
  • ZZZ_LDG_DETAIL
Number of Weeks to Retain Interface Tables
These tables are cleared:
  • ACNT_PYMT_IFACE
  • ASSET_DISPOSAL_IFACE
  • ASSET_STATUS_IFACE
  • CALC_DEP_IFACE
  • CASH_SUMMARY_IFACE
  • DAYBOOK_IFACE
  • GEN_PYMT_IFACE
  • LDG_REVAL_IFACE
  • PMD_RDS_IFACE
  • PMD_RPTG_IFACE_TBL
  • TAX_RPTG_IFACE_FIN
  • PMD_RPTG_IFACE_TBL
  • TAX_RPTG_IFACE_SC
  • TAX_RPTG_IFACE_SOP
  • PMD_RPTG_IFACE_TBL
  • TRIAL_BAL_IFACE
  • TXN_MATCH_IFACE
  • VOID_PYMT_IFACE
Number of Weeks to Retain Financial Reports
These tables are cleared:
  • FIN_ANL_RPT
  • FIN_STMNT_RPT
  • FIN_TBL_RPT
Number of Weeks to Retain Business Unit Temporary Tables
These tables are cleared:
  • BUCPY_STD_TEXT
  • BUCPY_TEMP_DAG
  • BUCPY_TEMP_FILTER
  • BUCPY_TEMP_OPR
  • BUCPY_TEMP_OPR_GRP
  • BUCPY_XFER_TBL_LIST
  • BU_TEMPLATE_PARAMS
Number of Weeks to Retain Business Unit Work Tables
These tables are cleared:
  • ZZZ_AUTHORISTN_SET_BANK
  • ZZZ_AUTHORISTN_SET_PAY
  • ZZZ_BILLING_LINK_ADJUST
  • ZZZ_COSTING_ITEM_COSTS
  • ZZZ_COSTING_UD_COSTS
  • ZZZ_COSTING_WORK
  • ZZZ_COSTING_KEY_INFO
  • ZZZ_CURRENTLY_SELECTED
  • ZZZ_DOC_FMT_HLD
  • ZZZ_GEN_INVY_CNT_WRK_1
  • ZZZ_LINK_CHECK
  • ZZZ_NOTE_DETAIL_TEMP
  • ZZZ_NOTE_LDG_TEMP
  • ZZZ_NOTE_TEMP
  • ZZZ_PSTG_ERR_MSG
  • ZZZ_PSTG_ERR
  • ZZZ_PSTG_WRK_TBL_NOTE
  • ZZZ_PSTG_WRK_TBL
  • ZZZ_SAPYDDB
  • ZZZ_SAPYPAY
  • ZZZ_VCHR_WRK
Number of Weeks to Retain Other Work Tables
These tables are cleared:
  • DAG_TEMP
  • OPR_BU_PERD
  • OPR_SESSION
  • RECON_MGR_TEMP_LAD
  • RECON_MGR_TEMP

Once Run is selected these tables are cleared:

  • DDE_USER_LABEL_WRK
  • OFCD_WORK_FILE
  • RI_ERR