Botswana EFT Payment / DO File

Overview

The processing of electronic fund transfers (EFT’s) payments and debit order collections on the Barclays Botswana funds.

Create file

When EFT Batch Job is executed, the system will read all of the transactions on EFT INSTRUCTION for which the Status is not C (Completed) and for which the Interface Type on the Bank Account is BARCLAYS BOTSWANA. The system will read the Interface Type for the DTI Account on the Business Transaction (BT) for which the Account is BANK on the BT to which the EFT Instruction is linked.

Separate files for payments and debit orders will be created as follows:

- If the Credit Account on the BT linked to the EFT Instruction is BANK, the system will extract the EFT Instruction in the debit order file.

Debit orders

A csv file will be created with a name according to the following naming convention:

DO_BW_EDU_10072014_1530

Where:

DO is the file type of Debit Order.

BW is the Country Code (Botswana).

EDU is the first three characters of the Education Product.

10072014 is the debit order collection date.

1530 the current time in hours and minutes.

Debit Order Collection File Paths

The Debit Order Collection files need to be placed in the paths as indicated in the table below:

ENVIRONMENT	PATH
Production	\\v008SQLffd00b\Connect\data\prd\Debit_Orders\Bot\out
Maintenance	\\v008SQLffd00b\Connect\data\uat\Debit_Orders\Bot\out

Debit Order Collection File Layout

Data will be extracted for each field in the file as per the details in the Description / Value column in the table below:

Note:

The DO file layout is the same as the current layout used for the Barclays Kenya DO Collection process.

FIELD NAME	FORMAT	DESCRIPTION / VALUE
Client Name	30 Character limit	Name on the DTI Account records for the Debit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked, followed by Initials on the DTI Account.
Branch code	5 digits	Credit Bank Sort Code for the Debit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked.
Account Number	15 digits	Debit DTI Account Number on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked.
Amount to be collected	12 digits with 2 decimal places	Amount on EFT Instruction E.g. 50.50
Narrative	20 Characters	Policy number i.e. Scheme code and Membership Reference Number.

EFT Payment File

EFT Payment File Name

A csv file will be created with a name according to the following naming convention:

· EFT_BW_Barclays_Education_Endowment_270815_1530

Where:

EFT is the File Type of EFT Payment

BW is the Country Code (Botswana)

Barclays Education Endowment is the Type of Product

270815 is the Payment Date

1530 is the current time in hours and minutes

EFT Payment File Paths

The EFT Payment files need to be placed in the paths as indicated in the table below.

ENVIRONMENT	PATH
Production	\\v008sqlffd00b\Connect\data\prd\Payments\Bot\out
Maintenance	\\v008sqlffd00b\Connect\data\uat\Payments\Bot\out

EFT Payment File Layout

Extract the data for each field in the file as per the details in the Description / Value column in the table below.

Note:

No header or trailer record is required.

FIELD	FORMAT	SIZE	DESCRIPTION	SAMPLE VALUES
Name	Char	30	Credit Name on EFT Instruction	Simba Chikuni
Branch	Numeric	5	Credit Bank Sort Code on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked.	3001
Account Number	Numeric	15	Credit DTI Account on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked.	023420234234256
Payment Amount	Numeric	12 (9.2)	Amount on EFT Instruction. Allow for 2 decimal places. The decimal is included as a position in the field.	123456789.01