2.5 International Fund Transfer Format 1
Format Supported - CSV
Field Descriptions
Sequence | Field Name | Mandatory | Remarks/Value | Max Length | Data Type |
---|---|---|---|---|---|
1 | mixedIdentifier | Y | This field can contain value A. | 1 | String |
2 | partyId | Y | Customer/Party id of customer who uploading the file. This value should be as per core banking data. | 20 | String |
3 | debitAccountId | Y | Source/Debit account number. Should be one account per file. It can either be VA or RA | 50 | String |
4 | amount type | Y | Debit amt or Trfr amount | 1 | String |
5 | amount | Y | Transaction amount with format (###.##) for example 20.25, 20.00 | - | BigDecimal |
6 | amountCurr | Y | 3 digit transfer currency such as EUR, GBP | 3 | String |
7 | valueDate | Y | Transfer date with format DD-MM-YYYY for example 26-03-2020 | 10 | Date |
8 | beneName | Y | Name of Beneficiary/Payee | 35 | String |
9 | creditAccountId | Y | Credit/beneficiary account number | 34 | String |
10 | beneAddrLine1 | N | Beneficiary/Payee address line 1 | String | |
11 | beneAddrLine2 | N | Beneficiary/Payee address line 2 | String | |
12 | beneCity | N | Beneficiary/Payee city | String | |
13 | beneCountry | N | Beneficiary/Payee country | String | |
14 | codeType | Y |
Code/Payment Type of intermediary bank For swiftCode the value should be - SWI For National Clearing Code the value should be – NAC For Specific Bank details the value should be - SPE |
String | |
15 | bicCode | N |
This will be swift code incase SWI This will be NCC code incase NCA This will be empty incase SPE |
String | |
16 | ultBankName | N | Beneficiary/Payee Bank Name | String | |
17 | ultAddrLine | N | Beneficiary/Payee Bank address | String | |
18 | ultCity | N | Beneficiary/Payee Bank City | String | |
19 | ultCountry | N | Beneficiary/Payee Bank Country | String | |
20 | paymentDetails1 | N | paymentDetails1 | 35 | String |
21 | paymentDetails2 | N | paymentDetails2 | 35 | String |
22 | paymentDetails3 | N | paymentDetails3 | 35 | String |
23 | paymentDetails4 | N | paymentDetails4 | 35 | String |
24 | charges | Y |
Correspondence Charges expected value PAYEE, PAYER or SHARED mapping logic - SHARED--> SHAR PAYEE --> CRED PAYER --> DEBT |
String | |
25 | Deal ref no | N | Deal Reference Number | 35 | String |
26 | Email id | N | Email ID of the creditor | 35 | String |
27 | Charges account | N | Charges Account Details | 35 | String |
28 | OBDX ref no | N | OBDX Reference Number | 35 | String |
Structure for International Adhoc Payment via intermediary bank details | |||||
1 | mixedIdentifier | Y | Incase international adhoc payment the value should be AI | 1 | String |
2 | partyId | Y | Customer/Party id of customer who uploading the file. This value should be as per core banking data. | 20 | String |
3 | debitAccountId | Y | Source/Debit account number. Should be one account per file. It can either be VA or RA | 50 | String |
4 | amount type | Y |
Debit amount or Transfer amount Allowed Value - D/T |
1 | String |
5 | amount | Y | Transaction amount with format (###.##) for example 20.25, 20.00 | - | BigDecimal |
6 | amountCurr | Y | 3 digit transfer currency such as EUR, GBP | 3 | String |
7 | valueDate | Y | Transfer date with format DD-MM-YYYY for example 26-03-2020 | 10 | Date |
8 | beneficiary Name | Y | Name of Beneficiary/Payee | 35 | String |
9 | creditAccountId | Y | Credit/beneficiary account number | 34 | String |
10 | beneAddrLine1 | N | Beneficiary/Payee address line 1 | String | |
11 | beneAddrLine2 | N | Beneficiary/Payee address line 2 | String | |
12 | beneCity | N | Beneficiary/Payee city | String | |
13 | beneCountry | N | Beneficiary/Payee country | String | |
14 | intmdCodeType | N |
Code/Payment Type of intermediary bank For swiftCode the value should be - SWI For National Clearing Code the value should be – NAC For Specific Bank details the value should be - SPE |
String | |
15 | intmdBicCode | N |
This will be swift code incase SWI added for intermediary bank This will be NCC code incase NCA added for intermediary bank This will be empty incase SPE added for intermediary bank |
String | |
16 | intmdBankName | N | Intermediary bank name | String | |
17 | intmdAddrLine | N | Intermediary bank address line | String | |
18 | intmdCity | N | Intermediary bank city | String | |
19 | intmdCountry | N | Intermediary bank country | String | |
20 | codeType | Y |
Code/Payment Type of intermediary bank For swiftCode the value should be - SWI For National Clearing Code the value should be – NAC For Specific Bank details the value should be - SPE |
String | |
21 | bicCode | N |
This will be swift code incase SWI This will be NCC code incase NCA This will be empty incase SPE |
String | |
22 | ultBankName | N | Beneficiary/Payee Bank Name | String | |
23 | ultAddrLine | N | Beneficiary/Payee Bank address | String | |
24 | ultCity | N | Beneficiary/Payee Bank City | String | |
25 | ultCountry | N | Beneficiary/Payee Bank Country | String | |
26 | paymentDetails1 | N | paymentDetails1 | 35 | String |
27 | paymentDetails2 | N | paymentDetails2 | 35 | String |
28 | paymentDetails3 | N | paymentDetails3 | 35 | String |
29 | paymentDetails4 | N | paymentDetails4 | 35 | String |
30 | charge bearer | Y |
Correspondence Charges expected value PAYEE, PAYER or SHARED mapping logic - SHARED--> SHAR PAYEE --> CRED PAYER --> DEBT |
String | |
31 | Deal ref no | N | Deal Reference Number | 35 | String |
32 | Email id | N | Email ID of the creditor | 35 | String |
33 | Charges account | N | Charges Account Details | 35 | String |
34 | Ref no | N | Reference Number | 35 | String |
Field Mapping
Structure International Adhoc Payment
Sequence | Field Name | Canonical Field |
---|---|---|
1 | mixedIdentifier | Not Required |
2 | partyId | initiatingPartyId |
3 | debitAccountId | drAccNo |
4 | amount type | NA |
5 | amount | amount |
6 | amountCurr | currency |
7 | valueDate | valueDate |
8 | beneName | beneName |
9 | creditAccountId | beneAccNo |
10 | beneAddrLine1 | crBuildingNo |
11 | beneAddrLine2 | streetName |
12 | beneCity | townName |
13 | beneCountry | country |
14 | codeType | |
15 | bicCode | crBicFi |
16 | ultBankName | crAgentAccName |
17 | ultAddrLine | crAgentStreetName |
18 | ultCity | crAgentTownName |
19 | ultCountry | crAgentCountry |
20 | paymentDetails1 | remittanceInfo |
21 | paymentDetails2 | remittanceInfo |
22 | paymentDetails3 | remittanceInfo |
23 | paymentDetails4 | remittanceInfo |
24 | charges | chargeBearer |
25 | Deal ref no | contractID |
26 | Email id | emailAddress |
27 | Charges account | chargesAccount |
28 | OBDX ref no | instructionId |
Structure for International Adhoc Payment via intermediary bank details | ||
1 | mixedIdentifier | Not Required |
2 | partyId | initiatingPartyId |
3 | debitAccountId | drAccNo |
4 | amount type | NA |
5 | amount | amount |
6 | amountCurr | currency |
7 | valueDate | valueDate |
8 | beneficiary Name | beneName |
9 | creditAccountId | beneAccNo |
10 | beneAddrLine1 | crBuildingNo |
11 | beneAddrLine2 | streetName |
12 | beneCity | townName |
13 | beneCountry | country |
14 | intmdCodeType | |
15 | intmdBicCode | intrmBicFi |
16 | intmdBankName | |
17 | intmdAddrLine | intrmAgentStreetName |
18 | intmdCity | intrmAgentTownName |
19 | intmdCountry | |
20 | codeType | |
21 | bicCode | crBicFi |
22 | ultBankName | crAgentAccName |
23 | ultAddrLine | crAgentStreetName |
24 | ultCity | crAgentTownName |
25 | ultCountry | crAgentCountry |
26 | paymentDetails1 | remittanceInfo |
27 | paymentDetails2 | remittanceInfo |
28 | paymentDetails3 | remittanceInfo |
29 | paymentDetails4 | remittanceInfo |
30 | charge bearer | chargeBearer |
31 | Deal ref no | contractID |
32 | Email id | emailAddress |
33 | Charges account | chargesAccount |
34 | Reference number | instructionId |
Parent topic: Formats Supported (Out of the box)