{ "currentVersion": 10.81, "id": 4, "name": "CA-", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACCOUNTID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID_OLD", "type": "esriFieldTypeString", "alias": "Identificador", "length": 20, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Fecha instalación", "length": 8, "domain": null }, { "name": "CRITICAL", "type": "esriFieldTypeSmallInteger", "alias": "Cliente Crítico", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Habilitado", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "Geometric Network Enabled domain", "codedValues": [ { "name": "Desactivado", "code": 0 }, { "name": "Activado", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACCOUNTID", "type": "esriFieldTypeString", "alias": "Código Abonado", "length": 500, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "NUMBER_RUTA", "type": "esriFieldTypeString", "alias": "Nº de Ruta", "length": 50, "domain": { "type": "codedValue", "name": "wRutaContador", "description": "Número de Ruta", "codedValues": [ { "name": "Ruta1", "code": "1" }, { "name": "Ruta2", "code": "2" }, { "name": "Ruta3", "code": "3" }, { "name": "Ruta4", "code": "4" }, { "name": "Ruta5", "code": "5" }, { "name": "Ruta6", "code": "6" }, { "name": "Ruta7", "code": "7" }, { "name": "Ruta8", "code": "8" }, { "name": "Ruta9", "code": "9" }, { "name": "Ruta10", "code": "10" }, { "name": "Ruta11", "code": "11" }, { "name": "Ruta12", "code": "12" }, { "name": "Ruta13", "code": "13" }, { "name": "Ruta14", "code": "14" }, { "name": "Ruta15", "code": "15" }, { "name": "Ruta16", "code": "16" }, { "name": "Ruta17", "code": "17" }, { "name": "Ruta18", "code": "18" }, { "name": "Ruta19", "code": "19" }, { "name": "Ruta20", "code": "20" }, { "name": "Ruta21", "code": "21" }, { "name": "Ruta22", "code": "22" }, { "name": "Ruta23", "code": "23" }, { "name": "Ruta24", "code": "24" }, { "name": "Ruta25", "code": "25" }, { "name": "Ruta26", "code": "26" }, { "name": "Ruta27", "code": "27" }, { "name": "Ruta28", "code": "28" }, { "name": "Ruta29", "code": "29" }, { "name": "Ruta30", "code": "30" }, { "name": "Ruta31", "code": "31" }, { "name": "Ruta32", "code": "32" }, { "name": "Ruta33", "code": "33" }, { "name": "Ruta34", "code": "34" }, { "name": "Ruta35", "code": "35" }, { "name": "Ruta36", "code": "36" }, { "name": "Ruta37", "code": "37" }, { "name": "Ruta38", "code": "38" }, { "name": "Ruta39", "code": "39" }, { "name": "Ruta40", "code": "40" }, { "name": "Ruta41", "code": "41" }, { "name": "Ruta42", "code": "42" }, { "name": "Ruta43", "code": "43" }, { "name": "Ruta44", "code": "44" }, { "name": "Ruta80", "code": "80" }, { "name": "Ruta81", "code": "81" }, { "name": "Ruta82", "code": "82" }, { "name": "Ruta777", "code": "777" }, { "name": "Ruta83", "code": "83" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "TIPOCONTADOR", "type": "esriFieldTypeString", "alias": "Tipo de Contador", "length": 50, "domain": { "type": "codedValue", "name": "wTipoContador", "description": "Tipo de contador", "codedValues": [ { "name": "Toma", "code": "T" }, { "name": "Paralelo", "code": "P" }, { "name": "Control", "code": "C" }, { "name": "General", "code": "G" }, { "name": "General nivel 1", "code": "G1" }, { "name": "General nivel 2", "code": "G2" }, { "name": "General nivel 3", "code": "G3" }, { "name": "General nivel 4", "code": "G4" }, { "name": "General nivel 5", "code": "G5" }, { "name": "General nivel 6", "code": "G6" }, { "name": "General nivel 7", "code": "G7" }, { "name": "General nivel 8", "code": "G8" }, { "name": "General nivel 9", "code": "G9" }, { "name": "General nivel 10", "code": "G10" }, { "name": "General Comunidad", "code": "Gc" }, { "name": "General Comunidad nivel 1", "code": "Gc1" }, { "name": "General Comunidad nivel 2", "code": "Gc2" }, { "name": "General Comunidad nivel 3", "code": "Gc3" }, { "name": "SercoGeneral Comunidad", "code": "SGc" }, { "name": "SercoGeneral Comunidad nivel 1", "code": "SGc1" }, { "name": "SercoGeneral Comunidad nivel 2", "code": "SGc2" }, { "name": "SercoGeneral Comunidad nivel 3", "code": "SGc3" }, { "name": "Divisionario Red", "code": "Dr" }, { "name": "Divisionario Comunidad", "code": "Dc" }, { "name": "Individual", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NOMBRE", "type": "esriFieldTypeString", "alias": "Nombre", "length": 300, "domain": null }, { "name": "DOMICILIO", "type": "esriFieldTypeString", "alias": "Domicilio", "length": 300, "domain": null }, { "name": "POBLACION", "type": "esriFieldTypeString", "alias": "Población", "length": 300, "domain": null }, { "name": "NUMCONTADOR", "type": "esriFieldTypeString", "alias": "Número Contador", "length": 100, "domain": null }, { "name": "ID_TIP", "type": "esriFieldTypeString", "alias": "ID_TIP", "length": 50, "domain": null }, { "name": "S_RUTA", "type": "esriFieldTypeString", "alias": "Nombre Ruta", "length": 100, "domain": null }, { "name": "CONTADOR_PADRE", "type": "esriFieldTypeString", "alias": "Código abonado_PADRE", "length": 50, "domain": null }, { "name": "C_LECTURA", "type": "esriFieldTypeString", "alias": "Código Lectura", "length": 50, "domain": null }, { "name": "B_ALTA", "type": "esriFieldTypeSmallInteger", "alias": "B_ALTA", "domain": null }, { "name": "S_VSLETRA", "type": "esriFieldTypeString", "alias": "S_VSLETRA", "length": 1, "domain": null }, { "name": "S_TELEFONO1", "type": "esriFieldTypeString", "alias": "S_TELEFONO1", "length": 9, "domain": null }, { "name": "S_TELEFONO2", "type": "esriFieldTypeString", "alias": "S_TELEFONO2", "length": 9, "domain": null }, { "name": "S_CLASECONTADOR", "type": "esriFieldTypeString", "alias": "S_CLASECONTADOR", "length": 100, "domain": null }, { "name": "S_CLASEABREV", "type": "esriFieldTypeString", "alias": "S_CLASEABREV", "length": 10, "domain": null }, { "name": "GRANDES_CONSUMIDORES", "type": "esriFieldTypeSmallInteger", "alias": "GRANDES_CONSUMIDORES", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "AncillaryRole", "type": "esriFieldTypeSmallInteger", "alias": "AncillaryRole", "domain": { "type": "codedValue", "name": "AncillaryRoleDomain", "description": "", "codedValues": [ { "name": "Ninguno", "code": 0 }, { "name": "Fuente", "code": 1 }, { "name": "Sumidero", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "S_EMAIL", "type": "esriFieldTypeString", "alias": "S_EMAIL", "length": 500, "domain": null }, { "name": "S_ACTIVIDAD", "type": "esriFieldTypeString", "alias": "S_ACTIVIDAD", "length": 40, "domain": null }, { "name": "PISO", "type": "esriFieldTypeSmallInteger", "alias": "PISO", "domain": null }, { "name": "OBRA", "type": "esriFieldTypeSmallInteger", "alias": "OBRA", "domain": null }, { "name": "BATERIA", "type": "esriFieldTypeSmallInteger", "alias": "BATERIA", "domain": null }, { "name": "SOLAR", "type": "esriFieldTypeSmallInteger", "alias": "SOLAR", "domain": null }, { "name": "PARCELA", "type": "esriFieldTypeSmallInteger", "alias": "PARCELA", "domain": null }, { "name": "DESHABITADA", "type": "esriFieldTypeSmallInteger", "alias": "DESHABITADA", "domain": null }, { "name": "INACCESIBLE", "type": "esriFieldTypeSmallInteger", "alias": "INACCESIBLE", "domain": null }, { "name": "INTERIOR", "type": "esriFieldTypeSmallInteger", "alias": "INTERIOR", "domain": null }, { "name": "OID_PADRE", "type": "esriFieldTypeInteger", "alias": "OID_PADRE", "domain": null }, { "name": "ELIMINAR", "type": "esriFieldTypeSmallInteger", "alias": "ELIMINAR", "domain": null }, { "name": "REF_FID_PADRE", "type": "esriFieldTypeString", "alias": "REF_FID_PADRE", "length": 20, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "S_ACCESO", "type": "esriFieldTypeString", "alias": "S_ACCESO", "length": 50, "domain": null }, { "name": "F_CONTADOR", "type": "esriFieldTypeDate", "alias": "Fecha Instalación Contador", "length": 8, "domain": null }, { "name": "FECHABAJA", "type": "esriFieldTypeDate", "alias": "Fecha Baja", "length": 8, "domain": null }, { "name": "CODIGO_GENERAL_ARBOL", "type": "esriFieldTypeString", "alias": "Código general Árbol", "length": 50, "domain": null }, { "name": "CODIGO_GENERAL_ARBOL_PADRE", "type": "esriFieldTypeString", "alias": "Código general Árbol_PADRE", "length": 50, "domain": null }, { "name": "TOMA_AGUA", "type": "esriFieldTypeString", "alias": "Toma de Agua", "length": 50, "domain": null }, { "name": "OBSERVACIONES_1", "type": "esriFieldTypeString", "alias": "Observaciones 1", "length": 50, "domain": null }, { "name": "OBSERVACIONES_2", "type": "esriFieldTypeString", "alias": "Observaciones 2", "length": 50, "domain": null }, { "name": "ACCOUNTID_ORI", "type": "esriFieldTypeString", "alias": "ACCOUNTID_ORI", "length": 500, "domain": null }, { "name": "ID_PERIODO", "type": "esriFieldTypeInteger", "alias": "Periodo", "domain": null }, { "name": "F_LECTURA", "type": "esriFieldTypeDate", "alias": "Fecha lectura", "length": 8, "domain": null }, { "name": "L_LECTURA", "type": "esriFieldTypeInteger", "alias": "Lectura", "domain": null }, { "name": "L_CONSUMO", "type": "esriFieldTypeInteger", "alias": "Consumo", "domain": null }, { "name": "S_INCIDENCIAS", "type": "esriFieldTypeString", "alias": "Incidencias", "length": 10, "domain": null }, { "name": "B_TS", "type": "esriFieldTypeSmallInteger", "alias": "B_TS", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "B_TD", "type": "esriFieldTypeSmallInteger", "alias": "B_TD", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "B_SOLOBASURA", "type": "esriFieldTypeSmallInteger", "alias": "B_SOLOBASURA", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "B_SOLOAGUA", "type": "esriFieldTypeSmallInteger", "alias": "B_SOLOAGUA", "domain": { "type": "codedValue", "name": "BooleanDomain", "description": "A 0/1 boolean domain", "codedValues": [ { "name": "Falso", "code": 0 }, { "name": "Cierto", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "S_TIPOTARIFACRS", "type": "esriFieldTypeString", "alias": "S_TIPOTARIFACRS", "length": 20, "domain": { "type": "codedValue", "name": "mTipoTarifaCRS", "description": "Tipo tarifa CRS", "codedValues": [ { "name": "No Facturar", "code": "No Facturar" }, { "name": "Doméstica", "code": "Doméstica" }, { "name": "No Doméstica", "code": "No Doméstica" }, { "name": "No Doméstica (NF)", "code": "No Doméstica (NF)" }, { "name": "Doméstica (2ªviv)", "code": "Doméstica (2ªviv)" }, { "name": "No Doméstica (2ªviv)", "code": "No Doméstica (2ªviv)" }, { "name": "No Doméstica (-20%)", "code": "No Doméstica (-20%)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "S_CONTRATO", "type": "esriFieldTypeString", "alias": "S_CONTRATO", "length": 25, "domain": null }, { "name": "F_CONTRATO", "type": "esriFieldTypeDate", "alias": "F_CONTRATO", "length": 8, "domain": null } ], "indexes": [ { "name": "R16296_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_16296", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1288080REF_FID_", "fields": "REF_FID_PADRE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_16296", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PuntosAcometida", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REF_FID_PADRE", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "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": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }