Setting Up EFT Processing

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.

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 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 Financial Gateway documentation.

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).

Delivered ACH and EFT Layouts

PeopleSoft delivers two types of file layouts: those intended for nongovernmental business use, and those intended for U.S. 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 Receivable 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 U.S. Federal Government, see the section entitled U.S. 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 Transfer	(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

Pages Used to Set Up EFT Processing

Page Name	Definition Name	Navigation	Usage
EFT File Layouts	EFT_LAYOUT	select Set Up Financials/Supply Chain, then select Common Definitions, then select EFT, then select EFT File Layout, then select EFT File Layouts	View, modify, and add any EFT layouts.
BACS Options	BACS_LOGON_UK	Click Details for the BACS EFT file layout on the EFT File Layouts page.	(GBR) Set options for the BACS format.
BTL91 Options	BTL91_EFT_OPTIONS	Click Details 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 Details for the CPA005 file layout on the EFT File Layouts page.	(CAN) Set options for the CPA005 format.
DTALSV Options	DTALSV_EFT_OPTIONS	Click Details for the DTALSV file layout on the EFT File Layouts page.	(CHE) Set options for the DTSALV format.
DTAZV Options	DTAZV_EFT_OPTIONS	Click Details 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.

(USF) U.S. Federal ACH and EFT Layouts

The United States Federal Government (through the U.S. Treasury) has certain requirements for check, ACH, and EFT payments. Setting up this information (that is, defining that the file layout is for employee suppliers, other suppliers, 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 supplier payment are correct as per U.S. Treasury specifications.

The edits verify these U.S. Treasury specifications:

Employee payments are on a PPD or PPD+ file format.
Vendor/supplier (non-employee vendor/supplier) payments are on a CCD, CCD+, or CTX file format.
Payments, including both employee and non-employee vendor/suppliers, are on the SF1166SCHK, SPSCHK, or SDPR file format.

Note: You must use the SF1166SCHK, SPSCHK, or SDPR file format for payments that are created for both employee and non-employee vendor/suppliers. These file formats are check requests to the U.S. 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 U.S. 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
SDPR	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
SPSCHK	SPS vendor check payment	EFT	Both employee and vendor/supplier
SPSTRVL	SPS travel ACH payment (PPD+)	EFT	Employee
SPSVNDR	SPS vendor ACH payment (CCD+)	EFT	Vendor/supplier
SPSMISC	SPS Miscellaneous Payment	EFT	Vendor/supplier
SPSSDRP	SPS Same Day Payment Request	EFT	Both employee and vendor/supplier
SPSIATTRVL	SPS Travel IAT Payment	IAT (International ACH Transaction)	Employee
SPSIATMISC	SPS Miscellaneous IAT Payment	IAT	Vendor/supplier
SPSIATVNDR	SPS supplier IAT payment	IAT	Supplier

You can also add file formats. You should refer to the Federal Management Service bureau of the United States Department of the Treasury web site (http://www.fms.treas.gov) regarding file payment requirements before creating and adding file payment formats.

(USF) IPAC Transactions

Another delivered federal EFT layout (that is listed in the table entitled Delivered ACH and EFT layouts) is the IPAC layout. The Intra-Governmental Payment and Collection (IPAC) System is an interagency funds transfer mechanism for U.S. 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.

Prerequisite

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.

Common Elements Used for EFT Processing

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.

EFT File Layouts Page

Use the EFT File Layouts page (EFT_LAYOUT) to view, modify, and add EFT layouts.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select EFT, then select EFT File Layout, then select EFT File Layouts

Image: EFT File Layouts page

This example illustrates the fields and controls on the EFT File Layouts page. You can find definitions for the fields and controls later on this 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.

Select if the file layout is for direct debits.

Select if the file layout is for draft files.

Select if the file layout is for inbound files.

Out

Select if the file layout is for outbound files.

Prenote

Select if the file layout is for a prenote.

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/supplier 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/supplier payment methods with a valid PPD or PPD+ EFT file layout. Delivered valid file layouts are SPSTRVL, SF116TRVL, and SPSIATTRVL.

Supplier: You must associate all other vendor/supplier (non-employee) payment methods with a valid CCD or CTX EFT file layout. Delivered valid file layouts are SPSVNDR, SPSMISC, SPSIATVNDR, SPSIATMISC, SF1166VNDR, CTX, and CTX820FED.

Both: For employee and vendor/supplier payments. You must associate this option with a valid PPD or PPD+ EFT file layout. Delivered valid file layouts are SPSCHK, SDPR, and SF1166SCHK.

For delivered valid layouts, see (USF) U.S. Federal ACH and EFT Layouts in this topic.

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 suppliers.

BACS Options Page

Use the BACS Options page (BACS_LOGON_UK) to set options for the BACS format. (GBR)

Navigation

Click Details for the BACS EFT file layout on the EFT File Layouts 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.

BTL91 Options Page

Use the BTL91 Options page (BTL91_EFT_OPTIONS) to set options for the BTL91 format. (NLD)

Navigation

Click Details for the BTL91 EFT file layout on the EFT File Layouts 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, 92 for PeopleSoft 9.2.

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.

CPA005 Options Page

Use the CPA005 Options page (CPA005_EFT_OPTIONS) to set options for the CPA005 format. (CAN)

Navigation

Click Details for the CPA005 file layout on the EFT File Layouts 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.

DTALSV Options Page

Use the DTALSV Options page (DTALSV_EFT_OPTIONS) to set options for the DTSALV format. (CHE)

Navigation

Click Details for the DTALSV file layout on the EFT File Layouts page.

DTALSV ID

Enter the customer identification number for the Central Swiss Data Processing Center.

DTAZV Options Page

Use the DTAZV Options page (DTAZV_EFT_OPTIONS) to set options for the DTAZV format. (DEU)

Navigation

Click Details for the DTAZV file layout on the EFT File Layouts 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.

ETEBAC Options Page

Use the ETEBAC Options page (ETEBAC_EFT_OPTIONS) to set options for the ETEBAC format. (FRA)

Navigation

Click Detail for the ETEBAC EFT file layout on the EFT File Layouts page.

Op ID(operation identifier)

Select the type of transfer from the following:

Ord Xfer: Ordinary transfer.
Tr Xfer: Treasury transfer.
Xfer E-3: Transfer at due date minus three days.
Xfer E-2: Transfer at due date minus two days.

FEDI Options Page

Use the FEDI Options page (FEDI_EFT_OPTIONS) to set options for the FEDI format. (SGP)

Navigation

Click Detail for the FEDI EFT file layout on the EFT File Layouts 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.

Creating an SQR Module for the EFT File Layout

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.