Sl No | Beneficiary Account Number | Beneficiary Name | Amount | Bank Code | Employee No | Special Instructions for Beneficiary Bank |
---|---|---|---|---|---|---|
1 | AE280330000001111111111 | Suhail Farnath | 3250.00 | 033 | 1 | Sal Nov 2011 |
2 | AE140330000001111111111 | Kashif malik | 4000.00 | 033 | 2 | Sal Oct 2012 |
3 | AE450330000001111111111 | Kamran masood | 5500.00 | 033 | 3 | Sal Nov 2013 |
The field specification is as follows: (Note: No special characters are allowed)
SNO. | Field Label | Max Size | Type | Use | Remarks |
---|---|---|---|---|---|
1 | Sl No | 6 | Numeric | Mandatory | This number must be unique in this file and need not be in any specific occurrence order. |
2 | Beneficiary account number | 23 | Alpha Numeric | Mandatory | The Beneficiary account number (IBAN) must be specified in this field. |
3 | Beneficiary Name | 35 | Alpha Numeric | Mandatory | Special characters including comma not allowed |
4 | Amount | 9 | Numeric | Mandatory | Valid transaction amount with 2 decimals. Negative & zero value are not permitted. Maximum length is inclusive of decimal values and decimal DOT. Eg: 123456.78 |
5 | Bank code | 3 | Numeric | Mandatory | Valid bank code, 2nd, 3rd & 4th digit of the bank 9 digit routing number |
6 | Employee number | 8 | Numeric | Mandatory | This number must be unique in this file and need not be in any specific occurrence order. |
7 | Special Instructions for Beneficiary Bank | 175 | Alpha Numeric | Optional |
Details | Sample value |
---|---|
Company A/c no (last 12 digit of IBAN) | 010494300206 |
Date (DDMMYYYY) | 01052012 |
File Creation Time (HHMM) | 2315 |
Sample excel file name will be as below | |
010494300206010520122315 |
An IBAN can always be distinguished from a normal customer account number by the following:
Two letters at the beginning of the IBAN, which refer to the country code where the account resides;
Sl No | Beneficiary Account Number | Beneficiary Name | Amount | Bank Code | Employee No | Special Instructions for Beneficiary Bank |
---|---|---|---|---|---|---|
1 | AE280330000001111111111 | Suhail Farnath | 3250.00 | 033 | 1 | Sal Nov 2011 |
2 | AE140330000001111111111 | Kashif malik | 4000.00 | 033 | 2 | Sal Oct 2012 |
3 | AE450330000001111111111 | Kamran masood | 5500.00 | 033 | 3 | Sal Nov 2013 |
The field specification is as follows: (Note: No special characters are allowed)
SNO. | Field Label | Max Size | Type | Use | Remarks |
---|---|---|---|---|---|
1 | Sl No | 6 | Numeric | Mandatory | This number must be unique in this file and need not be in any specific occurrence order. |
2 | Beneficiary account number | 23 | Alpha Numeric | Mandatory | The Beneficiary account number (IBAN) must be specified in this field. |
3 | Beneficiary Name | 35 | Alpha Numeric | Mandatory | Special characters including comma not allowed |
4 | Amount | 9 | Numeric | Mandatory | Valid transaction amount with 2 decimals. Negative & zero value are not permitted. Maximum length is inclusive of decimal values and decimal DOT. Eg: 123456.78 |
5 | Bank code | 3 | Numeric | Mandatory | Valid bank code, 2nd, 3rd & 4th digit of the bank 9 digit routing number |
6 | Employee number | 8 | Numeric | Mandatory | This number must be unique in this file and need not be in any specific occurrence order. |
7 | Special Instructions for Beneficiary Bank | 175 | Alpha Numeric | Optional |
Details | Sample value |
---|---|
Company A/c no (last 12 digit of IBAN) | 010494300206 |
Date (DDMMYYYY) | 01052012 |
File Creation Time (HHMM) | 2315 |
Sample excel file name will be as below | |
010494300206010520122315 |
Did you find the information you were looking for on this page?