Name: AConsumidorExtraido

Display Field: edccod

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 84b71d75a69645f4bbff5aba6303a691

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
Supports Sql Expression: false
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: Object ID, nullable: false, defaultValue: null, modelName: OBJECTID, editable: false )
• clitotdeu ( type: esriFieldTypeDouble, alias: Valor Deuda, editable: true, nullable: true, defaultValue: null, modelName: CLITOTDEU )
• clifecultp ( type: esriFieldTypeDate, alias: Fecha Ultimo Pago, editable: true, nullable: true, length: 29, defaultValue: null, modelName: CLIFECULTP )
• cliultconm ( type: esriFieldTypeInteger, alias: Ultimo Consumo Mes (Kwh), editable: true, nullable: true, defaultValue: null, modelName: CLIULTCONM )
• cliultconp ( type: esriFieldTypeDouble, alias: Consumo Diario Promedio (Kwh), editable: true, nullable: true, defaultValue: null, modelName: CLIULTCONP )
• clifecins ( type: esriFieldTypeDate, alias: Fecha Instalacion, editable: true, nullable: true, length: 29, defaultValue: null, modelName: CLIFECINS )
• edccod ( type: esriFieldTypeString, alias: Estado del Servicio, editable: true, nullable: true, length: 1, defaultValue: null, modelName: EDCCOD , Coded Values: [W: Suspendido Definitivo] , [A: Activo] , [Y: Cambio de Medidor] , ...27 more... )
• cdafas ( type: esriFieldTypeSmallInteger, alias: Numero de Fases, editable: true, nullable: true, defaultValue: null, modelName: CDAFAS )
• cdacon ( type: esriFieldTypeSmallInteger, alias: Numero de Conductores, editable: true, nullable: true, defaultValue: null, modelName: CDACON )
• usocod ( type: esriFieldTypeString, alias: Codigo Uso Energia, editable: true, nullable: true, length: 2, defaultValue: null, modelName: USOCOD , Coded Values: [A3: ASISTENCIA SOCIAL BT CON DEMANDA HORARIA] , [AB: AS/BP BT CON DEMANDA] , [AC: AUTOCONSUMO CON DEMANDA EN BT] , ...114 more... )
• caldes ( type: esriFieldTypeString, alias: Calle, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CALDES )
• cliprvcod ( type: esriFieldTypeString, alias: Provincia, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CLIPRVCOD , Coded Values: [01: AZUAY] , [02: BOLIVAR] , [03: CANAR] , ...22 more... )
• clicancod ( type: esriFieldTypeString, alias: Canton, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CLICANCOD , Coded Values: [0101: CUENCA] , [0102: GIRON] , [0103: GUALACEO] , ...221 more... )
• cliparcod ( type: esriFieldTypeString, alias: Parroquia, editable: true, nullable: true, length: 6, defaultValue: null, modelName: CLIPARCOD , Coded Values: [010101: BELLAVISTA] , [010102: CAÑARIBAMBA] , [010103: EL BATÁN] , ...1407 more... )
• clifecult ( type: esriFieldTypeDate, alias: Fecha Facturación, editable: true, nullable: true, length: 29, defaultValue: null, modelName: CLIFECULT )
• tipomedidor ( type: esriFieldTypeString, alias: Tipo Medidor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TIPOMEDIDOR )
• potenciaactiva ( type: esriFieldTypeDouble, alias: Potencia Activa, editable: true, nullable: true, defaultValue: null, modelName: POTENCIAACTIVA )
• potenciareactiva ( type: esriFieldTypeDouble, alias: POTENCIA REACTIVA, editable: true, nullable: true, defaultValue: null, modelName: POTENCIAREACTIVA )
• categoria ( type: esriFieldTypeString, alias: CATEGORIA, editable: true, nullable: true, length: 4, defaultValue: null, modelName: CATEGORIA , Coded Values: [01: EEASA_ResidencialUrbano] , [02: EEASA_ResidencialRural] , [03: EEASA_IndustrialUrbano] , ...124 more... )
• paquete ( type: esriFieldTypeString, alias: PAQUETE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PAQUETE )
• telefono ( type: esriFieldTypeString, alias: TELEFONO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TELEFONO )
• celular ( type: esriFieldTypeString, alias: CELULAR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CELULAR )
• es_bdh ( type: esriFieldTypeString, alias: ES_BDH, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ES_BDH )
• agencia ( type: esriFieldTypeString, alias: AGENCIA, editable: true, nullable: true, length: 14, defaultValue: null, modelName: AGENCIA )
• tasabasura ( type: esriFieldTypeDouble, alias: TASABASURA, editable: true, nullable: true, defaultValue: null, modelName: TASABASURA )
• consumopromedio ( type: esriFieldTypeDouble, alias: CONSUMOPROMEDIO, editable: true, nullable: true, defaultValue: null, modelName: CONSUMOPROMEDIO )
• estadoextendido ( type: esriFieldTypeString, alias: ESTADOEXTENDIDO, editable: true, nullable: true, length: 2, defaultValue: null, modelName: ESTADOEXTENDIDO )
• fechaprimerainstalacion ( type: esriFieldTypeDate, alias: FECHAPRIMERAINSTALACION, editable: true, nullable: true, length: 29, defaultValue: null, modelName: FECHAPRIMERAINSTALACION )
• factormult ( type: esriFieldTypeString, alias: FACTORMULT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FACTORMULT )
• tipotarifa ( type: esriFieldTypeString, alias: TIPOTARIFA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TIPOTARIFA )
• estado ( type: esriFieldTypeString, alias: ESTADO, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ESTADO )
• cuentacontrato ( type: esriFieldTypeString, alias: CUENTACONTRATO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CUENTACONTRATO )
• clislccod ( type: esriFieldTypeString, alias: CLISLCCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLISLCCOD )
• clisecinm ( type: esriFieldTypeString, alias: CLISECINM, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLISECINM )
• clirlscod ( type: esriFieldTypeString, alias: CLIRLSCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLIRLSCOD )
• codigoempresa ( type: esriFieldTypeString, alias: Empresa, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOEMPRESA , Coded Values: [CNELMANABI: CNELEP-MANABI] , [CNELELORO: CNELEP-EL ORO] , [CNELSTODGO: CNELEP-SANTO DOMINGO] , ...17 more... )
• clinomabr ( type: esriFieldTypeString, alias: NOMBRES, editable: true, nullable: true, length: 125, defaultValue: null, modelName: CLINOMABR )
• codigocliente ( type: esriFieldTypeString, alias: Codigo Cliente, editable: true, nullable: false, length: 8, defaultValue: null, modelName: CODIGOCLIENTE )
• codigounico ( type: esriFieldTypeString, alias: CUENTA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CODIGOUNICO )
• criticidad ( type: esriFieldTypeString, alias: Criticidad, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CRITICIDAD )
• discapacidad ( type: esriFieldTypeString, alias: Discapacidad, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DISCAPACIDAD )
• email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EMAIL )
• idccedruc ( type: esriFieldTypeString, alias: RUC Cliente, editable: true, nullable: true, length: 20, defaultValue: null, modelName: IDCCEDRUC )
• mdmcod ( type: esriFieldTypeString, alias: Código Marca Medidor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MDMCOD )
• nivtension ( type: esriFieldTypeString, alias: Nivel Tension, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NIVTENSION )
• nummedidor ( type: esriFieldTypeString, alias: Numero de Medidor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NUMMEDIDOR )
• clinumpos ( type: esriFieldTypeString, alias: Numero de Poste, editable: true, nullable: true, length: 16, defaultValue: null, modelName: CLINUMPOS )

Templates:

• Name: AConsumidorExtraido
  Description:
  Prototype:
  nummedidor: null
  clinumpos: null
  clitotdeu: null
  clifecultp: null
  cliultconm: null
  cliultconp: null
  clifecins: null
  edccod: null
  cdafas: null
  cdacon: null
  usocod: null
  caldes: null
  cliprvcod: null
  clicancod: null
  cliparcod: null
  clifecult: null
  tipomedidor: null
  potenciaactiva: null
  potenciareactiva: null
  categoria: null
  paquete: null
  telefono: null
  celular: null
  es_bdh: null
  agencia: null
  tasabasura: null
  consumopromedio: null
  estadoextendido: null
  fechaprimerainstalacion: null
  factormult: null
  tipotarifa: null
  estado: null
  cuentacontrato: null
  clislccod: null
  clisecinm: null
  clirlscod: null
  codigoempresa: null
  clinomabr: null
  codigocliente:
  codigounico: null
  criticidad: null
  discapacidad: null
  email: null
  idccedruc: null
  mdmcod: null
  nivtension: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata