{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 23, "name": "ATRIBUTOSCONSUMIDOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SIGELEC.ATRIBUTOSCONSUMIDOR.CODIGOCLIENTE", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID" }, { "name": "CLITOTDEU", "type": "esriFieldTypeDouble", "alias": "Valor Deuda" }, { "name": "CLIFECULTP", "type": "esriFieldTypeDate", "alias": "Fecha Ultimo Pago", "length": 8 }, { "name": "CLIULTCONM", "type": "esriFieldTypeInteger", "alias": "Ultimo Consumo Mes (Kwh)" }, { "name": "CLIULTCONP", "type": "esriFieldTypeDouble", "alias": "Consumo Diario Promedio (Kwh)" }, { "name": "CLINUMPOS", "type": "esriFieldTypeString", "alias": "Numero de Poste", "length": 16 }, { "name": "CLIFECINS", "type": "esriFieldTypeDate", "alias": "Fecha Instalacion", "length": 8 }, { "name": "EDCCOD", "type": "esriFieldTypeString", "alias": "Estado del Servicio", "length": 1 }, { "name": "CDAFAS", "type": "esriFieldTypeSmallInteger", "alias": "Numero de Fases" }, { "name": "CDACON", "type": "esriFieldTypeSmallInteger", "alias": "Numero de Conductores" }, { "name": "USOCOD", "type": "esriFieldTypeString", "alias": "Codigo Uso Energia", "length": 2 }, { "name": "CALDES", "type": "esriFieldTypeString", "alias": "Calle", "length": 255 }, { "name": "CLIPRVCOD", "type": "esriFieldTypeString", "alias": "Provincia", "length": 2 }, { "name": "CLICANCOD", "type": "esriFieldTypeString", "alias": "Canton", "length": 4 }, { "name": "CLIPARCOD", "type": "esriFieldTypeString", "alias": "Parroquia", "length": 6 }, { "name": "CLIFECULT", "type": "esriFieldTypeDate", "alias": "Fecha Facturación", "length": 8 }, { "name": "TIPOMEDIDOR", "type": "esriFieldTypeString", "alias": "Tipo Medidor", "length": 30 }, { "name": "POTENCIAACTIVA", "type": "esriFieldTypeDouble", "alias": "Potencia Activa" }, { "name": "POTENCIAREACTIVA", "type": "esriFieldTypeDouble", "alias": "Potencia Reactiva" }, { "name": "CATEGORIA", "type": "esriFieldTypeString", "alias": "Categoria", "length": 4 }, { "name": "PAQUETE", "type": "esriFieldTypeString", "alias": "Paquete", "length": 20 }, { "name": "TELEFONO", "type": "esriFieldTypeString", "alias": "Telefono", "length": 30 }, { "name": "CELULAR", "type": "esriFieldTypeString", "alias": "Celular", "length": 30 }, { "name": "ES_BDH", "type": "esriFieldTypeString", "alias": "Es BDH", "length": 1 }, { "name": "AGENCIA", "type": "esriFieldTypeString", "alias": "Agencia", "length": 14 }, { "name": "TASABASURA", "type": "esriFieldTypeDouble", "alias": "Tasa Basura" }, { "name": "CONSUMOPROMEDIO", "type": "esriFieldTypeDouble", "alias": "Consumo Promedio" }, { "name": "ESTADOEXTENDIDO", "type": "esriFieldTypeString", "alias": "Estado Extendido", "length": 2 }, { "name": "FECHAPRIMERAINSTALACION", "type": "esriFieldTypeDate", "alias": "Fecha Primera Inst.", "length": 8 }, { "name": "TIPOTARIFA", "type": "esriFieldTypeString", "alias": "Tipo Tarifa", "length": 10 }, { "name": "ESTADO", "type": "esriFieldTypeString", "alias": "Estado", "length": 1 }, { "name": "CUENTACONTRATO", "type": "esriFieldTypeString", "alias": "Cuenta Contrato", "length": 50 }, { "name": "CODIGOEMPRESA", "type": "esriFieldTypeString", "alias": " Empresa", "length": 10 }, { "name": "CLINOMABR", "type": "esriFieldTypeString", "alias": "NOMBRES", "length": 125 }, { "name": "CODIGOCLIENTE", "type": "esriFieldTypeString", "alias": "Codigo Cliente", "length": 8 }, { "name": "CODIGOUNICO", "type": "esriFieldTypeString", "alias": "Cuenta", "length": 20 }, { "name": "CRITICIDAD", "type": "esriFieldTypeString", "alias": "Criticidad", "length": 1 }, { "name": "DISCAPACIDAD", "type": "esriFieldTypeString", "alias": "Discapacidad", "length": 1 }, { "name": "EMAIL", "type": "esriFieldTypeString", "alias": "Email", "length": 255 }, { "name": "IDCCEDRUC", "type": "esriFieldTypeString", "alias": "RUC Cliente", "length": 20 }, { "name": "MDMCOD", "type": "esriFieldTypeString", "alias": "Código Marca Medidor", "length": 20 }, { "name": "NIVTENSION", "type": "esriFieldTypeString", "alias": "Nivel Tension", "length": 10 }, { "name": "NUMMEDIDOR", "type": "esriFieldTypeString", "alias": "Numero de Medidor", "length": 20 } ], "indexes": [ { "name": "G175CODIGOUNICO", "fields": "CODIGOUNICO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R29_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 62, "name": "CONEXIONCONSUMIDOR", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "CODIGOUNICO", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "199334d4d4af4bc5baa69e3253bf1844" }