Understanding Interface Tables

The Receivables Update process uses the information contained in the pending data tables to create and update rows in the tables that contain posted data.

Pending Data Tables Include:	Posted Data Tables Include:
PS_GROUP_CONTROL	PS_CUST_DATA
PS_PENDING_ITEM	PS_CUST_HISTORY
PS_PENDING_VAT	PS_SUBCUST_DATA
PS_PENDING_TAX	PS_ITEM_ACTTAX
PS_PENDING_TAX_DTL	PS_ITEM_ACTTAX_DTL
PS_PENDING_DST	PS_SUBCUST_HISTORY
	PS_ITEM
	PS_ITEM_ACTIVITY
	PS_ITEM_ACT_VAT
	PS_ITEM_DST

Use these tables to interface continuously with a billing system for the purposes of conversion and for online and background processing within PeopleSoft Receivables. They provide a single point of processing for the Receivables Update process.

Just as you populate PS_GROUP_CONTROL, PS_PENDING_ITEM, and possibly PS_PENDING_VAT, PS_PENDING_DST, PS_PENDING_TAX, or PS_PENDING_TAX_DTL, the PeopleSoft Receivables processes populate these tables as a result of group item entry, overdue charge processing, and activity from payments, maintenance, transfer worksheets, unpost processing, and draft processing; and direct debit processing, the Automatic Maintenance Application Engine process (AR_AUTOMNT), and the Payment Predictor Application Engine process (ARPREDCT).

The system defines the groups that you create for billing interface or conversion purposes as external groups, and they receive more extensive editing during the Receivables Update process. When you enter groups online during group item entry, the system performs online edits that reduce the editing that is needed during the Receivables Update process. The PeopleSoft application categorizes the third kind of group (created by the system through the worksheet, overdue charge, unpost, draft, direct debit, item splits, and the Automatic Maintenance and Payment Predictor processes) as system-defined groups with a required origin of PS_AR. These system-defined groups receive the least amount of editing during the Receivables Update process.