{ "currentVersion": 10.81, "id": 22, "name": "Datos de Clientes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CODIGOCLIENTE", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "Object ID" }, { "name": "CODIGOCLIENTE", "type": "esriFieldTypeString", "alias": "Codigo Cliente", "length": 8 }, { "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": "NUMMEDIDOR", "type": "esriFieldTypeString", "alias": "Numero de Medidor", "length": 20 }, { "name": "MDMCOD", "type": "esriFieldTypeString", "alias": "Codigo Marca Medidor", "length": 20 }, { "name": "CLISLCCOD", "type": "esriFieldTypeString", "alias": "Ruta Sector", "length": 20 }, { "name": "CLISECINM", "type": "esriFieldTypeString", "alias": "Ruta Secuenca", "length": 20 }, { "name": "CLIRLSCOD", "type": "esriFieldTypeString", "alias": "Ruta Numero", "length": 20 }, { "name": "NIVTENSION", "type": "esriFieldTypeString", "alias": "Nivel Tension", "length": 10 }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38 }, { "name": "PAQUETE", "type": "esriFieldTypeString", "alias": "PAQUETE", "length": 20 }, { "name": "CRITICIDAD", "type": "esriFieldTypeString", "alias": "CRITICIDAD", "length": 1 }, { "name": "CODIGOUNICO", "type": "esriFieldTypeString", "alias": "CODIGOUNICO", "length": 20 }, { "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": "CATEGORIA", "type": "esriFieldTypeString", "alias": "Categoría", "length": 4 }, { "name": "POTENCIAREACTIVA", "type": "esriFieldTypeDouble", "alias": "Potencia Reactiva" }, { "name": "ES_BDH", "type": "esriFieldTypeString", "alias": "Es DBH", "length": 1 }, { "name": "TASABASURA", "type": "esriFieldTypeDouble", "alias": "Tasa de Basura" }, { "name": "AGENCIA", "type": "esriFieldTypeString", "alias": "Agencia", "length": 14 }, { "name": "CONSUMOPROMEDIO", "type": "esriFieldTypeDouble", "alias": "Consumo Promedio" }, { "name": "ESTADOEXTENDIDO", "type": "esriFieldTypeString", "alias": "Estado Extendido", "length": 2 }, { "name": "FECHAPRIMERAINSTALACION", "type": "esriFieldTypeDate", "alias": "Fec. Primera Inst.", "length": 8 }, { "name": "FACTORMULT", "type": "esriFieldTypeString", "alias": "Tiene Fact.Mult.", "length": 50 }, { "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 } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G212CODIGOUNICO", "fields": "CODIGOUNICO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G212CODIGOCLIENT", "fields": "CODIGOCLIENTE", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 44, "name": "SIGELEC.CONEXIONCONSUMIDOR", "relatedTableId": 25, "role": "esriRelRoleOrigin", "keyField": "CODIGOUNICO", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }