CNAPS 银行联行号、银行档案 2024年5月27日转储15.5万条

/* Navicat Premium Data Transfer Source Server : 127.0.0.1 Source Server Type : MySQL Source Server Version : 50726 Source Host : localhost:3306 Source Schema : etl Target Server Type : MySQL Target Server Version : 50726 File Encoding : 65001 Date: 31/05/2024 17:45:48 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cmb_cnaps -- ---------------------------- DROP TABLE IF EXISTS cnaps; CREATE TABLE cnaps ( bankCode text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, bankType text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, bankTypeName text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, cityCode text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, cityName text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, cnapsCode text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, currentPage bigint(20) NULL DEFAULT NULL, deleted tinyint(1) NULL DEFAULT NULL, expiredDate text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, fullName text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, id bigint(20) NULL DEFAULT NULL, modifyDate text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, modifyType text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, orderBy text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, pageNum bigint(20) NULL DEFAULT NULL, pageSize bigint(20) NULL DEFAULT NULL, provinceCode text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, provinceName text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, relateCode text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, status text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, type text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, validDate text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cmb_cnaps -- ---------------------------- INSERT INTO cnaps VALUES ('TRC', 'TRC', '天津农商行', '120000', '天津市', '402110014831', 1, 0, '2999-12-31 00:00:00', '天津农村商业银行股份有限公司武清八里桥分理处', 1048514, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '12', '天津市', NULL, 'A', '7', '2003-04-21 00:00:00'); INSERT INTO cnaps VALUES ('RCB', 'RCB', '农村商业银行', '220800', '白城市', '314247000018', 1, 0, '2999-12-31 00:00:00', '白城农村商业银行股份有限公司营业部', 1048515, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '22', '吉林省', NULL, 'A', '7', '2018-03-03 00:00:00'); INSERT INTO cnaps VALUES ('CMB', 'CMB', '招商银行', '140100', '太原市', '308161039018', 1, 0, '2999-12-31 00:00:00', '招商银行太原分行', 1048517, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '14', '山西省', NULL, 'A', '7', '2014-02-20 00:00:00'); INSERT INTO cnaps VALUES ('BBJ', 'BBJ', '北京银行', '320100', '南京市', '313301014016', 1, 0, '2999-12-31 00:00:00', '北京银行股份有限公司南京分行营业部', 1048521, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '32', '江苏省', NULL, 'A', '7', '2011-02-21 00:00:00'); INSERT INTO cnaps VALUES ('BOC', 'BOC', '中国银行', '211300', '朝阳市', '104234080332', 1, 0, '2999-12-31 00:00:00', '中国银行股份有限公司朝阳燕都支行', 1048522, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '21', '辽宁省', NULL, 'A', '7', '2014-09-13 00:00:00'); INSERT INTO cnaps VALUES ('CZB', 'CZB', '浙商银行', '440400', '珠海市', '316585000023', 1, 0, '2999-12-31 00:00:00', '浙商银行股份有限公司横琴粤澳深度合作区支行', 1048523, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '44', '广东省', ' ', 'A', '7', '2023-08-05 00:00:00'); INSERT INTO cnaps VALUES ('OTH', 'OTH', '其他银行', '500000', '重庆市', '593653000014', 1, 0, '2999-12-31 00:00:00', '友利银行（中国）有限公司重庆分行', 1048524, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '50', '重庆市', NULL, 'A', '7', '2015-03-07 00:00:00'); INSERT INTO cnaps VALUES ('HXB', 'HXB', '华夏银行', '110000', '北京市', '304100042691', 1, 0, '2999-12-31 00:00:00', '华夏银行北京分行', 1048525, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '11', '北京市', NULL, 'A', '7', '2014-02-20 00:00:00'); INSERT INTO cnaps VALUES ('ICB', 'ICB', '中国工商银行', '320500', '苏州市', '102305602708', 1, 0, '2999-12-31 00:00:00', '中国工商银行股份有限公司张家港分行', 1048527, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '32', '江苏省', NULL, 'A', '7', '2005-06-27 00:00:00'); INSERT INTO cnaps VALUES ('ABC', 'ABC', '中国农业银行', '330100', '杭州市', '103331001034', 1, 0, '2999-12-31 00:00:00', '中国农业银行股份有限公司杭州半山支行', 1048528, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '33', '浙江省', ' ', 'A', '7', '2003-12-01 00:00:00'); INSERT INTO cnaps VALUES ('HDB', 'HDB', '邯郸银行', '130400', '邯郸市', '313127050506', 1, 0, '2999-12-31 00:00:00', '邯郸银行股份有限公司滨河支行', 1048529, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '13', '河北省', NULL, 'A', '7', '2015-04-18 00:00:00'); INSERT INTO cnaps VALUES ('PSB', 'PSB', '中国邮政储蓄银行', '410200', '开封市', '403492000063', 1, 0, '2999-12-31 00:00:00', '中国邮政储蓄银行股份有限公司开封市公园路支行', 1048530, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '41', '河南省', NULL, 'A', '7', '2021-06-12 00:00:00'); INSERT INTO cnaps VALUES ('ABC', 'ABC', '中国农业银行', '360400', '九江市', '103424634314', 1, 0, '2999-12-31 00:00:00', '中国农业银行股份有限公司德安县支行', 1048531, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '36', '江西省', ' ', 'A', '7', '2005-04-11 00:00:00'); INSERT INTO cnaps VALUES ('OTH', 'OTH', '其他银行', '211100', '盘锦市', '011232213026', 1, 0, '2999-12-31 00:00:00', '国家金库辽宁省盘锦市盘山县支库', 1048532, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '21', '辽宁省', NULL, 'A', '7', '2005-04-11 00:00:00'); INSERT INTO cnaps VALUES ('CCB', 'CCB', '中国建设银行', '210500', '本溪市', '105225000502', 1, 0, '2999-12-31 00:00:00', '中国建设银行股份有限公司本溪解放路支行', 1048533, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '21', '辽宁省', NULL, 'A', '7', '2015-04-18 00:00:00'); INSERT INTO cnaps VALUES ('PSB', 'PSB', '中国邮政储蓄银行', '211200', '铁岭市', '403233000032', 1, 0, '2999-12-31 00:00:00', '中国邮政储蓄银行股份有限公司铁岭县支行', 1048534, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '21', '辽宁省', NULL, 'A', '7', '2008-07-14 00:00:00'); INSERT INTO cnaps VALUES ('PSB', 'PSB', '中国邮政储蓄银行', '429000', '省直辖县级行政单位', '403537407281', 1, 0, '2999-12-31 00:00:00', '中国邮政储蓄银行股份有限公司天门市皂市镇支行', 1048535, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '42', '湖北省', ' ', 'A', '7', '2008-07-14 00:00:00'); INSERT INTO cnaps VALUES ('OTH', 'OTH', '其他银行', '330900', '舟山市', '011342000003', 1, 0, '2999-12-31 00:00:00', '国家金库舟山市中心支库', 1048536, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '33', '浙江省', NULL, 'A', '7', '2010-05-01 00:00:00'); INSERT INTO cnaps VALUES ('VTB', 'VTB', '村镇银行', '110000', '北京市', '320100010054', 1, 0, '2999-12-31 00:00:00', '北京顺义银座村镇银行股份有限公司南彩支行', 1048538, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '11', '北京市', NULL, 'A', '7', '2013-04-22 00:00:00'); INSERT INTO cnaps VALUES ('CCB', 'CCB', '中国建设银行', '232700', '大兴安岭地区', '105279000167', 1, 0, '2999-12-31 00:00:00', '中国建设银行股份有限公司加格达奇北山支行', 1048541, '2023-10-07 00:00:00', 'I', NULL, 1, 20, '23', '黑龙江省', NULL, 'A', '7', '2010-01-11 00:00:00'); INSERT INTO cnaps VALUES ('OTH', 'OTH', '其他银行'