Name: CConsumidorExtraido

Display Field: usuarioregistro

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: OBJECTID, nullable: false, defaultValue: null, modelName: OBJECTID, editable: false )
• usuarioregistro ( type: esriFieldTypeString, alias: Usu Cre, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UsuarioRegistro )
• fecharegistro ( type: esriFieldTypeDate, alias: F Cre Sis, editable: true, nullable: true, length: 29, defaultValue: null, modelName: FechaRegistro )
• fechamodificacionregistro ( type: esriFieldTypeDate, alias: F Mod Sis, editable: true, nullable: true, length: 29, defaultValue: null, modelName: FechaModificacionRegistro )
• usuariomodificacionregistro ( type: esriFieldTypeString, alias: Usu Mod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UsuarioModificacionRegistro )
• puntocargaobjectid ( type: esriFieldTypeInteger, alias: Punto Carga OId, editable: true, nullable: true, defaultValue: null, modelName: PuntoCargaObjectID )
• codigocliente ( type: esriFieldTypeString, alias: Codigo, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CodigoCliente )
• proyectoconstruccion ( type: esriFieldTypeString, alias: PROYECTOCONSTRUCCION, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROYECTOCONSTRUCCION )
• fechaconstruccion ( type: esriFieldTypeDate, alias: FECHACONSTRUCCION, editable: true, nullable: true, length: 29, defaultValue: null, modelName: FECHACONSTRUCCION )
• pos_t_hor ( type: esriFieldTypeInteger, alias: POS_T_HOR, editable: true, nullable: true, defaultValue: 1, modelName: POS_T_HOR )
• pos_t_ver ( type: esriFieldTypeInteger, alias: POS_T_VER, editable: true, nullable: true, defaultValue: 1, modelName: POS_T_VER )
• mipcrgcod ( type: esriFieldTypeString, alias: MIPCRGCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIPCRGCOD )
• mipcrg_oid ( type: esriFieldTypeString, alias: MIPCRG_OID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIPCRG_OID )
• cliprvcodp ( type: esriFieldTypeString, alias: CLIPRVCOD, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CLIPRVCODP )
• clicancodp ( type: esriFieldTypeString, alias: CLICANCODP, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CLICANCODP )
• novedades ( type: esriFieldTypeSmallInteger, alias: Novedades, editable: true, nullable: true, defaultValue: null, modelName: NOVEDADES , Coded Values: [5: Hurto] , [0: Sin Novedad] , [1: Medidor Alto (se requiere escalera)] , ...12 more... )
• codrut ( type: esriFieldTypeString, alias: Agencia_Ruta, editable: true, nullable: true, length: 9, defaultValue: null, modelName: CODRUT )
• mdenumfab ( type: esriFieldTypeString, alias: N. Serie Medidor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MDENUMFAB )
• mdenumemp ( type: esriFieldTypeString, alias: SR del Medidor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MDENUMEMP )
• puntocargaglobalid ( type: esriFieldTypeGUID, alias: PUNTOCARGAGLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PUNTOCARGAGLOBALID )
• codigounico ( type: esriFieldTypeString, alias: Código Único, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOUNICO )
• miguid ( type: esriFieldTypeGUID, alias: MIGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: MIGUID )
• secuenciafase ( type: esriFieldTypeString, alias: Fase de Bajo Voltaje, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SECUENCIAFASE , Coded Values: [a: a] , [b: b] , [c: c] , ...4 more... )
• medmar ( type: esriFieldTypeString, alias: MARCA, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MEDMAR , Coded Values: [ACT: Actaris] , [ABB: Asea Brown Boveri] , [AEG: AEG] , ...124 more... )
• tipomedidor ( type: esriFieldTypeString, alias: TIPOMEDIDOR, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TIPOMEDIDOR , Coded Values: [0601: Eletromecánico-Directa-Bornera] , [0602: Eletromecánico-Directa-Socket] , [0603: Eletromec-Indirecta-Bornera] , ...20 more... )
• prepago ( type: esriFieldTypeString, alias: PREPAGO, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREPAGO , Coded Values: [N: No] , [S: Si] )
• codigoestructura ( type: esriFieldTypeString, alias: CODIGOESTRUCTURA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOESTRUCTURA , Coded Values: [MEC0001: 1E100_1AC] , [MED0001: 1D200_2SD] , [MED0002: 1E100_2AD] , ...53 more... )
• fechamodificacion ( type: esriFieldTypeDate, alias: FECHAMODIFICACION, editable: true, nullable: true, length: 29, defaultValue: null, modelName: FECHAMODIFICACION )
• codigoempresa ( type: esriFieldTypeString, alias: CODIGOEMPRESA, editable: true, nullable: true, length: 10, defaultValue: EEA, modelName: CODIGOEMPRESA , Coded Values: [CNELMANABI: CNELEP-MANABI] , [CNELELORO: CNELEP-EL ORO] , [CNELSTODGO: CNELEP-SANTO DOMINGO] , ...17 more... )
• proyectomodificacion ( type: esriFieldTypeString, alias: PROYECTOMODIFICACION, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROYECTOMODIFICACION )
• observaciones ( type: esriFieldTypeString, alias: OBSERVACIONES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OBSERVACIONES )
• comentarios ( type: esriFieldTypeString, alias: COMENTARIOS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMENTARIOS )
• provincia ( type: esriFieldTypeString, alias: PROVINCIA, editable: true, nullable: true, length: 2, defaultValue: 03, modelName: PROVINCIA , Coded Values: [01: AZUAY] , [02: BOLIVAR] , [03: CANAR] , ...22 more... )
• canton ( type: esriFieldTypeString, alias: CANTON, editable: true, nullable: true, length: 4, defaultValue: 0301, modelName: CANTON , Coded Values: [0101: CUENCA] , [0102: GIRON] , [0103: GUALACEO] , ...221 more... )
• parroquia ( type: esriFieldTypeString, alias: PARROQUIA, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PARROQUIA , Coded Values: [010101: BELLAVISTA] , [010102: CAÑARIBAMBA] , [010103: EL BATÁN] , ...1407 more... )
• clirlscod ( type: esriFieldTypeString, alias: CLIRLSCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLIRLSCOD )
• clislccod ( type: esriFieldTypeString, alias: CLISLCCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLISLCCOD )
• ordentrabajo ( type: esriFieldTypeString, alias: Orden de trabajo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ORDENTRABAJO )
• circuitos ( type: esriFieldTypeString, alias: Circuitos, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CIRCUITOS , Coded Values: [A: A] , [B: B] , [C: C] , ...7 more... )
• clisecinm ( type: esriFieldTypeString, alias: CLISECINM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLISECINM )
• estado ( type: esriFieldTypeSmallInteger, alias: Estdo, editable: true, nullable: true, defaultValue: null, modelName: ESTADO , Coded Values: [1: Buen Estado] , [2: Mal Estado] )
• existenovedad ( type: esriFieldTypeSmallInteger, alias: Existe Novedad, editable: true, nullable: true, defaultValue: null, modelName: EXISTENOVEDAD , Coded Values: [1: Si] , [2: No] )
• miestado ( type: esriFieldTypeString, alias: MIESTADO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIESTADO )
• mioid ( type: esriFieldTypeInteger, alias: MIOID, editable: true, nullable: true, defaultValue: null, modelName: MIOID )
• alimentadorid ( type: esriFieldTypeString, alias: Alimentador, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AlimentadorID , Coded Values: [0200S10V01: A0121] , [0200S10V02: A0122] , [0200S10V03: A0123] , ...7 more... )
• parroquia_1 ( type: esriFieldTypeString, alias: Parroquia, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PARROQUIA , Coded Values: [010101: BELLAVISTA] , [010102: CAÑARIBAMBA] , [010103: EL BATÁN] , ...1407 more... )
• coord_x ( type: esriFieldTypeDouble, alias: Coord X, editable: true, nullable: true, defaultValue: null, modelName: COORD_X )
• coord_y ( type: esriFieldTypeDouble, alias: Coord Y, editable: true, nullable: true, defaultValue: null, modelName: COORD_Y )
• miguid_1 ( type: esriFieldTypeGUID, alias: MIGUID_1, editable: true, nullable: true, length: 38, defaultValue: null, modelName: MIGUID )
• codigocliente_1 ( type: esriFieldTypeString, alias: Codigo Cliente, editable: true, nullable: true, length: 150, defaultValue: null, modelName: CODIGOCLIENTE )
• medidor ( type: esriFieldTypeString, alias: Medidor, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MEDIDOR )
• 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 )
• caldes ( type: esriFieldTypeString, alias: Calle, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CALDES )
• clifecult ( type: esriFieldTypeDate, alias: Fecha Facturación, editable: true, nullable: true, length: 29, defaultValue: null, modelName: CLIFECULT )
• 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... )
• consumopromedio ( type: esriFieldTypeDouble, alias: CONSUMOPROMEDIO, editable: true, nullable: true, defaultValue: null, modelName: CONSUMOPROMEDIO )
• estado_1 ( type: esriFieldTypeString, alias: ESTADO_1, 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 )
• clinomabr ( type: esriFieldTypeString, alias: NOMBRES, editable: true, nullable: true, length: 125, defaultValue: null, modelName: CLINOMABR )
• codigocliente_12 ( type: esriFieldTypeString, alias: Codigo Cliente, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CODIGOCLIENTE )
• codigounico_1 ( type: esriFieldTypeString, alias: CUENTA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CODIGOUNICO )
• 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 )
• nummedidor ( type: esriFieldTypeString, alias: Numero de Medidor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NUMMEDIDOR )

