{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["数据库信息","视图清单","基础数据类","项目概况","设备设施","其它事项","维修维保＆专维"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"数据库信息","index":0,"n_rows":17,"n_cols":18,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,9,0],[2,1,9,1],[2,2,9,2],[2,3,9,3],[13,3,18,3],[2,4,9,4],[2,5,9,5],[2,8,9,8],[2,9,9,9],[11,0,11,7],[11,9,18,12],[13,0,18,0],[13,1,18,1],[13,2,18,2]]}
["源系统信息"]
["源系统名称","生产/测试","联系人","数据库信息","表/视图","表（视图）含义","回调函数","推送模式","主键","增量字段","标识字段","初始数据量","日（月）均数据增量"]
["商管工程信息化管理系统","测试环境","甲方\n负责人（必填）：刘建东\n业务系统负责人：孙明明","数据库类型：oracle\n数据库域名：10.199.204.166/orapub5\n数据库名称：orapub5\n用户名：maximo \n密码：XcSvzjLec7RJZ1Rl\n端口：1521","见视图清单页","见视图清单页",null,null,"见视图清单页","见视图清单页"]
{"$rows_empty":8}
["对接系统信息",{"$nulls":8},"注意：1.建议源系统和对接系统分别为主数据平台创建专用数据库账号，创建后请在“用户名”处标明；\n2.源系统的主键需要保证数据的唯一性；\n3.增量字段：增量数据的时间戳（能区分大小的数据类型均可）\n4.标识字段：每一批次增量数据的批次标识\n5.不允许对接系统使用、修改对接表的字段及数据"]
["对接系统名称","生产/测试","联系人","数据源类型","表","回调函数","过滤条件","推送频率",{"$nulls":9}," "]
[null,"测试环境","甲方负责人（必填）：\n业务系统负责人：","数据库类型：Mysql\n数据库域名：\n数据库名称：\n用户名：\n密码：\n端口："]
[{"$nulls":8}," "]
[{"$nulls":8}," "]
[{"$nulls":8}," "]

