× 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
  • Posts: 46
  • Karma: -1
  • Thank you received: 0

baskarjay created the topic: How to find the BIC code from IBAN id

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.
#22269

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

  • Posts: 13
  • Thank you received: 0

CK replied the 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
#23009

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

Time to create page: 0.171 seconds