{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["视图清单","基础数据类","项目概况","设备设施","其它事项","维修维保＆专维"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[12,0,14,0],[15,0,19,0],[20,0,23,0],[24,0,29,0],[1,0,11,0]]}
["分类","视图","视图名称","推送方式","增量字段",null,"红色代表已完成"]
["基础数据视图","V_GLSMS_ASSET","位置台账视图","增量"]
[null,"V_GLSMS_LOCATION","设备台帐视图","增量"]
[null,"V_GLSMS_WZFL","位置分类视图","全量"]
[null,"V_GLSMS_CLASSSTRUCTURE","设备分类视图","全量"]
[null,"V_GLSMS_AUTH","人员权限视图","全量"]
[null,"V_GLSMS_UPWC","广场管理说明书上传完成视图","全量"]
[null,"V_GLSMS_WB_BZGL","维保标准视图(日常、安全)","全量"]
[null,"V_GLSMS_SYSTEMCFG ","设备系统关系视图","全量"]
[null,"V_GLSMS_CONFIGURING ","图片类型配置视图","全量"]
[null,"V_GCGLSMS_WXWBSX","维修维保事项配置主表视图","全量"]
[null,"V_GCGLSMS_WXWBSXLINE","维修维保事项配置子表视图","全量"]
["项目概况","V_GLSMS_PROIMGUP","图片上传视图","增量"]
[null,"V_GLSMS_CONSTRUCTION","施工单位信息视图","增量","CHANGEDATE"]
[null,"V_GLSMS_BUILD","建筑综合信息视图","增量","CHANGEDATE"]
["设备设施","V_GLSMS_DYGJCXLINE","低压出线柜明细视图","增量","CHANGEDATE"]
[null,"V_GLSMS_SHOPS","商铺范围清单视图","增量","CHANGEDATE"]
[null,"V_GLSMS_SHOPSLINE","商铺范围清单子表视图","增量","CHANGEDATE"]
[null,"V_GLSMS_QTSX","其它事项视图","增量","CHANGEDATE"]
[null,"V_GCGLSMS_MATERIAL","土建材料清单视图","增量","CHANGEDATE"]
["其他事项","V_GLSMS_ZHSXJL","综合事项记录视图","增量","CHANGEDATE"]
[null,"V_GLSMS_ZHSXFJ","综合事项附件视图","增量","CREATEDATE"]
[null,"V_GLSMS_GCFZYFHZ","广场辅助用房汇总统计视图","增量","CHANGEDATE"]
[null,"V_GLSMS_FZYFCHANGE","辅助用房调改变更记录视图","增量","CHANGEDATE"]
["维修维保/专维","V_GLSMS_WX","标准维修视图","增量","REPORTDATE"]
[null,"V_GLSMS_WBZY","标准维保（专业）视图","增量","CHANGEDATE"]
[null,"V_GLSMS_WBSMS","标准维保（说明书）视图","增量","REPORTDATE"]
[null,"V_GLSMS_IMAGE","维修维保图片视图","增量","CREATEDATE"]
[null,"V_GLSMS_ZW","标准专维视图","增量","SXJD"]
[null,"V_GLSMS_DSFRW","第三方检测任务视图","增量","SJWCSJ"]

