Generating the EFT Payment File and Banking Report
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
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.
Navigation
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.
|
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.