Clearing PeopleSoft Receivables Transaction Tables

During your implementation process, you may have entered test data that you want to delete without going through a formal archiving process.

To remove test data without going through a formal archiving process, remove records from the database through a program that you have written. If you have tested archiving, you will also need to remove data from the history tables.

This section lists the tables, keyed by business unit, from which you need to delete rows to clear receivables transactions and history from the system:

Type of Data

Tables

Pending item data

  • PS_GROUP_CONTROL

  • PS_PENDING_DST

  • PS_PENDING_ITEM

  • PS_PENDING_VAT

  • PS_PENDING_TAX

  • PS_PENDING_TAX_DTL

  • PS_PENDING_IT_MRL

Payment data

  • PS_DEPOSIT_CONTROL

  • PS_PAYMENT

  • PS_PAYMENT_ID_CUST

  • PS_PAYMENT_ID_ITEM

  • PS_PAYMENT_ITEM

  • PS_PAY_MISC_DST

  • PS_ITEM_MRL

  • PS_EE_DJR_ACCTG_LN

Maintenance worksheet data

  • PS_WS_CONTROL

  • PS_WS_ID_CUST

  • PS_WS_ID_ITEM

  • PS_WS_ITEM

Transfer worksheet data

  • PS_TRN_CONTROL

  • PS_TRN_ID_CUST

  • PS_TRN_ID_ITEM

  • PS_TRN_ITEM

Draft worksheet data

  • PS_DRAFT_CONTROL

  • PS_DRAFT_ITEM

  • PS_DR_REMIT_CNTL

  • PS_DR_REMIT_CUST

  • PS_DR_REMIT_DATE

  • PS_DR_REMIT_DTL

  • PS_DR_REMIT_ITEM

Posted item data

  • PS_ITEM

  • PS_ITEM_ACT_VAT

  • PS_ITEM_ACTIVITY

  • PS_ITEM_DST

  • PS_ITEM_ACTTAX

  • PS_ITEM_ACTTAX_DTL

  • PS_ITEM_AUDIT

  • PS_AR_IPAC_HDR

  • PS_AR_IPAC_SGL

  • PS_AR_IPAC_DETAIL

  • PS_AR_CC_TRAN_HDR

  • PS_AR_CC_TRAN_TBL

  • PS_EE_ITM_ACCTG_LN

Direct debit worksheet data

  • PS_DD_CONTROL

  • PS_DD_ITEM

  • PS_DD_ITEM_MRL

Action list data

PS_ACTION_LST

Posted customer data

  • PS_CUST_AGING

  • PS_CUST_DATA

  • PS_CUST_HISTORY

  • PS_SUBCUST_AGING

  • PS_SUBCUST_DATA

  • PS_SUBCUST_HISTORY

Statement data

  • PS_STMT_CUST

  • PS_STMT_CUST_DTL

  • PS_STMT_CUST_BFWD

  • PS_AR_STMT_CUST

Dunning data

  • PS_DUN_CUST

  • PS_DUN_CUST_DTL

Overdue charge data

  • PS_FC_CUST

  • PS_FC_CUST_DTL

Conversation data

  • PS_CUST_CONVER

  • PS_CUST_CONVER_DTL

  • PS_CUST_CONVER_HDR

  • PS_CUST_CONVER_ATT

Revaluation

PS_RVL_ACCTG_LN_AR

Archived closed items

  • PS_AR_ITEM_H

  • PS_AR_ITEM_DST_H

  • PS_AR_ITM_ACTVTY_H

  • PS_AR_ITM_ACTVAT_H

  • PS_AR_ITM_ACTTAX_H

  • PS_AR_ITMACTXDT_H

  • PS_AR_ITEM_AUDIT_H

  • PS_AR_IPAC_HDR_H

  • PS_AR_IPAC_SGL_H

  • PS_AR_IPAC_DET_H

  • PS_AR_CCTRN_HDR_H

  • PS_AR_CCTRN_TBL_H

  • PS_AR_EE_ITACLN_H

Archived pending items

  • PS_AR_GROUP_CNTL_H

  • PS_AR_PEND_ITM_H

  • PS_AR_PEND_DST_H

  • PS_AR_PEND_VAT_H

  • PS_AR_PEND_TAX_H

  • PS_AR_PEND_TX_DT_H

  • PS_AR_PEND_IT_MR_H

Archived payments

  • PS_AR_DEP_CONTRL_H

  • PS_AR_PAYMENT_H

  • PS_AR_PAY_ITEM_H

  • PS_AR_PAY_ID_CUS_H

  • PS_AR_PAY_ID_ITM_H

  • PS_AR_PAY_IT_MRL_H

  • PS_AR_PAY_MIS_DS_H

  • PS_AR_EE_DJR_ACT_H

Archived direct debits

  • PS_AR_DD_CONTROL_H

  • PS_AR_DD_ITEM_H

  • PS_AR_DD_ITM_MRL_H

Archived actions

PS_AR_ACTION_LST_H

Archived statements

  • PS_AR_STMT_CUST_H

  • PS_AR_STMT_CUSTDT_H

  • PS_AR_STMT_CUSBD_H

  • PS_AR_STMT_CUS_H