OT: US Banks: Bank Routing Number and BIC/SWIFT

Posted by Konerak on Stack Overflow See other posts from Stack Overflow or by Konerak
Published on 2010-05-07T07:09:16Z Indexed on 2010/05/09 4:58 UTC
Read the original article Hit count: 466

Filed under:

mysql

|

banking

|

swift

|

iban

|

not-programming-related

I know it is a bit offtopic, but I've been having a hard time finding more information to this question, and since this site is visited by a lot of people from the United States, you guys might know/find the answer more easily.

Banks in europe each have a SWIFT Number, while US Banks use Routing Numbers. This leads to following questions:

Does each bank in the US also carry a BIC number? (SWIFT)
Is there a 1-1 relationship between BIC and SWIFT?
Is there a list of these numbers somewhere?

(background information: we're adding international payments to our bookkeeping application. Users can add international suppliers, but my boss prefered not to change the current supplier table but to have the ROUTING NUMBER in another table, with as PK the BIC. I'm wondering if BIC is a valid choice, or if it should just be BANK ACCOUNT NUMBER.)

© Stack Overflow or respective owner

Related posts about mysql

How to remove MySQL completely with config and library files on ubuntu 12.04 gnome 3.0

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... But whenever I am trying to locate mysql. I get a no. of files related to mysql command: shell>>… >>> More
mysql: Cannot load from mysql.proc. The table is probably corrupted

as seen on Server Fault - Search for 'Server Fault'
Mysql was started: /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 but when I'm trying to do something: ERROR 1548 (HY000) at line 1: Cannot… >>> More
Why is there a /etc/init.d/mysql file on this Slackware machine? How could it have gotten there?

as seen on Server Fault - Search for 'Server Fault'
A client of my IT-consulting service owns a web-development shop. He's been having problems with a Slackware 12.0 server running MySQL 5.0.67. The machine was set up by the client's sysadmin, who left on bad terms. My client no longer employs a sysadmin. As far as I can tell, the only copy of MySQL… >>> More
mysql: Bind on unix socket: Permission denied

as seen on Server Fault - Search for 'Server Fault'
Can't start mysql with: sudo /usr/bin/mysqld_safe --datadir=/srv/mysql/myDB --log-error=/srv/mysql/logs/mysqld-myDB.log --pid-file=/srv/mysql/pids/mysqld-myDB.pid --user=mysql --socket=/srv/mysql/sockets/mysql-myDB.sock --port=3700 120222 13:40:48 mysqld_safe Starting mysqld daemon with databases… >>> More
MySQL – Learning MySQL Online in 6 Hours – MySQL Fundamentals in 320 Minutes

as seen on SQL Authority - Search for 'SQL Authority'
MySQL is one of the most popular database language and I have been recently working with it a lot. Data have no barrier and every database have their own place. I have been working with MySQL for quite a while and just like SQL Server, I often find lots of people asking me if I have a tutorial which… >>> More

Related posts about banking

Banking applications

as seen on Super User - Search for 'Super User'
Is there still scope left for a banking software? Almost all the banks now run core-banking solution, still I could see new companies coming with their banking solutions. Is there still scope left for the new comers in this segment? >>> More
Is Financial Inclusion an Obligation or an Opportunity for Banks?

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Why should banks care about financial inclusion? First, the statistics, I think this will set the tone for this blog post. There are close to 2.5 billion people who are excluded from the banking stream and out of this, 2.2 billion people are from the continents of Africa, Latin America and Asia… >>> More
Open Financial Exchange (OFX) Banking API

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, First of all I apologize if this question is asked before. I am planning to develop a small application which displays my bank account details(like Mint.com) where I can customize the display of my own. I want to know how and where to start. Where these OFX API's are available? Are they free… >>> More
ASP.NET MVC Case Study on Jwaala’s Online Banking Solution

as seen on ASP.NET - Search for 'ASP.NET'
Learn how Jwaala was able to provide a better solution to its banking and credit union customers by moving its Money Tracker application, to ASP.NET MVC and the Microsoft Web Platform from the LAMR (Linux, Apache, MySQL, Ruby on Rails) environment. >>> More
Windows and Online Banking, Like Oil and Water

as seen on Internet.com - Search for 'Internet.com'
Windows may be safe enough for most functions, but it's not safe enough for the average user's online banking. >>> More