Understanding PeopleSoft Receivables Pending Item Tables

PeopleSoft Receivables accepts information from an unlimited number of billing systems. The relational structure of tables is flattened to contain posted data to simplify the interface process for converting existing items or bringing in billing information.

At a minimum, the interface program or utility must populate two tables:

• PS_GROUP_CONTROL

• PS_PENDING_ITEM

If you use the system for VAT processing, the system populates an additional table, PS_PENDING_VAT, with VAT data.

If you use the system for excise duty and sales taxes in India, the system populates additional tables: PS_PENDING_TAX and PS_PENDING_TAX_DTL.

If you create accounting entries during the Receivables Update process, the system creates rows in a sixth table, PS_PENDING_DST. Under certain circumstances and with certain limitations, you may also need to populate PS_PENDING_DST in your interface.

Because the PS/Import utility runs only on the client and has limited processing capability, write an interface program or use a tool such as Structured Query Report (SQR) to populate the interface tables. As another alternative, use the DC_PENDITEM_CI component interface to populate the pending item tables.