Parameter Tables
The Housekeeping option clears data from specific SQL tables.
- Ledger Dtls Retention Months
- 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
- Interface Tbls Retention Weeks
- 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
- Del Fin Rpts Retention Weeks
- These tables are cleared:
- FIN_ANL_RPT
- FIN_STMNT_RPT
- FIN_TBL_RPT
- Del BU Tmp Tbl Retention Weeks
- 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
- Del BU Wrk Tbl Retention Weeks
- 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
- Del Other Tbl Retention Weeks
- These tables are cleared:
- DAG_TEMP
- OPR_BU_PERD
- OPR_SESSION
- RECON_MGR_TEMP_LAD
- RECON_MGR_TEMP
Once is selected these tables are cleared:- DDE_USER_LABEL_WRK
- OFCD_WORK_FILE
- RI_ERR