{"text_format":"3","workbook":"xls","n_sheets":16,"sheets":["目录","节假日表","机构信息","债券基本资料表","付息计划表","债券行权信息表","债券评级信息表","债券估值行情表","债券市场行情","浮息债报价表","中国共同基金基本资料","中国共同基金净值","利率行情","收益率曲线表","基金场内行情","商业银行净资产"],"not_rendered":{"comments":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"目录","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[2,0,3,0],[2,2,3,2],[4,0,6,0],[4,2,6,2],[9,0,10,0],[9,2,10,2],[15,0,16,0],[15,2,16,2],[17,0,19,0]],"flags":["formulas_cached_only"]}
["业务表","原有表名称","缩短后的表名称","接入的数据时点","接入方式","财汇表英文名","财汇表中文名"]
["节假日","INTERF_PAYHSRCHOLIDAY","INTERF_PAYHSRCHOLIDAY","日终","增量","TQ_OA_TRDSCHEDULE","交易日期表","节假日需自行逻辑判断"]
["机构信息","INTERF_CUSTOMER_INFO","INTERF_CUSTOMER_INFO","日终","增量","TQ_COMP_INFO","机构资料表"]
[{"$nulls":5},"TQ_COMP_INDUSTRY","行业分类表"]
["债券基本资料表","INTERF_PAYHSRCSECINFO","INTERF_PAYHSRCSECINFO","日终","全量","TQ_BD_BASICINFO","债券基本要素表"]
[{"$nulls":5},"TQ_BD_INTRATECHG","债券利率变动表"]
[{"$nulls":5},"TQ_BD_BOARDMAP","债板对照表"]
["付息计划表","INTERF_PAYHSRCSECSCHEDULE","INTERF_PAYHSRCSECSCHEDULE","日终","全量","TQ_BD_PFCASHFLOW","债券预估现金流表"]
["债券行权信息表","INTERF_PAYHSRCSECOPTION","INTERF_PAYHSRCSECOPTION","日终","全量","TQ_BD_PROOPTION_NEW","含权债权益明细表（新）"]
["债券评级信息表","INTERF_PAYHSRCSECRATING","INTERF_PAYHSRCSECRATING","日终","增量","TQ_BD_CREDITRATE","债券信用评级"]
[{"$nulls":5},"TQ_BD_CREDITRTISSUE","发债机构信用评级"]
["债券估值行情表","INTERF_PAYHSRCCBVLT","INTERF_PAYHSRCCBVLT","日终","增量","TQ_QT_CBESTIMATE","债券估值表"]
["债券市场行情表","INTERF_BOND_MARKET_INFO","INTERF_BOND_MARKET_INFO","日终","增量","TQ_QT_BDDAILYPRICE_NEW","债券历史日交易（新）"]
["浮息债报价表","INTERF_FLOATINGCOUPONSRATE","INTERF_FLOATCOUPRATE","日终","增量","TQ_BD_INTRATECHG","债券利率变动表"]
["中国共同基金基本资料","INTERF_CHINAMUTUALFUNDDESCRIPTION","INTERF_CMFUNDDESCRIP","日终","增量","TQ_FD_BASICINFO","基金基本信息"]
["中国共同基金净值","INTERF_ChinaMutualFundNAV","INTERF_CMFundNAV","日终","增量","TQ_FUND_NAV","基金净值"]
[{"$nulls":5},"TQ_FUND_NAVCUR","货币式基金净值"]
["利率行情","INTERF_INT_RATE_INFO","INTERF_INT_RATE_INFO","日终","增量","TQ_RT_RATE","利率表"]
[{"$nulls":5},"TQ_RT_WRIBOR","全球同业拆放利率表"]
[{"$nulls":5},"TQ_RT_SHIBOR","上海银行间同业拆放利率表"]
["收益率曲线表","INTERF_PAYHSRCBONDENCASHYIELD","INTERF_PAYHSRCCASHYIELD","日终","增量","TQ_QT_YIELDCURVE","债券收益率曲线"]
["场内基金行情",null,"INTERF_F_MARKET_INFO","日终","增量","TQ_QT_FDQUOTE","基金历史日交易"]
["商业银行净资产",null,"INTERF_BANK_NETASSET","日终","增量"," TQ_FIN_PRGBBALBSHEETNEW","银行资产负债表(新准则产品表)"]

{"sheet":"节假日表","index":1,"n_rows":12,"n_cols":11,"rows_kept":12,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["节假日表",{"$nulls":5},"外部数据源"]
["INTERF_PAYHSRCHOLIDAY",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["节假日表",null,null,"数据字典值"]
["CDATE","DATE","日期",null,"是","key"]
["MARKET_CODE","VARCHAR(50)","市场代码\n","参考：MST_CALENDAR_INFO表字段CALENDAR_ID\n 01 中国法定节假日\n02 美国法定节假日\n03 银行间\n04 上交所\n05 深交所\n06 商业银行柜台市场\n07 其他\n08 香港节假日\n09 澳大利亚节假日\n10 欧元区节假日\n11 美元节假日\n12 伦敦节假日","是","key"]
["IS_HOLIDAY","NUMERIC(10)","是否节假日","0：工作日\n1：节假日","是"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"是",{"$nulls":5},"数据源系统缩写"]

{"sheet":"机构信息","index":2,"n_rows":575,"n_cols":11,"rows_kept":575,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["机构信息",{"$nulls":5},"外部数据源"]
["INTERF_CUSTOMER_INFO",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["机构信息表",null,null,"数据字典值"]
["CUSTOMER_ID","VARCHAR(32)","客户代码",null,"key"]
["CUSTOMER_NAME","VARCHAR(500)","机构名称",null,"是"]
["CUSTOMER_ABBR","VARCHAR(500)","机构简称",null,"是"]
["PARTY_TYPE3","VARCHAR(50)","机构类型（技术领域），高新技术企业、其他"," 参考参数：PARTY_TYPE3\n01 高新技术企业\n 99 其他","否"]
["PARTY_TYPE2","VARCHAR(50)","机构类型（经济类型），国有企业、集体企业、民营企业、其他企业"," 参考参数：PARTY_TYPE2\n01 国有企业\n02 集体企业\n03 私营企业\n99 其他","否"]
["PARTY_TYPE1","VARCHAR(50)","机构类型（规模），大型企业、中小微企业","参考参数：PARTY_TYPE1\n01 中小微企业\n02 大型企业\n99 其他","否"]
["INDUSTRY","VARCHAR(50)","国标一级分类","参考参数：INSTITUTION_INDUSTRY_FIRST_LEVEL\n具体枚举值见下\n","否"]
["INDUSTRY2","VARCHAR(50)","国标二级分类","参考参数：INSTITUTION_INDUSTRY_SECOND_LEVEL\n具体枚举值见下","否"]
["INSITITUTE_CODE","VARCHAR(50)","组织机构代码/统一社会信用代码",null,"否"]
["IS_GOV","VARCHAR(50)","是否政府融资平台","Y：是\nN:否","否"]
["MAIN_CAPITAL","NUMERIC(30, 14)","核心资本（万元），存的是万元",null,"否"]
["REGISTER_CAPITAL","NUMERIC(30, 14)","注册资本（万元），存的是万元",null,"否"]
["PROVINCE","VARCHAR(50)","所属省"," 参考参数：ADMINISTRATIVE_TYPE1\n枚举值见下","否"]
["CITY","VARCHAR(50)","所属市"," 参考参数：ADMINISTRATIVE_TYPE2\n枚举值见下","否"]
["COUNTY","VARCHAR(50)","所属县"," 参考参数：ADMINISTRATIVE_TYPE3\n枚举值见下","否"]
["HOLDING_TYPE","VARCHAR(50)","控股类型"," 参考参数：HOLDING_TYPE\n枚举值见下","否"]
["CUSTOMER_OBJ_TYPE","VARCHAR(50)","客户主体类型，我国中央政府、境外主权国家或经济实体区域政府、中国人民银行、境外中央银行等","参考参数：CUSTOMER_PRIN_TYPE\n枚举值见下","否"]
["IS_LISTED_COMPANY","VARCHAR(50)","是否上市公司","Y：是\nN:否","否"]
["IS_GROUP_CUSTOMER","VARCHAR(50)","是否集团客户","Y：是\nN:否","否"]
["PARENT_CUSTOMER_ID","VARCHAR(32)","所属集团客户编号",null,"否"]
["PARENT_CUSTOMER_NAME","VARCHAR(200)","所属集团客户名称",null,"否"]
["IS_PRIVATE","VARCHAR(50)","是否民营企业","Y：是\nN:否","否"]
["IS_ESCAPE_DEPT","VARCHAR(50)","是否为逃废债企业","Y：是\nN:否","否"]
["CREDIT_TYPE","VARCHAR(50)","授信策略","参考参数：CREDIT_POLICY\n 01 增加\n 02 维持\n 03 压缩\n 04 退出\n 05 限制敞口申报","否"]
["IS_CREDIT_RELATED_TRD","VARCHAR(50)","是否授信类关联交易","Y：是\nN:否","否"]
["STRUCT_ADJUST_TYPE","VARCHAR(50)","产业结构调整类型","参考参数：INDUSTY_STRUCT_ADJ_TYPE\n 01 鼓励\n 02 限制\n 03 淘汰","否"]
["INDUS_UPGRATE_TYPE","VARCHAR(50)","工业转型升级标识","参考参数：INDUSTY_TRANSFORM_TYPE\n 01 标准化\n 02 现代化","否"]
["BUSI_SCOPE","VARCHAR(1000)","经营范围",null,"否"]
["MAIN_BUSI","VARCHAR(1000)","主营业务",null,"否"]
["COMPANY_NATURE","VARCHAR(50)","企业性质","参考参数：ENTERPRISE_PROPERTY\n 01 国有企业\n 02 集体企业\n 03 民营企业\n 04 外资企业\n 05 公众企业\n 99 其他企业","否"]
["REMARK","VARCHAR(1000)","备注",null,"否"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"是",{"$nulls":5},"数据源系统缩写"]
["INDUSTRY_SRC","VARCHAR2(100)","行业（证监会）",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
["INDUSTRY_SRC_TWO","VARCHAR2(100)","行业（证监会）二级",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
["INDUSTRY_WIND","VARCHAR2(100)","行业（wind）",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
["INDUSTRY_WIND","VARCHAR2(100)","行业（wind）二级",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
["INDUSTRY_SHENWAN","VARCHAR2(100)","行业（申万）",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
["INDUSTRY_WIND_TWO","VARCHAR2(100)","行业（申万）二级",null,"否",{"$nulls":5},"2019.09.26号增加，用于报表统计（若不需要可不加）"]
[]
[null,"国标一级分类","INSTITUTION_INDUSTRY_FIRST_LEVEL","01","农、林、牧、渔业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","02","采矿业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","03","制造业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","04","电力、热力、燃气及水生产和供应业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","05","建筑业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","06","批发和零售业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","07","交通运输、仓储和邮政业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","08","住宿和餐饮业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","09","信息传输、软件和信息技术服务业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","10","金融业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","11","房地产"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","12","租赁和商务服务业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","13","科学研究和技术服务业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","14","水利、环境和公共设施管理业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","15","居民服务、修理和其他服务业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","16","教育"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","17","卫生和社会工作"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","18","文化、体育和娱乐业"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","19","公共管理、社会保障和社会组织"]
[null,null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","20","国际组织"]
[]
[null,"国标二级分类","INSTITUTION_INDUSTRY_SECOND_LEVEL","A01","农业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A02","林业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A03","畜牧业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A04","渔业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A05","农、林、牧、渔服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B06","煤炭开采和洗选业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B07","石油和天然气开采业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B08","黑色金属矿采选业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B09","有色金属矿采选业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B10","非金属矿采选业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B11","开采辅助活动"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B12","其他采矿业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C13","农副食品加工业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C14","食品制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C15","酒、饮料和精制茶制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C16","烟草制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C17","纺织业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C18","纺织服装、服饰业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C19","皮革、毛皮、羽毛及其制品和制鞋业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C20","木材加工和木、竹、藤、棕、草制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C21","家具制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C22","造纸及纸制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C23","印刷业和记录媒介的复制业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C24","文教、工美、体育和娱乐用品制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C25","石油加工、炼焦及核燃料加工业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C26","化学原料和化学制品制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C27","医药制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C28","化学纤维制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C29","橡胶和塑料制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C30","非金属矿物制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C31","黑色金属冶炼及压延加工业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C32","有色金属冶炼及压延加工业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C33","金属制品业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C34","通用设备制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C35","专用设备制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C36","汽车制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C37","铁路、船舶、航空航天和其他运输设备制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C38","电气机械和器材制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C39","计算机、通信和其他电子设备制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C40","仪器仪表制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C41","其他制造业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C42","废弃资源综合利用业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C43","金属制品、机械和设备修理业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D44","电力、热力生产和供应业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D45","煤气生产和供应业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D46","水的生产和供应业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E47","房屋建筑业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E48","土木工程建筑业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E49","建筑安装业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E50","建筑装饰和其他建筑业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","F51","批发业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","F52","零售业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G53","铁路运输业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G54","道路运输业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G55","水上运输业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G56","航空运输业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G57","管道运输业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G58","装卸搬运和其他运输服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G59","仓储业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G60","邮政业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","H61","住宿业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","H62","餐饮业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I63","电信、广播电视和卫星传输服务"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I64","互联网和相关服务"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I65","软件和信息技术服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J66","货币金融服务"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J67","资本市场服务"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J68","保险业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J69","其他金融业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","K70","房地产业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","L71","租赁业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","L72","商务服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M73","研究与试验发展"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M74","专业技术服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M75","科技推广和应用服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N76","水利管理业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N77","生态保护和环境治理业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N78","公共设施管理业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O79","居民服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O80","机动车、电子产品和日用产品修理业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O81","其他服务业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","P82","教育"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","Q83","卫生"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","Q84","社会工作"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R85","新闻和出版业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R86","广播、电视、电影和影视录音制作业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R87","文化艺术业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R88","体育"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R89","娱乐业"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S90","中国共产党机关"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S91","国家机构"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S92","人民政协、民主党派"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S93","社会保障"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S94","群众团体、社会团体和其他成员组织"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S95","基层群众自治组织"]
[null,null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","T96","国际组织"]
[]
[null,"所属省","ADMINISTRATIVE_TYPE1",110000,"北京市"]
[null,null,"ADMINISTRATIVE_TYPE1",120000,"天津市"]
[null,null,"ADMINISTRATIVE_TYPE1",130000,"河北省"]
[null,null,"ADMINISTRATIVE_TYPE1",140000,"山西省"]
[null,null,"ADMINISTRATIVE_TYPE1",150000,"内蒙古自治区"]
[null,null,"ADMINISTRATIVE_TYPE1",210000,"辽宁省"]
[null,null,"ADMINISTRATIVE_TYPE1",220000,"吉林省"]
[null,null,"ADMINISTRATIVE_TYPE1",230000,"黑龙江省"]
[null,null,"ADMINISTRATIVE_TYPE1",310000,"上海市"]
[null,null,"ADMINISTRATIVE_TYPE1",320000,"江苏省"]
[null,null,"ADMINISTRATIVE_TYPE1",330000,"浙江省"]
[null,null,"ADMINISTRATIVE_TYPE1",340000,"安徽省"]
[null,null,"ADMINISTRATIVE_TYPE1",350000,"福建省"]
[null,null,"ADMINISTRATIVE_TYPE1",360000,"江西省"]
[null,null,"ADMINISTRATIVE_TYPE1",370000,"山东省"]
[null,null,"ADMINISTRATIVE_TYPE1",410000,"河南省"]
[null,null,"ADMINISTRATIVE_TYPE1",420000,"湖北省"]
[null,null,"ADMINISTRATIVE_TYPE1",430000,"湖南省"]
[null,null,"ADMINISTRATIVE_TYPE1",440000,"广东省"]
[null,null,"ADMINISTRATIVE_TYPE1",450000,"广西壮族自治区"]
[null,null,"ADMINISTRATIVE_TYPE1",460000,"海南省"]
[null,null,"ADMINISTRATIVE_TYPE1",500000,"重庆市"]
[null,null,"ADMINISTRATIVE_TYPE1",510000,"四川省"]
[null,null,"ADMINISTRATIVE_TYPE1",520000,"贵州省"]
[null,null,"ADMINISTRATIVE_TYPE1",530000,"云南省"]
[null,null,"ADMINISTRATIVE_TYPE1",540000,"西藏自治区"]
[null,null,"ADMINISTRATIVE_TYPE1",610000,"陕西省"]
[null,null,"ADMINISTRATIVE_TYPE1",620000,"甘肃省"]
[null,null,"ADMINISTRATIVE_TYPE1",630000,"青海省"]
[null,null,"ADMINISTRATIVE_TYPE1",640000,"宁夏回族自治区"]
[null,null,"ADMINISTRATIVE_TYPE1",650000,"新疆维吾尔自治区"]
[null,null,"ADMINISTRATIVE_TYPE1","710000","台湾省"]
[null,null,"ADMINISTRATIVE_TYPE1",810000,"香港特别行政区"]
[null,null,"ADMINISTRATIVE_TYPE1",820000,"澳门特别行政区"]
[]
[null,"所属市","ADMINISTRATIVE_TYPE2",110100,"北京市（市辖区）"]
[null,null,"ADMINISTRATIVE_TYPE2",110200,"北京市（县）"]
[null,null,"ADMINISTRATIVE_TYPE2",120100,"天津市（市辖区）"]
[null,null,"ADMINISTRATIVE_TYPE2",120200,"天津市（县）"]
[null,null,"ADMINISTRATIVE_TYPE2",130100,"石家庄市"]
[null,null,"ADMINISTRATIVE_TYPE2",130200,"唐山市"]
[null,null,"ADMINISTRATIVE_TYPE2",130300,"秦皇岛市"]
[null,null,"ADMINISTRATIVE_TYPE2",130400,"邯郸市"]
[null,null,"ADMINISTRATIVE_TYPE2",130500,"邢台市"]
[null,null,"ADMINISTRATIVE_TYPE2",130600,"保定市"]
[null,null,"ADMINISTRATIVE_TYPE2",130700,"张家口市"]
[null,null,"ADMINISTRATIVE_TYPE2",130800,"承德市"]
[null,null,"ADMINISTRATIVE_TYPE2",130900,"沧州市"]
[null,null,"ADMINISTRATIVE_TYPE2",131000,"廊坊市"]
[null,null,"ADMINISTRATIVE_TYPE2",131100,"衡水市"]
[null,null,"ADMINISTRATIVE_TYPE2",140100,"太原市"]
[null,null,"ADMINISTRATIVE_TYPE2",140200,"大同市"]
[null,null,"ADMINISTRATIVE_TYPE2",140300,"阳泉市"]
[null,null,"ADMINISTRATIVE_TYPE2",140400,"长治市"]
[null,null,"ADMINISTRATIVE_TYPE2",140500,"晋城市"]
[null,null,"ADMINISTRATIVE_TYPE2",140600,"朔州市"]
[null,null,"ADMINISTRATIVE_TYPE2",140700,"晋中市"]
[null,null,"ADMINISTRATIVE_TYPE2",140800,"运城市"]
[null,null,"ADMINISTRATIVE_TYPE2",140900,"忻州市"]
[null,null,"ADMINISTRATIVE_TYPE2",141000,"临汾市"]
[null,null,"ADMINISTRATIVE_TYPE2",141100,"吕梁市"]
[null,null,"ADMINISTRATIVE_TYPE2",150100,"呼和浩特市"]
[null,null,"ADMINISTRATIVE_TYPE2",150200,"包头市"]
[null,null,"ADMINISTRATIVE_TYPE2",150300,"乌海市"]
[null,null,"ADMINISTRATIVE_TYPE2",150400,"赤峰市"]
[null,null,"ADMINISTRATIVE_TYPE2",150500,"通辽市"]
[null,null,"ADMINISTRATIVE_TYPE2",150600,"鄂尔多斯市"]
[null,null,"ADMINISTRATIVE_TYPE2",150700,"呼伦贝尔市"]
[null,null,"ADMINISTRATIVE_TYPE2",150800,"巴彦淖尔市"]
[null,null,"ADMINISTRATIVE_TYPE2",150900,"乌兰察布市"]
[null,null,"ADMINISTRATIVE_TYPE2",152200,"兴安盟"]
[null,null,"ADMINISTRATIVE_TYPE2",152500,"锡林郭勒盟"]
[null,null,"ADMINISTRATIVE_TYPE2",152900,"阿拉善盟"]
[null,null,"ADMINISTRATIVE_TYPE2",210100,"沈阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",210200,"大连市"]
[null,null,"ADMINISTRATIVE_TYPE2",210300,"鞍山市"]
[null,null,"ADMINISTRATIVE_TYPE2",210400,"抚顺市"]
[null,null,"ADMINISTRATIVE_TYPE2",210500,"本溪市"]
[null,null,"ADMINISTRATIVE_TYPE2",210600,"丹东市"]
[null,null,"ADMINISTRATIVE_TYPE2",210700,"锦州市"]
[null,null,"ADMINISTRATIVE_TYPE2",210800,"营口市"]
[null,null,"ADMINISTRATIVE_TYPE2",210900,"阜新市"]
[null,null,"ADMINISTRATIVE_TYPE2",211000,"辽阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",211100,"盘锦市"]
[null,null,"ADMINISTRATIVE_TYPE2",211200,"铁岭市"]
[null,null,"ADMINISTRATIVE_TYPE2",211300,"朝阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",211400,"葫芦岛市"]
[null,null,"ADMINISTRATIVE_TYPE2",220100,"长春市"]
[null,null,"ADMINISTRATIVE_TYPE2",220200,"吉林市"]
[null,null,"ADMINISTRATIVE_TYPE2",220300,"四平市"]
[null,null,"ADMINISTRATIVE_TYPE2",220400,"辽源市"]
[null,null,"ADMINISTRATIVE_TYPE2",220500,"通化市"]
[null,null,"ADMINISTRATIVE_TYPE2",220600,"白山市"]
[null,null,"ADMINISTRATIVE_TYPE2",220700,"松原市"]
[null,null,"ADMINISTRATIVE_TYPE2",220800,"白城市"]
[null,null,"ADMINISTRATIVE_TYPE2",222400,"延边朝鲜族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",230100,"哈尔滨市"]
[null,null,"ADMINISTRATIVE_TYPE2",230200,"齐齐哈尔市"]
[null,null,"ADMINISTRATIVE_TYPE2",230300,"鸡西市"]
[null,null,"ADMINISTRATIVE_TYPE2",230400,"鹤岗市"]
[null,null,"ADMINISTRATIVE_TYPE2",230500,"双鸭山市"]
[null,null,"ADMINISTRATIVE_TYPE2",230600,"大庆市"]
[null,null,"ADMINISTRATIVE_TYPE2",230700,"伊春市"]
[null,null,"ADMINISTRATIVE_TYPE2",230800,"佳木斯市"]
[null,null,"ADMINISTRATIVE_TYPE2",230900,"七台河市"]
[null,null,"ADMINISTRATIVE_TYPE2",231000,"牡丹江市"]
[null,null,"ADMINISTRATIVE_TYPE2",231100,"黑河市"]
[null,null,"ADMINISTRATIVE_TYPE2",231200,"绥化市"]
[null,null,"ADMINISTRATIVE_TYPE2",232700,"大兴安岭地区"]
[null,null,"ADMINISTRATIVE_TYPE2",310100,"上海市（市辖区）"]
[null,null,"ADMINISTRATIVE_TYPE2",310200,"上海市（县）"]
[null,null,"ADMINISTRATIVE_TYPE2",320100,"南京市"]
[null,null,"ADMINISTRATIVE_TYPE2",320200,"无锡市"]
[null,null,"ADMINISTRATIVE_TYPE2",320300,"徐州市"]
[null,null,"ADMINISTRATIVE_TYPE2",320400,"常州市"]
[null,null,"ADMINISTRATIVE_TYPE2",320500,"苏州市"]
[null,null,"ADMINISTRATIVE_TYPE2",320600,"南通市"]
[null,null,"ADMINISTRATIVE_TYPE2",320700,"连云港市"]
[null,null,"ADMINISTRATIVE_TYPE2",320800,"淮安市"]
[null,null,"ADMINISTRATIVE_TYPE2",320900,"盐城市"]
[null,null,"ADMINISTRATIVE_TYPE2",321000,"扬州市"]
[null,null,"ADMINISTRATIVE_TYPE2",321100,"镇江市"]
[null,null,"ADMINISTRATIVE_TYPE2",321200,"泰州市"]
[null,null,"ADMINISTRATIVE_TYPE2",321300,"宿迁市"]
[null,null,"ADMINISTRATIVE_TYPE2",330100,"杭州市"]
[null,null,"ADMINISTRATIVE_TYPE2",330200,"宁波市"]
[null,null,"ADMINISTRATIVE_TYPE2",330300,"温州市"]
[null,null,"ADMINISTRATIVE_TYPE2",330400,"嘉兴市"]
[null,null,"ADMINISTRATIVE_TYPE2",330500,"湖州市"]
[null,null,"ADMINISTRATIVE_TYPE2",330600,"绍兴市"]
[null,null,"ADMINISTRATIVE_TYPE2",330700,"金华市"]
[null,null,"ADMINISTRATIVE_TYPE2",330800,"衢州市"]
[null,null,"ADMINISTRATIVE_TYPE2",330900,"舟山市"]
[null,null,"ADMINISTRATIVE_TYPE2",331000,"台州市"]
[null,null,"ADMINISTRATIVE_TYPE2",331100,"丽水市"]
[null,null,"ADMINISTRATIVE_TYPE2",340100,"合肥市"]
[null,null,"ADMINISTRATIVE_TYPE2",340200,"芜湖市"]
[null,null,"ADMINISTRATIVE_TYPE2",340300,"蚌埠市"]
[null,null,"ADMINISTRATIVE_TYPE2",340400,"淮南市"]
[null,null,"ADMINISTRATIVE_TYPE2",340500,"马鞍山市"]
[null,null,"ADMINISTRATIVE_TYPE2",340600,"淮北市"]
[null,null,"ADMINISTRATIVE_TYPE2",340700,"铜陵市"]
[null,null,"ADMINISTRATIVE_TYPE2",340800,"安庆市"]
[null,null,"ADMINISTRATIVE_TYPE2",341000,"黄山市"]
[null,null,"ADMINISTRATIVE_TYPE2",341100,"滁州市"]
[null,null,"ADMINISTRATIVE_TYPE2",341200,"阜阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",341300,"宿州市"]
[null,null,"ADMINISTRATIVE_TYPE2",341500,"六安市"]
[null,null,"ADMINISTRATIVE_TYPE2",341600,"亳州市"]
[null,null,"ADMINISTRATIVE_TYPE2",341700,"池州市"]
[null,null,"ADMINISTRATIVE_TYPE2",341800,"宣城市"]
[null,null,"ADMINISTRATIVE_TYPE2",350100,"福州市"]
[null,null,"ADMINISTRATIVE_TYPE2",350200,"厦门市"]
[null,null,"ADMINISTRATIVE_TYPE2",350300,"莆田市"]
[null,null,"ADMINISTRATIVE_TYPE2",350400,"三明市"]
[null,null,"ADMINISTRATIVE_TYPE2",350500,"泉州市"]
[null,null,"ADMINISTRATIVE_TYPE2",350600,"漳州市"]
[null,null,"ADMINISTRATIVE_TYPE2",350700,"南平市"]
[null,null,"ADMINISTRATIVE_TYPE2",350800,"龙岩市"]
[null,null,"ADMINISTRATIVE_TYPE2",350900,"宁德市"]
[null,null,"ADMINISTRATIVE_TYPE2",360100,"南昌市"]
[null,null,"ADMINISTRATIVE_TYPE2",360200,"景德镇市"]
[null,null,"ADMINISTRATIVE_TYPE2",360300,"萍乡市"]
[null,null,"ADMINISTRATIVE_TYPE2",360400,"九江市"]
[null,null,"ADMINISTRATIVE_TYPE2",360500,"新余市"]
[null,null,"ADMINISTRATIVE_TYPE2",360700,"赣州市"]
[null,null,"ADMINISTRATIVE_TYPE2",360800,"吉安市"]
[null,null,"ADMINISTRATIVE_TYPE2",360900,"宜春市"]
[null,null,"ADMINISTRATIVE_TYPE2",361000,"抚州市"]
[null,null,"ADMINISTRATIVE_TYPE2",361100,"上饶市"]
[null,null,"ADMINISTRATIVE_TYPE2",370100,"济南市"]
[null,null,"ADMINISTRATIVE_TYPE2",370200,"青岛市"]
[null,null,"ADMINISTRATIVE_TYPE2",370300,"淄博市"]
[null,null,"ADMINISTRATIVE_TYPE2",370400,"枣庄市"]
[null,null,"ADMINISTRATIVE_TYPE2",370500,"东营市"]
[null,null,"ADMINISTRATIVE_TYPE2",370600,"烟台市"]
[null,null,"ADMINISTRATIVE_TYPE2",370700,"潍坊市"]
[null,null,"ADMINISTRATIVE_TYPE2",370800,"济宁市"]
[null,null,"ADMINISTRATIVE_TYPE2",370900,"泰安市"]
[null,null,"ADMINISTRATIVE_TYPE2",371000,"威海市"]
[null,null,"ADMINISTRATIVE_TYPE2",371100,"日照市"]
[null,null,"ADMINISTRATIVE_TYPE2",371200,"莱芜市"]
[null,null,"ADMINISTRATIVE_TYPE2",371300,"临沂市"]
[null,null,"ADMINISTRATIVE_TYPE2",371400,"德州市"]
[null,null,"ADMINISTRATIVE_TYPE2",371500,"聊城市"]
[null,null,"ADMINISTRATIVE_TYPE2",371600,"滨州市"]
[null,null,"ADMINISTRATIVE_TYPE2",371700,"菏泽市"]
[null,null,"ADMINISTRATIVE_TYPE2",410100,"郑州市"]
[null,null,"ADMINISTRATIVE_TYPE2",410200,"开封市"]
[null,null,"ADMINISTRATIVE_TYPE2",410300,"洛阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",410400,"平顶山市"]
[null,null,"ADMINISTRATIVE_TYPE2",410500,"安阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",410600,"鹤壁市"]
[null,null,"ADMINISTRATIVE_TYPE2",410700,"新乡市"]
[null,null,"ADMINISTRATIVE_TYPE2",410800,"焦作市"]
[null,null,"ADMINISTRATIVE_TYPE2",410900,"濮阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",411000,"许昌市"]
[null,null,"ADMINISTRATIVE_TYPE2",411100,"漯河市"]
[null,null,"ADMINISTRATIVE_TYPE2",411200,"三门峡市"]
[null,null,"ADMINISTRATIVE_TYPE2",411300,"南阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",411400,"商丘市"]
[null,null,"ADMINISTRATIVE_TYPE2",411500,"信阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",411600,"周口市"]
[null,null,"ADMINISTRATIVE_TYPE2",411700,"驻马店市"]
[null,null,"ADMINISTRATIVE_TYPE2",419000,"河南省（省直辖县级行政区划）"]
[null,null,"ADMINISTRATIVE_TYPE2",420100,"武汉市"]
[null,null,"ADMINISTRATIVE_TYPE2",420200,"黄石市"]
[null,null,"ADMINISTRATIVE_TYPE2",420300,"十堰市"]
[null,null,"ADMINISTRATIVE_TYPE2",420500,"宜昌市"]
[null,null,"ADMINISTRATIVE_TYPE2",420600,"襄阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",420700,"鄂州市"]
[null,null,"ADMINISTRATIVE_TYPE2",420800,"荆门市"]
[null,null,"ADMINISTRATIVE_TYPE2",420900,"孝感市"]
[null,null,"ADMINISTRATIVE_TYPE2",421000,"荆州市"]
[null,null,"ADMINISTRATIVE_TYPE2",421100,"黄冈市"]
[null,null,"ADMINISTRATIVE_TYPE2",421200,"咸宁市"]
[null,null,"ADMINISTRATIVE_TYPE2",421300,"随州市"]
[null,null,"ADMINISTRATIVE_TYPE2",422800,"恩施土家族苗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",429000,"湖北省（省直辖县级行政区划）"]
[null,null,"ADMINISTRATIVE_TYPE2",430100,"长沙市"]
[null,null,"ADMINISTRATIVE_TYPE2",430200,"株洲市"]
[null,null,"ADMINISTRATIVE_TYPE2",430300,"湘潭市"]
[null,null,"ADMINISTRATIVE_TYPE2",430400,"衡阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",430500,"邵阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",430600,"岳阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",430700,"常德市"]
[null,null,"ADMINISTRATIVE_TYPE2",430800,"张家界市"]
[null,null,"ADMINISTRATIVE_TYPE2",430900,"益阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",431000,"郴州市"]
[null,null,"ADMINISTRATIVE_TYPE2",431100,"永州市"]
[null,null,"ADMINISTRATIVE_TYPE2",431200,"怀化市"]
[null,null,"ADMINISTRATIVE_TYPE2",431300,"娄底市"]
[null,null,"ADMINISTRATIVE_TYPE2",433100,"湘西土家族苗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",440100,"广州市"]
[null,null,"ADMINISTRATIVE_TYPE2",440200,"韶关市"]
[null,null,"ADMINISTRATIVE_TYPE2",440300,"深圳市"]
[null,null,"ADMINISTRATIVE_TYPE2",440400,"珠海市"]
[null,null,"ADMINISTRATIVE_TYPE2",440500,"汕头市"]
[null,null,"ADMINISTRATIVE_TYPE2",440600,"佛山市"]
[null,null,"ADMINISTRATIVE_TYPE2",440700,"江门市"]
[null,null,"ADMINISTRATIVE_TYPE2",440800,"湛江市"]
[null,null,"ADMINISTRATIVE_TYPE2",440900,"茂名市"]
[null,null,"ADMINISTRATIVE_TYPE2",441200,"肇庆市"]
[null,null,"ADMINISTRATIVE_TYPE2",441300,"惠州市"]
[null,null,"ADMINISTRATIVE_TYPE2",441400,"梅州市"]
[null,null,"ADMINISTRATIVE_TYPE2",441500,"汕尾市"]
[null,null,"ADMINISTRATIVE_TYPE2",441600,"河源市"]
[null,null,"ADMINISTRATIVE_TYPE2",441700,"阳江市"]
[null,null,"ADMINISTRATIVE_TYPE2",441800,"清远市"]
[null,null,"ADMINISTRATIVE_TYPE2",441900,"东莞市"]
[null,null,"ADMINISTRATIVE_TYPE2",445100,"潮州市"]
[null,null,"ADMINISTRATIVE_TYPE2",445200,"揭阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",445300,"云浮市"]
[null,null,"ADMINISTRATIVE_TYPE2",450100,"南宁市"]
[null,null,"ADMINISTRATIVE_TYPE2",450200,"柳州市"]
[null,null,"ADMINISTRATIVE_TYPE2",450300,"桂林市"]
[null,null,"ADMINISTRATIVE_TYPE2",450400,"梧州市"]
[null,null,"ADMINISTRATIVE_TYPE2",450500,"北海市"]
[null,null,"ADMINISTRATIVE_TYPE2",450600,"防城港市"]
[null,null,"ADMINISTRATIVE_TYPE2",450700,"钦州市"]
[null,null,"ADMINISTRATIVE_TYPE2",450800,"贵港市"]
[null,null,"ADMINISTRATIVE_TYPE2",450900,"玉林市"]
[null,null,"ADMINISTRATIVE_TYPE2",451000,"百色市"]
[null,null,"ADMINISTRATIVE_TYPE2",451100,"贺州市"]
[null,null,"ADMINISTRATIVE_TYPE2",451200,"河池市"]
[null,null,"ADMINISTRATIVE_TYPE2",451300,"来宾市"]
[null,null,"ADMINISTRATIVE_TYPE2",451400,"崇左市"]
[null,null,"ADMINISTRATIVE_TYPE2",460100,"海口市"]
[null,null,"ADMINISTRATIVE_TYPE2",460200,"三亚市"]
[null,null,"ADMINISTRATIVE_TYPE2",460300,"三沙市"]
[null,null,"ADMINISTRATIVE_TYPE2",469000,"海南省（省直辖县级行政区划）"]
[null,null,"ADMINISTRATIVE_TYPE2",500100,"重庆市（市辖区）"]
[null,null,"ADMINISTRATIVE_TYPE2",500200,"重庆市（县）"]
[null,null,"ADMINISTRATIVE_TYPE2",510100,"成都市"]
[null,null,"ADMINISTRATIVE_TYPE2",510300,"自贡市"]
[null,null,"ADMINISTRATIVE_TYPE2",510400,"攀枝花市"]
[null,null,"ADMINISTRATIVE_TYPE2",510500,"泸州市"]
[null,null,"ADMINISTRATIVE_TYPE2",510600,"德阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",510700,"绵阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",510800,"广元市"]
[null,null,"ADMINISTRATIVE_TYPE2",510900,"遂宁市"]
[null,null,"ADMINISTRATIVE_TYPE2",511000,"内江市"]
[null,null,"ADMINISTRATIVE_TYPE2",511100,"乐山市"]
[null,null,"ADMINISTRATIVE_TYPE2",511300,"南充市"]
[null,null,"ADMINISTRATIVE_TYPE2",511400,"眉山市"]
[null,null,"ADMINISTRATIVE_TYPE2",511500,"宜宾市"]
[null,null,"ADMINISTRATIVE_TYPE2",511600,"广安市"]
[null,null,"ADMINISTRATIVE_TYPE2",511700,"达州市"]
[null,null,"ADMINISTRATIVE_TYPE2",511800,"雅安市"]
[null,null,"ADMINISTRATIVE_TYPE2",511900,"巴中市"]
[null,null,"ADMINISTRATIVE_TYPE2",512000,"资阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",513200,"阿坝藏族羌族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",513300,"甘孜藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",513400,"凉山彝族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",520100,"贵阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",520200,"六盘水市"]
[null,null,"ADMINISTRATIVE_TYPE2",520300,"遵义市"]
[null,null,"ADMINISTRATIVE_TYPE2",520400,"安顺市"]
[null,null,"ADMINISTRATIVE_TYPE2",520500,"毕节市"]
[null,null,"ADMINISTRATIVE_TYPE2",520600,"铜仁市"]
[null,null,"ADMINISTRATIVE_TYPE2",522300,"黔西南布依族苗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",522600,"黔东南苗族侗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",522700,"黔南布依族苗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",530100,"昆明市"]
[null,null,"ADMINISTRATIVE_TYPE2",530300,"曲靖市"]
[null,null,"ADMINISTRATIVE_TYPE2",530400,"玉溪市"]
[null,null,"ADMINISTRATIVE_TYPE2",530500,"保山市"]
[null,null,"ADMINISTRATIVE_TYPE2",530600,"昭通市"]
[null,null,"ADMINISTRATIVE_TYPE2",530700,"丽江市"]
[null,null,"ADMINISTRATIVE_TYPE2",530800,"普洱市"]
[null,null,"ADMINISTRATIVE_TYPE2",530900,"临沧市"]
[null,null,"ADMINISTRATIVE_TYPE2",532300,"楚雄彝族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",532500,"红河哈尼族彝族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",532600,"文山壮族苗族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",532800,"西双版纳傣族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",532900,"大理白族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",533100,"德宏傣族景颇族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",533300,"怒江傈僳族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",533400,"迪庆藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",540100,"拉萨市"]
[null,null,"ADMINISTRATIVE_TYPE2",542100,"昌都地区"]
[null,null,"ADMINISTRATIVE_TYPE2",542200,"山南地区"]
[null,null,"ADMINISTRATIVE_TYPE2",542300,"日喀则地区"]
[null,null,"ADMINISTRATIVE_TYPE2",542400,"那曲地区"]
[null,null,"ADMINISTRATIVE_TYPE2",542500,"阿里地区"]
[null,null,"ADMINISTRATIVE_TYPE2",542600,"林芝地区"]
[null,null,"ADMINISTRATIVE_TYPE2",610100,"西安市"]
[null,null,"ADMINISTRATIVE_TYPE2",610200,"铜川市"]
[null,null,"ADMINISTRATIVE_TYPE2",610300,"宝鸡市"]
[null,null,"ADMINISTRATIVE_TYPE2",610400,"咸阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",610500,"渭南市"]
[null,null,"ADMINISTRATIVE_TYPE2",610600,"延安市"]
[null,null,"ADMINISTRATIVE_TYPE2",610700,"汉中市"]
[null,null,"ADMINISTRATIVE_TYPE2",610800,"榆林市"]
[null,null,"ADMINISTRATIVE_TYPE2",610900,"安康市"]
[null,null,"ADMINISTRATIVE_TYPE2",611000,"商洛市"]
[null,null,"ADMINISTRATIVE_TYPE2",620100,"兰州市"]
[null,null,"ADMINISTRATIVE_TYPE2",620200,"嘉峪关市"]
[null,null,"ADMINISTRATIVE_TYPE2",620300,"金昌市"]
[null,null,"ADMINISTRATIVE_TYPE2",620400,"白银市"]
[null,null,"ADMINISTRATIVE_TYPE2",620500,"天水市"]
[null,null,"ADMINISTRATIVE_TYPE2",620600,"武威市"]
[null,null,"ADMINISTRATIVE_TYPE2",620700,"张掖市"]
[null,null,"ADMINISTRATIVE_TYPE2",620800,"平凉市"]
[null,null,"ADMINISTRATIVE_TYPE2",620900,"酒泉市"]
[null,null,"ADMINISTRATIVE_TYPE2",621000,"庆阳市"]
[null,null,"ADMINISTRATIVE_TYPE2",621100,"定西市"]
[null,null,"ADMINISTRATIVE_TYPE2",621200,"陇南市"]
[null,null,"ADMINISTRATIVE_TYPE2",622900,"临夏回族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",623000,"甘南藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",630100,"西宁市"]
[null,null,"ADMINISTRATIVE_TYPE2",632100,"海东地区"]
[null,null,"ADMINISTRATIVE_TYPE2",632200,"海北藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",632300,"黄南藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",632500,"海南藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",632600,"果洛藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",632700,"玉树藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",632800,"海西蒙古族藏族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",640100,"银川市"]
[null,null,"ADMINISTRATIVE_TYPE2",640200,"石嘴山市"]
[null,null,"ADMINISTRATIVE_TYPE2",640300,"吴忠市"]
[null,null,"ADMINISTRATIVE_TYPE2",640400,"固原市"]
[null,null,"ADMINISTRATIVE_TYPE2",640500,"中卫市"]
[null,null,"ADMINISTRATIVE_TYPE2",650100,"乌鲁木齐市"]
[null,null,"ADMINISTRATIVE_TYPE2",650200,"克拉玛依市"]
[null,null,"ADMINISTRATIVE_TYPE2",652100,"吐鲁番地区"]
[null,null,"ADMINISTRATIVE_TYPE2",652200,"哈密地区"]
[null,null,"ADMINISTRATIVE_TYPE2",652300,"昌吉回族自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",652700,"博尔塔拉蒙古自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",652800,"巴音郭楞蒙古自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",652900,"阿克苏地区"]
[null,null,"ADMINISTRATIVE_TYPE2",653000,"克孜勒苏柯尔克孜自治州"]
[null,null,"ADMINISTRATIVE_TYPE2",653100,"喀什地区"]
[null,null,"ADMINISTRATIVE_TYPE2",653200,"和田地区"]
[]
[null,"控股类型","HOLDING_TYPE","A","公有控股经济"]
[null,null,"HOLDING_TYPE","A01","国有控股"]
[null,null,"HOLDING_TYPE","A0101","国有相对控股"]
[null,null,"HOLDING_TYPE","A0102","国有绝对控股"]
[null,null,"HOLDING_TYPE","A02","集体控股"]
[null,null,"HOLDING_TYPE","A0202","集体绝对控股"]
[null,null,"HOLDING_TYPE","B","非公有控股经济"]
[null,null,"HOLDING_TYPE","B01","私人控股"]
[null,null,"HOLDING_TYPE","B0101","私人相对控股"]
[null,null,"HOLDING_TYPE","B0102","私人绝对控股"]
[null,null,"HOLDING_TYPE","B02","港澳台控股"]
[null,null,"HOLDING_TYPE","B0201","港澳台相对控股"]
[null,null,"HOLDING_TYPE","B0202","港澳台绝对控股"]
[null,null,"HOLDING_TYPE","B03","外商控股"]
[null,null,"HOLDING_TYPE","B0301","外商相对控股"]
[null,null,"HOLDING_TYPE","B0302","外商绝对控股"]
[null,null,"HOLDING_TYPE","A0201","集体相对控股"]
[]
[null,"客户主体类型","CUSTOMER_PRIN_TYPE","01","我国中央政府"]
[null,null,"CUSTOMER_PRIN_TYPE","02","境外主权国家或经济实体区域政府"]
[null,null,"CUSTOMER_PRIN_TYPE","03","中国人民银行"]
[null,null,"CUSTOMER_PRIN_TYPE","04","境外中央银行"]
[null,null,"CUSTOMER_PRIN_TYPE","05","我国公共部门实体"]
[null,null,"CUSTOMER_PRIN_TYPE","06","境外公共部门实体"]
[null,null,"CUSTOMER_PRIN_TYPE","07","多边开发银行"]
[null,null,"CUSTOMER_PRIN_TYPE","08","国际清算银行"]
[null,null,"CUSTOMER_PRIN_TYPE","09","国际货币基金组织"]
[null,null,"CUSTOMER_PRIN_TYPE","10","境外商业银行"]
[null,null,"CUSTOMER_PRIN_TYPE","11","我国政策性银行"]
[null,null,"CUSTOMER_PRIN_TYPE","12","我国商业银行"]
[null,null,"CUSTOMER_PRIN_TYPE","13","我国其他银行类金融机构"]
[null,null,"CUSTOMER_PRIN_TYPE","14","我国其他非银行金融机构"]
[null,null,"CUSTOMER_PRIN_TYPE","15","其他法人企业"]
[null,null,"CUSTOMER_PRIN_TYPE","16","其他非法人企业"]
[null,null,"CUSTOMER_PRIN_TYPE","17","个人(自然人)"]

{"sheet":"债券基本资料表","index":3,"n_rows":141,"n_cols":11,"rows_kept":141,"merged":[[0,0,0,5],[1,0,1,2],[1,4,2,4],[1,5,2,5],[2,0,2,2],[63,6,70,6],[98,6,104,6],[98,7,104,7],[99,1,106,1],[99,2,106,2],[105,6,106,6],[105,7,106,7],[107,1,108,1],[107,2,108,2],[107,6,108,6],[107,7,108,7],[109,1,111,1],[109,2,111,2],[109,6,110,6],[109,7,110,7],[111,6,112,6],[111,7,112,7],[112,1,115,1],[112,2,115,2],[116,6,118,6],[116,7,118,7]],"flags":["formulas_cached_only"]}
["债券基本资料表"]
["INTERF_PAYHSRCSECINFO",{"$nulls":3},"是否必填","说明"]
["债券基本资料表",null,null,"数据字典值"]
["SECID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"是","KEY"]
["SECNAME","VARCHAR2(200)","债券简称",null,"是"]
["SECCODE","VARCHAR2(50)","债券code",null,"是"]
["MARKET","CHAR(2)","市场 ","参考参数：TRADE_PLACE\n09 OTC场外\n01 银行间\n03 上海证券交易所\n04 深圳证券交易所\n05 机构间私募系统","是"]
["SECFULLNAME","VARCHAR2(200)","债券全称",null,"是"]
["RATEBASIC","VARCHAR2(10)","计息基准：参考右边明细","参考参数：BASIS\n A/365 A/365\n A/360 A/360\n A/A_B_COUP A/A(平均分配)\n A/A_B_DAY A/A(按实际天数分配)\n A/365F A/365F\n 30/360 30/360\n","是"]
["COUPONSPECIES","CHAR(3)","息票品种","参考参数：COUPON_SPECIES\n01 附息\n 02 贴现\n 03 零息\n 04 利随本清","是"]
["INTERESTRATE","CHAR(2)","利率类型 ","参考参数：INT_TYPE\n 01 固定利率\n 02 浮动利率","是"]
["VDATE","DATE","起息日",null,"是"]
["MDATE","DATE","到期日",null,"是"]
["payCycle","VARCHAR(50)","付息频率","03 月付\n04 季付\n05 年付\n06 半年付\n07 到期一次\n","是"]
["FACEVALUE","NUMBER(20,4)","面额 默认100",null,"是"]
["ISSUEPRICE","NUMBER(20,4)","发行价",null,"是"]
["PAPERIR","NUMBER(18,12)","票面利率",null,"否"]
["SCHECALRULE","CHAR(2)","付息区间推算方法 VF起息日向后，MB到期日向前，FD首次付息日","参考参数：CALC_RULE\n 01 起息日向后\n 02 到期日向前\n 03 首次支付日","是"]
["FIRSTRATEDAY","DATE","首次付息日",null,"否","当为首次付息日时必填"]
["WORKDAYRULE","CHAR","营业日准则","参考参数：TDAY_RULE\n 01 向前调整\n 02 向后调整\n 03 调整的向后调整\n 04 不调整","是"]
["ISSUERSHORT","VARCHAR(50)","发行人",null,"是","机构信息表的 ID\n发行人相关信息在机构表"]
["RESETTYPE","VARCHAR(50)","利率调整规则","参考参数：RESET_TYPE\n 01 基准利率变动后固定间隔生效\n 02 付息后下一计息期生效","否"]
["OBSERVEBEFDAY","NUMBER(10)","延后时间",null,"否"]
["OBSERVEBEFUNIT","VARCHAR(50)","延后时间单位",null,"否"]
["TOPRATE","NUMBER(20,14)","利率上限",null,"否"]
["BOTTOMRATE","NUMBER(20,14)","利率下限",null,"否"]
["ISSUEAMT","NUMBER(20,4)","发行总额",null,"是"]
["RATECODE","VARCHAR2(50)","浮动利率code",null,"否","浮动利率时必填"]
["SPREADRATE_8","NUMBER(20,14)","浮动利差",null,"否","浮动利率时必填"]
["COEFFICIENT","NUMBER(18,12)","浮动系数",null,"否","浮动利率时必填"]
["SECTYPE","VARCHAR2(50)","系统债券类型：","数据字典：SECTYPE1枚举值见下","是","一级分类"]
["SECTYPE2","VARCHAR2(50)","系统债券类型：","数据字典：SECTYPE1枚举值见下","是","二级分类"]
["CHBSECTYPE","VARCHAR2(50)","中债债券类型：",null,"是","一级分类"]
["CHBSECTYPE2","VARCHAR2(50)","中债债券类型：",null,"否","二级分类"]
["PBOCSECTYPE","VARCHAR2(50)","人行债券类型：","数据字典：BONDTYPEONE枚举值见下","否","一级分类"]
["PBOCSECTYPE2","VARCHAR2(50)","人行债券类型：","数据字典：BONDTYPETWO枚举值见下","否","二级分类"]
["REMARK","NVARCHAR2(255)","备注",null,"否"]
["isSecBond","VARCHAR(50)","是否次级债,Y是N否","Y：是\nN:否","是"]
["isSus","VARCHAR(50)","是否永续债,Y是N否","Y：是\nN:否","是"]
["CALLOPTION","VARCHAR(50)","是否可赎回,Y是N否","Y：是\nN:否","是"]
["PUTOPTION","VARCHAR(50)","是否可回售,Y是N否","Y：是\nN:否","是"]
["INSTITUTION","VARCHAR2(50)","登记托管机构","数据字典：INSTITUTION","是"]
["INSTITUTIONTEXT","NVARCHAR2(400)","登记托管机构说明",null,"否"]
["MARKETTEXT","NVARCHAR2(400)","交易场所说明",null,"否"]
["MARKET2","CHAR(2)","交易流通场所：01 银行间市场、02 商业银行柜台市场、03 上海交易所、04 深圳交易所、99 其它","参考参数：TRADE_MARKET 枚举值见下","是"]
["CCY","CHAR(3)","币种\nCNY 人民币、HKD 港币、JPY 日元、USD 美元","数据字典：CCY 枚举值见下","是"]
["issueType","VARCHAR(50)","发行方式","参考参数：ISSUE_TYPE\n 01 公开发行\n 02 非公开发行","是"]
["blnArea","VARCHAR(50)","境内外","参考参数：BLN_AREA\n 01 境内\n 02 境外","是"]
["guarantor","VARCHAR(400)","担保人",null,"是"]
["guartype","VARCHAR(100)","担保方式",null,"是"]
["pubenddate","DATE","发行截止日",null,"是"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是",null,"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是",null,"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是",null,"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是",null,"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"是","KEY","数据源系统缩写"]
["CITY_INVEST_SEC_CHB","VARCHAR2(50)","是否城投债（中债）","Y：是\nN:否","是",null,"2019.08.13新增"]
["CITY_INVEST_SEC_PROVINCES","VARCHAR2(50)","城投债省及省会（单列市）",null,"否",null,"2019.08.13新增"]
["CITY_INVEST_SEC_CITIES","VARCHAR2(50)","城投债地级市",null,"否",null,"2019.08.13新增"]
["CITY_INVEST_SEC_COUNTY","VARCHAR2(50)","城投债县及县级市",null,"否",null,"2019.08.13新增"]
["CITY_INVEST_SEC_WIND","VARCHAR2(50)","是否城投债（WIND）","Y：是\nN:否","是",null,"2019.08.13新增"]
["CITY_INVEST_SEC_CBRC","VARCHAR2(50)","是否城投债（银监）",null,"否",null,"2019.08.13新增"]
["ASSET_CLASS","VARCHAR2(50)","资产/负债类别","中债报送信息","是",null,"2019.09.26新增，用于中债报送"]
["CONCRETE_CLASS","VARCHAR2(50)","具体类别","中债报送信息","否"]
["CONCRETE_CLASS_SM","VARCHAR2(50)","具体类别说明","中债报送信息","否"]
["ISSUER_SCALE_TYPE","VARCHAR2(50)","发行机构类型（按规模划分）","中债报送信息","是"]
["ISSUER_TECHNOLOGY_TYPE","VARCHAR2(50)","发行机构类型（按技术领域划分）","中债报送信息","是"]
["ISSUER_ECONOMIC_TYPE","VARCHAR2(50)","发行机构类型（按经济领域划分）","中债报送信息","是"]
["ISSUER_DESC","VARCHAR2(50)","发行机构类型说明","中债报送信息","否"]
["ISSUER_INSTITUTIONS","VARCHAR2(50)","*发行机构所属行业","中债报送信息","是"]
[]
[]
[null,"TRADE_MARKET","01","银行间债券市场","中债一级类别","1101 国债"]
[null,"TRADE_MARKET","02","商业银行柜台市场",null,"1110 地方政府债"]
[null,"TRADE_MARKET","03","上海证券交易所",null,"1109 央票"]
[null,"TRADE_MARKET","04","深圳证券交易所",null,"1102 政策性金融债"]
[null,"TRADE_MARKET","05","全国中小企业股份转让系统",null,"1111 政府支持机构债券"]
[null,"TRADE_MARKET","06","上海期货交易所",null,"1112 商业性金融债"]
[null,"TRADE_MARKET","07","郑州商品交易所",null,"1113 企业债券"]
[null,"TRADE_MARKET","08","大连商品交易所",null,"1114 公司债券"]
[null,"TRADE_MARKET","09","中国金融期货交易所",null,"1115 企业债务融资工具"]
[null,"TRADE_MARKET",10,"上海黄金交易所",null,"1116 资产支持证券"]
[null,"TRADE_MARKET",11,"区域性产权/资产交易市场",null,"1117 外国债券"]
[null,"TRADE_MARKET",12,"区域性商品交易所",null,"2501 本行发行的同业存单"]
[null,"TRADE_MARKET",13,"区域性贵金属交易所",null,"2502 他行发行的同业存单"]
[null,"TRADE_MARKET",14,"艺术品市场"]
[null,"TRADE_MARKET",15,"基金市场"]
[null,"TRADE_MARKET",16,"信托市场"]
[null,"TRADE_MARKET",17,"全国银行间同业拆借市场"]
[null,"TRADE_MARKET",18,"上海票据交易所"]
[null,"TRADE_MARKET",99,"其他交易流通场所"]
[]
[null,"BONDTYPEONE",null,"BONDTYPETWO",null,null,"SECTYPE1",null,"SECTYPE2",null,"对应的BONDTYPE2"]
[null,"B01","国债","01","国债",null,"B01","国债",null,null,"01"]
[null,"B02","地方政府债","02","地方政府债",null,"B02","地方政府债",null,null,"02"]
[null,"B03","央行票据","03","央行票据",null,"B03","央行票据",null,null,"03"]
[null,"B04","政策性金融债","04","政策性金融债",null,"B04","同业存单",null,null,24]
[null,"B05","政府支持机构债","05","政府支持机构债",null,"B05","金融债","01","政策银行债","04"]
[null,"B06","商业性金融债","06","金融债",{"$nulls":3},"02","商业银行债","06"]
[{"$nulls":3},"07","银行次级金融债",{"$nulls":3},"03","商业银行次级债券","07"]
[{"$nulls":3},"08","银行微小金融债",{"$nulls":3},"04","保险公司债","12"]
[{"$nulls":3},"09","非银行金融机构债",{"$nulls":3},"05","证券公司债","06"]
[{"$nulls":3},"10","次级债务",{"$nulls":3},"06","证券公司短期融资券","06"]
[{"$nulls":3},"11","证券公司次级债",{"$nulls":3},"07","其它金融机构债","06"]
[{"$nulls":3},"12","保险公司资本补充债",null,"B06","企业债","08","一般企业债",14]
[{"$nulls":3},"13","绿色金融债",{"$nulls":3},"09","集合企业债",14]
[null,"B07","企业债券",14,"企业债",null,"B07","公司债",10,"一般公司债",16]
[{"$nulls":3},15,"中小企业私募债券",{"$nulls":3},11,"私募债",16]
[null,"B08","公司债券",16,"公司债",null,"B08","中期票据",12,"一般中期票据",19]
[{"$nulls":3},17,"可转债",{"$nulls":3},13,"集合票据",19]
[{"$nulls":3},18,"可交换债",null,"B09","短期融资券",14,"超短期融资债券",21]
[null,"B09","企业债务融资工具",19,"中期票据",{"$nulls":3},15,"一般短期融资券",20]
[{"$nulls":3},20,"短期融资券",null,"B10","定向工具",null,null,22]
[{"$nulls":3},21,"超短期融资券",null,"B11","国际机构债",null,null,99]
[{"$nulls":3},22,"非公开定向债务融资工具",null,"B12","政府支持机构债",null,null,"05"]
[null,"B10","资产支持证券",23,"资产支持证券",null,"B13","资产支持证券",16,"证监会主管ABS",23]
[null,"B11","同业存单",24,"同业存单",{"$nulls":3},17,"银监会主管ABS",23]
[null,"B12","优先股",25,"优先股",{"$nulls":3},18,"交易商协会ABN",23]
[null,"B13","理财直接融资工具",26,"理财直接融资工具",null,"B14","可转债",null,null,17]
[null,"B99","其他",99,"其他",null,"B15","可交换债",null,null,18]
[{"$nulls":6},"B16","可分离转债存债",null,null,99]
[{"$nulls":6},"B17","优先股",null,null,25]
[{"$nulls":9},"大额存单",99]
[{"$nulls":9},"项目收益票据",99]
[]
[null,"CCY","CNY","人民币（CNY）","INSTITUTION","01","中国国债登记结算有限责任公司"]
[null,"CCY","HKD","港元（HKD）",null,"02","上海清算所"]
[null,"CCY","USD","美元（USD）",null,"03","中国证券登记结算有限公司"]
[null,"CCY","EUR","欧元（EUR）",null,"99","其他"]
[null,"CCY","JPY","日元（JPY）"]
[null,"CCY","MOP","澳门元（MOP）"]
[null,"CCY","CHF","瑞士法郎（CHF）"]
[null,"CCY","GBP","英镑（GBP）"]
[null,"CCY","RUB","俄罗斯卢布（RUB）"]
[null,"CCY","CAD","加拿大元（CAD）"]
[null,"CCY","DKK","丹麦克朗（DKK）"]
[null,"CCY","AUD","澳大利亚元（AUD）"]
[null,"CCY","SEK","瑞典克朗（SEK）"]
[null,"CCY","SGD","新加坡元（SGD）"]
[null,"CCY","TWD","新台币（TWD）"]

{"sheet":"付息计划表","index":4,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["付息计划表",{"$nulls":5},"外部数据源"]
["INTERF_PAYHSRCSECSCHEDULE",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["付息计划表",null,null,"数据字典"]
["SECID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"是","KEY"]
["SCHEDUTYPE","VARCHAR(50)","现金流类型\n","参考参数：CASH_CLASS_TYPE \n01 中间收息\n 02 中间还本\n 03 到期还本\n 05 费用支付\n 04 到期收息","是","KEY\n同一天既还本又付息，存2条\n在同一天是两条数据，不在同一天各自保"]
["TOTALINTERESTSTARTDAY","DATE","理论付息起始日",null,"是"]
["TOTALINTERESTENDDAY","DATE","理论付息结束日",null,"是"]
["INTERESTSTARTDAY","DATE","实际付息起始日",null,"是","KEY"]
["INTERESTENDDAY","DATE","实际付息结束日",null,"是","KEY"]
["INTERESTPAYDAY","DATE","理论支付日",null,"是"]
["COUPONRATE","NUMBER(20,14)","当期利率",null,"否"]
["ACCRUEINTAMT","NUMBER(18,12)","应计利息和",null,"是"]
["DAILYACCRUEINT","NUMBER(18,12)","日应计利息",null,"是"]
["PRINAMTPAY","NUMBER(18,12)","支付本金",null,"是"]
["CASHPAY","NUMBER(18,12)","支付现金流，即支付的本金加利息",null,"是"]
["PRINAMT","NUMBER(18,12)","计息本金",null,"是"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"是","KEY",{"$nulls":4},"数据源系统缩写"]

{"sheet":"债券行权信息表","index":5,"n_rows":17,"n_cols":13,"rows_kept":17,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["债券行权信息表",{"$nulls":5},"外部数据源"]
["INTERF_PAYHSRCSECOPTION",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["债券行权信息表"]
["SECID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"是","key"]
["OPTIONSTARTDAY","DATE","行权申请起始日",null,"是"]
["OPTIONENDDAY","DATE","行权申请结束日",null,"是"]
["THEORYOPTIONPAYDAY","DATE","理论行权日",null,"是"]
["OPTIONPAYDAY","DATE","实际行权日",null,"是","key",{"$nulls":5},"EXERCISE_DATE","计划行权日"]
["OPTIONPRICE","NUMBER(18,12)","行权价(净价)",null,"是"]
["OPTIONTYPE","VARCHAR2(10)","行权类型，CALL赎回,PUT回售,对应参数表的OPTIONTYPE","参考参数：EXEC_MODE\n 01 赎回\n 02 回售\n其他-枚举值待咨询方提供","是","key"]
["OPTIONCLAUSE","VARCHAR2(400)","行权条款",null,"否"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是"]
["SOURCE","VARCHAR(50)","数据来源",null,"是","key"]

{"sheet":"债券评级信息表","index":6,"n_rows":101,"n_cols":11,"rows_kept":101,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["债券评级信息表",{"$nulls":5},"外部数据源"]
["INTERF_PAYHSRCSECRATING",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["债券评级信息表"]
["SECID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"是","key"]
["RATINGORG","NVARCHAR2(50)","评级机构","参考参数：GRADE_PARTY\n枚举值见下","是","key数据字典"]
["RATINGTYPE","VARCHAR2(50)","评级类型\nC：主体评级\nI：债项评级","参考参数：MAIN_GRADE_TYPE  \n01：主体评级\n02：债项评级\n03担保人评级","是","key\n2019.8.20号修改"]
["RATINGSUBTYPE","VARCHAR2(50)","长期短期\n S（短期）\n L（长期）","参考参数：LONG_SHORT_TERM\n 01 长期\n 02 短期\n 03 市场隐含评级\n 04 财务顾问分类评级\n 05 期货公司分类评级 \n 06 证券公司分类评级 ","是","key\n2019.8.20号修改"]
["RATING","VARCHAR2(50)","评级结果\n长期评级结果选择：\nAAA\nAA+\nAA\nAA-\nA+\nA\nA-\nBBB+\nBBB\nBBB-\nBB+\nBB\nBB-\nB+\nB\nB-\nCCC+\nCCC\nCCC-\nCC\nC\n短期评级结果选择：\nA-1\nA-2\nA-3\nB\nC\nR","参考参数：GRADE_RESULT","是"]
["IS_RECOMMAND","VARCHAR2(50)","是否推荐","01 是\n02 否","否","如果当天同一债券有不同评级机构的评级，则其中有一条为是"]
["RATING_PROSPECTS","VARCHAR2(50)","评级展望","枚举值：\n正面、负面、稳定、观望、待决",null,"2019.8.20号新增"]
["CHANGE_DIRECTION","VARCHAR2(50)","变动方向","枚举值：\n调高、调低、维持、首次",null,"2019.8.20号新增"]
["ANNOUNCEMENT_DATE","DATE","公告日期",null,null,"2019.8.20号新增"]
["PUBDATE","DATE","评级日期",null,"是","key\n2019.8.20号更名"]
["CREATE_USER","VARCHAR(20)","创建人",null,"是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门",null,"否"]
["CREATE_TIME","TIMESTAMP","创建时间",null,"是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",null,"是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",null,"是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"是","key",{"$nulls":4},"数据源系统缩写"]
[]
[]
[null,null,"GRADE_PARTY","01","标准普尔评级服务公司",null,"r"]
[null,null,"GRADE_PARTY","02","中诚信国际信用评级有限责任公司"]
[null,null,"GRADE_PARTY","03","远东资信评估有限公司"]
[null,null,"GRADE_PARTY","04","上海新世纪资信评估投资服务有限公司"]
[null,null,"GRADE_PARTY","05","联合资信评估有限公司"]
[null,null,"GRADE_PARTY","06","大公国际资信评估有限公司"]
[null,null,"GRADE_PARTY","07","联合信用评级有限公司"]
[null,null,"GRADE_PARTY","08","辽宁省资信评估有限公司"]
[null,null,"GRADE_PARTY","09","长城资信评估有限公司"]
[null,null,"GRADE_PARTY","10","云南省资信评估事务所"]
[null,null,"GRADE_PARTY","11","北京穆迪投资者服务有限公司"]
[null,null,"GRADE_PARTY","12","福建省资信评级委员会"]
[null,null,"GRADE_PARTY","13","中诚信证券评估有限公司"]
[null,null,"GRADE_PARTY","14","中证鹏元资信评估股份有限公司"]
[null,null,"GRADE_PARTY","15","穆迪投资者服务有限公司 "]
[null,null,"GRADE_PARTY","16","惠誉国际信用评级有限公司"]
[null,null,"GRADE_PARTY","17","中国诚信信用管理股份有限公司"]
[null,null,"GRADE_PARTY","18","中国证券监督管理委员会"]
[null,null,"GRADE_PARTY","19","东方金诚国际信用评估有限公司"]
[null,null,"GRADE_PARTY","20","中国证券业协会"]
[null,null,"GRADE_PARTY","21","北京资信评级有限公司"]
[null,null,"GRADE_PARTY","22","中债资信评估有限责任公司",null,"r"]
[null,null,"GRADE_PARTY","23","天津海泰信用服务有限公司"]
[null,null,"GRADE_PARTY","24","中华信用评等公司"]
[null,null,"GRADE_PARTY","25","联合信用管理有限公司"]
[null,null,"GRADE_PARTY","26","南京中贝国际信用管理咨询有限公司"]
[null,null,"GRADE_PARTY","27","穆迪投资者服务香港有限公司"]
[null,null,"GRADE_PARTY","28","标准普尔香港有限公司"]
[null,null,"GRADE_PARTY","29","上海资信有限公司"]
[null,null,"GRADE_PARTY","30","株式会社日本格付研究所"]
[null,null,"GRADE_PARTY","31","江苏安博尔信用评估有限公司"]
[null,null,"GRADE_PARTY","32","其他"]
{"$rows_empty":17}
[null,null,"GRADE_RESULT","01","AAA+"]
[null,null,"GRADE_RESULT","02","AAA"]
[null,null,"GRADE_RESULT","03","AAA-"]
[null,null,"GRADE_RESULT","04","AA+"]
[null,null,"GRADE_RESULT","05","AA"]
[null,null,"GRADE_RESULT","06","AA-"]
[null,null,"GRADE_RESULT","07","A+"]
[null,null,"GRADE_RESULT","08","A"]
[null,null,"GRADE_RESULT","09","A-"]
[null,null,"GRADE_RESULT",10,"A-1"]
[null,null,"GRADE_RESULT",11,"A-2"]
[null,null,"GRADE_RESULT",12,"A-3"]
[null,null,"GRADE_RESULT",13,"BBB+"]
[null,null,"GRADE_RESULT",14,"BBB"]
[null,null,"GRADE_RESULT",15,"BBB-"]
[null,null,"GRADE_RESULT",16,"BB+"]
[null,null,"GRADE_RESULT",17,"BB"]
[null,null,"GRADE_RESULT",18,"BB-"]
[null,null,"GRADE_RESULT",19,"B+"]
[null,null,"GRADE_RESULT",20,"B"]
[null,null,"GRADE_RESULT",21,"B-"]
[null,null,"GRADE_RESULT",22,"CCC+"]
[null,null,"GRADE_RESULT",23,"CCC"]
[null,null,"GRADE_RESULT",24,"CCC-"]
[null,null,"GRADE_RESULT",25,"CC+"]
[null,null,"GRADE_RESULT",26,"CC"]
[null,null,"GRADE_RESULT",27,"CC-"]
[null,null,"GRADE_RESULT",28,"C+"]
[null,null,"GRADE_RESULT",29,"C"]
[null,null,"GRADE_RESULT",30,"C-"]
[null,null,"GRADE_RESULT",31,"D"]

{"sheet":"债券估值行情表","index":7,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[2,0,2,2]],"flags":["formulas_cached_only"]}
["债券估值表",{"$nulls":4},"外部数据源"]
["INTERF_PAYHSRCCBVLT",null,null,"是否必填","说明","字段","长度","表名","转换规则"]
["债券市价估值表"]
["SECID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ","是","key"]
["CDATE","VARCHAR2(10)","估值日","是","key"]
["ENCASH_YEARS","NUMBER(18,12)","剩余期限","是"]
["MDPRICE","NUMBER(18,12)","市价全价","是"]
["MCPRICE","NUMBER(18,12)","市价净价","是"]
["M_MDURATION","NUMBER(18,12)","市价修正久期","是"]
["M_CNVXTY","NUMBER(18,12)","市价凸性","是"]
["MBASISVALUE","NUMBER(18,12)","市价基点价值（PVBP）","是"]
["BASISVALUE","NUMBER(18,12)","基点价值（PVBP）","是"]
["MSPRD_D","NUMBER(18,12)","利差久期","是"]
["MSPRD_CNVXTY","NUMBER(18,12)","利差凸性","是"]
["MYIELD_D","NUMBER(18,12)","利率久期","是"]
["MYIELD_CNVXTY","NUMBER(18,12)","利率凸性","是"]
["MYIELD","NUMBER(18,14)","市价收益率","是"]
["VAR","NUMBER(24,8)","风险价值","是"]
["CVAR","NUMBER(24,8)","条件风险价值","是"]
["VALUE_SOURCE","VARCHAR(50)","估值来源","是","key\n中债CBC、中证CSD",{"$nulls":4},"数据源系统缩写"]
["CREATE_USER","VARCHAR(20)","创建人","是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门","否"]
["CREATE_TIME","TIMESTAMP","创建时间","是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人","是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间","是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源","是","key",{"$nulls":4},"数据源系统缩写"]

{"sheet":"债券市场行情","index":8,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[2,0,2,2]],"flags":["formulas_cached_only"]}
["市场行情",{"$nulls":4},"外部数据源"]
["INTERF_BOND_MARKET_INFO",null,null,"是否必填","说明","字段","长度","表名","转换规则"]
["市场行情"]
["SEC_ID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"key"]
["VALUE_DATE","DATE","市值日",null,"key"]
["CLOSE_PRICE","NUMERIC(30, 14)","收盘价（净价）","是",{"$nulls":5},"2019.10.12号修改字段名"]
["AVERAGE_PRICE","NUMERIC(30, 14)","平均价（净价）","否",{"$nulls":5},"2019.10.12号修改字段名"]
["MAX_PRICE","NUMERIC(30, 14)","最高价（净价）","是",{"$nulls":5},"2019.10.12号修改字段名"]
["MIN_PRICE","NUMERIC(30, 14)","最低价（净价）","是",{"$nulls":5},"2019.10.12号修改字段名"]
["BUY_ONE_PRICE","NUMERIC(30, 14)","买一价（净价）","否",{"$nulls":5},"2019.10.12号修改字段名"]
["SELL_ONE_PRICE","NUMERIC(30, 14)","卖一价（净价）","否",{"$nulls":5},"2019.10.12号修改字段名"]
["CLOSE_PRICE_FULL","NUMERIC(30, 14)","收盘价（全价）","是",{"$nulls":5},"2019.10.12号新增字段"]
["AVERAGE_PRICE_FULL","NUMERIC(30, 14)","平均价（全价）","否",{"$nulls":5},"2019.10.12号新增字段"]
["MAX_PRICE_FULL","NUMERIC(30, 14)","最高价（全价）","是",{"$nulls":5},"2019.10.12号新增字段"]
["MIN_PRICE_FULL","NUMERIC(30, 14)","最低价（全价）","是",{"$nulls":5},"2019.10.12号新增字段"]
["BUY_ONE_PRICE_FULL","NUMERIC(30, 14)","买一价（全价）","否",{"$nulls":5},"2019.10.12号新增字段"]
["SELL_ONE_PRICE_FULL","NUMERIC(30, 14)","卖一价（全价）","否",{"$nulls":5},"2019.10.12号新增字段"]
["CREATE_USER","VARCHAR(20)","创建人","是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门","否"]
["CREATE_TIME","TIMESTAMP","创建时间","是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人","是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间","是",{"$nulls":5},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源","是","key",{"$nulls":4},"数据源系统缩写"]

{"sheet":"浮息债报价表","index":9,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[2,0,2,2]],"flags":["formulas_cached_only"]}
["浮息债报价表",{"$nulls":4},"外部数据源"]
["INTERF_FLOATCOUPRATE",null,null,"是否必填","说明","字段","长度","表名","转换规则"]
["市场行情"]
["SEC_ID","VARCHAR2(50)","债券ID：xxxx.IB/xxxx.SZ",null,"key"]
["CHANGE_DT","DATE","变动日期",null,"key"]
["RATE","NUMERIC(30, 14)","利率(%)"]
["CREATE_USER","VARCHAR(20)","创建人",{"$nulls":6},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门"]
["CREATE_TIME","TIMESTAMP","创建时间",{"$nulls":6},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",{"$nulls":6},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",{"$nulls":6},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"key",{"$nulls":4},"数据源系统缩写"]

{"sheet":"中国共同基金基本资料","index":10,"n_rows":210,"n_cols":10,"rows_kept":210,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["中国共同基金基本资料",{"$nulls":5},"外部数据源"]
["INTERF_CMFUNDDESCRIP",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["中国共同基金基本资料",null,null,"数据字典"]
["F_INFO_CODE","VARCHAR2(40)","基金代码",null,"是 ","KEY"]
["F_INFO_FRONT_CODE","VARCHAR2(40)","前端代码",null,"否"]
["F_INFO_BACKEND_CODE","VARCHAR2(40)","后端代码",null,"否"]
["F_INFO_FULLNAME","VARCHAR2(100)","名称",null,"是"]
["F_INFO_NAME","VARCHAR2(100)","简称",null,"是"]
["F_INFO_TYPE","VARCHAR2(50)","基金类型","参考参数：FUND_ASSET_TYPE \nF01 货币基金\n F02 非货币基金","是","数据字典F01货币基金、F02非货币基金"]
["F_INFO_TYPE2","VARCHAR2(50)","基金类型2","参考参数：FUND_ASSET_SECOND_TYPE\n 01 债券基金\n 02 货币市场基金\n 03 股票基金\n 04 混合基金\n 06 其他公募基金\n","是","二级类型数据字典"]
["F_PROFIT_TYPE","VARCHAR2(50)","收益类型","01 净值型\n03 货币型","是"]
["F_INFO_FIRSTINVESTTYPE","VARCHAR2(40)","投资类型",null,"否"]
["F_INFO_ISSUEDATE","VARCHAR2(8)","发行日期",null,"是"]
["F_ISSUE_OEF_STARTDATEINST","VARCHAR2(8)","认购起始日",null,"是"]
["F_ISSUE_OEF_DNDDATEINST","VARCHAR2(8)","认购终止日",null,"是"]
["F_INFO_SETUPDATE","VARCHAR2(8)","成立日期",null,"是"]
["F_INFO_MATURITYDATE","VARCHAR2(8)","到期日期",null,"否"]
["JYSJJLX","VARCHAR2(50)","交易所基金类型","参数参数：\nETF、LOF、分级基金、封闭式基金","否"]
["JYSJJJC","VARCHAR2(50)","交易所基金简称",null,"否"]
["SGSHDM","VARCHAR2(50)","申购赎回代码","当交易所基金类型为ETF时必填","否"]
["SGSHJC","VARCHAR2(50)","申购赎回简称","当交易所基金类型为ETF时必填","否"]
["DBSGJEXX","NUMBER(20,4)","单笔申购金额下限",null,"否"]
["DBSHJEXX","NUMBER(20,4)","单笔赎回份额下限",null,"否"]
["ZXSGSHDW","VARCHAR2(50)","ETF最小申购赎回单位","交易所基金类型为ETF时必填","否"]
["ETFLX","VARCHAR2(50)","ETF类型","交易所基金类型为ETF时必填；\n参考参数;\n单市场ETF/跨市场ETF/跨境ETF/债券ETF/黄金ETF","否"]
["F_ISSUE_TOTALUNIT","NUMBER(20,4)","发行份额",null,"否"]
["F_INFO_MANAGEMENTFEERATIO","NUMBER(20,4)","管理费",null,"否"]
["F_INFO_CUSTODIANFEERATIO","NUMBER(20,4)","托管费",null,"否"]
["CCY","VARCHAR2(10)","币种","参考参数：CCY","是"]
["F_INFO_BENCHMARK","VARCHAR2(500)","业绩比较基准",null,"否"]
["F_INFO_EXCHMARKET","VARCHAR2(10)","交易所","参考参数：TRADE_PLACE\n 01 银行间\n 03 上海证券交易所\n 04 深圳证券交易所\n 05 机构间私募系统\n 09 OTC场外","是"]
["F_INFO_CORP_FUNDMANAGEMENTID","VARCHAR2(10)","基金管理人ID",null,"是"]
["F_INFO_CUSTODIANBANKID","VARCHAR2(40)","托管人id",null,"否"]
["PconfirmSpeed","VARCHAR2(50)","买入确认日",null,"是","t+0/t+1","界面展示的是买入的确认清算速度"]
["SconfirmSpeed","VARCHAR2(50)","卖出确认日",null,"是","t+0/t+1"]
["repIsGovInvest","VARCHAR2(10)","是否属于政府投资基金","01 是\n02 否"]
["repGovInvestFor","VARCHAR2(50)","政府投资基金投向","参考参数：CHB_INVEST_FUND_TURN\n 01 投向创业早期企业\n 02 投向中小微企业\n 03 投向产业转型升级和发展\n 04 投向基础设施和公共服务领域\n 99 其他"]
["repIndustry1","VARCHAR2(50)","行业1","参考参数：INSTITUTION_INDUSTRY_FIRST_LEVEL\n具体枚举值见下",null,"该基金投资行业一级类型"]
["repIndustry2","VARCHAR2(50)","行业2","参考参数INSTITUTION_INDUSTRY_SECOND_LEVEL\n具体枚举值见下",null,"该基金投资行业二级类型"]
["repRegistOrg","VARCHAR2(50)","登记备案机构","参考参数：REGIST_ORG_REC \n 01 中央国债登记结算有限责任公司\n 02 上海清算所\n 03 中国证券登记结算有限责任公司\n 04 中国证券投资基金业协会\n 99 其他",null,"数据字典"]
["repFundInvestAsset","VARCHAR2(500)","基金投资资产"]
["repTrustPartyName","VARCHAR2(500)","基金托管机构名称"]
["MARKET2","CHAR(2)","交易流通场所：01 银行间市场、02 商业银行柜台市场、03 上海交易所、04 深圳交易所、99 其它","参考参数：TRADE_MARKET  \n见表下","是"]
["payType","VARCHAR(50)","分红方式：红利再投","参考参数：BONUS_MODE \n01 现金分红\n 02 红利再投","是","货币基金传，非货币基金不用"]
["payCycle","VARCHAR(50)","分红频率","参考参数：RETURN_FREQUENCY\n 01 按日结转\n 02 按月结转","是","数据字典：按月/按日"]
["dayValue","NUMBER(2)","分红日",null,"是","按日为空，按月填写月的第几天。"]
["IS_COMPOUND_INT","VARCHAR(50)","是否日复利","Y 是\nN 否","是"]
["ISSUER_SCALE_TYPE"," VARCHAR2(50)","投资企业类型（按规模划分）",null,"否","2019.9.26号增加，中债报送用"]
["ISSUER_TECHNOLOGY_TYPE"," VARCHAR2(50)","投资企业类型（按技术领域划分）",null,"否","2019.9.26号增加，中债报送用"]
["ISSUER_ECONOMIC_TYPE"," VARCHAR2(50)","投资企业类型（按经济类型划分）",null,"否","2019.9.26号增加，中债报送用"]
["FUND_COMPANY_NAME"," VARCHAR2(100)","基金公司名称",null,"否","2019.9.26号增加，中债报送用"]
["INVESTMENT_PHASE"," VARCHAR2(50)","投资阶段",null,"否","2019.9.26号增加，中债报送用"]
["CREATE_USER","VARCHAR(20)","创建人"]
["CREATE_DEPT","VARCHAR(32)","创建部门"]
["CREATE_TIME","TIMESTAMP","创建时间"]
["UPDATE_USER","VARCHAR(20)","更新人"]
["UPDATE_TIME","TIMESTAMP","更新时间"]
["SOURCE","VARCHAR(50)","数据来源",null,null,"key"]
[]
["币种","CCY","CNY","人民币（CNY）"]
[null,"CCY","HKD","港元（HKD）"]
[null,"CCY","USD","美元（USD）"]
[null,"CCY","EUR","欧元（EUR）"]
[null,"CCY","JPY","日元（JPY）"]
[null,"CCY","MOP","澳门元（MOP）"]
[null,"CCY","CHF","瑞士法郎（CHF）"]
[null,"CCY","GBP","英镑（GBP）"]
[null,"CCY","RUB","俄罗斯卢布（RUB）"]
[null,"CCY","CAD","加拿大元（CAD）"]
[null,"CCY","DKK","丹麦克朗（DKK）"]
[null,"CCY","AUD","澳大利亚元（AUD）"]
[null,"CCY","SEK","瑞典克朗（SEK）"]
[null,"CCY","SGD","新加坡元（SGD）"]
[null,"CCY","TWD","新台币（TWD）"]
[]
["交易所","TRADE_MARKET","01","银行间债券市场"]
[null,"TRADE_MARKET","02","商业银行柜台市场"]
[null,"TRADE_MARKET","03","上海证券交易所"]
[null,"TRADE_MARKET","04","深圳证券交易所"]
[null,"TRADE_MARKET","05","全国中小企业股份转让系统"]
[null,"TRADE_MARKET","06","上海期货交易所"]
[null,"TRADE_MARKET","07","郑州商品交易所"]
[null,"TRADE_MARKET","08","大连商品交易所"]
[null,"TRADE_MARKET","09","中国金融期货交易所"]
[null,"TRADE_MARKET",10,"上海黄金交易所"]
[null,"TRADE_MARKET",11,"区域性产权/资产交易市场"]
[null,"TRADE_MARKET",12,"区域性商品交易所"]
[null,"TRADE_MARKET",13,"区域性贵金属交易所"]
[null,"TRADE_MARKET",14,"艺术品市场"]
[null,"TRADE_MARKET",15,"基金市场"]
[null,"TRADE_MARKET",16,"信托市场"]
[null,"TRADE_MARKET",17,"全国银行间同业拆借市场"]
[null,"TRADE_MARKET",18,"上海票据交易所"]
[null,"TRADE_MARKET",99,"其他交易流通场所"]
[]
["行业1","INSTITUTION_INDUSTRY_FIRST_LEVEL","03","制造业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","04","电力、热力、燃气及水生产和供应业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","05","建筑业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","06","批发和零售业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","07","交通运输、仓储和邮政业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","08","住宿和餐饮业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","09","信息传输、软件和信息技术服务业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","10","金融业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","11","房地产"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","12","租赁和商务服务业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","13","科学研究和技术服务业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","14","水利、环境和公共设施管理业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","15","居民服务、修理和其他服务业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","16","教育"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","17","卫生和社会工作"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","18","文化、体育和娱乐业"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","19","公共管理、社会保障和社会组织"]
[null,"INSTITUTION_INDUSTRY_FIRST_LEVEL","20","国际组织"]
[]
["行业2","INSTITUTION_INDUSTRY_SECOND_LEVEL","A01","农业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A02","林业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A03","畜牧业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A04","渔业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","A05","农、林、牧、渔服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B06","煤炭开采和洗选业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B07","石油和天然气开采业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B08","黑色金属矿采选业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B09","有色金属矿采选业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B10","非金属矿采选业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B11","开采辅助活动"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","B12","其他采矿业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C13","农副食品加工业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C14","食品制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C15","酒、饮料和精制茶制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C16","烟草制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C17","纺织业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C18","纺织服装、服饰业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C19","皮革、毛皮、羽毛及其制品和制鞋业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C20","木材加工和木、竹、藤、棕、草制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C21","家具制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C22","造纸及纸制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C23","印刷业和记录媒介的复制业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C24","文教、工美、体育和娱乐用品制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C25","石油加工、炼焦及核燃料加工业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C26","化学原料和化学制品制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C27","医药制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C28","化学纤维制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C29","橡胶和塑料制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C30","非金属矿物制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C31","黑色金属冶炼及压延加工业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C32","有色金属冶炼及压延加工业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C33","金属制品业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C34","通用设备制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C35","专用设备制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C36","汽车制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C37","铁路、船舶、航空航天和其他运输设备制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C38","电气机械和器材制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C39","计算机、通信和其他电子设备制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C40","仪器仪表制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C41","其他制造业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C42","废弃资源综合利用业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","C43","金属制品、机械和设备修理业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D44","电力、热力生产和供应业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D45","煤气生产和供应业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","D46","水的生产和供应业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E47","房屋建筑业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E48","土木工程建筑业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E49","建筑安装业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","E50","建筑装饰和其他建筑业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","F51","批发业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","F52","零售业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G53","铁路运输业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G54","道路运输业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G55","水上运输业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G56","航空运输业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G57","管道运输业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G58","装卸搬运和其他运输服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G59","仓储业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","G60","邮政业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","H61","住宿业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","H62","餐饮业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I63","电信、广播电视和卫星传输服务"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I64","互联网和相关服务"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","I65","软件和信息技术服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J66","货币金融服务"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J67","资本市场服务"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J68","保险业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","J69","其他金融业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","K70","房地产业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","L71","租赁业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","L72","商务服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M73","研究与试验发展"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M74","专业技术服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","M75","科技推广和应用服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N76","水利管理业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N77","生态保护和环境治理业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","N78","公共设施管理业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O79","居民服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O80","机动车、电子产品和日用产品修理业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","O81","其他服务业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","P82","教育"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","Q83","卫生"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","Q84","社会工作"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R85","新闻和出版业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R86","广播、电视、电影和影视录音制作业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R87","文化艺术业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R88","体育"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","R89","娱乐业"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S90","中国共产党机关"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S91","国家机构"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S92","人民政协、民主党派"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S93","社会保障"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S94","群众团体、社会团体和其他成员组织"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","S95","基层群众自治组织"]
[null,"INSTITUTION_INDUSTRY_SECOND_LEVEL","T96","国际组织"]

{"sheet":"中国共同基金净值","index":11,"n_rows":21,"n_cols":10,"rows_kept":21,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[2,0,2,2]],"flags":["formulas_cached_only"]}
["中国共同基金净值",{"$nulls":4},"外部数据源"]
["INTERF_CMFundNAV",null,null,"是否必填","说明","字段","长度","表名","转换规则"]
["中国共同基金净值"]
["F_INFO_CODE","VARCHAR2(40)","基金代码","是","key"]
["ANN_DATE","VARCHAR2(8)","公告日期","是",{"$nulls":5},"公布日期"]
["PRICE_DATE","VARCHAR2(8)","截止日期","是","key"]
["F_NAV_UNIT","NUMBER(20,4)","单位净值/万份收益","是","货币/非货币"]
["F_INFO_YEARLYROE","NUMBER(20,4)","最近七日收益所折算的年资产收益率","是","货币/非货币"]
["YEARLYROE","NUMBER(20,4)","年化收益率","是","货币/非货币"]
["F_NAV_ACCUMULATED","NUMBER(20,4)","累计净值","是","非货币"]
["F_NAV_DIVACCUMULATED","NUMBER(20,4)","累计分红","是","非货币"]
["F_NAV_ADJFACTOR","NUMBER(20,6)","复权因子","否","非货币"]
["CCY","VARCHAR2(10)","币种","否"]
["F_PRT_NETASSET","NUMBER(20,4)","资产净值","是","货币/非货币"]
["F_NAV_ADJUSTED","NUMBER(18,4)","复权单位净值","否","非货币"]
["CREATE_USER","VARCHAR(20)","创建人",{"$nulls":6},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门"]
["CREATE_TIME","TIMESTAMP","创建时间",{"$nulls":6},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",{"$nulls":6},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",{"$nulls":6},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,"key",{"$nulls":4},"数据源系统缩写"]

{"sheet":"利率行情","index":12,"n_rows":175,"n_cols":11,"rows_kept":175,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["利率行情，SHIBOR行情、LIBOR行情等",{"$nulls":5},"外部数据源"]
["INTERF_INT_RATE_INFO",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["利率行情，SHIBOR行情、LIBOR行情等"]
["INT_RATE_ID","VARCHAR(50)","行情代码，行情名称从数据字典中获取","参考参数：SECRATE_DATA \n枚举值见下","是","key"]
["EFF_DATE","DATE","生效日",null,"是","key"]
["RELAESE_DATE","DATE","发布日",null,"是"]
["INT_RATE","NUMERIC(30, 14)","利率",null,"是"]
["CCY","VARCHAR(50)","币种",null,"是"]
["CREATE_USER","VARCHAR(20)","创建人",{"$nulls":7},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门"]
["CREATE_TIME","TIMESTAMP","创建时间",{"$nulls":7},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",{"$nulls":7},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",{"$nulls":7},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,null,"key",{"$nulls":4},"数据源系统缩写"]
[]
[{"$nulls":4},"SECRATE_DATA",1010100,"个人活期"]
[{"$nulls":4},"SECRATE_DATA",1010201,"个人定期(整存整取)三个月"]
[{"$nulls":4},"SECRATE_DATA",1010202,"个人定期(整存整取)半年"]
[{"$nulls":4},"SECRATE_DATA",1010203,"个人定期(整存整取)一年"]
[{"$nulls":4},"SECRATE_DATA",1010204,"个人定期(整存整取)二年"]
[{"$nulls":4},"SECRATE_DATA",1010205,"个人定期(整存整取)三年"]
[{"$nulls":4},"SECRATE_DATA",1010206,"个人定期(整存整取)五年"]
[{"$nulls":4},"SECRATE_DATA",1010207,"个人定期(整存整取)八年及以上"]
[{"$nulls":4},"SECRATE_DATA",1010301,"个人定期(零存整取,整存零取,存本取息)一年"]
[{"$nulls":4},"SECRATE_DATA",1010302,"个人定期(零存整取,整存零取,存本取息)三年"]
[{"$nulls":4},"SECRATE_DATA",1010303,"个人定期(零存整取,整存零取,存本取息)五年"]
[{"$nulls":4},"SECRATE_DATA",1010600,"协定存款"]
[{"$nulls":4},"SECRATE_DATA",1010701,"通知存款一天"]
[{"$nulls":4},"SECRATE_DATA",1010702,"通知存款七天"]
[{"$nulls":4},"SECRATE_DATA",1010801,"个人住房公积金贷款5年以下(含5年)"]
[{"$nulls":4},"SECRATE_DATA",1010802,"个人住房公积金贷款5年以上"]
[{"$nulls":4},"SECRATE_DATA",2020206,"短期贷款六个月"]
[{"$nulls":4},"SECRATE_DATA",2020207,"短期贷款一年"]
[{"$nulls":4},"SECRATE_DATA",2020208,"中长期贷款一至三年(含)"]
[{"$nulls":4},"SECRATE_DATA",2020209,"中长期贷款三至五年(含)"]
[{"$nulls":4},"SECRATE_DATA",2020210,"中长期贷款五年以上"]
[{"$nulls":4},"SECRATE_DATA","AUDIBO1M.IB","澳元1月拆借"]
[{"$nulls":4},"SECRATE_DATA","AUDIBO1W.IB","澳元1周拆借"]
[{"$nulls":4},"SECRATE_DATA","AUDIBO2M.IB","澳元2月拆借"]
[{"$nulls":4},"SECRATE_DATA","AUDIBO2W.IB","澳元2周拆借"]
[{"$nulls":4},"SECRATE_DATA","AUDIBO3M.IB","澳元3月拆借"]
[{"$nulls":4},"SECRATE_DATA","AUDIBOTN.IB","澳元次日拆借"]
[{"$nulls":4},"SECRATE_DATA","DR001.IB","银行间1天质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR007.IB","银行间7天质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR014.IB","银行间14天质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR021.IB","银行间21天质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR1M.IB","银行间1个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR1Y.IB","银行间1年质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR2M.IB","银行间2个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR3M.IB","银行间3个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR4M.IB","银行间4个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR6M.IB","银行间6个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","DR9M.IB","银行间9个月质押式回购利率"]
[{"$nulls":4},"SECRATE_DATA","EURIBO1M.IB","欧元1月拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO1W.IB","欧元1周拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO1Y.IB","欧元1年拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO2M.IB","欧元2月拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO2W.IB","欧元2周拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO3M.IB","欧元3月拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO3W.IB","欧元3周拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO6M.IB","欧元6月拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBO9M.IB","欧元9月拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBOON.IB","欧元隔夜拆借"]
[{"$nulls":4},"SECRATE_DATA","EURIBOTN.IB","欧元次日拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO1M.IB","港元1月拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO1W.IB","港元1周拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO2M.IB","港元2月拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO2W.IB","港元2周拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO3M.IB","港元3月拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO3W.IB","港元3周拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO6M.IB","港元6月拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBO9M.IB","港元9月拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBOON.IB","港元隔夜拆借"]
[{"$nulls":4},"SECRATE_DATA","HKDIBOTN.IB","港元次日拆借"]
[{"$nulls":4},"SECRATE_DATA","IBO001.IB","银行间1天同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO007.IB","银行间7天同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO014.IB","银行间14天同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO021.IB","银行间21天同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO1M.IB","银行间1个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO1Y.IB","银行间1年同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO2M.IB","银行间2个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO3M.IB","银行间3个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO4M.IB","银行间4个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO6M.IB","银行间6个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","IBO9M.IB","银行间9个月同业拆借利率"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO1M.IB","日元1月拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO1W.IB","日元1周拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO2M.IB","日元2月拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO2W.IB","日元2周拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO3M.IB","日元3月拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBO6M.IB","日元6月拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBOON.IB","日元隔夜拆借"]
[{"$nulls":4},"SECRATE_DATA","JPYIBOTN.IB","日元次日拆借"]
[{"$nulls":4},"SECRATE_DATA","L001.IB","银行间债券借贷1天"]
[{"$nulls":4},"SECRATE_DATA","L007.IB","银行间债券借贷7天"]
[{"$nulls":4},"SECRATE_DATA","L014.IB","银行间债券借贷14天"]
[{"$nulls":4},"SECRATE_DATA","L021.IB","银行间债券借贷21天"]
[{"$nulls":4},"SECRATE_DATA","L1M.IB","银行间债券借贷1个月"]
[{"$nulls":4},"SECRATE_DATA","L1Y.IB","银行间债券借贷1年"]
[{"$nulls":4},"SECRATE_DATA","L2M.IB","银行间债券借贷2个月"]
[{"$nulls":4},"SECRATE_DATA","L3M.IB","银行间债券借贷3个月"]
[{"$nulls":4},"SECRATE_DATA","L4M.IB","银行间债券借贷4个月"]
[{"$nulls":4},"SECRATE_DATA","L6M.IB","银行间债券借贷6个月"]
[{"$nulls":4},"SECRATE_DATA","L9M.IB","银行间债券借贷9个月"]
[{"$nulls":4},"SECRATE_DATA","LICHF12M.IR","瑞士法郎LIBOR12月"]
[{"$nulls":4},"SECRATE_DATA","LICHF1M.IR","瑞士法郎LIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","LICHF1W.IR","瑞士法郎LIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","LICHF2M.IR","瑞士法郎LIBOR2月"]
[{"$nulls":4},"SECRATE_DATA","LICHF3M.IR","瑞士法郎LIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","LICHF6M.IR","瑞士法郎LIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","LICHFON.IR","瑞士法郎LIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","LIEUR12M.IR","欧元LIBOR12月"]
[{"$nulls":4},"SECRATE_DATA","LIEUR1M.IR","欧元LIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","LIEUR1W.IR","欧元LIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","LIEUR2M.IR","欧元LIBOR2月"]
[{"$nulls":4},"SECRATE_DATA","LIEUR3M.IR","欧元LIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","LIEUR6M.IR","欧元LIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","LIEURON.IR","欧元LIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","LIGBP12M.IR","英镑LIBOR12月"]
[{"$nulls":4},"SECRATE_DATA","LIGBP1M.IR","英镑LIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","LIGBP1W.IR","英镑LIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","LIGBP2M.IR","英镑LIBOR2月"]
[{"$nulls":4},"SECRATE_DATA","LIGBP3M.IR","英镑LIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","LIGBP6M.IR","英镑LIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","LIGBPON.IR","英镑LIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","LIJPY12M.IR","日元LIBOR12月"]
[{"$nulls":4},"SECRATE_DATA","LIJPY1M.IR","日元LIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","LIJPY1W.IR","日元LIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","LIJPY2M.IR","日元LIBOR2月"]
[{"$nulls":4},"SECRATE_DATA","LIJPY3M.IR","日元LIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","LIJPY6M.IR","日元LIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","LIJPYON.IR","日元LIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","LIUSD12M.IR","美元LIBOR12月"]
[{"$nulls":4},"SECRATE_DATA","LIUSD1M.IR","美元LIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","LIUSD1W.IR","美元LIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","LIUSD2M.IR","美元LIBOR2月"]
[{"$nulls":4},"SECRATE_DATA","LIUSD3M.IR","美元LIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","LIUSD6M.IR","美元LIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","LIUSDON.IR","美元LIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","OR001.IB","银买断1日"]
[{"$nulls":4},"SECRATE_DATA","OR007.IB","银买断7日"]
[{"$nulls":4},"SECRATE_DATA","OR014.IB","银买断14日"]
[{"$nulls":4},"SECRATE_DATA","OR021.IB","银买断21日"]
[{"$nulls":4},"SECRATE_DATA","OR1M.IB","银买断1月"]
[{"$nulls":4},"SECRATE_DATA","OR2M.IB","银买断2月"]
[{"$nulls":4},"SECRATE_DATA","OR3M.IB","银买断3月"]
[{"$nulls":4},"SECRATE_DATA","R001.IB","银存间质押1日"]
[{"$nulls":4},"SECRATE_DATA","R007.IB","银存间质押7日"]
[{"$nulls":4},"SECRATE_DATA","R014.IB","银存间质押14日"]
[{"$nulls":4},"SECRATE_DATA","R021.IB","银存间质押21日"]
[{"$nulls":4},"SECRATE_DATA","R1M.IB","银存间质押1月"]
[{"$nulls":4},"SECRATE_DATA","R1Y.IB","银存间质押1年"]
[{"$nulls":4},"SECRATE_DATA","R3M.IB","银存间质押3月"]
[{"$nulls":4},"SECRATE_DATA","R4M.IB","银存间质押4月"]
[{"$nulls":4},"SECRATE_DATA","R6M.IB","银存间质押6月"]
[{"$nulls":4},"SECRATE_DATA","R9M.IB","银存间质押9月"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR1M.IR","SHIBOR1月"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR1W.IR","SHIBOR1周"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR1Y.IR","SHIBOR1年"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR2W.IR","SHIBOR2周"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR3M.IR","SHIBOR3月"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR6M.IR","SHIBOR6月"]
[{"$nulls":4},"SECRATE_DATA","SHIBOR9M.IR","SHIBOR9月"]
[{"$nulls":4},"SECRATE_DATA","SHIBORON.IR","SHIBOR隔夜"]
[{"$nulls":4},"SECRATE_DATA","USDIBO1M.IB","美元1月拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO1W.IB","美元1周拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO1Y.IB","美元1年拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO2M.IB","美元2月拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO2W.IB","美元2周拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO3M.IB","美元3月拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO3W.IB","美元3周拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO6M.IB","美元6月拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBO9M.IB","美元9月拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBOON.IB","美元隔夜拆借"]
[{"$nulls":4},"SECRATE_DATA","USDIBOSN.IB","美元1日拆借"]

{"sheet":"收益率曲线表","index":13,"n_rows":17,"n_cols":15,"rows_kept":17,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["收益率曲线表",{"$nulls":5},"外部数据源"]
["INTERF_PAYHSRCCASHYIELD",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["收益率曲线表，包括的曲线类型如右边列表",null,null,"数据字典值",{"$nulls":9},"曲线类型包括："]
["STATE_DATE","VARCHAR2(10)","曲线日期",null,"是","key",{"$nulls":7},"债券收盘收益率曲线","外汇交易中心"]
["CURVE_CODE","VARCHAR2(50)","曲线code-原始code",null,"是","key",{"$nulls":7},"外汇隐含利率曲线","外汇交易中心"]
["CURVE_NAME","VARCHAR2(128)","曲线名称",null,"是",{"$nulls":8},"债券到期收益率曲线（多条）","中债登"]
["MTRTY","NUMBER(20,4)","关键年限点",null,"是","key",{"$nulls":7},"债券即期收益率曲线（多条）","中债登"]
["YLD","NUMBER(38,10)","收益率（%）",null,"是",{"$nulls":8},"远期利率曲线（多条）","中债登"]
["CURVE_TYPE","CHAR(2)","曲线类型\nSP即期\nMA远期\nFS远期的即期\nFM远期的到期","参考参数：CURVE_TYPE \n 01 SP即期\n 02 MA远期\n 03 FS远期的即期\n 04 FM远期的到期","是",{"$nulls":8},"债券到期收益率曲线（多条）","中证指数"]
["N","NUMBER(20,4)","N",null,"否","远期的年限点",{"$nulls":7},"债券即期收益率曲线（多条）","中证指数"]
["K","NUMBER(20,4)","K",null,"否","远期的利率期限",{"$nulls":7},"远期利率曲线（多条）","中证指数"]
["SOURCE","VARCHAR(50)","数据来源",null,null,"key\n中债登/上清所/中证/外汇交易中心",{"$nulls":4},"数据源系统缩写",null,null,"债券到期收益率曲线（多条）","上清所 "]
["CREATEDATE","DATE","创建日期",null,"是",{"$nulls":5},"数据库时间",null,null,"债券即期收益率曲线（多条）","上清所 "]
["CREATEUSER","NVARCHAR2(20)","创建人",null,"是",{"$nulls":5},"interf",null,null,"远期利率曲线（多条）","上清所 "]
["LSTMNTDATE","DATE","最后修改日期",null,"否",{"$nulls":5},"数据库时间",null,null,"境内美元同业拆放参考利率(USD CIROR)","外汇交易中心"]
["LSTMNTUSER","NVARCHAR2(20)","最后修改人",null,"否",{"$nulls":5},"interf"]
[{"$nulls":13},"时间范围要求：历史3年"]

{"sheet":"基金场内行情","index":14,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[0,0,0,4],[0,5,0,8],[1,0,1,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[2,0,2,2]],"flags":["formulas_cached_only"]}
["基金场内行情",{"$nulls":4},"外部数据源"]
["INTERF_F_MARKET_INFO",null,null,"是否必填","说明","字段","长度","表名","转换规则"]
["基金场内行情"]
["FUND_CODE","VARCHAR2(32)","基金代码（市场代码）","是","key"]
["VALUE_DATE","DATE","交易日","是","key"]
["VALUATION_SOURCE","VARCHAR2(50)","估值来源","否","key：上海证券交易所、深圳证券交易所"]
["FUND_TYPE","VARCHAR2(50)","基金类型","否","货币基金、债券基金、股票基金、混合基金、ETF指数基金"]
["CLOSE_PRICE_PRE","NUMBER(30,14)","前收盘价","是"]
["CLOSE_PRICE","NUMBER(30,14)","收盘价","是"]
["AVERAGE_PRICE","NUMBER(30,14)","平均价","是"]
["MAX_PRICE","NUMBER(30,14)","最高价","是"]
["MIN_PRICE","NUMBER(30,14)","最低价","是"]
["VOLUME","NUMBER(30,2)","成交量","否"]
["TURNOVER","NUMBER(30,2)","成交金额","否"]
["CHANGE","NUMBER(30,14)","涨跌","否"]
["CHG","NUMERIC(30,14)","涨跌幅","否"]
["AMPLITUDE","NUMERIC(30,14)","振幅","否"]
["TURNOVERRATE","NUMERIC(30,14)","换手率","否"]
["DISCOUNTRATE","NUMERIC(30,14)","折价率","否"]
["BUY_ONE_PRICE","NUMBER(30,14)","买一价","否"]
["SELL_ONE_PRICE","NUMBER(30,14)","卖一价","否"]
["CREATE_USER","VARCHAR2(20)","创建人","是",{"$nulls":5},"interf"]
["CREATE_DEPT","VARCHAR2(32)","创建部门","否"]
["CREATE_TIME","TIMESTAMP(6)","创建时间","是",{"$nulls":5},"数据库时间"]
["UPDATE_USER","VARCHAR2(20)","更新人","是",{"$nulls":5},"interf"]
["UPDATE_TIME","TIMESTAMP(6)","更新时间","是",{"$nulls":5},"数据库时间"]

{"sheet":"商业银行净资产","index":15,"n_rows":12,"n_cols":11,"rows_kept":12,"merged":[[0,0,0,5],[0,6,0,9],[1,0,1,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[2,0,2,2]],"flags":["formulas_cached_only"]}
["商业银行净资产",{"$nulls":5},"外部数据源"]
["INTERF_BANK_NETASSET",{"$nulls":3},"是否必填","说明","字段","长度","表名","转换规则"]
["商业银行净资产",null,null,"数据字典"]
["CUSTOMER_ID","VARCHAR(32)","客户代码",null,"是","KEY"]
["CDATE","VARCHAR2(10)","估值日","是","是","KEY"]
["NETASSET","NUMBER(20,4)","净资产金额（亿元）",null,"是"]
["CREATE_USER","VARCHAR(20)","创建人",{"$nulls":7},"interf"]
["CREATE_DEPT","VARCHAR(32)","创建部门"]
["CREATE_TIME","TIMESTAMP","创建时间",{"$nulls":7},"数据库时间"]
["UPDATE_USER","VARCHAR(20)","更新人",{"$nulls":7},"interf"]
["UPDATE_TIME","TIMESTAMP","更新时间",{"$nulls":7},"数据库时间"]
["SOURCE","VARCHAR(50)","数据来源",null,null,"key",{"$nulls":4},"数据源系统缩写"]