银行联行号-银行编码(联行号前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', '银联商务');