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