Understanding the DC_PENDITEM_CI Component Interface

When you implement the PeopleSoft Receivables system, you will want to convert existing information to the PeopleSoft Receivables system. Use the DC_PENDITEM_CI component interface and the Excel to Component Interface utility to populate existing PeopleSoft tables with data from third-party applications. The interface uses a combination of technologies such as iScript, Microsoft Excel spreadsheets, and Visual Basic for Application programs to convert data.

The DC_PENDITEM_CI component interface is a PeopleTools object that is created in PeopleSoft Application Designer that enables you to access a PeopleSoft component from another application. The component interface uses business logic to update the data in the Pending Item tables. You do this by using the ExceltoCI.xls Excel spreadsheet to map the data and move the data into the PeopleSoft Receivables tables.

The component interface populates these tables:

• PS_GROUP_CONTROL

• PS_PENDING_ITEM

• PS_PENDING_VAT

• PS_PENDING_TAX

• PS_PENDING_TAX_DTL

• PS_PENDING_DST

Note:

Excel has a physical limitation of 256 columns and 65k rows. To work around these limitations, you may need to limit the import data so that the number of rows on the Data Input page does not exceed 65k.

The user must have privileges to the DC_PENDITEM_CI component interface with full access to create methods to run the component interface.