The processing of electronic fund transfers (EFT’s) via Barclays Kenya Integrator.
When the EFT Batch Job runs, the system will read all of the EFT INSTRUCTION records for which the Status is not C (Completed) and for which the Interface Type on the Bank Account is BARCLAYS KENYA. 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 record is BANK, the system will extract the EFT Instruction in the payments file.
If the Debit Account on the BT linked to the EFT Instruction is BANK, the system will extract the EFT Instruction record in the debit order file.
A csv file will be created with a name according to the following naming convention:
DO_KE_END_ENDOW_12072013_1245
Where:
DO is the file type of Debit Order.
KE is the Country Code.
END is the first three characters of the Scheme Code
ENDOW is the Originator Code. (Header User Code on Bank Account Interface Details)
12072013 is the debit order collection date.
1245 is the current time in hours and minutes
Data will be extracted 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.
|
Detail records – Subscribers to be debited |
|||
|
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 E.g. 50.50 |
Amount on EFT Instruction
|
|
|
Narrative |
20 Characters |
Policy number i.e. Scheme code and Membership Reference Number. |
|
A csv file will be created with a name according to the following naming convention and not exceeding 20 characters:
EFT_KEN_120713_1425
Where:
EFT is the file type
KEN is the first character of the Country Code (K) plus the first two characters of the Product Code (EN).
12072013 is the payment date.
1425 is the current time in hours and minutes
Data will be extracted for each field in the file as per the details in the Description / Value column in the table below:
|
HEADER RECORD |
||
|
FIELD NAME |
FORMAT |
DESCRIPTION / VALUE |
|
Record Type
|
N (1) |
1 – Header record identifier Default to 1 |
|
File Type |
X (7) |
LOCAL indicates file is local Default to LOCAL |
|
DR/CR |
X (2) |
Default to CR |
|
File Creation Date |
DDMMYYYY |
Current date |
|
File Creation Time |
HHMMSS |
Current time |
|
DEBIT DETAIL RECORD |
|||
|
FIELD NAME |
|
FORMAT |
DESCRIPTION / VALUE |
|
Record type |
N (1) |
2 indicates Debit Detail Record Default to 2 |
|
|
Debit A/C No. |
X (34) |
Debit DTI Account on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked. |
|
|
Debit A/C Bank Code |
X (9) |
First two characters of Credit Bank Sort Code for the Debit DTI Account on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked. |
|
|
Branch code |
X (15) |
Last three characters of Credit Bank Sort Code for the Debit DTI Account on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked. Left padded with zeroes. |
|
|
Debit A/C Currency |
X (3) |
Currency on the Schemes - KES |
|
|
Execution Date |
DDMMYYYY |
Date Effective on EFT Instruction. |
|
|
Internal Reference |
X (15) |
|
|
|
Collection date |
DDMMYYYY |
Date Effective on EFT Instruction |
|
|
Payment Description |
X (20) |
Default to INSUREPAYT |
|
|
Debit Amount |
X (15,7) |
Sum of the Payment Amount values for all of the Payment Records |
|
|
Customer Name |
X (25) |
Name on DTI Account for Debit DTI Account Number on EFT Instruction i.e. Accountholder for Scheme’s Bank Account. |
|
|
PAYMENT RECORD |
|||
|
FIELD NAME |
|
FORMAT |
DESCRIPTION / VALUE |
|
Record type |
N (1) |
3 indicates Payment file Default to 3 |
|
|
Beneficiary A/C No. |
X (34) |
Debit DTI Account Number for the Credit DTI Account on EFT Instruction where the Account BANK is the Credit Account on the BT to which the EFT Instruction is linked. |
|
|
Display Code |
X (8) |
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. |
|
|
Payment Date |
DDMMYYYY |
Date Effective on EFT Instruction. |
|
|
Payment Currency |
X (3) |
Currency on the BT to which the EFT Instruction record is linked. KES |
|
|
Payment Amount |
X (18) |
Amount on EFT Instruction |
|
|
Beneficiary Name |
X (25) |
Credit Name on EFT Instruction |
|
|
Beneficiary Reference |
X (15) |
Description on EFT Instruction (Policy Number i.e. Scheme Code and Reference Number) |
|
|
TRAILER RECORD |
||
|
FIELD NAME |
FORMAT |
DESCRIPTION / VALUE |
|
Record Type
|
N (1) |
9 – trailer record identifier Default to 9 |
|
Total number of records |
N (5) |
Total number of Payment Records |
|
Total Payment Amount |
N (18) |
Sum of the values for Payment Amount on the Payment records. |