{"sheet":"视图清单","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,0,16,0],[17,0,21,0],[22,0,24,0],[25,0,30,0],[1,0,13,0]]}
["分类","视图","视图名称","推送方式","增量字段","主键id","推送频率","现有总量","预估每日新增条数","三年后预估总数量","备注"]
["基础数据视图","V_GLSMS_ASSET","设备台账视图","增量","CHANGEDATE","ASSETID","一天一次",1837632,1000,{"$f":"I2*1095+H2","v":2932632},"新开业广场才会有大量录入"]
[null,"V_GLSMS_LOCATION","位置台帐视图","增量","CHANGEDATE","LOCATIONSID","一天一次",371553,1000,{"$f":"I3*1095+H3","v":1466553},"新开业广场才会有大量录入"]
[null,"V_GLSMS_WZFL","位置分类视图","全量",null,"LOCATIONFLID","一天一次",100,null,120]
[null,"V_GLSMS_CLASSSTRUCTURE","设备分类视图","全量",null,"CLASSSTRUCTUREUID","一天一次",544,null,600]
[null,"V_GLSMS_AUTH","人员权限视图","全量",null,"GLSMS_AUTHID","一小时一次",0,null,50000]
[null,"V_GLSMS_UPWC","广场管理说明书上传完成视图","全量",null,"SITEID","一天一次",300,null,500]
[null,"V_GLSMS_WB_BZGL","维保标准视图(日常、安全)","全量",null,"WB_BZGLID","一天一次",224,null,300]
[null,"V_GLSMS_SYSTEMCFG ","设备系统关系视图","全量",null,"GCXXHXT","一天一次",23,null,30,"线下配置，工程信息化修改前通知管理说明书系统"]
[null,"V_GLSMS_CONFIGURING ","图片类型配置视图","全量",null,"GLSMS_CONFIGURINGID","一天一次",24,null,50,"线下配置，工程信息化修改前通知管理说明书系统"]
[null,"V_GCGLSMS_WXWBSX","维修维保事项配置主表视图","全量",null,"GCGLSMS_WXWBSXID","一天一次",100,null,300]
[null,"V_GCGLSMS_WXWBSXLINE","维修维保事项配置子表视图","全量",null,"GCGLSMS_WXWBSXLINEID","一天一次",400,null,1200]
[null,"V_GLSMS_ZHSXCFG","综合记录事项配置","全量",null,"ALNDOMAINID","一天一次",4,null,12,"线下配置，工程信息化修改前通知管理说明书系统"]
[null,"V_GLSMS_DSFJCSXCFG","第三方检测事项配置","全量",null,"GLSMS_DSFJCSXCFGLINEID","一天一次",33,null,99,"线下配置，工程信息化修改前通知管理说明书系统"]
["项目概况","V_GLSMS_PROIMGUP","图片上传视图","增量","CHANGEDATE","GLSMS_PROIMGUPID","一小时一次",0,1000,{"$f":"I15*1095+H15","v":1095000}]
[null,"V_GLSMS_CONSTRUCTION","施工单位信息视图","增量","CHANGEDATE","GLSMS_CONSTRUCTIONID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_BUILD","建筑综合信息视图","增量","CHANGEDATE","GLSMS_BUILDID","一小时一次",0,1000,1095000]
["设备设施","V_GLSMS_DYGJCXLINE","低压出线柜明细视图","增量","CHANGEDATE","GLSMS_DYGJCXLINEID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_SHOPS","商铺范围清单视图","增量","CHANGEDATE","GLSMS_SHOPSID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_SHOPSLINE","商铺范围清单子表视图","增量","CHANGEDATE","GLSMS_SHOPSLINEID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_QTSX","其它事项视图","增量","CHANGEDATE","GLSMS_ZWQTSXID","一小时一次",0,1000,1095000]
[null,"V_GCGLSMS_MATERIAL","土建材料清单视图","增量","CHANGEDATE","GCGLSMS_MATERIALID","一小时一次",0,1000,1095000]
["其他事项","V_GLSMS_ZHSXJL","综合事项记录视图","增量","CHANGEDATE","GLSMS_ZHSXJLID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_ZHSXFJ","综合事项附件视图","增量","CREATEDATE","DOCLINKSID","一小时一次",0,1000,1095000]
[null,"V_GLSMS_FZYFCHANGE","辅助用房调改变更记录视图","增量","CHANGEDATE","GLSMS_FZYFCHANGEID","一小时一次",0,1000,1095000]
["维修维保/专维","V_GLSMS_WX","标准维修视图","增量","CHANGEDATE","WORKORDERID","一天一次",4666390,6000,11236390]
[null,"V_GLSMS_WBSMS","标准维保（说明书）视图","增量","CHANGEDATE","WORKORDERID","一天一次",0,2000,2190000]
[null,"V_GLSMS_WBZY","标准维保（专业）视图","增量","CHANGEDATE","WB_GZGLBZID","一天一次",47563849,60000,113263849]
[null,"V_GLSMS_IMAGE","维修维保图片视图","增量","CREATEDATE","DOCLINKSID","一天一次",14000000,30000,46850000]
[null,"V_GLSMS_ZW","标准专维视图","全量",null,"GCZXWX_LINEID","一天一次",22749,null,30000]
[null,"V_GLSMS_DSFRW","第三方检测任务视图","增量","SJWCSJ","WB_GZGLID","一天一次",15992,100,125492]

{"sheet":"基础数据类","index":2,"n_rows":94,"n_cols":14,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,10,0,13],[90,0,90,3],[82,0,82,3],[0,0,0,3],[29,0,29,3],[13,5,13,8],[0,5,0,8],[74,0,74,3],[57,5,57,8],[10,10,10,13],[22,10,22,13],[31,10,31,13],[37,10,37,13]]}
["位置台账表v_glsms_location",{"$nulls":4},"位置分类v_glsms_wzfl",{"$nulls":4},"图片类型配置视图V_GLSMS_CONFIGURING "]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","长度",null,"中文描述","列名","类型","长度"]
["位置内码","LOCATION","VARCHAR2(20)",null,null,"修改时间","CHANGEDATE","DATET",null,null,"唯一ID","GLSMS_CONFIGURINGID","NUMBER",19]
["位置简码","WZJM","VARCHAR2(50)",null,null,"分类名称","DESCRIPTION","VARCHAR2",50,null,"模块","MODULE","VARCHAR2",30]
["位置简称","WZJC","VARCHAR2(160)",null,null,"大类","DL","VARCHAR2",50,null,"系统","SYSTEM","VARCHAR2",30]
["位置序号","WZXH","VARCHAR2(40)",null,null,"管控数量","GKSL","NUMBER",12,null,"图片类型序号","SN","NUMBER",10]
["序号说明","XHSM","VARCHAR2(50)",null,null,"分类等级","LEVELFL","NUMBER",19,null,"图片类型编号","TYPECODE","NUMBER",10]
["分类内码","LOCFL","NUMBER(19)",null,null,"唯一ID","LOCATIONFLID","NUMBER",19,null,"图片类型名称","TYPENAME","VARCHAR2",50]
["分类编码","WDNUM","VARCHAR2(50)",null,null,"备注","NOTE","VARCHAR2",500]
["分类名称","FLMC","VARCHAR2(50)",null,null,"顺序","SEQUENCE","NUMBER",12]
["管理归属","S_WZGLGS","VARCHAR2(30)",null,null,"状态","STATUS","VARCHAR2",50,null,"维修维保事项配置主表v_gcglsms_wxwbsx"]
["物业类型","S_WYLX","VARCHAR2(30)",null,null,"万达编码","WDNUM","VARCHAR2",50,null,"中文描述","列名","类型","备注"]
["用途","PURPOSE","VARCHAR2(30)",{"$nulls":7},"所属系统","system","VARCHAR2(30)","中文"]
["重要级别","S_WZZYJB","VARCHAR2(30)",null,null,"设备分类V_GLSMS_CLASSSTRUCTURE",{"$nulls":4},"唯一ID","gcglsms_wxwbsxid","NUMBER(19)"]
["变更时间","CHANGEDATE","DATE",null,null,"中文描述","列名","类型","长度",null,"说明书位置","smswz","VARCHAR2(100)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"分类备注说明","BZ","VARCHAR2",1000,null,"说明书设备","smsasset","VARCHAR2(100)"]
["唯一id","locationsid","NUMBER(19)",null,null,"标准数量","BZSL","VARCHAR2",10,null,"区分(如区分给水和排水)","DIFFERENCE","VARCHAR2(50)"]
["是否是主力店","S_SFZLD","NUMBER(4)",null,null,"修改人","CHANGEBY","VARCHAR2",30,null,"位置序号","sn","NUMBER(12)"]
["位置责任人","ZRR","VARCHAR2(30)",null,null,"修改时间","CHANGEDATE","DATE ",null,null,"设备序号","assetsn","NUMBER(12)"]
[" 层高m（地面至吊顶的高度） ","CENGGAO","NUMBER(16,2)",null,null,"节点的分类标识","CLASSIFICATIONID","VARCHAR2",192]
["面积㎡","MIANJI","NUMBER(16,2)",null,null,"分类全称","CLASSQC","VARCHAR2",200]
["备注","S_REMARK","VARCHAR2(200)",null,null,"分类全码","CLASSQM","VARCHAR2",100]
["位置全码","S_WZQM","VARCHAR2(100)",null,null,"分类ID","CLASSSTRUCTUREID","VARCHAR2",30,null,"维修维保事项配置子表v_gcglsms_wxwbsxline"]
["位置全称","S_WZQC","VARCHAR2(200)",null,null,"唯一标识","CLASSSTRUCTUREUID","NUMBER",19,null,"中文描述","列名","类型","备注"]
["位置原码","S_WZBM","VARCHAR2(50)",null,null,"创建人","CREATEBY","VARCHAR2",30,null,"唯一ID","gcglsms_wxwbsxlineid","NUMBER(19)"]
["位置原称","DESCRIPTION","VARCHAR2(200)",null,null,"创建时间","CREATEDATE","DATE ",null,null,"主表ID","gcglsms_wxwbsxid","NUMBER(19)"]
["铺位可视化楼层","GNAME","VARCHAR2(30)","f2推送对接",null,"描述所选资产类结构。","DESCRIPTION","VARCHAR2",100,null,"事项","matter","VARCHAR2(200)"]
["租赁系统楼层","FLOORNAME","VARCHAR2(30)","2F",null,"父级系统分类","FJXTFL","VARCHAR2",10,null,"序号","sn","NUMBER(12)"]
[{"$nulls":5},"万达编码","FLBM","VARCHAR2",50]
["设备台账表v_glsms_asset",{"$nulls":4},"使用该类结构时是否生成资产描述？","GENASSETDESC","Boolean",1]
["中文描述","列名","类型","备注",null,"是否关键设备","GJSB","Boolean",1]
["设备内编码","ASSETNUM","VARCHAR2(20)",null,null,"管控数量","GKSL","NUMBER",12,null,"综合事项配置视图V_GLSMS_ZHSXCFG"]
["设备简称","SBJC","VARCHAR2(160)",null,null,"管理方式","GLFS","VARCHAR2",50,null,"中文描述","列名","类型","长度"]
["设备简码","SBJBM","VARCHAR2(100)",null,null,"该节点有子节点吗？","HASCHILDREN","Boolean",1,null,"alndomainid","唯一ID","NUMBER",19]
["数量","SL","NUMBER(12)",null,null,"是否在报修中强制填写设备信息","ISBX","Boolean",1,null,"value","描述","VARCHAR2",100]
["品牌","BRAND","VARCHAR2(100)",null,null,"是否需要合格证","ISHGZ","Boolean",1]
["设备型号","SBXH","VARCHAR2(100)",null,null,"慧云是否使用","ISHY","Boolean",1]
["楼层","FLOOR","VARCHAR2(40)","位置序号、忽略",null,"计量单位","JLDW","VARCHAR2",30,null,"第三方检测事项配置视图V_GLSMS_DSFJCSXCFG"]
["安装位置","WZJC","VARCHAR2(160)",null,null,"语言列","LANGCODE","VARCHAR2",4,null,"中文描述","列名","类型","长度"]
["生产厂商","MANUFACTURER","VARCHAR2(100)",null,null,"组织标识","ORGID","VARCHAR2",8,null,"GLSMS_DSFJCSXCFGlineID","唯一ID","NUMBER",19]
["供应商","VENDOR ","VARCHAR2(100)",null,null,"父级类结构","PARENT","VARCHAR2",30,null,"jcsx","检测事项","VARCHAR2",100]
["服务商","FWS ","VARCHAR2(100)",null,null,"是否全面预算","SFQMYS","Boolean",1,null,"zgbm","主管部门","VARCHAR2",250]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"在资产拓扑查看器中显示","SHOWINASSETTOPO","Boolean",1,null,"jlsx","记录事项","VARCHAR2",250]
["位置内码","LOCATION","VARCHAR2(20)",null,null,"地点标识","SITEID","VARCHAR2",8]
["分类内码","CLASSSTRUCTUREID","VARCHAR2(30)",null,null,"序号","SN","NUMBER",12]
["变更时间","CHANGEDATE","DATE","增量",null,"活动","STATUS","VARCHAR2",30]
["唯一id","assetid","NUMBER(19)",null,null,"定义节点的类型。常用于“解决方案内容”、“资产分类”和“常见问题解答”等。","TYPE","VARCHAR2",10]
["设备全码","SBQM","VARCHAR2(100)",null,null,"是否在生成的描述中使用分类？","USECLASSINDESC","Boolean",1]
["设备全称","SBQC","VARCHAR2(200)",null,null,"是否用电设备","YDFL","VARCHAR2",30]
["设备原称","DESCRIPTION","VARCHAR2(200)",null,null,"专业","ZY","VARCHAR2",30]
["设备序号","SBXHH","VARCHAR2(30)",null,null,"重要性","ZYX","VARCHAR2",10]
["序号说明","XHSM","VARCHAR2(50)",null,null,"区分(如区分给水和排水)","DIFFERENCE","VARCHAR2(50)",50]
["物业类型","WYLX","VARCHAR2(30)",null,null,"所属系统","system","VARCHAR2",30]
["管理归属","SBGLGS","VARCHAR2(30)",null,null,"所属系统全码","systemqm","VARCHAR2",30]
["服务区域","FWQY","VARCHAR2(120)",null,null,"所属系统id","systemid","NUMBER",12]
["分类说明","BZ","VARCHAR2(1000)","分类表"]
["分类全称","CLASSQC","VARCHAR2(200)","分类表"]
["管理方式","GLFS","VARCHAR2(50)","分类表",null,"维保标准视图(日常、安全)V_GLSMS_WB_BZGL"]
["责任人","ZRR","VARCHAR2(20)",null,null,"中文描述","列名","类型","长度"]
["设备状态","SB_STATUS","VARCHAR2(30)",null,null,"应用名称","APPTYPE","VARCHAR2",10]
["待/已拆除时间","SB_STOPDATE","DATE",null,null,"版本","BB","NUMBER",12]
["设备完好度","SB_INTEGRITY","VARCHAR2(20)",null,null,"标准的重要等级","BZ","VARCHAR2",30]
["停用原因","SB_STOPCAUSE","VARCHAR2(20)",null,null,"供方合同标准分类","BZFL","VARCHAR2",30]
["计量单位","JLDW","VARCHAR2(30)",null,null,"运营中心","CENTER","NUMBER",12]
["设备类型","SBLX","VARCHAR2(30)",null,null,"变更时间","CHANGEDATE","DATE"]
["设备重要等级","SBZYDJ","VARCHAR2(30)",null,null,"创建人","CREATEBY","VARCHAR2",30]
["位置区域","WZQY","VARCHAR2(100)",null,null,"创建时间","CREATEDATE","DATE"]
["父设备内码","PARENT","VARCHAR2(20)",null,null,"描述","CUSTOM","VARCHAR2",50]
["父设备全码","PARENTSBQM","VARCHAR2(100)",null,null,"描述","DESCRIPTION","VARCHAR2",100]
["父设备全称","PARENTSBQC","VARCHAR2(200)",null,null,"审批时间","ENDDATE","DATE"]
["位置全称","S_WZQC","VARCHAR2(200)",null,null,"是否需要费用（全面预算）","ISCOST","VARCHAR2",10]
["位置id","LOCATIONSID","NUMBER(19)",null,null,"是否需要上传附件","ISDOCLINK","Boolean",1]
["备注","MARK","VARCHAR2(100)",null,null,"是否根据任务填写合格证到期日","ISDQR","VARCHAR2",5]
[{"$nulls":5},"是否随机拍照","ISPZ","Boolean",1]
["设备系统关系视图V_GLSMS_SYSTEMCFG ",{"$nulls":4},"对项目异常的扣分标准","KFVALUE","FLOAT",8]
["中文描述","列名","类型","备注",null,"是否区分广场开业年限","KYNX","Boolean",1]
["说明书系统编号","SMSXT","VARCHAR2（10）",null,null,"位置分类","LOCATIONFLID","NUMBER",19]
["说明书系统名称","SMSXTNAME","VARCHAR2（30）",null,null,"组织","ORGID","VARCHAR2",8]
["工程信息化系统编号","GCXXHXT","VARCHAR2（10）","唯一id",null,"区域","REGION","NUMBER",12]
["工程信息化系统编码","GCXXHXTNUM","VARCHAR2（20）",null,null,"地点","SITEID","VARCHAR2",20]
["工程信息化系统名称","GCXXHXTNAME","VARCHAR2（30）",null,null,"最后审批人","SPR","VARCHAR2",30]
[{"$nulls":5},"状态","STATUS","VARCHAR2",30]
["人员权限V_GLSMS_AUTH",{"$nulls":4},"生效时间","SXDATE","DATE"]
["中文描述","列名","类型","备注",null,"提前提醒（天）","TQTS","NUMBER",12]
["工程信息化人员id","employeecode ","VARCHAR2(30)",null,null,"标准版本号","VERSION","VARCHAR2",30]
["工程信息化ctx","username ","VARCHAR2(30)",null,null,"标准等级","WBLEVEL","VARCHAR2",15]
["权限","code","VARCHAR2(50)",null,null,"唯一ID","WB_BZGLID","NUMBER",19]
["权限说明","name ","VARCHAR2(50)",null,null,"编号","WB_BZGLNUM","VARCHAR2",50]
["唯一id","GLSMS_AUTHID","VARCHAR2(50)",null,null,"批准时间","XFDATE","DATE"]
[{"$nulls":5},"系统","XT","VARCHAR2",192]
["广场管理说明书上传完成视图V_GLSMS_UPWC",{"$nulls":4},"专业/系统","ZY","VARCHAR2",30]
["中文描述","列名","类型","备注",null,"专业/系统编号","ZYNUM","VARCHAR2",30]
["广场ID","SITEID","VARCHAR2(30)"]
["广场名称","GCNAME","VARCHAR2(30)"]

