Name: tb_consulta_obras_siconv_vw_obras_contrato

Display Field: nome_fornecedor_contrato

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 61410345eb2f464a993fba4d417aaed7

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• seq ( type: esriFieldTypeOID, alias: seq, editable: false, nullable: false, defaultValue: null, modelName: seq )
• id_proposta ( type: esriFieldTypeString, alias: id_proposta, editable: true, nullable: true, length: 7, defaultValue: null, modelName: id_proposta )
• nr_convenio ( type: esriFieldTypeString, alias: nr_convenio, editable: true, nullable: true, length: 6, defaultValue: null, modelName: nr_convenio )
• id_licitacao ( type: esriFieldTypeString, alias: id_licitacao, editable: true, nullable: true, length: 6, defaultValue: null, modelName: id_licitacao )
• nr_contrato ( type: esriFieldTypeString, alias: nr_contrato, editable: true, nullable: true, length: 15, defaultValue: null, modelName: nr_contrato )
• data_inicio_vigencia_contrato ( type: esriFieldTypeDate, alias: data_inicio_vigencia_contrato, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_inicio_vigencia_contrato )
• data_fim_vigencia_contrato ( type: esriFieldTypeDate, alias: data_fim_vigencia_contrato, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_fim_vigencia_contrato )
• objeto_contrato ( type: esriFieldTypeString, alias: objeto_contrato, editable: true, nullable: true, length: 432, defaultValue: null, modelName: objeto_contrato )
• valor_global_contrato ( type: esriFieldTypeString, alias: valor_global_contrato, editable: true, nullable: true, length: 120, defaultValue: null, modelName: valor_global_contrato )
• nome_fornecedor_contrato ( type: esriFieldTypeString, alias: nome_fornecedor_contrato, editable: true, nullable: true, length: 55, defaultValue: null, modelName: nome_fornecedor_contrato )
• data_inicio_obra_contrato_acompanhamento_obra ( type: esriFieldTypeDate, alias: data_inicio_obra_contrato_acompanhamento_obra, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_inicio_obra_contrato_acompanhamento_obra )
• ug ( type: esriFieldTypeString, alias: ug, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ug )
• objeto ( type: esriFieldTypeString, alias: objeto, editable: true, nullable: true, length: 254, defaultValue: null, modelName: objeto )
• situacao_atual ( type: esriFieldTypeString, alias: situacao_atual, editable: true, nullable: true, length: 12, defaultValue: null, modelName: situacao_atual )
• data_inicio ( type: esriFieldTypeDate, alias: data_inicio, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_inicio )
• data_conclusao ( type: esriFieldTypeDate, alias: data_conclusao, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: data_conclusao )
• empresa_contratada ( type: esriFieldTypeString, alias: empresa_contratada, editable: true, nullable: true, length: 49, defaultValue: null, modelName: empresa_contratada )
• percentual_concluido ( type: esriFieldTypeDouble, alias: percentual_concluido, editable: true, nullable: true, defaultValue: null, modelName: percentual_concluido )
• quantitativo ( type: esriFieldTypeString, alias: quantitativo, editable: true, nullable: true, length: 182, defaultValue: null, modelName: quantitativo )
• preco_unitario ( type: esriFieldTypeString, alias: preco_unitario, editable: true, nullable: true, length: 120, defaultValue: null, modelName: preco_unitario )
• totais_contratados ( type: esriFieldTypeString, alias: totais_contratados, editable: true, nullable: true, length: 120, defaultValue: null, modelName: totais_contratados )
• quantitativo_executados ( type: esriFieldTypeString, alias: quantitativo_executados, editable: true, nullable: true, length: 120, defaultValue: null, modelName: quantitativo_executados )
• precos_efetivamente_pagos ( type: esriFieldTypeString, alias: precos_efetivamente_pagos, editable: true, nullable: true, length: 120, defaultValue: null, modelName: precos_efetivamente_pagos )
• datahora_carga ( type: esriFieldTypeDate, alias: datahora_carga, editable: true, nullable: false, length: 8, defaultValue: null, modelName: datahora_carga )

Templates:

• Name: tb_consulta_obras_siconv_vw_obras_contrato
  Description:
  Prototype:
  precos_efetivamente_pagos: null
  datahora_carga: -2209161600000
  id_proposta: null
  nr_convenio: null
  id_licitacao: null
  nr_contrato: null
  data_inicio_vigencia_contrato: null
  data_fim_vigencia_contrato: null
  objeto_contrato: null
  valor_global_contrato: null
  nome_fornecedor_contrato: null
  data_inicio_obra_contrato_acompanhamento_obra: null
  ug: null
  objeto: null
  situacao_atual: null
  data_inicio: null
  data_conclusao: null
  empresa_contratada: null
  percentual_concluido: null
  quantitativo: null
  preco_unitario: null
  totais_contratados: null
  quantitativo_executados: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata