Using PeopleSoft Receivables 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