Name: regTransacciones

Display Field: codInmueble

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• codInmueble (type: esriFieldTypeString, alias: codInmueble, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Interesado (type: esriFieldTypeString, alias: Interesado, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ofertador (type: esriFieldTypeString, alias: Ofertador, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Gobierno de Navarra: Gobierno de Navarra], [Sodena: Sodena])
• FechaInicio (type: esriFieldTypeDate, alias: Fecha Inicio, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FechaFin (type: esriFieldTypeDate, alias: Fecha Fin, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• ParentGuid (type: esriFieldTypeGUID, alias: ParentGuid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• TipoInteresado (type: esriFieldTypeString, alias: Tipo Interesado, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: )
• EstadoTransaccion (type: esriFieldTypeString, alias: Estado transacción, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Disponible (alquiler/venta): Disponible (alquiler/venta)], [Ofertada: Ofertada], [Reservada: Reservada], ... 3 more ...)
• Observaciones (type: esriFieldTypeString, alias: Observaciones, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• EstadoTransaccionFinal (type: esriFieldTypeString, alias: EstadoTransaccionFinal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Venta: Venta], [Alquiler: Alquiler])
• PrecioTransaccionFinal (type: esriFieldTypeInteger, alias: PrecioTransaccionFinal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Estado (type: esriFieldTypeString, alias: Estado actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PrecioFinalVenta (type: esriFieldTypeInteger, alias: Precio final de venta, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PrecioFinalAlquiler (type: esriFieldTypeInteger, alias: Precio final de alquiler, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Titular (type: esriFieldTypeString, alias: Titular actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nuevoTitular (type: esriFieldTypeString, alias: Nuevo titular, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TipoCliente (type: esriFieldTypeString, alias: Tipo de cliente, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cliente (type: esriFieldTypeString, alias: Cliente, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FechaTransaccion (type: esriFieldTypeDate, alias: Fecha del cambio de estado, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FechaVigenciaOferta (type: esriFieldTypeDate, alias: Fecha de vigencia del cambio de estado, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FechaTransaccionTxt (type: esriFieldTypeString, alias: FechaTransaccionTxt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FechaVigenciaOfertaTxt (type: esriFieldTypeString, alias: FechaVigenciaOfertaTxt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Notas (type: esriFieldTypeString, alias: Notas, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OID_inmueble (type: esriFieldTypeString, alias: OID_inmueble, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tipoInmueble (type: esriFieldTypeString, alias: tipoInmueble, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comarca (type: esriFieldTypeString, alias: comarca, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nombreMunicipio (type: esriFieldTypeString, alias: nombreMunicipio, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• nombreAAE (type: esriFieldTypeString, alias: nombreAAE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ultimaTransaccion (type: esriFieldTypeString, alias: Última Transacción, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: regTransacciones
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (0) -- Related To: Inmuebles (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/22/2026 4:01:20 AM

Schema Last Edit Date: 5/8/2025 10:47:36 AM

Data Last Edit Date: 2/22/2026 4:01:20 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat