The processing of electronic fund transfers (EFT’s) via Barclays Zambia Integrator.
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 ZAMBIA. 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 payments file.
- If the Debit Account on the BT linked to the EFT Instruction is BANK, the system will extract the EFT Instruction in the debit order file.
- If the Debit Account on the BT linked to the EFT Instruction is BANK, the system will extract the EFT Instruction in the credit card collections file.
A csv file will be created with a name according to the following naming convention:
DO_ZM_EDU_12072013_001
Where:
DO is the file type of Debit Order.
ZM is the Country Code.
EDU is the first three characters of the Scheme Code
12072013 is the debit order collection date.
001 is a sequential number starting from 01 for each debit order file submitted per day
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 Botswana DO Collection process.
Header record – Credit account details:
|
DATA ELEMENT |
DESCRIPTION / VALUE |
|
Record Identifier |
01 – Header record identifier Default to 01 |
|
Account Initiating Direct Debit |
DTI Account Number for the Credit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked. Must be 7 digits. |
|
Branch Code for Initiating Account |
Code of the DTI Branch for the Credit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked. Must be 6 digits. |
|
Direct Debit Type |
Default the value to Adhoc. Lower Case with upper case A. |
|
Collection Currency |
Default to ZMW. |
|
Direct Debit Description |
Default to Insurance Payment. |
|
Credit Amount |
Sum of the values for Amount to be collected of the detail records. 2 Decimals. |
|
Originator Name |
DTI Account Name for the Credit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked. |
|
Originator Address |
Lusaka |
|
Originator Code |
Usercode on the DTI Account Interface record for the Scheme’s Bank Account. |
Detail records – Subscribers to be debited:
|
FIELD NAME |
|
DESCRIPTION / VALUE |
|
Record Identifier |
2 – transaction record identifier Default to 2 |
|
|
Subscriber Account Number |
Debit DTI Account Number for the Credit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked. Must be 7 digits. |
|
|
Branch Code |
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. Must be 6 digits with leading zeroes if less than 6 digits. |
|
|
Payment Reference Number |
Unique number per transaction. First 24 digits must be the file sequence number and the last 10 a sequential number for each item. |
|
|
Collection Date |
Date on which transaction is to be actioned (DDMMYYYY). Date Effective on EFT Instruction. |
|
|
Amount to be Collected |
Amount on EFT Instruction |
|
|
Subscriber Name |
Policy number i.e. Scheme Code and Membership Reference Number e.g. SAFM130085 where SAFM equals Scheme Code and 130085 equals Membership Reference Number. No full stops or commas. |
|
|
Currency |
Code for Currency on the BT to which the EFT Instruction record is linked. |
|
|
Mandate Reference |
Scheme Code |
|
|
Remit Info |
Product followed by policy number and separated by a hyphen e.g. Umoyo-SAFM1300853 |
|
A csv file will be created with a name according to the following naming convention:
EFT_ZM_EDU_12072013_001
Where:
DO is the file type of Debit Order.
ZM is the Country Code.
EDU is the first three characters of Scheme Code
12072013 is the payment date.
001 is a sequential number starting from 01 for each payment file submitted per day
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 – Credit account details:
|
DATA ELEMENT |
DESCRIPTION / VALUE |
|
Record Identifier |
01 – Header record identifier Default to 01 |
|
Account Initiating Direct Debit |
DTI Account Number 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. Must be 7 digits. |
|
Branch Code For Initiating Account |
Code of the DTI Branch 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. Must be 6 digits. |
|
Direct Debit Type |
Default the value to Adhoc. Lower Case with upper case A. |
|
Collection Currency |
Default to ZMW. |
|
Direct Debit Description |
Default to Insurance Payment. |
|
Credit Amount |
Sum of the values for Amount to be collected of the detail records. 2 Decimals. |
|
Originator Name |
DTI Account Name for the Credit DTI Account on EFT Instruction where the Account BANK is the Debit Account on the BT to which the EFT Instruction is linked. |
|
Originator Address |
Lusaka |
|
Originator Code |
Usercode on the DTI Account Interface record for the Scheme’s Bank Account. |
Detail records – Subscribers to be debited:
|
FIELD NAME |
|
DESCRIPTION / VALUE |
|
Record Identifier |
2 – transaction record identifier. Default to 2 |
|
|
Subscriber Account Number |
Credit DTI Account Number 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. Must be 7 digits. |
|
|
Branch Code |
Credit Bank Sort Code 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. Must be 6 digits with leading zeroes if less than 6 digits. |
|
|
Payment Reference Number |
Unique number per transaction. First 24 digits must be the file sequence number and the last 10 a sequential number for each item. |
|
|
Collection Date |
Date on which transaction is to be actioned (DDMMYYYY). Date Effective on EFT Instruction. |
|
|
Amount to be Collected |
Amount on EFT Instruction. |
|
|
Subscriber Name |
Policy number i.e. Scheme Code and Membership Reference Number e.g. SAFM130085 where SAFM equals Scheme Code and 130085 equals Membership Reference Number. No full stops or commas. |
|
|
Currency |
Code for Currency on the BT to which the EFT Instruction record is linked. |
|
|
Mandate Reference |
Scheme Code |
|
|
Remit Info |
Product followed by policy number and separated by a hyphen e.g. Umoyo-SAFM1300853 |
|
Sample file:
0100000099860000009986201204170021020100000014541123340000001454112334
0200000014541123340000009986201204170021020000000001250655000006216420086800000004000020120417INPENSIONS-28222944-P-20120417BYTES SYSTEMS INTEGRATION 999901000000145411233401
81
0300000001000000000000040000