This chapter discusses how to:
Set up electronic funds transfer (EFT) processing.
Define EFT payment format codes.
Manage bank and branch files for EFT payments.
Define Automatic Clearing House (ACH) layouts.
Note. The processes and procedures described here pertain to the FIN2025 electronic payment file formatting process used by Receivables and by the Pay Cycle Manager in PeopleSoft Enterprise Payables. Cash Management provides enhanced EFT functionality through its Financial Gateway functionality. To set up payment file formatting for Financial Gateway, refer to the PeopleSoft Enterprise Financial Gateway PeopleBook.
See Also
Setting Up Electronic Banking Using Financial Gateway
To define EFT layouts, use the EFT File Layout component (EFT_LAYOUT_GBL)
To define ACH layouts, use the ACH Layout component (ACH_LAYOUT_GBL)
PeopleSoft provides several EFT layouts that you can use as delivered or modify. In addition, you must specify EFT payment format codes. These codes define the number of extra settlement days to consider when the system calculates payment schedules for EFTs.
In the event that you need to use an EFT file layout that PeopleSoft does not deliver with this release, you can add a new layout to the EFT processing package.
This section discusses how to:
Add a new layout to the EFT File Layouts page.
(Optional) Modify these existing layouts:
(GBR) BACS
(NLD) BTL91
(CAN) CPA005
(CHE) DTALSV
(DEU) DTAZV
(FRA) ETEBAC
(SGP) FEDI
Create the Structured Query Copybook (SQC) module that formats the payment details into your layout.
PeopleSoft delivers a template to help you do this.
Important! After you create the SQC module, you must tie it to the main EFT routing SQC to enable the EFT layout.
If you are adding additional EFT layouts, you should be familiar with coding in Structured Query Report-writer (SQR).
PeopleSoft delivers two types of file layouts: those intended for nongovernmental business use, and those intended for US federal government payments.
The “+” suffix of a PPD or CCD file layout indicates the file includes an 80 character addendum section. Addenda records are used by the Originator (originating financial institution) to supply additional information about the detail records that are transferred from the ODFI (Originating Depository Financial Institution) through the ACH Operator to the RDFI (Receiving Depository Financial Institution). The addenda transactions serve as an “envelope” to contain ANSI x.812 EDI 820 transactions.
In PeopleSoft, the CCD+ layout has certain restrictions. The RMR (Remittance Advice Accounts Receivables Open Item Reference) segment is the only transaction (out of many ANSI x.812 EDI 820 transactions) that is supported by PeopleSoft. In addition, the implementation of RMR segment is limited to certain remittance information such as invoice number.
The following table lists the delivered ACH and EFT layout formats that are generally used for nongovernmental payments and their country of use. For file formats that are required by the US Federal Government, see the section entitled US Federal ACH and EFT Layouts.
Layout Name/Code |
Description |
Country |
Layout Type |
CCD+ |
Cash Collect & Disburse Plus |
(USA) |
ACH |
PPD |
Prearranged Payment & Deposit |
(USA) |
ACH |
BACS |
BACS |
(GBR) |
EFT |
BECS |
Bulk Electronic Clearing System |
(AUS) |
EFT |
BSI1 |
Domestic Payments |
(BEL) |
EFT |
BSI4 |
International Payments |
(BEL) |
EFT |
BTL91 |
ABN AMRO Btl91 |
(NLD) |
EFT |
CLIEOP2 |
ClieOp2 |
(NLD) |
EFT |
CLIEOP3 |
ClieOp3 |
(NLD) |
EFT |
CPA005 |
Canadian Payment Association. |
(CAN) |
EFT |
CSB19 |
Direct Debit |
(ESP) |
EFT |
CSB34 |
CSB34 |
(ESP) |
EFT |
CSB43 |
Direct Debit |
(ESP) |
EFT |
DDRD |
Direct Debit |
(JPN) |
EFT |
DOM80 |
Direct Debits |
(BEL) |
EFT |
DTALSV |
Payments |
(CHE) |
EFT |
DTAUS |
Domestic Payments |
(DEU) |
EFT |
DTAZV |
International Payments |
(DEU) |
EFT |
EDI |
EDI Manager |
(USA) |
EFT |
ETBDD |
Direct Debit |
(FRA) |
EFT |
ETBDR |
Drafts |
(FRA) |
EFT |
ETBIPT |
International Payments |
(FRA) |
EFT |
ETEBAC |
Domestic Payments |
(FRA) |
EFT |
FEDI |
Singapore Giro |
(SGP) |
EFT |
GENX |
General Transfer |
(JPN) |
EFT |
HIPAA |
HIPAA 820 Outbound Map |
(USA) |
EFT |
IPAC |
IPAC Federal Payments |
(USA) |
EFT |
ISABEL |
Payment Clearing System |
(BEL) |
EFT |
ITAPYMT |
Domestic Payments |
(ITA) |
EFT |
KIJ |
Kijitsu |
(JPN) |
EFT |
MT100 |
SWIFT Customer Transferr |
(USA) |
EFT |
MT202 |
SWIFT Financial Institution Transfer |
(USA) |
EFT |
PPD |
Prearranged Payment & Deposit |
(USA) |
EFT |
RIBA |
Drafts |
(ITA) |
EFT |
RID |
Direct Debit |
(ITA) |
EFT |
UFF |
Universal File Format |
(USA) |
EFT |
The United States Federal Government (through the US Treasury) has certain requirements for check, ACH, and EFT payments. Setting up this information (that is, defining that the file layout is for employee vendors, other vendors, or both) enables edits that are associated with the voucher creation process to work correctly. The edits check that the bank account and the file layout for the vendor payment are correct as per US Treasury specifications.
These specifications include the following:
That employee payments are on a PPD or PPD+ file format.
That vendors' (non-employee vendors) payments are on a CCD, CCD+, or CTX file format.
That payments, including both employee and non-employee vendors, are on the SF1166SCHK, ECSCHK, or SDPR file format.
Note. You must use the SF1166SCHK, ECSCHK, or SDPR file format for payments that are created for both employee and non-employee vendors. These file formats are check requests to the US Treasury, and designed to bypass the system edit for federal ACH or EFT payments.
These EFT and ACH layouts that are delivered by PeopleSoft are specific for use when conducting business with the United States Federal government:
Layout Name |
Format |
Layout Type |
Use |
CTX |
Corporate Trade Exchange (CTX) flat file payment order |
ACH |
Non-employee |
CTX820FED |
CTX ASC X120 820 payment order |
ACH |
Non-employee |
ECSCHK |
ECS vendor check payment |
EFT |
Both employee and non-employee |
ECSVNDR |
ECS vendor ACH payment (CCD+) |
EFT |
Non-employee |
ECSTRVL |
ECS travel ACH payment (PPD+) |
EFT |
Employee |
SDPR |
ECS same day payment request (SDPR) |
EFT |
Both employee and non-employee |
SF1166SCHK |
Bulk vendor check payment |
EFT |
Both employee and non-employee |
SF1166VNDR |
Bulk vendor ACH payment (CCD+) |
EFT |
Non-employee |
SF1166TRVL |
Bulk travel ACH payment (PPD+) |
EFT |
Employee |
You can also add file formats. You should refer to the United States Federal Treasury web site (http://www.ustreas.gov/) regarding file payment requirements before creating and adding file payment formats.
Another delivered federal EFT layout (that is listed in the table entitled Delivered ACH and EFT layouts) is the IPAC layout. The Intragovernmental Payment and Collection System (IPAC) is an interagency funds transfer mechanism for US federal agencies. The IPAC EFT layout is used in conjunction with Payables to process three types of IPAC transactions: payments, adjustments, and zero-dollar transactions.
If you are processing IPAC transactions in Payables, the following two items must be defined in PeopleSoft banks functionality:
The delivered IPAC EFT layout is enabled for system use (select the pertinent options next to the EFT Layout Code field).
The bank accounts that process IPAC transactions are configured with the IPAC EFT layout on the External Accounts - Payment Methods page.
See Also
Setting Up EFT and ACH Payment Formats
If you are setting up PeopleSoft EFT functionality to conduct business with United States Federal or government agencies, you must first complete the Enable Federal Payment region on the Installation Options - Payables page. Completing this region ensures that certain federal-specific fields display in this component.
See Also
Setting Up Payables Installation Options
EFT Number |
Enter the number that is associated with the SQC file name (for example, FINEFT02.SQC). |
File |
Displays the next file number that the system uses every time that you create a new file in the specified layout. |
File Ext (file extension) |
Displays a user-defined file extension (for example, BACS002.txt). To output the file to the web, you must save it as .txt. |
NNE (National Remitter Number) |
Displays the number that is assigned by the National Bank in France for EFT file transmissions. |
Output Filename |
Displays a user-defined output file name. |
Page Name |
Object Name |
Navigation |
Usage |
EFT File Layouts |
EFT_LAYOUT |
Set Up Financials/Supply Chain, Common Definitions, EFT, EFT File Layouts |
View, modify, and add any EFT layouts. |
BACS Options |
BACS_LOGON_UK |
Click Detail for the BACS EFT file layout on the EFT File Layouts page. |
(GBR) Set options for the BACS format. |
BTL91Options |
BTL91_EFT_OPTIONS |
Click Detail for the BTL91 EFT file layout on the EFT File Layouts page. |
(NLD) Set options for the BTL91 format. |
CPA005 Options |
CPA005_EFT_OPTIONS |
Click Detail for the CPA005 file layout on the EFT File Layouts page. |
(CAN) Set options for the CPA005 format. |
DTALSV Options |
DTALSV_EFT_OPTIONS |
Click Detail for the DTALSV file layout on the EFT File Layouts page. |
(CHE) Set options for the DTSALV format. |
DTAZV Options |
DTAZV_EFT_OPTIONS |
Click Detail for the DTAZV file layout on the EFT File Layouts page. |
(DEU) Set options for the DTAZV format. |
ETEBAC Options |
ETEBAC_EFT_OPTIONS |
Click Detail for the ETEBAC EFT file layout on the EFT File Layouts page. |
(FRA) Set options for the ETEBAC format. |
FEDI Options |
FEDI_EFT_OPTIONS |
Click Detail for the FEDI EFT file layout on the EFT File Layouts page. |
(SGP) Set options for the FEDI format. |
Access the EFT File Layouts page.
The options next to the EFT Layout Code field determine the purpose of the EFT file, where applicable.
Pay |
Select if the file layout is for payment files. |
DD |
Select if the file layout is for direct debits. |
DR |
Select if the file layout is for draft files. |
In |
Select if the file layout is for inbound files. |
Out |
Select if the file layout is for outbound files. |
The remaining fields are:
Federal Payment Indicator |
Indicates that an EFT layout is applicable for Federal payments. When a voucher is saved, the system verifies that the correct payment format is selected for the vendor type bank account. Note. This field is visible only when Enable Federal Payment is selected on the Installation Options - Payables page. Select from these options: Employee: You must associate employee vendor payment methods with a valid PPD or PPD+ EFT file layout. Delivered valid file layouts are ECSTRVL and SF116TRVL. Vendor: You must associate all other vendor (non-employee) payment methods with a valid CCD or CTX EFT file layout. Delivered valid file layouts are ESCVNDR, SF1166VNDR, CTX, and CTX820FED. Both: For employee and vendor payments. You must associate this option with a valid PPD or PPD+ EFT file layout. Delivered valid file layouts are ECSCHK, SDPR, and SF1166SCHK. |
Max Remits (maximum remittances) |
Use to limit the number of invoices that are included on each payment to the specified number. |
ID Type |
Enter the type of identification number to identify the trading partners on the EFT file. You enter these different types of identification numbers when you set up business units, customers, and vendors. |
Access the BACS Options page.
User No. (user number) |
Enter your BACS user number. BACS uses this number to verify authorization. |
Subm Type (submission type) |
Select a submission type: Bureau or User. |
Media |
Select the type of media to use: 3.5” disk or telecommunications. |
Audit |
Check on audit for a sample of transactions to print on the input report that is supplied by BACS after processing the file. |
From |
Indicates the interval at which BACS selects the records for printing. |
Serial No. (serial number) |
Enter the submission serial number, which is a volume serial number that you uniquely assign for the 3.5” disk. |
Expire Days |
Enter the number of expiration days for the output file. This is the earliest date that you can override the file. |
Access the BTL91 Options page.
Media |
Define the type of media used (for example, non-ABN-AMRO software). |
Version |
Enter the version number of the software that creates the payment file (for example, 89 for PeopleSoft 8.90. |
DNB Reg # (DNB registration number) |
Enter the number that is assigned by the Netherlands Central Bank to register a number of foreign payment categories. |
DNB Trad # (DNB trade number) |
Enter the code that is assigned by the Netherlands Central Bank to transit traders. |
Access the CPA005 Options page.
Data Center |
Enter the destination data center from Canadian Payment Association. A five-digit numeric. |
Remitter ID Number |
Enter the national remitter number from the Canadian Payment Association. |
Access the DTALSV Options page.
DTALSV ID |
Enter the customer identification number for the Central Swiss Data Processing Center. |
Access the DTAZV Options page.
File Options
The EFT payment process automatically increments the file sequence number (Daily Num) by the file Creation Date according to the requirements of the DTAZV layout. You can reset the file creation date and number if there is a processing error.
Payer Options
CB Cust Num (central bank customer number) |
Enter the German Central Bank customer number for your organization. |
CB Rpt (central bank report) |
Select to submit reporting information for international movements of goods to the German Central Bank within your EFT file. |
Access the ETEBAC Options page.
Op ID (operation identifier) |
Select the type of transfer from the following:
|
Access the FEDI Options page.
Signature Limit 1 |
If the payment is equal to or greater than this amount, the file layout requires at least one person to sign before making the payment. |
Signature Limit 2 |
If the payment is equal to or greater than this amount, the file layout requires two people to sign before making the payment. |
Batch ID |
Enter the group ID for FEDI processing. |
Restricted Viewing Flag |
Enter U or leave it blank to allow any FEDI user to view the payment instruction. Enter R to restrict viewing of this payment instruction to FEDI unrestricted users. |
Pre Sign Flag |
Enter Y to indicate that the payment instruction has been signed at the host application level and does not require signing within FEDI. Otherwise, leave the default N. |
If you do not use any of the delivered EFT layouts in your country, you can develop your own EFT layout. To do this, you must first add the new EFT layout and its options to the list of available EFT layouts using the EFT File Layouts page (EFT_LAYOUT). After you add a new EFT layout, you need to create an SQR module for the file layout that you added. The module that you create will be an SQR Copybook, which has a file extension of SQC.
The files that you require are provided on the system for modification. The FINEFTxx.SQC script, which is shipped with Payables, Receivables, Expenses, and Cash Management, is a template that you can configure to meet your current requirements. In addition, you also need to make changes to the FINEFT.SQC file.This file acts as a router that directs the Pay Cycle process to the appropriate SQC based on the current EFT file layout requirement.
The FINEFTxx.SQC template assumes that one output file is created for each bank account.
File Naming Conventions for EFT Files
The payment process uses these conventions to name the EFT output files: xxxxxnnn.ttt (for example BACS002.txt).
Value |
Define in This Field |
xxxxx |
Output Filename |
nnn |
File |
ttt |
File Ext (file extension) |
You define these values on the EFT File Layouts page.
To define EFT payment format codes, use the EFT Payment Format Codes component (PYMNT_FMT_CD_PNL_GBL)
To make EFT payments, you must specify EFT payment format codes. These codes define the number of extra settlement days to consider when the system calculates payment schedules for EFTs. The system uses the EFT payment format code in conjunction with the EFT payment calendar to build a detailed adjustment table. The system references this table during voucher processing to calculate the scheduled payment date.
The system also uses the table during payment creation to calculate the settlement date for EFTs. The payment creation process adjusts the scheduled payment date to reflect both the number of settlement days you specify with the EFT payment format code and any business holidays that are recorded in the business calendar. This process ensures that the system selects a voucher for payment on a valid processing date and gives the bank enough time to process the EFT to make the payment due date.
Page Name |
Object Name |
Navigation |
Usage |
Payment Format Codes |
PYMNT_FMT_CD_PNL |
Set Up Financials/Supply Chain, Common Definitions, EFT, Payment Format Codes |
Define or modify EFT payment format codes. |
Access the Payment Format Codes page.
Format |
Select from the following values:
|
Settlement Days |
Enter the number of extra settlement days to include when the system calculates payment schedules for EFTs. |
Note. For the Spanish EFT layout CSB34, if you select certain format codes, the system automatically populates the EFT file with predefined values. If you select the Wire format code, the system populates the Payment Type field with a value of 56. If you select the Check Std format code, the system populates the Payment Type field with a value of 57.
Bankers' associations in some countries keep bank and branch data for the purpose of providing efficient interbank settlement. You can use the bank information that is provided by the association in PeopleSoft applications by loading the bank/branch file electronically. You can also enter bank/branch data online and store it in PeopleSoft applications. This way, you can reuse the bank/branch data when creating vendor and employee data instead of entering bank information each time.
In countries where EFT is used for payment, the EFT payment may require that bank information be written in alternate characters.In Japan, for example, EFT payments must be written in Katakana. For this reason, the bank and branch information that is stored in PeopleSoft might include alternate characters in addition to the rest of the information in the file.
Although the bank and branch file functionality is designed to reflect Japanese requirements, you can use it in any country that receives bank/branch information in a text file format. The examples that follow use Japan as the example.
Note. This functionality is not designed to maintain external banks in the Treasury module. PeopleSoft developed the bank load process to minimize time and effort in maintaining pay to bank information and employee bank information.
This section discusses how to:
Load the bank/branch file by running the External Bank / Branch Load Application Engine process (EBK_BANKLOAD).
Maintain external bank/branch information.
Before you load the branch file, you must:
Obtain a text file that includes all member bank information from the bankers association.
Define bank ID qualifiers.
See Also
Establishing Bank ID Qualifiers
Page Name |
Object Name |
Navigation |
Usage |
Load Bank/Branch File |
EBK_RUN_CNTRL |
Set Up Financials/Supply Chain, Common Definitions, Bank Branch File, Load Bank / Branch File |
Specify the run parameters for the External Bank / Branch Load process. |
Bank-Branch File - External Bank-Branch Information |
EBK_BANK |
Set Up Financials/Supply Chain, Common Definitions, Bank Branch File, Bank-Branch File |
Maintain external bank and branch file information. |
Access the Bank/Branch File page.
File Type |
Select either Fixed or CSV. |
File Name |
Enter the full file path and file name of the bank file. |
Reload |
Select to reload the entire bank file. In this case, the system deletes the existing bank/branch information and replaces it with a new set of information. |
In Japan, the file has the following format (CSV):
Field Name |
Type |
Length |
Description |
Bank ID |
Char |
4 |
Bank Master ID |
Branch ID |
Char |
3 |
Bank Branch Master ID |
Bank Name |
Char |
30 |
Bank Name (Alternate Characters) - Katakana |
Bank Name |
Char |
46 |
Bank Name (Chinese Characters) - Kanji |
Branch Name |
Char |
20 |
Branch Name (Alternate Characters) - Katakana |
Branch Name |
Char |
30 |
Branch Name (Chinese Characters) - Kanji |
Postal Code |
Char |
10 |
Postal Code of the Branch |
Address |
Char |
110 |
Branch Address (Chinese Characters) |
Phone Number |
Char |
17 |
Branch Phone Number |
Clearing House Number |
Char |
4 |
Clearing House Number for drafts |
Additional Code |
Char |
1 |
Main Office or Liaison Office |
Note. All of the fields except Additional Code are required.
The process reads the input file and inserts records into PeopleSoft Applications by country. Depending on the specified runtime parameters, the process either reloads the entire file, or inserts bank/branches that are not already in the PeopleSoft database.
Access the External Bank-Branch Information page.
Alternate Char (alternate character) |
Enter the alternate character for the bank. You can use this field for Katakana characters in Japan. |
Clearing # (clearing number) |
Enter the clearing number for drafts for this branch. |
Additional |
Use this field for any additional codes. In Japan, for example, the values for this field in the file provided by the Banker’s Association would be 1 for the main office, and “ “ for another office. |
ACH information is similar to EFT information in that all information that you enter in the ACH Layout page (or EFT Layout page) is used by FIN2025.SQR to produce the actual output file.
Page Name |
Object Name |
Navigation |
Usage |
ACH Layout |
ACH_LAYOUT |
Set Up Financials/Supply Chain, Common Definitions, EFT, ACH Layout |
Create identifying information for ACH files. |
PPD Options |
PPD_ACH_OPTIONS |
Click Details on the ACH Layout page. |
Define additional parameters for the PPD layout. |