{"sheet":"项目概况","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8],[15,5,15,8]]}
["图片上传表V_GLSMS_PROIMGUP(项目概况图片/设备设施原理图/位置分布图/分水器支路分布明细/示意图/库房管理图)",{"$nulls":4},"施工单位信息v_glsms_construction"]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注"]
["唯一ID","GLSMS_PROIMGUPID","NUMBER(19)",null,null,"总包/分包","type","VARCHAR2(30)"]
["图片类型编码","typecode","number(4)","对应图片类型名称：1/2/3/4/5/6/7",null,"专业","professional ","VARCHAR2(30)"]
["图片类型名称","typename","VARCHAR2(100)","区位图/鸟瞰图/原理图/位置分布图/分水器支路分布明细图/示意图/库房管理图",null,"施工单位","unit ","VARCHAR2(200)"]
["图片名称","description","VARCHAR2(100)",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["序号","sn","NUMBER(12)",null,null,"版本","VERSION","VARCHAR2(10)"]
["上传人","upperson","VARCHAR2(30)",null,null,"版本状态","VERSTATUS","VARCHAR2(30)"]
["上传时间","uptime","DATE",null,null,"变更时间","CHANGEDATE","DATE"]
["布置图位置编号","location","VARCHAR2(30)",null,null,"唯一id","glsms_constructionid","NUMBER(19)"]
["楼层/位置名称","floor","VARCHAR2(30)","库房管理图用",null,"操作类型","OPERATE","VARCHAR2(50)"]
["所属系统","system","VARCHAR2(50)","支持配置多个系统",null,"联系人","lxr","VARCHAR2(150)"]
["图片地址","url","VARCHAR2(100)",null,null,"联系电话","lxdh","VARCHAR2(50)"]
["操作类型","OPERATE","VARCHAR2(50)"]
["变更时间","CHANGEDATE","DATE"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"建筑综合信息v_glsms_build"]
["版本","VERSION","VARCHAR2(10)",null,null,"中文描述","列名","类型","备注"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"项目","project","VARCHAR2(200)"]
["所属模块","MODULE","VARCHAR2(50)",null,null,"概况","basic ","VARCHAR2(500)"]
[{"$nulls":5},"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
[{"$nulls":5},"版本","VERSION","VARCHAR2(10)"]
[{"$nulls":5},"版本状态","VERSTATUS","VARCHAR2(30)"]
[{"$nulls":5},"变更时间","CHANGEDATE","DATE"]
[{"$nulls":5},"唯一id","glsms_buildid","NUMBER(19)"]
[{"$nulls":5},"操作类型","OPERATE","VARCHAR2(50)"]

{"sheet":"设备设施","index":4,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,3],[18,0,18,3],[34,0,34,3],[21,5,21,8],[0,5,0,8]]}
["低压柜及出线明细V_GLSMS_DYGJCXLINE",{"$nulls":4},"其它事项v_glsms_qtsx"]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注"]
["位置分布图ID","PROIMGUPID","NUMBER(19)","关联位置分布图",null,"位置编号","location"," VARCHAR2(50)"]
["抽屉编号","DRAWERNUM","VARCHAR2(100)",null,null,"位置名称","Description"," VARCHAR2(200)"]
["出线规格","OUTSPEC","VARCHAR2(100)",null,null,"内容","CONTENT"," VARCHAR2(1000)"]
["楼层","FLOOR","VARCHAR2(30)",null,null,"数量","SL","NUMBER(12)"]
["电井编号","WELLNUM","VARCHAR2(100)",null,null,"金额(万元)","ZFJE","NUMBER(16)"]
["电箱编号","BOXNUM","VARCHAR2(100)",null,null,"处理日期","HANDLEDATE","DATE"]
["供电容量（KW） ","CAPACITYNUM","VARCHAR2(100)",null,null,"处理结果","HANDLERESULTS","VARCHAR2(2000)"]
["控制回路","CONTROL ","VARCHAR2(200)",null,null,"资料存放位置","ZLWFWZ","VARCHAR2(500)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"记录日期","CREATEDATE","DATE"]
["版本","VERSION","VARCHAR2(10)",null,null,"操作类型","OPERATE","VARCHAR2(50)"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["变更时间","CHANGEDATE","DATE",null,null,"版本","VERSION","VARCHAR2(10)"]
["唯一id","GLSMS_DYGJCXLINEid","NUMBER(19)",null,null,"版本状态","VERSTATUS","VARCHAR2(30)"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"变更时间","CHANGEDATE","DATE"]
[{"$nulls":5},"唯一id","GLSMS_ZWQTSXID","NUMBER(19)"]
[{"$nulls":5},"管理说明书系统编号","SYSTEM","VARCHAR2(30)"]
["商铺范围清单V_GLSMS_shops",{"$nulls":4},"记录事项","JLSX","VARCHAR2(300)"]
["中文描述","列名","类型","备注"]
["唯一ID","GLSMS_shopsid","NUMBER(19)"]
["楼层编号"," Floornum","VARCHAR2(30)",null,null,"土建主要材料清单v_gcglsms_material"]
["楼层名称"," Floor ","VARCHAR2(100)",null,null,"中文描述","列名","类型","备注"]
["电井编号","wellnum","VARCHAR2(30)",null,null,"一级类别","CLASSA","VARCHAR2(50)"]
["电井名称","welldes","VARCHAR2(100)",null,null,"二级类别","category","VARCHAR2(100)"]
["商铺电表箱","meterbox","VARCHAR2(100)",null,null,"数量","sl","NUMBER(12)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"单位","unit","VARCHAR2(30)"]
["版本","VERSION","VARCHAR2(10)",null,null,"品牌","brand","VARCHAR2(100)"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"唯一ID","gcglsms_materialid","NUMBER(19)"]
["变更时间","CHANGEDATE","DATE",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"版本","VERSION","VARCHAR2(10)"]
[{"$nulls":5},"版本状态","VERSTATUS","VARCHAR2(30)"]
[{"$nulls":5},"变更时间","CHANGEDATE","DATE"]
[{"$nulls":5},"操作类型","OPERATE","VARCHAR2(50)"]
["商铺范围清单子表V_GLSMS_shopsline"]
["中文描述","列名","类型","备注"]
["商铺主表ID","GLSMS_shopsid","NUMBER(19)"]
["商铺编号","shopsnum","VARCHAR2(100)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["版本","VERSION","VARCHAR2(10)"]
["版本状态","VERSTATUS","VARCHAR2(30)"]
["变更时间","CHANGEDATE","DATE"]
["唯一id","GLSMS_shopslineid","NUMBER(19)"]
["操作类型","OPERATE","VARCHAR2(50)"]

{"sheet":"其它事项","index":5,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8],[18,0,18,3],[14,1,14,3]]}
["综合事项记录V_GLSMS_ZHSXJL",{"$nulls":4},"辅助用房调改变更记录V_GLSMS_fzyfchange"]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注"]
["变更时间","CHANGEDATE","DATE",null,null,"楼层","floor","VARCHAR2(30)"]
["日期","CREATEDATE","DATE",null,null,"调整前库房总数(间)","beforekf","NUMBER(12)"]
["部门","DEPARTMENT","VARCHAR2(50)",null,null,"新增库房(间)","xzkf","NUMBER(12)"]
["唯一ID","GLSMS_ZHSXJLID","NUMBER(19)",null,null,"减少库房(间)","jskf","NUMBER(12)"]
["其它部门说明","OTHERDESCRIPTION","VARCHAR2(200)",null,null,"区域","region","VARCHAR2(100)"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"面积","area","NUMBER(12)"]
["记录事项","RECORDSX","VARCHAR2(1000)",null,null,"调整后库房总数(间)","afterkf","NUMBER(12)"]
["广场ID","SITEID","VARCHAR2(30)","租赁系统广场id",null,"记录日期","RECORDTIME","DATE"]
["工作要求","WORKYQ","VARCHAR2(1000)",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["整改要求","ZGYQ","VARCHAR2(2000)",null,null,"版本","VERSION","VARCHAR2(10)"]
["版本","VERSION","VARCHAR2(10)",null,null,"版本状态","VERSTATUS","VARCHAR2(30)"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"变更时间","CHANGEDATE","DATE"]
["附件","查询V_GLSMS_ZHSXFJ附件视图条件（ownertable='GLSMS_ZHSXJL' AND OWNERID=GLSMS_ZHSXJLID）",null,null,null,"唯一id","GLSMS_fzyfchangeid","NUMBER(19)"]
[{"$nulls":5},"操作类型","OPERATE","VARCHAR2(50)"]
[]
[]
["综合事项附件视图V_GLSMS_ZHSXFJ"]
["中文描述","列名","类型","备注"]
["唯一ID","doclinksid","NUMBER(19)","doclinks"]
["创建人","CREATEBY ","VARCHAR2(30)","doclinks"]
["创建时间","CREATEDATE","date","doclinks增量字段"]
["该文档连接点的文档信息唯一标识","DOCINFOID","NUMBER(19)","doclinks"]
["类型","TYPE","VARCHAR2(30)","doclinks"]
["表名","OWNERTABLE","VARCHAR2(30)","doclinks"]
["表id","OWNERID","NUMBER(19)","doclinks"]
["文档地址","URLNAME","VARCHAR2(250)","docinfo"]
["文档类型的值","DOCTYPE","VARCHAR2(30)","docinfo"]
["文档名称","DESCRIPTION","VARCHAR2(260)","docinfo"]

{"sheet":"维修维保＆专维","index":6,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[43,6,43,9],[26,6,26,8],[26,11,26,13],[0,5,0,8],[0,10,0,13],[58,0,58,3],[0,0,0,3],[21,4,23,4],[49,0,49,1],[29,0,29,4],[27,1,27,3],[28,0,28,3]]}
["标准维修表v_glsms_wx",{"$nulls":4},"标准维保（说明书）表v_glsms_wbsms",{"$nulls":4},"标准维保（专业）表v_glsms_wbzy"]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注"]
["设备编号","ASSETNUM","VARCHAR2(20)","工单子表1",null,"设备编号","ASSETNUM","VARCHAR2(20)","工单子表1",null,"设备编号","ASSETNUM","VARCHAR2(20)","lx"]
["设备名称","sbmc","VARCHAR2(100)","设备简称",null,"设备名称","sbmc","VARCHAR2(100)","工单子表1",null,"设备名称","sbmc","VARCHAR2(100)","lx"]
["位置编号","location","VARCHAR2(20)",null,null,"工程信息化系统编号","GCXXHXT","VARCHAR2（10）","工单子表1",null,"异常工单编号","WONUM","VARCHAR2(10)","工单 "]
["位置名称","WZJC","VARCHAR2(100)",null,null,"工程信息化系统编码","GCXXHXTNUM","VARCHAR2（20）","工单子表1",null,"描述","DESCRIPTION","VARCHAR2(1000)","工单描述"]
["工程信息化系统编号","GCXXHXT","VARCHAR2（10）","工单子表1",null,"工程信息化系统名称","GCXXHXTNAME","VARCHAR2（30）","工单子表1",null,"填报人","REPORTEDBY","VARCHAR2(30)","工单 "]
["工程信息化系统编码","GCXXHXTNUM","VARCHAR2（20）","工单子表1",null,"工单编号","WONUM","VARCHAR2(10)","工单",null,"填报时间","REPORTDATE","DATE","工单 "]
["工程信息化系统名称","GCXXHXTNAME","VARCHAR2（30）","工单子表1",null,"唯一id","workorderid","NUMBER(19)","工单",null,"验收时间","SJJSSJ","DATE","工单 "]
["区分","DIFFERENCE","VARCHAR2(50)","区分,如区分给水和排水",null,"区分","DIFFERENCE","VARCHAR2(50)","区分,如区分给水和排水",null,"区分","DIFFERENCE","VARCHAR2(50)","区分,如区分给水和排水"]
["工单编号","WONUM","VARCHAR2(10)","工单",null,"工单状态","STATUS","VARCHAR2(30)","新建、待派工、已派工、待验收、验收通过\n待审批、已取消、工单执行退回\n问题待解决、执行中",null,"工单id","workorderid","NUMBER(19)","工单 "]
["修改时间","changedate","DATE","工单 增量字段",null,"修改时间","changedate","DATE","工单 增量字段"]
["唯一id","workorderid","NUMBER(19)","工单",null,"工单描述","DESCRIPTION","VARCHAR2(1000)","工单",null,"维保任务名称","WBRWMC","VARCHAR2(100)","rw"]
["工单描述","DESCRIPTION","VARCHAR2(1000)","工单",null,"填报人","REPORTEDBY","VARCHAR2(30)","工单",null,"维保任务编号","WB_GZGLID","NUMBER(12)","rw"]
["填报人","REPORTEDBY","VARCHAR2(30)","工单",null,"填报时间","REPORTDATE","DATE","工单",null,"执行人","ZXPERSON","VARCHAR2(30)","rw"]
["填报时间","REPORTDATE","DATE","工单",null,"验收时间","SJJSSJ","DATE","工单",null,"任务状态","STATUS2","VARCHAR2(30)","rw"]
["验收时间","SJJSSJ","DATE","工单",null,"报修单id","TICKETID","VARCHAR2(10)","工单子表2",null,"实际开始时间","SJKSSJ","DATE","rw"]
["工单状态","STATUS","VARCHAR2(30)","新建、待派工、已派工、待验收、验收通过\n待审批、已取消、工单执行退回\n问题待解决、执行中",null,"重要事项记录","MATTERS","VARCHAR2(300)","工单子表2",null,"实际完成时间","SJWCSJ","DATE","rw"]
["报修单id","TICKETID","VARCHAR2(10)","工单子表2",null,"是否更换配件","ISMODEL","NUMBER(1)","1代表是 0代表否",null,"实际工时(天)","SJCXSJT","NUMBER(16)","rw"]
["重要事项记录","MATTERS","VARCHAR2(300)","工单子表2",null,"配件名称型号","MODEL","VARCHAR2(100)","工单子表2",null,"实际工时(小时)","SJCXSJ"," NUMBER(16,2)","rw"]
["是否更换配件","ISMODEL","NUMBER(1)","1代表是 0代表否",null,"数量","SL","NUMBER(12)","工单子表2",null,"唯一id","wb_gzglbzid","NUMBER(19)"]
["配件名称型号","MODEL","VARCHAR2(100)","工单子表2",null,"费用（万元）","COST","VARCHAR2(30)","工单子表2",null,"重要事项记录","MATTERS","VARCHAR2(300)","项目描述"]
["数量","SL","NUMBER(12)","工单子表2",null,"费用出处","SOURCE","VARCHAR2(300)","工单子表2",null,"是否正常","ZT","VARCHAR2(10)"]
["费用（万元）","COST","VARCHAR2(30)","工单子表2",null,"维保任务编号","WB_GZGLID","NUMBER(12)","工单子表2",null,"变更时间","CHANGEDATE","DATE","项目实际完成时间、增量字段"]
["费用出处","SOURCE","VARCHAR2(300)","工单子表2",null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"表名","OWNERTABLE","VARCHAR2(10)","WORKORDER",null,"表名","OWNERTABLE","VARCHAR2(10)","WB_GZGLBZ"]
["表名","OWNERTABLE","VARCHAR2(10)","WORKORDER",null,"工单完工照片","查询v_glsms_image图片视图条件（ownertable='WORKORDER' AND OWNERID=WORKORDERID）",null,null,null,"现场照片","查询v_glsms_image图片视图条件（ownertable='WB_GZGLBZ' AND OWNERID=WB_GZGLBZID）"]
["工单完工照片","查询v_glsms_image图片视图条件（ownertable='WORKORDER' AND OWNERID=WORKORDERID）",null,null,null,"查询主表为workorder","只查询有设备的，只有设备类才能报 验收通过的",null,null,null,"报修单id","ticketid"," VARCHAR2(10)"]
["     查询主表为workorder,位置和设备的都包含，来源为非说明书维保的 验收通过的",{"$nulls":4},"来源为说明书维保的",{"$nulls":4},"工程信息化系统编号","GCXXHXT","VARCHAR2（10）"]
["标准专维表v_glsms_zw",{"$nulls":9},"工程信息化系统编码","GCXXHXTNUM","VARCHAR2（20）"]
["中文描述","列名","类型","备注","数据来源备注","程序流转顺序",{"$nulls":4},"工程信息化系统名称","GCXXHXTNAME","VARCHAR2（30）"]
["类别","LB","VARCHAR2(500)",null,"ZXWX专项维修基金使用范围明细表",1,{"$nulls":7},"只查询有设备的"]
["项目","XM","VARCHAR2(500)",null,"ZXWX专项维修基金使用范围明细表",1]
["说明书系统","SMSXT","VARCHAR2(50)","管理说明书中系统id","ZXWX专项维修基金使用范围明细表",1]
["区分","DIFFERENCE","VARCHAR2(50)","区分,如区分给水和排水","ZXWX专项维修基金使用范围明细表",1]
["数量","SL","NUMBER(10)","统计子表设备位置数量","GCZXWX_SBWZ广场专项维修设备位置表",1.1000000000000001]
["年度","ND","VARCHAR2(50)",null,"GCZXWX基金计划",2]
["期数","QS","VARCHAR2(20)",null,"GCZXWX基金计划",2]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id","GCZXWX_LINE基金计划明细",2.1]
["唯一id","GCZXWX_LINEID","NUMBER(19)",null,"GCZXWX_LINE基金计划明细",2.1]
["实施方案说明","SSFASM","VARCHAR2(4000)",null,"GCZXWX_LINE基金计划明细",2.1]
["费用说明","FYSM","VARCHAR2(4000)",null,"GCZXWX_LINE基金计划明细",2.1]
["项目说明","ZXSM","VARCHAR2(4000)",null,"GCZXWX_LINE基金计划明细",2.1]
["当前阶段","SXJD","VARCHAR2(30)","工程信息化叫事项阶段","GCZXWX_LINE基金计划明细",2.1,"维修维保图片视图v_glsms_image"]
["立项日期","LXSJWCSJ","DATE","招采立项实际完成时间","GCZXWX_LINE基金计划明细",2.1,"中文描述","列名","类型","备注"]
["验收日期","YSSJWCSJ","DATE","验收实际完成时间","GCZXWX_LINE基金计划明细",2.1,"创建人","CREATEBY ","VARCHAR2(30)"]
["结算金额","ZFJE","NUMBER(16,2)",null,"GCZXWX_LINE基金计划明细",2.1,"创建时间","CREATEDATE","date"]
["资料存放位置","ZLCFWZ ","VARCHAR2(500)","任务表新增字段","GCZXWX_RW任务填报",3,"该文档连接点的文档信息唯一标识","DOCINFO","NUMBER(19)"]
["验收结果","STATUS","VARCHAR2(30)",null,"GCZXWX_Rw任务填报",3,"类型","TYPE","VARCHAR2(30)"]
["全推，无条件",{"$nulls":5},"图片地址","URLNAME","VARCHAR2(250)"]
[{"$nulls":6},"文档类型的值","DOCTYPE","VARCHAR2(30)"]
[{"$nulls":6},"图片名称","DESCRIPTION","VARCHAR2(260)"]
[{"$nulls":6},"唯一ID","doclinksid","NUMBER(19)"]
[{"$nulls":6},"表名","OWNERTABLE","VARCHAR2(30)"]
[{"$nulls":6},"表id","OWNERID","NUMBER(19)"]
[]
[]
[]
["第三方检测任务视图v_glsms_dsfrw"]
["中文描述","列名","类型","备注"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["唯一ID","WB_GZGLID","NUMBER(19)"]
["任务名称","DESCRIPTION","VARCHAR2(100)"]
["状态","STATUS2"," VARCHAR2(30)"]
["主管部门","ZGBM"," VARCHAR2(250)"]
["检测结论","CONCLUSION","VARCHAR2(500)"]
["实际完成时间","SJWCSJ","DATE","增量字段"]