{ "currentVersion": 10.81, "id": 28, "name": "SIGELEC.CONEXIONCONSUMIDOR", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "USUARIOREGISTRO", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "CODIGOCLIENTE", "type": "esriFieldTypeString", "alias": "Codigo", "length": 8 }, { "name": "PROYECTOCONSTRUCCION", "type": "esriFieldTypeString", "alias": "PROYECTOCONSTRUCCION", "length": 32 }, { "name": "FECHACONSTRUCCION", "type": "esriFieldTypeDate", "alias": "FECHACONSTRUCCION", "length": 8 }, { "name": "NOVEDADES", "type": "esriFieldTypeSmallInteger", "alias": "Novedades" }, { "name": "CODRUT", "type": "esriFieldTypeString", "alias": "Agencia_Ruta", "length": 9 }, { "name": "MDENUMFAB", "type": "esriFieldTypeString", "alias": "N. Serie Medidor", "length": 50 }, { "name": "MDENUMEMP", "type": "esriFieldTypeString", "alias": "SR del Medidor", "length": 50 }, { "name": "CODIGOUNICO", "type": "esriFieldTypeString", "alias": "Código Único", "length": 10 }, { "name": "SECUENCIAFASE", "type": "esriFieldTypeString", "alias": "Fase de Bajo Voltaje", "length": 3 }, { "name": "MEDMAR", "type": "esriFieldTypeString", "alias": "Marca", "length": 3 }, { "name": "TIPOMEDIDOR", "type": "esriFieldTypeString", "alias": "Tipo Medidor", "length": 30 }, { "name": "PREPAGO", "type": "esriFieldTypeString", "alias": "Prepago", "length": 2 }, { "name": "CODIGOESTRUCTURA", "type": "esriFieldTypeString", "alias": "Codigo Estructua", "length": 10 }, { "name": "FECHAMODIFICACION", "type": "esriFieldTypeDate", "alias": "Fecha Modificacion", "length": 8 }, { "name": "CODIGOEMPRESA", "type": "esriFieldTypeString", "alias": "Codigo Empresa", "length": 10 }, { "name": "PROYECTOMODIFICACION", "type": "esriFieldTypeString", "alias": "Proyecto Modificacion", "length": 32 }, { "name": "OBSERVACIONES", "type": "esriFieldTypeString", "alias": "Observaciones", "length": 255 }, { "name": "COMENTARIOS", "type": "esriFieldTypeString", "alias": "Comentarios", "length": 255 }, { "name": "PROVINCIA", "type": "esriFieldTypeString", "alias": "Provincia", "length": 2 }, { "name": "CANTON", "type": "esriFieldTypeString", "alias": "Canton", "length": 4 }, { "name": "PARROQUIA", "type": "esriFieldTypeString", "alias": "Parroquia", "length": 6 }, { "name": "ORDENTRABAJO", "type": "esriFieldTypeString", "alias": "Orden de trabajo", "length": 50 }, { "name": "CIRCUITOS", "type": "esriFieldTypeString", "alias": "Circuitos", "length": 3 }, { "name": "ESTADO", "type": "esriFieldTypeSmallInteger", "alias": "Estdo" }, { "name": "EXISTENOVEDAD", "type": "esriFieldTypeSmallInteger", "alias": "Existe Novedad" } ], "indexes": [ { "name": "G171CODIGOUNICO", "fields": "CODIGOUNICO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I171CODIGOCLIENT", "fields": "CODIGOCLIENTE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R25_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 30, "name": "Punto Carga", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "PUNTOCARGAGLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 41, "name": "ATRIBUTOSCONSUMIDOR", "relatedTableId": 27, "role": "esriRelRoleDestination", "keyField": "CODIGOUNICO", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "serviceItemId": "5683ed4881b945ec8ed8568b66765570" }