{"sheet":"基础数据类","index":1,"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]]}
["位置台账表v_glsms_location",{"$nulls":4},"位置分类v_glsms_wzfl",{"$nulls":4},"图片类型配置视图V_GLSMS_CONFIGURING "]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","长度",null,"中文描述","列名","类型","长度"]
["位置内码","LOCATION","VARCHAR2(20)",null,null,"CHANGEDATE","修改时间","DATET",null,null,"GLSMS_CONFIGURINGID","唯一ID","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,"LOCATIONFLID","唯一ID","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},"位置分编号","LOCFL","NUMBER(19)"]
["变更时间","CHANGEDATE","DATE",null,null,"中文描述","列名","类型","长度",null,"位置分类名称","LOCFLDES","VARCHAR2(100)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"分类备注说明","BZ","VARCHAR2",1000,null,"位置内外","WZNW","VARCHAR2(10)"]
["唯一id","locationsid","NUMBER(19)",null,null,"标准数量","BZSL","VARCHAR2",10,null,"设备分类编号","CLASSSTRUCTUREID","VARCHAR2(30)"]
["是否是主力店","S_SFZLD","NUMBER(4)",null,null,"修改人","CHANGEBY","VARCHAR2",30,null,"设备分类全称","CLASSQC","VARCHAR2(200)"]
["位置责任人","ZRR","VARCHAR2(30)",null,null,"修改时间","CHANGEDATE","DATE ",null,null,"唯一ID","gcglsms_wxwbsxid","NUMBER(19)"]
[" 层高m（地面至吊顶的高度） ","CENGGAO","NUMBER(16,2)",null,null,"节点的分类标识","CLASSIFICATIONID","VARCHAR2",192,null,"说明书位置","smswz","VARCHAR2(100)"]
["面积㎡","MIANJI","NUMBER(16,2)",null,null,"分类全称","CLASSQC","VARCHAR2",200,null,"说明书设备","smsasset","VARCHAR2(100)"]
["备注","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)"]
["租赁系统楼层","FLOORNAME","VARCHAR2(30)",null,null,"描述所选资产类结构。","DESCRIPTION","VARCHAR2",100,null,"事项","matter","VARCHAR2(200)"]
[{"$nulls":5},"父级系统分类","FJXTFL","VARCHAR2",10,null,"所属系统","system","VARCHAR2(30)"]
["设备台账表v_glsms_asset",{"$nulls":4},"万达编码","FLBM","VARCHAR2",50,null,"序号","sn","VARCHAR2(10)"]
["中文描述","列名","类型","备注",null,"使用该类结构时是否生成资产描述？","GENASSETDESC","Boolean",1]
["设备内编码","ASSETNUM","VARCHAR2(20)",null,null,"是否关键设备","GJSB","Boolean",1]
["设备简称","SBJC","VARCHAR2(160)",null,null,"管控数量","GKSL","NUMBER",12]
["设备简码","SBJBM","VARCHAR2(100)",null,null,"管理方式","GLFS","VARCHAR2",50]
["数量","SL","NUMBER(12)",null,null,"该节点有子节点吗？","HASCHILDREN","Boolean",1]
["品牌","BRAND","VARCHAR2(100)",null,null,"是否在报修中强制填写设备信息","ISBX","Boolean",1]
["设备型号","SBXH","VARCHAR2(100)",null,null,"是否需要合格证","ISHGZ","Boolean",1]
["楼层","FLOOR","VARCHAR2(40)","位置序号",null,"慧云是否使用","ISHY","Boolean",1]
["安装位置","WZJC","VARCHAR2(160)",null,null,"计量单位","JLDW","VARCHAR2",30]
["生产厂商","MANUFACTURER","VARCHAR2(100)",null,null,"语言列","LANGCODE","VARCHAR2",4]
["供应商","VENDOR ","VARCHAR2(100)",null,null,"组织标识","ORGID","VARCHAR2",8]
["服务商","FWS ","VARCHAR2(100)",null,null,"父级类结构","PARENT","VARCHAR2",30]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"是否全面预算","SFQMYS","Boolean",1]
["位置内码","LOCATION","VARCHAR2(20)",null,null,"在资产拓扑查看器中显示","SHOWINASSETTOPO","Boolean",1]
["分类内码","CLASSSTRUCTUREID","VARCHAR2(30)",null,null,"地点标识","SITEID","VARCHAR2",8]
["变更时间","CHANGEDATE","DATE",null,null,"序号","SN","NUMBER",12]
["唯一id","assetid","NUMBER(19)",null,null,"活动","STATUS","VARCHAR2",30]
["设备全码","SBQM","VARCHAR2(100)",null,null,"定义节点的类型。常用于“解决方案内容”、“资产分类”和“常见问题解答”等。","TYPE","VARCHAR2",10]
["设备全称","SBQC","VARCHAR2(200)",null,null,"是否在生成的描述中使用分类？","USECLASSINDESC","Boolean",1]
["设备原称","DESCRIPTION","VARCHAR2(200)",null,null,"是否用电设备","YDFL","VARCHAR2",30]
["设备序号","SBXHH","VARCHAR2(30)",null,null,"专业","ZY","VARCHAR2",30]
["序号说明","XHSM","VARCHAR2(50)",null,null,"重要性","ZYX","VARCHAR2",10]
["物业类型","WYLX","VARCHAR2(30)",null,null,"区分(如区分给水和排水)","DIFFERENCE","VARCHAR2(50)",50]
["管理归属","SBGLGS","VARCHAR2(30)",null,null,"所属系统","system","VARCHAR2",30]
["服务区域","FWQY","VARCHAR2(120)",null,null,"所属系统全码","systemqm","VARCHAR2",30]
["分类说明","BZ","VARCHAR2(1000)","分类表",null,"所属系统id","systemid","NUMBER",12]
["分类全称","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）",null,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":2,"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,"中文描述","列名","类型","备注"]
["序号","sn","NUMBER(12)"]
["图片类型","type","VARCHAR2(100)","区位图/鸟瞰图/原理图/位置分布图/分水器支路分布明细图/示意图/库房管理图",null,"总包/分包","type","VARCHAR2(30)"]
["图片名称","descrption","VARCHAR2(100)",null,null,"专业","professional ","VARCHAR2(30)"]
["上传人","upperson","VARCHAR2(30)",null,null,"施工单位","unit ","VARCHAR2(200)"]
["上传时间","uptime","DATE",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["布置图位置编号","loction","VARCHAR2(30)",null,null,"版本","VERSION","VARCHAR2(10)"]
["所属系统","system","VARCHAR2(50)","支持配置多个系统",null,"版本状态","VERSTATUS","VARCHAR2(30)"]
["楼层/位置名称","floor","VARCHAR2(30)","库房管理图用",null,"变更时间","CHANGEDATE","DATE"]
["图片地址","url","VARCHAR2(100)",null,null,"唯一id","glsms_constructionid","NUMBER(19)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"操作类型","OPERATE","VARCHAR2(50)"]
["版本","VERSION","VARCHAR2(10)",null,null,"联系人","lxr","VARCHAR2(150)"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"联系电话","lxdh","VARCHAR2(50)"]
["变更时间","CHANGEDATE","DATE"]
["唯一ID","GLSMS_PPROIMGUPID","NUMBER(19)",null,null,"建筑综合信息v_glsms_build"]
["图片类型编码","tyepcode","number(4)","对应图片类型名称：1/2/3/4/5/6/7",null,"中文描述","列名","类型","备注"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"项目","project","VARCHAR2(200)"]
["所属模块",{"$nulls":4},"概况","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":3,"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],[19,5,19,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"]
["中文描述","列名","类型","备注",null,"土建主要材料清单v_gcglsms_material"]
["唯一ID","GLSMS_shopsid","NUMBER(19)",null,null,"中文描述","列名","类型","备注"]
["楼层编号"," Floornum","VARCHAR2(30)"]
["楼层名称"," Floor ","VARCHAR2(100)",null,null,"类别","category","VARCHAR2(100)"]
["电井编号","wellnum","VARCHAR2(30)",null,null,"数量","sl","NUMBER(12)"]
["电井名称","welldes","VARCHAR2(100)",null,null,"单位","unit","VARCHAR2(30)"]
["商铺电表箱","meterbox","VARCHAR2(100)",null,null,"品牌","brand","VARCHAR2(100)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"唯一ID","gcglsms_materialid","NUMBER(19)"]
["版本","VERSION","VARCHAR2(10)",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"版本","VERSION","VARCHAR2(10)"]
["变更时间","CHANGEDATE","DATE",null,null,"版本状态","VERSTATUS","VARCHAR2(30)"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"变更时间","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":4,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,3],[17,0,17,3],[0,5,0,8],[20,5,20,8],[31,1,31,3]]}
["广场辅助用房汇总统计表V_GLSMS_gcfzyfhz",{"$nulls":4},"辅助用房调改变更记录V_GLSMS_fzyfchange"]
["中文描述","列名","类型","备注",null,"中文描述","列名","类型","备注"]
["记录日期","RECORDTIME","DATE",null,null,"楼层","floor","VARCHAR2(30)"]
["楼层","floor","VARCHAR2(30)",null,null,"调整前库房总数(间)","beforekf","NUMBER(12)"]
["总间数","roomsl","NUMBER(12)",null,null,"新增库房(间)","xzkf","NUMBER(12)"]
["面积","area","NUMBER(12)",null,null,"减少库房(间)","jskf","NUMBER(12)"]
["唯一id","GLSMS_gcfzyfhzid","NUMBER(19)",null,null,"区域","region","VARCHAR2(100)"]
["变更时间","CHANGEDATE","DATE",null,null,"面积","area","NUMBER(12)"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"调整后库房总数(间)","afterkf","NUMBER(12)"]
["广场id","SITEID","VARCHAR2(30)","租赁系统广场id",null,"记录日期","RECORDTIME","DATE"]
["版本","VERSION","VARCHAR2(10)"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"广场id","SITEID","VARCHAR2(30)","租赁系统广场id"]
[{"$nulls":5},"版本","VERSION","VARCHAR2(10)"]
[{"$nulls":5},"版本状态","VERSTATUS","VARCHAR2(30)"]
[{"$nulls":5},"变更时间","CHANGEDATE","DATE"]
[{"$nulls":5},"唯一id","GLSMS_fzyfchangeid","NUMBER(19)"]
[{"$nulls":5},"操作类型","OPERATE","VARCHAR2(50)"]
["综合事项记录V_GLSMS_ZHSXJL"]
["中文描述","列名","类型","备注"]
["变更时间","CHANGEDATE","DATE"]
["日期","CREATEDATE","DATE",null,null,"综合事项附件视图V_GLSMS_ZHSXFJ"]
["部门","DEPARTMENT","VARCHAR2(50)",null,null,"中文描述","列名","类型","备注"]
["唯一ID","GLSMS_ZHSXJLID","NUMBER(19)",null,null,"唯一ID","doclinksid","NUMBER(19)","doclinks"]
["其它部门说明","OTHERDESCRIPTION","VARCHAR2(200)",null,null,"创建人","CREATEBY ","VARCHAR2(30)","doclinks"]
["操作类型","OPERATE","VARCHAR2(50)",null,null,"创建时间","CREATEDATE","date","doclinks增量字段"]
["记录事项","RECORDSX","VARCHAR2(1000)",null,null,"该文档连接点的文档信息唯一标识","DOCINFOID","NUMBER(19)","doclinks"]
["广场ID","SITEID","VARCHAR2(30)","租赁系统广场id",null,"类型","TYPE","VARCHAR2(30)","doclinks"]
["工作要求","WORKYQ","VARCHAR2(1000)",null,null,"表名","OWNERTABLE","VARCHAR2(30)","doclinks"]
["整改要求","ZGYQ","VARCHAR2(2000)",null,null,"表id","OWNERID","NUMBER(19)","doclinks"]
["版本","VERSION","VARCHAR2(10)",null,null,"文档地址","URLNAME","VARCHAR2(250)","docinfo"]
["版本状态","VERSTATUS","VARCHAR2(30)",null,null,"文档类型的值","DOCTYPE","VARCHAR2(30)","docinfo"]
["附件","查询V_GLSMS_ZHSXFJ附件视图条件（ownertable='GLSMS_ZHSXJL' AND OWNERID=GLSMS_ZHSXJLID）",null,null,null,"文档名称","DESCRIPTION","VARCHAR2(260)","docinfo"]

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