Understanding EDI Payment File Import Using the Data Export Import Utility

PeopleSoft Receivables enables you to receive a payment (cash and remittance advice combined) or just the remittance (remittance information without cash) in an Electronic Data Interchange (EDI) transmission.

PeopleSoft Receivables supports both European and U.S. EDI formats. The European EDI standard is EDIFACT, and the supported format is CREEXT. The U.S. standard is ANSI-X12; its supported format is 820.

The Data Export and Import Utility provides a mechanism to import the raw or translated EDI files with payment data into the staging tables, bypassing steps that are needed using application messages. PeopleSoft Receivables provides a sample setup to import EDI payment data using the Data Export Import Utility. Businesses should test their own DEIU setup before implementation.

The EDI payment data transformation is based on People Tools Document Technology and the Data Export and Import Utility (DEIU) tool, which allows users to configure transformation through an online mapping component. Users should be familiar with PeopleSoft documents, as well as Data Export Import Utility map definitions and document relationships, before customizing EDI file import setup using DEIU.

PeopleSoft delivers the following sample DEIU transformation programs for processing EDI payment files and loading the data in the Receivables payment staging tables.

Receivables Process	Delivered DEIU Transformation Program	EDI File Type
Load Payment EDI File	EDI_820_PAYMENT_IMPORT_RUN	Flat
Load Delimited Payment EDI File	EDI_820_PAYMENT_DELIMITED_RUN	Delimited

Once data is loaded into the staging tables, run the Payment Interface Application Engine to load payment data into the Receivables tables.

For more information about the Data Export Import Utility, see Application Fundamentals: Understanding the Data Export Import Utility.