Setting Up the Data Export Import Utility for Payment Dispatch

Before using the Data Export Import Utility for payment dispatch, review PeopleSoft Documents and document relationships delivered for use with Financial Gateway payment dispatch. You must also ensure that the map definition has been associated with the bank. Finally, select Data Mapper as the transformation type to create payment files using the Data Export Import Utility.

To set up payment dispatch through Financial Gateway using the mapping utility:

  1. Review the PeopleSoft documents delivered for use with Financial Gateway:

    • Source Document: FINANCIAL_GATEWAY, Payment.

    • Target Documents: FINANCIAL_GATEWAY, SEPA_CT_03, SEPA_CT_CH or SEPA_DD_02.

    Navigate to PeopleTools > Documents > Document Builder > Document.

    For more information, see Mapping File Layouts and Document Relationships.

    This example illustrates the fields and controls on the PeopleSoft Document page for the SEPA Direct Debit Target Document.

     Example of the PeopleSoft Document page for the SEPA Direct Debit Target Document

  2. Review the document relationship. The document relationship for the payment source document is delivered to support Financial Gateway payments.

    Navigate to Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > Document Relationship.

    For more information, see Mapping File Layouts and Document Relationships.

    This example illustrates the fields and controls on the Document Relationship page for the Payment Source Document.

     Example of the Document Relationship page for the Payment Source Document

  3. Review the map definition. The status of the map definition should always be Ready. If the status is Modified, then click the Validate button and then click the Submit button.

    Navigate to Set Up Financials/Supply Chain > Common Definitions > Data Export Import Utility > DEIU Map Definition.

    Note: If your business needs require you to generate alternate SEPA payment files, you can create similar PeopleSoft target documents and map definitions and associate the map definition with layout property FS_MAP_ID for the bank on the Bank Integration Layouts page.

    For more information, see Defining the Data Source and Target.

    This example illustrates the fields and controls on the Map Definition - Summary Page for the SEPA Direct Debit Map (1 of 2).

     Example of the Map Definition - Summary Page for the SEPA Direct Debit Map (1 of 2)

    This example illustrates the fields and controls on the Map Definition - Summary Page for the SEPA Direct Debit Map (2 of 2).

     Example of the Map Definition - Summary Page for the SEPA Direct Debit Map (2 of 2)

  4. Configure the layouts to use the Data Export Import Utility transformation by changing the transformation type to Data Mapper on the Layout Catalog page. A FS_MAP_ID layout property is associated with the layout when using Data Mapper.

    Navigate to Banking > Administer Bank Integration > Layout Catalog

    For more information, see Setting Up Common Components for Bank Statement, Payment, and Payment Acknowledgment Processing.

  5. Populate the Map Definition value for the FS_MAP_ID property on the Bank Integration Layouts page. This enables you to create separate map definitions for each bank and assign the appropriate map ID to a bank.

    Navigate to Banking > Administer Bank Integration > Bank Integration Layouts.

    For more information, see Setting Up Payment Processing.