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 |
|
Payment data |
|
Maintenance worksheet data |
|
Transfer worksheet data |
|
Draft worksheet data |
|
Posted item data |
|
Direct debit worksheet data |
|
Action list data |
PS_ACTION_LST |
Posted customer data |
|
Statement data |
|
Dunning data |
|
Overdue charge data |
|
Conversation data |
|
Revaluation |
PS_RVL_ACCTG_LN_AR |
Archived closed items |
|
Archived pending items |
|
Archived payments |
|
Archived direct debits |
|
Archived actions |
PS_AR_ACTION_LST_H |
Archived statements |
|