银行联行号-银行编码(联行号前3位)
https://blog.csdn.net/dice_6/article/details/92651150
1 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'001\', \'中国人民银行\'); 2 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'011\', \'国家金库\'); 3 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'102\', \'中国工商银行\'); 4 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'103\', \'中国农业银行\'); 5 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'104\', \'中国银行\'); 6 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'105\', \'中国建设银行\'); 7 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'201\', \'国家开发银行\'); 8 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'202\', \'中国进出口银行\'); 9 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'203\', \'中国农业发展银行\'); 10 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'301\', \'交通银行\'); 11 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'302\', \'中信银行\'); 12 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'303\', \'中国光大银行\'); 13 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'304\', \'华夏银行\'); 14 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'305\', \'中国民生银行\'); 15 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'306\', \'广东发展银行\'); 16 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'307\', \'平安银行\'); 17 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'308\', \'招商银行\'); 18 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'309\', \'兴业银行\'); 19 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'310\', \'上海浦东发展银行\'); 20 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'313\', \'城市商业银行\'); 21 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'314\', \'农村商业银行\'); 22 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'315\', \'恒丰银行\'); 23 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'316\', \'浙商银行\'); 24 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'317\', \'农村合作银行\'); 25 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'318\', \'渤海银行股份有限公司\'); 26 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'319\', \'徽商银行股份有限公司\'); 27 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'320\', \'镇银行有限责任公司\'); 28 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'321\', \'重庆三峡银行股份有限公司\'); 29 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'322\', \'上海农村商业银行\'); 30 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'325\', \'上海银行\'); 31 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'401\', \'城市信用社\'); 32 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'402\', \'农村信用社\'); 33 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'403\', \'中国邮政储蓄银行\'); 34 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'501\', \'汇丰银行\'); 35 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'502\', \'东亚银行\'); 36 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'503\', \'南洋商业银行\'); 37 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'504\', \'恒生银行(中国)有限公司\'); 38 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'505\', \'中国银行(香港)有限公司\'); 39 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'506\', \'集友银行有限公司\'); 40 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'507\', \'创兴银行有限公司\'); 41 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'510\', \'永亨银行(中国)有限公司\'); 42 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'512\', \'永隆银行\'); 43 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'513\', \'大新银行\'); 44 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'531\', \'花旗银行(中国)有限公司\'); 45 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'532\', \'美国银行有限公司\'); 46 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'533\', \'摩根大通银行(中国)有限公司\'); 47 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'561\', \'三菱东京日联银行(中国)有限公司\'); 48 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'563\', \'日本三井住友银行股份有限公司\'); 49 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'564\', \'瑞穗实业银行(中国)有限公司\'); 50 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'565\', \'日本山口银行股份有限公司\'); 51 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'591\', \'韩国外换银行股份有限公司\'); 52 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'593\', \'友利银行(中国)有限公司\'); 53 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'594\', \'韩国产业银行\'); 54 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'595\', \'新韩银行(中国)有限公司\'); 55 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'596\', \'韩国中小企业银行有限公司\'); 56 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'597\', \'韩亚银行(中国)有限公司\'); 57 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'621\', \'华侨银行(中国)有限公司\'); 58 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'622\', \'大华银行(中国)有限公司\'); 59 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'623\', \'星展银行(中国)有限公司\'); 60 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'631\', \'泰国盘谷银行(大众有限公司)\'); 61 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'641\', \'奥地利中央合作银行股份有限公司\'); 62 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'651\', \'比利时联合银行股份有限公司\'); 63 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'652\', \'比利时富通银行有限公司\'); 64 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'661\', \'荷兰银行\'); 65 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'662\', \'荷兰安智银行股份有限公司\'); 66 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'671\', \'渣打银行\'); 67 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'672\', \'英国苏格兰皇家银行公众有限公司\'); 68 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'691\', \'法国兴业银行(中国)有限公司\'); 69 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'694\', \'法国东方汇理银行股份有限公司\'); 70 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'695\', \'法国外贸银行股份有限公司\'); 71 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'711\', \'德国德累斯登银行股份公司\'); 72 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'712\', \'德意志银行(中国)有限公司\'); 73 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'713\', \'德国商业银行股份有限公司\'); 74 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'714\', \'德国西德银行股份有限公司\'); 75 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'715\', \'德国巴伐利亚州银行\'); 76 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'716\', \'德国北德意志州银行\'); 77 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'732\', \'意大利联合圣保罗银行股份有限公司\'); 78 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'741\', \'瑞士信贷银行股份有限公司\'); 79 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'742\', \'瑞士银行\'); 80 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'751\', \'加拿大丰业银行有限公司\'); 81 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'752\', \'加拿大蒙特利尔银行有限公司\'); 82 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'761\', \'澳大利亚和新西兰银行集团有限公司\'); 83 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'771\', \'摩根士丹利国际银行(中国)有限公司\'); 84 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'775\', \'联合银行(中国)有限公司\'); 85 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'776\', \'荷兰合作银行有限公司\'); 86 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'781\', \'厦门国际银行\'); 87 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'782\', \'法国巴黎银行(中国)有限公司\'); 88 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'785\', \'华商银行787华一银行\'); 89 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'900\', \'第三方支付(支付宝、快钱）\'); 90 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'901\', \'中央结算公司\'); 91 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'902\', \'公开市场业务操作室\'); 92 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'903\', \'中国外汇交易中心\'); 93 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'904\', \'城市商业银行资金清算中心\'); 94 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'905\', \'中国银联股份有限公司\'); 95 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'906\', \'银行电子结算中心\'); 96 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'907\', \'财务公司\'); 97 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'908\', \'电子商业汇票系统处理中心\'); 98 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'909\', \'银行间市场清算所\'); 99 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'969\', \'(澳门地区)银行\'); 100 INSERT INTO t_input_bank_code (CODE, NAME) VALUES (\'980\', \'银联商务\');
版权声明：本文为chinazhou-wang原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。