Templates:

• Name: CConsumidorExtraido
  Description:
  Prototype:
  idccedruc: null
  nummedidor: null
  usuarioregistro: null
  fecharegistro: null
  fechamodificacionregistro: null
  usuariomodificacionregistro: null
  puntocargaobjectid: null
  codigocliente: null
  proyectoconstruccion: null
  fechaconstruccion: null
  pos_t_hor: 1
  pos_t_ver: 1
  mipcrgcod: null
  mipcrg_oid: null
  cliprvcodp: null
  clicancodp: null
  novedades: null
  codrut: null
  mdenumfab: null
  mdenumemp: null
  puntocargaglobalid: null
  codigounico: null
  miguid: null
  secuenciafase: null
  medmar: null
  tipomedidor: null
  prepago: null
  codigoestructura: null
  fechamodificacion: null
  codigoempresa: EEA
  proyectomodificacion: null
  observaciones: null
  comentarios: null
  provincia: 03
  canton: 0301
  parroquia: null
  clirlscod: null
  clislccod: null
  ordentrabajo: null
  circuitos: null
  clisecinm: null
  estado: null
  existenovedad: null
  miestado: null
  mioid: null
  alimentadorid: null
  parroquia_1: null
  coord_x: null
  coord_y: null
  miguid_1: null
  codigocliente_1: null
  medidor: null
  clitotdeu: null
  clifecultp: null
  caldes: null
  clifecult: null
  categoria: null
  consumopromedio: null
  estado_1: null
  cuentacontrato: null
  clinomabr: null
  codigocliente_12: null
  codigounico_1: null
  discapacidad: null
  email: 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