Understanding Archive Objects Definitions, Query Definitions, and Template Definitions
PeopleSoft Receivables delivers archive object definitions, query definitions, and template definitions to archive:
Pending item data
Payment data
Posted item data
Action list data
Direct debit data
Statement data
You can modify them if needed using the Data Archive Manager. You can also use the Data Archive Manager to create your own archive object definitions, query definitions, and template definitions to archive other types of data.
Archive Object Definitions
An archive object definition identifies the tables that contain the data to be archived and the history tables that will be updated for each table. PeopleSoft Receivables delivers these archive objects:
Data Type |
Archive Object |
---|---|
Pending item data |
AR_ARCH_PENDING_ITEM |
Payment data |
AR_ARCH_PAYMENTS |
Posted item data |
AR_ARCH_ITEMS |
Direct debit data |
AR_ARCH_DIRECT_DEBITS |
Action list data |
AR_ARCH_ACTIONS |
Statement data |
AR_ARCH_STATEMENTS |
Archive Query Definitions
Each archive query definition defines the selection criteria to archive data from transaction tables. PeopleSoft Receivables delivers these archive queries:
Data Type |
Archive Query |
---|---|
Pending item data |
AR_ARCH_PENDING_ITEM |
Payment data |
AR_ARCH_PAYMENTS |
Posted item data |
AR_ARCH_ITEM |
Direct debit data |
AR_ARCH_DIRECT_DEBIT |
Action list data |
AR_ARCH_ACTION_LST |
Statement data |
AR_ARCH_STATEMENTS |
Review these queries to determine whether you want to add additional selection criteria for the transactions to be archived.
Archive Template Definitions
When you archive data, you select an archive template definition. Each archive template definition includes one or more archive object definitions and the archive query definitions used to select the data. PeopleSoft Receivables delivers these archive templates:
Data Type |
Archive Template |
---|---|
Pending item data |
ARPEND |
Payment data |
ARPYMT |
Posted item data |
ARITEM |
Direct debit data |
ARDIRDEB |
Action list data |
ARACTLST |
Statement data |
ARSTMT |