× Discuss on Insight, business intelligence and reporting, Regulatory, Risk, Financial & Performance, Monitoring with Systar, T-Risk, ALCO Reporting, etc…

How to find the BIC code from IBAN id

  • baskarjay
  • baskarjay's Avatar Topic Author
  • Offline
  • Senior Member
  • Senior Member
More
4 years 7 months ago - 4 years 7 months ago #22269 by baskarjay
How to find the BIC code from IBAN id was created by baskarjay
Hello All,

I have IBAN id (FR7615629002560002012400354).

How Can I find the respective BIC code for this IBAN id.

I have used CALL getBICfromIBAN(IbanId, BicCode, Error)

But sometimes I didnt get BIC code for some IBAN ids.

I have checked the IN.IBAN.PLUS table with National ID from the IBAN (FR7615629002560002012400354)
National Id is IBAN[5,10]

But I iddnt found any IN.IBAN.PLUS / DE.BIC records for this national ID.

Any other way to get BIC code from IBAN ???

Please let me know if you guys have any clue ...

Thanks in advance.
Last edit: 4 years 7 months ago by baskarjay.

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #23009 by CK
Replied by CK on topic How to find the BIC code from IBAN id
Hello Baskarjay

This will be difficult because the DE.BIC table is normally loded from a databse file got from SWIFT, based on the IBAN structure BIC can be deduced from COUNTRY CODE + BANK ID + BRANCH ID.

I suggest you create a routine to do this, at the only condition you DE.BIC is up to date.


Regards

Please Log in or Create an account to join the conversation.

Time to create page: 0.097 seconds