Setting Up DEIU to Import EDI Payment Data

PeopleSoft provides a setup with sample field mapping for staging EDI payment data using the Data Export Import Utility. To set up the import process:

  1. Review PeopleSoft Documents for both source and target documents.

  2. Verify DEIU map definitions for EDI file transformation.

The EDI payment data import process is supported for flat and delimited EDI files.

For more information about setting up DEIU, see Application Fundamentals: Mapping File Layouts and Document Relationships and Application Fundamentals: Defining the Data Source and Target.

Reviewing the PeopleSoft Documents

Use the Document Builder - Document page (IB_LOGICALSCHEMA) to view and edit a document in the Document Builder.

Before using the Data Export Import Utility for EDI payment file import, review the PeopleSoft Documents delivered for use with EDI files.

PeopleSoft provides the following sample documents or layouts to support the Receivables payment load process:

  • Load Delimited Payment EDI File process

    • Source: PeopleSoft Document EDI_820_DELIMITED_FILE

    • Target: PeopleSoft Document EDI_820_PAYMENT

  • Load Payment EDI File process

    • Source: File Layout (Fixed) PAYMENT_LOAD

    • Target: PeopleSoft Document EDI_820_PAYMENT

Verifying the Map Definition

Use the Map Definition component (FS_MAPPER_DEF_WIZ) to set up the transformation from data source to target output.

The EDI payment file transformation occurs through the online mapping definition. DEIU provides a horizontal navigation, or train stops, to define a map that links the data source and target output format along with any data filter criteria. PeopleSoft provides sample EDI file map definitions for both flat files and delimited files. Businesses should create, test, and put their own map definitions into production.

PeopleSoft delivers the following sample map definitions:

  • The Load Delimited Payment EDI File process uses the map ID EDI_820_DELPAY_IMPORT.

  • The Mapping for the Load Payment EDI File process uses the map ID EDI_820_PAYMENT_IMPORT.

The Edit Transform Property secondary page is used to define the parameters for the selected transformation rule. PeopleSoft provides system-delivered transformation rules with the map definitions for EDI payment data import.

Note:

The Data Export Import Utility is a generic transformation tool that is used across PeopleSoft Financials. Not all transform types supported by Data Export Import Utility are applicable to EDI file data import.