{ "currentVersion": 10.71, "id": 9, "name": "INTEGRACION.I_CLIENT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME_CLIENT", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "COMPANY", "type": "esriFieldTypeString", "alias": "COMPANY", "length": 255, "domain": null }, { "name": "ID_SERVICE", "type": "esriFieldTypeDouble", "alias": "ID_SERVICE", "domain": null }, { "name": "FACILITY_ID", "type": "esriFieldTypeString", "alias": "FACILITY_ID", "length": 100, "domain": null }, { "name": "GID_CLIENT", "type": "esriFieldTypeString", "alias": "GID_CLIENT", "length": 50, "domain": null }, { "name": "ID_CLIENT", "type": "esriFieldTypeDouble", "alias": "ID_CLIENT", "domain": null }, { "name": "NAME_CLIENT", "type": "esriFieldTypeString", "alias": "NAME_CLIENT", "length": 100, "domain": null }, { "name": "ROAD_CENTER_LINE_INST", "type": "esriFieldTypeString", "alias": "ROAD_CENTER_LINE_INST", "length": 255, "domain": null }, { "name": "ADDRESS_POINT_INST", "type": "esriFieldTypeString", "alias": "ADDRESS_POINT_INST", "length": 255, "domain": null }, { "name": "INF_ADITIONAL_INST", "type": "esriFieldTypeString", "alias": "INF_ADITIONAL_INST", "length": 255, "domain": null }, { "name": "FULLADDR_SGC", "type": "esriFieldTypeString", "alias": "FULLADDR_SGC", "length": 255, "domain": null }, { "name": "ID_BLOCK", "type": "esriFieldTypeString", "alias": "ID_BLOCK", "length": 255, "domain": null }, { "name": "DV_SERVICE", "type": "esriFieldTypeString", "alias": "DV_SERVICE", "length": 255, "domain": null }, { "name": "NAME_SECTOR", "type": "esriFieldTypeString", "alias": "NAME_SECTOR", "length": 255, "domain": null }, { "name": "NAME_CLASP_SERVICE", "type": "esriFieldTypeString", "alias": "NAME_CLASP_SERVICE", "length": 255, "domain": null }, { "name": "NAME_CLASS_SERVICE", "type": "esriFieldTypeString", "alias": "NAME_CLASS_SERVICE", "length": 255, "domain": null }, { "name": "B_COMPANY", "type": "esriFieldTypeString", "alias": "B_COMPANY", "length": 255, "domain": null }, { "name": "SAFEWATER", "type": "esriFieldTypeDouble", "alias": "SAFEWATER", "domain": null }, { "name": "SEWAGE", "type": "esriFieldTypeDouble", "alias": "SEWAGE", "domain": null }, { "name": "ID_BANK_PAC", "type": "esriFieldTypeDouble", "alias": "ID_BANK_PAC", "domain": null }, { "name": "NAME_STATUS_ACTIVATION", "type": "esriFieldTypeString", "alias": "NAME_STATUS_ACTIVATION", "length": 255, "domain": null }, { "name": "NAME_STATUS_BILLING", "type": "esriFieldTypeString", "alias": "NAME_STATUS_BILLING", "length": 255, "domain": null }, { "name": "TOTAL_DEBT", "type": "esriFieldTypeDouble", "alias": "TOTAL_DEBT", "domain": null }, { "name": "EXPIRED_DEBT", "type": "esriFieldTypeDouble", "alias": "EXPIRED_DEBT", "domain": null }, { "name": "AGREED_DEBT", "type": "esriFieldTypeDouble", "alias": "AGREED_DEBT", "domain": null }, { "name": "CUSTOMER_DATE", "type": "esriFieldTypeDouble", "alias": "CUSTOMER_DATE", "domain": null }, { "name": "OUTAGE_STATUS", "type": "esriFieldTypeString", "alias": "OUTAGE_STATUS", "length": 255, "domain": null }, { "name": "DEBT_DATA", "type": "esriFieldTypeString", "alias": "DEBT_DATA", "length": 20, "domain": null }, { "name": "STRATEGIC_CLIENT", "type": "esriFieldTypeDouble", "alias": "STRATEGIC_CLIENT", "domain": null }, { "name": "CRITICAL", "type": "esriFieldTypeDouble", "alias": "CRITICAL", "domain": null }, { "name": "HISTORY_FRAUD_CLIENT", "type": "esriFieldTypeDouble", "alias": "HISTORY_FRAUD_CLIENT", "domain": null }, { "name": "SHEET_SOCIAL_PINTS", "type": "esriFieldTypeDouble", "alias": "SHEET_SOCIAL_PINTS", "domain": null }, { "name": "SUBSIDY", "type": "esriFieldTypeDouble", "alias": "SUBSIDY", "domain": null }, { "name": "RANGE_SUBSIDY", "type": "esriFieldTypeString", "alias": "RANGE_SUBSIDY", "length": 30, "domain": null }, { "name": "WSERVICECON_NUM", "type": "esriFieldTypeDouble", "alias": "WSERVICECON_NUM", "domain": null }, { "name": "LAST_READING_DATE", "type": "esriFieldTypeString", "alias": "LAST_READING_DATE", "length": 20, "domain": null }, { "name": "LAST_READING", "type": "esriFieldTypeDouble", "alias": "LAST_READING", "domain": null }, { "name": "LAST_READING_PRESENT", "type": "esriFieldTypeDouble", "alias": "LAST_READING_PRESENT", "domain": null }, { "name": "EXPIRATION_INVOICE_DATE", "type": "esriFieldTypeString", "alias": "EXPIRATION_INVOICE_DATE", "length": 20, "domain": null }, { "name": "CONSUMPTION_AVERAGE", "type": "esriFieldTypeDouble", "alias": "CONSUMPTION_AVERAGE", "domain": null }, { "name": "CONVENTION", "type": "esriFieldTypeString", "alias": "CONVENTION", "length": 30, "domain": null }, { "name": "REQUIREMENT_STATUS", "type": "esriFieldTypeDouble", "alias": "REQUIREMENT_STATUS", "domain": null }, { "name": "REQUIREMENT_NUM", "type": "esriFieldTypeDouble", "alias": "REQUIREMENT_NUM", "domain": null }, { "name": "FRAUD_TYPE", "type": "esriFieldTypeString", "alias": "FRAUD_TYPE", "length": 255, "domain": null }, { "name": "SERVICE_TRONCAL_ID", "type": "esriFieldTypeDouble", "alias": "SERVICE_TRONCAL_ID", "domain": null }, { "name": "NAME_ROUTE", "type": "esriFieldTypeString", "alias": "NAME_ROUTE", "length": 255, "domain": null }, { "name": "ROUTE_ORDER", "type": "esriFieldTypeDouble", "alias": "ROUTE_ORDER", "domain": null }, { "name": "SECTOR_LOT", "type": "esriFieldTypeInteger", "alias": "SECTOR_LOT", "domain": null }, { "name": "TARIFF_NAME", "type": "esriFieldTypeString", "alias": "TARIFF_NAME", "length": 255, "domain": null }, { "name": "PAC_HAVE", "type": "esriFieldTypeDouble", "alias": "PAC_HAVE", "domain": null }, { "name": "NAME_INSTALATION_TYPE", "type": "esriFieldTypeString", "alias": "NAME_INSTALATION_TYPE", "length": 255, "domain": null }, { "name": "INSTALATION_DATE", "type": "esriFieldTypeString", "alias": "INSTALATION_DATE", "length": 20, "domain": null }, { "name": "NAME_SERVICE_TYPE", "type": "esriFieldTypeString", "alias": "NAME_SERVICE_TYPE", "length": 255, "domain": null }, { "name": "FANTASY_NAME", "type": "esriFieldTypeString", "alias": "FANTASY_NAME", "length": 255, "domain": null }, { "name": "DIRECT_PHONE", "type": "esriFieldTypeString", "alias": "DIRECT_PHONE", "length": 15, "domain": null }, { "name": "MOBILE", "type": "esriFieldTypeString", "alias": "MOBILE", "length": 15, "domain": null }, { "name": "MAIL", "type": "esriFieldTypeString", "alias": "MAIL", "length": 255, "domain": null }, { "name": "DIAMETER_LATERAL_LINE", "type": "esriFieldTypeDouble", "alias": "DIAMETER_LATERAL_LINE", "domain": null }, { "name": "DIAMETER_UD", "type": "esriFieldTypeDouble", "alias": "DIAMETER_UD", "domain": null }, { "name": "DIAMETER_MEDIDOR", "type": "esriFieldTypeDouble", "alias": "DIAMETER_MEDIDOR", "domain": null }, { "name": "LATERAL_LINE_MATERIAL", "type": "esriFieldTypeString", "alias": "LATERAL_LINE_MATERIAL", "length": 255, "domain": null }, { "name": "METER_TYPE", "type": "esriFieldTypeString", "alias": "METER_TYPE", "length": 255, "domain": null }, { "name": "UTM_NORTE", "type": "esriFieldTypeDouble", "alias": "UTM_NORTE", "domain": null }, { "name": "UTM_ESTE", "type": "esriFieldTypeDouble", "alias": "UTM_ESTE", "domain": null }, { "name": "LOCALITY", "type": "esriFieldTypeString", "alias": "LOCALITY", "length": 255, "domain": null }, { "name": "SSERVICECON_ID", "type": "esriFieldTypeDouble", "alias": "SSERVICECON_ID", "domain": null }, { "name": "WSERVICECON_ID", "type": "esriFieldTypeDouble", "alias": "WSERVICECON_ID", "domain": null }, { "name": "CLIENT_TYPE", "type": "esriFieldTypeString", "alias": "CLIENT_TYPE", "length": 255, "domain": null }, { "name": "READING_KEY", "type": "esriFieldTypeString", "alias": "READING_KEY", "length": 255, "domain": null }, { "name": "ACTIVITY", "type": "esriFieldTypeString", "alias": "ACTIVITY", "length": 255, "domain": null }, { "name": "READING_LOT", "type": "esriFieldTypeString", "alias": "READING_LOT", "length": 255, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "B_PR019", "type": "esriFieldTypeSmallInteger", "alias": "B_PR019", "domain": null }, { "name": "WATERMIND_CLIENT", "type": "esriFieldTypeSmallInteger", "alias": "WATERMIND_CLIENT", "domain": null }, { "name": "GREAT_CONSUMPTION_CLIENT", "type": "esriFieldTypeSmallInteger", "alias": "GREAT_CONSUMPTION_CLIENT", "domain": null }, { "name": "NUM_SOL_ACT_GIS", "type": "esriFieldTypeDouble", "alias": "NUM_SOL_ACT_GIS", "domain": null }, { "name": "MARCA", "type": "esriFieldTypeString", "alias": "MARCA", "length": 255, "domain": null }, { "name": "MODELO", "type": "esriFieldTypeString", "alias": "MODELO", "length": 255, "domain": null }, { "name": "B_TELELECTURA", "type": "esriFieldTypeSmallInteger", "alias": "B_TELELECTURA", "domain": null }, { "name": "ULTIMA_CONEXION", "type": "esriFieldTypeDate", "alias": "ULTIMA_CONEXION", "length": 8, "domain": null }, { "name": "B_BAJA_TEMPERATURA", "type": "esriFieldTypeSmallInteger", "alias": "B_BAJA_TEMPERATURA", "domain": null }, { "name": "B_FUGA", "type": "esriFieldTypeSmallInteger", "alias": "B_FUGA", "domain": null }, { "name": "B_EXPLOSION", "type": "esriFieldTypeSmallInteger", "alias": "B_EXPLOSION", "domain": null }, { "name": "B_FLUJO_INVERTIDO", "type": "esriFieldTypeSmallInteger", "alias": "B_FLUJO_INVERTIDO", "domain": null }, { "name": "B_SECO", "type": "esriFieldTypeSmallInteger", "alias": "B_SECO", "domain": null }, { "name": "B_MANIPULACION", "type": "esriFieldTypeSmallInteger", "alias": "B_MANIPULACION", "domain": null }, { "name": "B_PERMANENTE", "type": "esriFieldTypeSmallInteger", "alias": "B_PERMANENTE", "domain": null }, { "name": "B_BATERIA", "type": "esriFieldTypeSmallInteger", "alias": "B_BATERIA", "domain": null }, { "name": "FECHA_ALERTA", "type": "esriFieldTypeDate", "alias": "FECHA_ALERTA", "length": 8, "domain": null }, { "name": "DIAS_ULTIMA_CONEXION", "type": "esriFieldTypeInteger", "alias": "DIAS_ULTIMA_CONEXION", "domain": null } ], "indexes": [ { "name": "CLIENT_IDSERV", "fields": "ID_SERVICE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ICLIENT_GIDCLIENT", "fields": "GID_CLIENT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "NDX_CLIENT", "fields": "COMPANY,ID_SERVICE,FACILITY_ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PK_I_CLIENT", "fields": "FACILITY_ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "R1973_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Data,Map,Query", "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": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }