{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["证书信息表","生产企业信息表"],"not_rendered":{"external_links":1,"defined_names":8},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"证书信息表","index":0,"n_rows":9,"n_cols":59,"rows_kept":9,"merged":[[1,0,3,0],[4,0,6,0],[4,38,4,40]],"flags":["formulas_cached_only"]}
["303010","字段名称","RZJG_ID","CERT_NO","CERTI_STATUS","CERT_FIRST_DATE","CERT_AWARD_DATE","CERT_E_DATE","CERT_MODE","AUTH_PROJ_CODE","AUTH_PROJ_RZGZ","CERT_AUTH_PROJ_CODEDEC","VOLUNTARY_AREA_CODE","PRO_NAME","PRO_TYPE","PRO_CAT","APP_COUNTRY","APP_NAME","APP_ORG_CODE","APP_DISTRICT","APP_ADDRESS","MANU_COUNTRY","MANU_NAME","MANU_ORG_CODE","MANU_DISTRICT","MANU_REG_ADDRESS","FAC_COUNTRY","FAC_CODING","FAC_NAME","FAC_ORG_CODE","IS_SCALE","BEL_INDUSTRY","FAC_DISTRICT","FAC_ADDRESS","FAC_LINK_MAN","FAC_TEL","ACC_SYMBOL","BUSI_SCOP_CODE","CERT_ATTACH_1","CERT_ATTACH_2","CERT_ATTACH_3","CERT_PAUSE_CAUSE","CERT_PAUSE_S_DATE","CERT_PAUSE_E_DATE","CERT_REVOKE_CAUSE","CERT_REVOKE_DATE","CERT_CANCEL_CAUSE","CERT_CANCEL_DATE","CERT_CHG_CAUSE","CERT_CHG_DATE","EXCHANGE_CAUSE","EXCHANGE_DATE","O_AWARD_JG","O_CERT_NO","REPORT_TYPE","PRO_CLASSFY_CODE","FYYP_PRO_CLASSFY_CODE","FYYP_GGJG_GGJG_CODE","REMARK"]
["自愿性工业产品信息上报数据模版","字段含义","1、认证机构批准号","2、认证证书号","3、证书状态","4、首次获证日期","5、证书发证日期","6、证书到期日期","7、认证模式","8、认证项目分类代码","9、认证规则编号","10、认证依据的标准和技术要求","11、自愿性产品认证领域分类代码","12、产品名称及单元","13、规格型号","14、产品所属分类","15、认证委托人所在国家地区","16、认证委托人名称","17、认证委托人统一社会信用代码","18、认证委托人注册地行政区划","19、认证委托人地址","20、生产者（制造商）所在国家地区代码","21、生产者（制造商）名称","22、生产者（制造商）统一社会信用代码","23、生产者（制造商）注册地址所在行政区划","24、生产者（制造商）注册地址","25、生产企业所在国家地区代码","26、生产企业编号（工厂编号）","27、生产企业名称","28、生产企业统一社会信用代码","29、生产企业是否属于规模以上企业","30、生产企业所属国民经济行业","31、生产企业实际地址所在地区行政区划","32、生产企业实际地址","33、生产企业联系人","34、生产企业联系电话","35、证书使用的认可标志代码","36、认证产品所属CNAS分类代码","37、认证证书附件文档名","38、认证证书附件产品规格型号","39、认证证书附件型式试验报告","40、暂停原因","41、暂停开始时间","42、暂停截止时间","43、撤销原因","44、撤销时间","45、注销原因","46、注销时间","47、变更原因","48、变更时间","49、换证原因","50、换证日期","51、原颁证机构批准号","52、原认证证书号","53、上报类型","54、产品分类代码","55、防疫产品分类代码","56、公告机构及公告机构编号","57、备注"]
[null,"数据类型","VARCHAR2","VARCHAR2","VARCHAR2","DATE","DATE","DATE","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","DATE","DATE","VARCHAR2","DATE","VARCHAR2","DATE","VARCHAR2","DATE","VARCHAR2","DATE","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2"]
[null,"最大长度（字符）",30,100,2,{"$nulls":3},2000,10,1000,2000,10,4000,4000,4,3,1000,30,6,1000,3,1000,30,6,1000,3,20,1000,30,2,100,6,1000,100,100,100,"100",300,300,300,10,null,null,10,null,10,null,10,null,4,null,30,100,2,10,"500","500",4000]
["证书信息表","填表说明","认监委颁发的认证机构批准号","与颁发的认证证书保持一致","按照《证书状态分类代码》填写","认证机构可以确认的生产企业该证书的首次获证日期","证书上打印的颁证日期","证书上打印的到期日期","填写具体的认证模式描述","按照《认证项目分类与编码》","填写认证机构向认监委备案的认证规则编号，可填写多个认证规则编码；使用国家认监委统一发布的认证规则不用填写","填写认证依据的具体标准号和标准名称、版本号或者技术规范编号和名称等，与认证证书保持一致。项目分类代码填写B0598时，填写依据欧盟指令或法规名称","认证项目分类代码为“B05”开头时必填且符合《自愿性产品认证领域分类代码》码表规范","与认证证书保持一致；有多个产品名称时，可以将产品名称与规格型号合并填写","与认证证书保持一致，如以附件形式报送，此处填写“详见附件”","按《国家统计局产品分类目录》填写4位分类代码","必填，按照《国别代码》填写，没有统一社会信用代码的中国境内组织，国家代码填写999","与认证证书保持一致","填写中国境内地区（国家地区代码为156）认证委托人的18位统一社会信用代码。当国家代码为999时，认证委托人的统一社会信用代码不用填写。统一社会信用代码查询网址https://www.cods.org.cn/","当认证委托人注册地所在国家地区代码为中国大陆、香港、澳门、台湾时，行政区域应依据《地区行政区划代码》填写；否则，此项为空","与认证证书保持一致","必填，按照《国别代码》填写，没有统一社会信用代码的中国境内组织，国家代码填写999","与认证证书保持一致","填写中国境内地区（国家地区代码为156）生产者（制造商）的18位统一社会信用代码。当国家代码为999时，生产者（制造商）的统一社会信用代码不用填写。统一社会信用代码查询网址https://www.cods.org.cn/","当生产者所在国家地区代码为中国大陆、香港、澳门、台湾时，行政区域应依据《地区行政区划代码》填写；否则，此项为空","与认证证书保持一致","必填，按照《国别代码》填写，没有统一社会信用代码的中国境内组织，国家代码填写999","根据认证机构对工厂赋予的工厂编号填写","与认证证书保持一致","填写中国境内地区（国家地区代码为156）生产企业的18位统一社会信用代码。当国家代码为999时，生产企业的统一社会信用代码不用填写。统一社会信用代码查询网址https://www.cods.org.cn/","参照《是非选项代码》（0否，1是）","参照GB/T 4754-2017《国民经济行业分类代码》，填写4位数字小类","当生产企业所在国家地区代码为中国大陆、香港、澳门、台湾时，行政区域应依据《地区行政区划代码》填写；否则，此项为空","与认证证书保持一致","多个联系人中间用全角中文分号隔开","多个联系人电话中间用全角中文分号隔开","依据《认可标志分类代码》填写，未获得认可不用填写；多个认可标志用全角分号分隔","根据《认证产品所属CNAS业务分类代码》填写；如没有对应代码则为空，有多个业务范围代码时，用全角分号分隔","填写该证书附件文档的文件名称（带后缀），多个文件名称使用全角分号分隔；如果该证书的附件很多，可以将这些附件压缩，此处填写压缩文件名称及后缀。上传文件类型包括：pdf、jpg、txt、zip、rar、doc、docx、xls、xlsx、wps、et、tif和tiff等13种格式",null,null,"参照《证书暂停原因代码》填写，只填写一项主要原因",null,null,"参照《证书撤销原因代码》填写，只填写一项主要原因",null,"参照《证书注销原因代码》填写，只填写一项主要原因",null,"参照《证书变更原因码表》填写，只填写一项主要原因",null,"参照《换证原因代码》填写，只允许填写一项",{"$nulls":3},"按《上报类型代码表》填写本次证书信息上报的类型","当认证项目分类代码所属的产品有分类时，必须按《产品分类代码表》填写分类代码，否则应为空值","当项目分类代码填写B0598时，必填且需符合《防疫产品分类代码表》规范，多个代码之间用全角分号；分隔","当项目分类代码填写B0598时，必填。填写取得欧盟合法授权的检测认证机构名称、编号","根据需要填写备注内容"]
[null,"校验级别",1,1,1,1,1,1,1,1,1,1,1,1,"0",1,1,1,1,1,1,1,1,1,1,1,1,"0",1,1,1,1,1,1,"0","0",1,"0",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,"0"]
[null,"是否公开","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","是","否","是","是","否","否","是","是","否","否","是","否","是","是","是","否","是","是","否","是","否","是","是","是","是","是","否","否","否","是","否","否","是"]
["从C8元格开始填写上报信息",null,"CNCA-R-2019-523","CETC1020200002","03","2020-12-23","2020-12-23",null,"现场检查（适用时）+产品检测+证后监督","B0599","CTS/CETC 0008-2020","GB 4806.9-2016食品安全国家标准 食品接触用金属材料及制品","PV10","商用厨具洗消设备（内壁、托架材质：不锈钢06Cr19Ni10)","热风循环消毒柜XR-XD、红外线消毒柜XR-HW、光波消毒柜XR-GB、筷子消毒车（机）XR-KX、刀具消毒柜XR-DXD、超声波洗碗机XR-CS、超声波洗菜机XR-CX、推车式消毒柜XR-TCX、长龙洗碗机XR-CL、揭盖洗碗机XR-JG、通道式洗碗机XR-TD、砧板消毒柜XR-ZB、组合式消毒柜XR-ZH、低温消毒柜XR-DE、紫外线消毒柜XR-ZWX、臭氧消毒柜XR-CY、毛巾消毒柜XR-MJ。",3699,"156","山东省博兴县兴润餐饮设备有限公司","91371625060429319C","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","156","山东省博兴县兴润餐饮设备有限公司","91371625060429319C","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","156",null,"山东省博兴县兴润餐饮设备有限公司","91371625060429319C","0","3381","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","孙超","13173284633",{"$nulls":8},"0307","2024-03-04",null,null,"0308","2024-03-04",{"$nulls":4},"05"]
[null,null,"CNCA-R-2019-523","CETC1020200001","03","2020-12-23","2020-12-23",null,"现场检查（适用时）+产品检测+证后监督","B0599","CTS/CETC 0008-2020","GB 4806.9-2016食品安全国家标准 食品接触用金属材料及制品","PV10","不锈钢调理设备（内壁、台面材质：不锈钢06Cr19Ni10)","双层工作台XR-GZT、单通工作台XR-GZT1、双通道工作台（XR-GZT2）、四层货架XR-HJ、台面立架XR-TM、四门碗柜XR-WG、调料柜XR-TL、单（多）星水池XR-SC、调料车XR-TLC、米面架XR-MM、面粉车XR-MFC、杀鱼台XR-SYT、解冻池、平板推车XR-PB、层架车XR-CJC、送餐车XR-SCC、不锈钢餐桌椅XR-CZY、吊柜XR-DG、售饭台XR-SFT、饼盘车XR-BPC、收餐车XR-SCC、收碗车XR-SWC、单层工作台CR-DC、单通打荷台柜XR-DT、双通打荷台柜XR-ST、翻门工作台XR-FM、下花格工作台XR-XHG、异型工作台XR-YX、储物柜XR-CWG、炉具拼台XR-PT、柜式单（多）星水池XR-GSC、砧板台XR-ZB、杀鱼台带单星沥水平台XR-LS、砧板台带沥水平台XR-LSZB、挂墙架XR-GQ、简易工作台XR-JY、备餐台XR-BC、污碟台XR-WD、洁碟台XR-JD、米柜XR-MG、多层货架XR-HJX。",3699,"156","山东省博兴县兴润餐饮设备有限公司","91371625060429319C","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","156","山东省博兴县兴润餐饮设备有限公司","91371625060429319C","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","156",null,"山东省博兴县兴润餐饮设备有限公司","91371625060429319C","0","3381","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","孙超","13173284633",{"$nulls":8},"0307","2024-03-04",null,null,"0308","2024-03-04",{"$nulls":4},"05"]

{"sheet":"生产企业信息表","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"merged":[[1,0,3,0],[4,0,6,0]],"flags":["formulas_cached_only"]}
["303011","字段名称","RZJG_ID","CERT_NO","FAC_COUNTRY","FAC_CODING","FAC_NAME","FAC_ORG_CODE","IS_SCALE","BEL_INDUSTRY","FAC_DISTRICT","FAC_ADDRESS","FAC_LINK_MAN","FAC_TEL"]
["自愿性工业产品信息上报数据模版","字段含义","1、认证机构批准号","2、认证证书号","3、生产企业所在国家地区代码","4、生产企业编号（工厂编号）","5、生产企业名称","6、生产企业统一社会信用代码/组织机构代码","7、生产企业是否属于规模以上企业","8、生产企业所属国民经济行业","9、生产企业实际地址所在地区行政区划","10、生产企业实际地址","11、生产企业联系人","12、生产企业联系电话"]
[null,"数据类型","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2","VARCHAR2"]
[null,"最大长度（字符）",30,100,3,20,1000,30,2,100,6,1000,100,100]
["生产企业信息表","填表说明","认监委颁发的认证机构批准号","与颁发的认证证书保持一致","按照《国别代码》填写三位数字代码","根据认证机构对工厂赋予的工厂编号填写","与认证证书保持一致","中国大陆地区企业填写生产企业织名称字段对应的16位统一社会信用代码/9位组织机构代码；其他企业不填写。","参照《是非选项代码》（0否，1是）","参照GB/T 4754-2017《国民经济行业分类代码》，填写4位数字小类","当生产企业所在国家地区代码为中国大陆、香港、澳门、台湾时，行政区域应依据《地区行政区划代码》填写；否则，此项为空","与认证证书保持一致","多个联系人中间用全角中文分号隔开","多个联系人电话中间用全角中文分号隔开"]
[null,"校验级别",1,1,1,"0",1,1,1,1,1,1,"0","0"]
[null,"是否公开","是","是","是","否","是","是","否","否","是","是","否","否"]
["从C8元格开始填写上报信息",null,"CNCA-R-2019-523","CETC1020200002","156",null,"山东省博兴县兴润餐饮设备有限公司",60429319,0,"3381","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","孙超","13173284633"]
[null,null,"CNCA-R-2019-523","CETC1020200001","156",null,"山东省博兴县兴润餐饮设备有限公司",60429319,0,"3381","371625","山东省滨州市博兴县兴福镇兴四村中心路南100米","孙超","13173284633"]