Generating the EFT Payment File and Banking Report

Page Name

Definition Name

Usage

Create EFT Payment File MEX Page

GPMX_BANK_EFT

Create an electronic flat file to be transferred (EFT) to the bank and generate a printed report.

Use the Create EFT Payment File MEX page (GPMX_BANK_EFT) to create an electronic flat file to be transferred (EFT) to the bank and generate a printed report.

Image: Create EFT Payment File MEX page

This example illustrates the fields and controls on the Create EFT Payment File MEX page. You can find definitions for the fields and controls later on this page.

Create EFT Payment File MEX page

Field or Control

Definition

Calendar Group ID

Select the Calendar Group ID for which you want to generate a payment file.

Pay Entity

Select the pay entity for which you want to generate a payment file.

Pay Entity Bank Id

Select the bank by Pay Entity. Option list displays the available banks populated after running the Payment Prep Process MEX.

Bank Format

Select the bank. Values are Banamex, BBVA Bancomer, Banorte, HSBC, Scotiabank, and Santander. Depending on which bank you select, additional fields may appear on this page. Each bank may require different information about the bank file transfer. The following table lists the additional fields that appear depending on the bank format you select.

Version and Format

For the Banamex bank format, you can build two versions of an EFT file: DOS or Windows. If you select the Windows version, you will also select the format:Pagomatico or Third Party.

Bank Format

Additional Fields that Appear

Banamex

File Name, Version, Format, Bank Cust ID, Reference Number A, Reference Number E, Message

Bancomer

File Name, Secondary Reference

Banorte

File Name, Bank Cust ID

HSBC

File Name, Transfer Type

Scotiabank

File Name, Bank Cust ID, Reference Number C, Reference Number D, Message

BBVA Cash

File Name

Banamex Interb

File Name, Payment Term, Reference Number E, Message

Santander

File Name, Transfer Type

Note: Once the GP_PAYMENT table and the GPMX_PAYMENT table are populated, you can launch an SQR that generates the flat file for banking along with a printed report of payment details.