Name: Municipal_Assets_CA_Finance_Table

Display Field: department_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 213f3a616c5247bc99479fd1064714ae

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

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: false
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: false
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:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• objectid_1 ( modelName: objectid_1, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• asset ( modelName: asset, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset, type: esriFieldTypeString )
• class ( modelName: class, nullable: true, editable: true, defaultValue: null, length: 255, alias: Class, type: esriFieldTypeString )
• class_type ( modelName: class_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Class Type, type: esriFieldTypeString )
• department_code ( modelName: department_code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Department Code, type: esriFieldTypeString )
• department_name ( modelName: department_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Department Name, type: esriFieldTypeString )
• sub_department ( modelName: sub_department, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sub-Department, type: esriFieldTypeString )
• company_code ( modelName: company_code, nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Code, type: esriFieldTypeString )
• sno_ ( modelName: sno_, nullable: true, editable: true, defaultValue: null, length: 255, alias: SNo., type: esriFieldTypeString )
• asset_description ( modelName: asset_description, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset description, type: esriFieldTypeString )
• asset_de_1 ( modelName: asset_de_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset description, type: esriFieldTypeString )
• asset_main_no__text ( modelName: asset_main_no__text, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset main no. text, type: esriFieldTypeString )
• serial_no_ ( modelName: serial_no_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Serial no., type: esriFieldTypeString )
• inventory_number ( modelName: inventory_number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Inventory number, type: esriFieldTypeString )
• quantity ( modelName: quantity, nullable: true, editable: true, defaultValue: null, alias: Quantity, type: esriFieldTypeDouble )
• base_unit_of_measure ( modelName: base_unit_of_measure, nullable: true, editable: true, defaultValue: null, length: 255, alias: Base Unit of Measure, type: esriFieldTypeString )
• inv_date ( modelName: inv_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Inv.date, type: esriFieldTypeDate )
• cap_date ( modelName: cap_date, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cap.date, type: esriFieldTypeString )
• deact_date ( modelName: deact_date, nullable: true, editable: true, defaultValue: null, length: 255, alias: Deact.Date, type: esriFieldTypeString )
• cost_ctr ( modelName: cost_ctr, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cost Ctr, type: esriFieldTypeString )
• fund ( modelName: fund, nullable: true, editable: true, defaultValue: null, length: 255, alias: Fund, type: esriFieldTypeString )
• functional_area ( modelName: functional_area, nullable: true, editable: true, defaultValue: null, length: 255, alias: Functional Area, type: esriFieldTypeString )
• funds_ctr ( modelName: funds_ctr, nullable: true, editable: true, defaultValue: null, length: 255, alias: Funds Ctr, type: esriFieldTypeString )
• ev_1 ( modelName: ev_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ev.1, type: esriFieldTypeString )
• plnt ( modelName: plnt, nullable: true, editable: true, defaultValue: null, length: 255, alias: Plnt, type: esriFieldTypeString )
• use ( modelName: use, nullable: true, editable: true, defaultValue: null, length: 255, alias: Use, type: esriFieldTypeString )
• per ( modelName: per, nullable: true, editable: true, defaultValue: null, length: 255, alias: Per, type: esriFieldTypeString )
• eul ( modelName: eul, nullable: true, editable: true, defaultValue: null, length: 255, alias: EUL, type: esriFieldTypeString )
• elp ( modelName: elp, nullable: true, editable: true, defaultValue: null, length: 255, alias: ELP, type: esriFieldTypeString )
• orgyr ( modelName: orgyr, nullable: true, editable: true, defaultValue: null, length: 255, alias: OrgYr, type: esriFieldTypeString )
• original_value ( modelName: original_value, nullable: true, editable: true, defaultValue: null, alias: Original value, type: esriFieldTypeDouble )
• acq_val__fyend ( modelName: acq_val__fyend, nullable: true, editable: true, defaultValue: null, alias: Acq.val. FYend, type: esriFieldTypeDouble )
• ord_dep__past ( modelName: ord_dep__past, nullable: true, editable: true, defaultValue: null, alias: Ord.dep.:Past, type: esriFieldTypeDouble )
• dep_pstd_ ( modelName: dep_pstd_, nullable: true, editable: true, defaultValue: null, alias: Dep.pstd., type: esriFieldTypeDouble )
• curr_bk_val_ ( modelName: curr_bk_val_, nullable: true, editable: true, defaultValue: null, alias: , type: esriFieldTypeDouble )
• plnd_dep_ ( modelName: plnd_dep_, nullable: true, editable: true, defaultValue: null, alias: Plnd.dep., type: esriFieldTypeDouble )
• dep_fye ( modelName: dep_fye, nullable: true, editable: true, defaultValue: null, alias: Dep.FYE, type: esriFieldTypeDouble )
• bk_val__fye ( modelName: bk_val__fye, nullable: true, editable: true, defaultValue: null, alias: Bk.val. FYE, type: esriFieldTypeDouble )
• depky ( modelName: depky, nullable: true, editable: true, defaultValue: null, length: 255, alias: DepKy, type: esriFieldTypeString )
• odep_start ( modelName: odep_start, nullable: true, editable: true, defaultValue: null, length: 255, alias: ODep.Start, type: esriFieldTypeString )
• manufacturer_of_asset ( modelName: manufacturer_of_asset, nullable: true, editable: true, defaultValue: null, length: 255, alias: Manufacturer of asset, type: esriFieldTypeString )
• l_reg__of ( modelName: l_reg__of, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: L.Reg. of, type: esriFieldTypeDate )
• entry_by ( modelName: entry_by, nullable: true, editable: true, defaultValue: null, length: 255, alias: Entry by, type: esriFieldTypeString )
• vol_ ( modelName: vol_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Vol., type: esriFieldTypeString )
• page ( modelName: page, nullable: true, editable: true, defaultValue: null, length: 255, alias: Page, type: esriFieldTypeString )
• seqno ( modelName: seqno, nullable: true, editable: true, defaultValue: null, length: 255, alias: SeqNo, type: esriFieldTypeString )
• map ( modelName: map, nullable: true, editable: true, defaultValue: null, length: 255, alias: Map, type: esriFieldTypeString )
• pltno ( modelName: pltno, nullable: true, editable: true, defaultValue: null, length: 255, alias: Pltno, type: esriFieldTypeString )
• indicator__historical_manageme ( modelName: indicator__historical_manageme, nullable: true, editable: true, defaultValue: null, length: 255, alias: Indicator: Historical manageme, type: esriFieldTypeString )
• inventory_indicator ( modelName: inventory_indicator, nullable: true, editable: true, defaultValue: null, length: 255, alias: Inventory indicator, type: esriFieldTypeString )
• inventory_note ( modelName: inventory_note, nullable: true, editable: true, defaultValue: null, length: 255, alias: Inventory note, type: esriFieldTypeString )
• plant ( modelName: plant, nullable: true, editable: true, defaultValue: null, length: 255, alias: Plant, type: esriFieldTypeString )
• license_plate ( modelName: license_plate, nullable: true, editable: true, defaultValue: null, length: 255, alias: License plate, type: esriFieldTypeString )
• municipality ( modelName: municipality, nullable: true, editable: true, defaultValue: null, length: 255, alias: Municipality, type: esriFieldTypeString )
• area ( modelName: area, nullable: true, editable: true, defaultValue: null, alias: area, type: esriFieldTypeDouble )
• area_unit ( modelName: area_unit, nullable: true, editable: true, defaultValue: null, length: 255, alias: Area unit, type: esriFieldTypeString )
• asset_super_number ( modelName: asset_super_number, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset super number, type: esriFieldTypeString )
• supplier ( modelName: supplier, nullable: true, editable: true, defaultValue: null, length: 255, alias: Supplier, type: esriFieldTypeString )
• type_name ( modelName: type_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Type name, type: esriFieldTypeString )
• man_net_wrth_val_ ( modelName: man_net_wrth_val_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Man.net wrth val., type: esriFieldTypeString )
• tax_office ( modelName: tax_office, nullable: true, editable: true, defaultValue: null, length: 255, alias: Tax Office, type: esriFieldTypeString )
• reason_for_manual_valuation_of ( modelName: reason_for_manual_valuation_of, nullable: true, editable: true, defaultValue: null, length: 255, alias: Reason for manual valuation of, type: esriFieldTypeString )
• down_payments ( modelName: down_payments, nullable: true, editable: true, defaultValue: null, alias: Down payments, type: esriFieldTypeInteger )
• man_ord__dep_ ( modelName: man_ord__dep_, nullable: true, editable: true, defaultValue: null, alias: , type: esriFieldTypeInteger )
• man_unplnd_dep_ ( modelName: man_unplnd_dep_, nullable: true, editable: true, defaultValue: null, alias: , type: esriFieldTypeInteger )
• w_up_ord_dep_ ( modelName: w_up_ord_dep_, nullable: true, editable: true, defaultValue: null, alias: W-up Ord.dep., type: esriFieldTypeInteger )
• w_up_unplnd_dep ( modelName: w_up_unplnd_dep, nullable: true, editable: true, defaultValue: null, alias: W-up unplnd.dep, type: esriFieldTypeInteger )
• created_by ( modelName: created_by, nullable: true, editable: true, defaultValue: null, length: 255, alias: Created by, type: esriFieldTypeString )
• created_on ( modelName: created_on, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Created on, type: esriFieldTypeDate )
• changed_by ( modelName: changed_by, nullable: true, editable: true, defaultValue: null, length: 255, alias: Changed by, type: esriFieldTypeString )
• chng_dat ( modelName: chng_dat, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Chng.dat, type: esriFieldTypeDate )
• indicator__asset_locked_to_acq ( modelName: indicator__asset_locked_to_acq, nullable: true, editable: true, defaultValue: null, length: 255, alias: Indicator: Asset Locked to Acq, type: esriFieldTypeString )
• indicator__negative_values_all ( modelName: indicator__negative_values_all, nullable: true, editable: true, defaultValue: null, length: 255, alias: Indicator: Negative values all, type: esriFieldTypeString )

Templates:

• Name: Municipal_Assets_CA_Finance_Table
  Description:
  Prototype:
  department_code: null
  type_name: null
  man_net_wrth_val_: null
  reason_for_manual_valuation_of: null
  use: null
  asset_de_1: null
  municipality: null
  inventory_number: null
  man_ord__dep_: null
  ev_1: null
  depky: null
  acq_val__fyend: null
  man_unplnd_dep_: null
  class_type: null
  dep_pstd_: null
  supplier: null
  bk_val__fye: null
  cost_ctr: null
  per: null
  chng_dat: null
  area: null
  cap_date: null
  original_value: null
  serial_no_: null
  curr_bk_val_: null
  elp: null
  indicator__historical_manageme: null
  orgyr: null
  created_by: null
  functional_area: null
  inv_date: null
  asset_super_number: null
  w_up_unplnd_dep: null
  created_on: null
  changed_by: null
  plant: null
  tax_office: null
  indicator__asset_locked_to_acq: null
  ord_dep__past: null
  page: null
  eul: null
  w_up_ord_dep_: null
  sub_department: null
  down_payments: null
  indicator__negative_values_all: null
  manufacturer_of_asset: null
  asset_description: null
  base_unit_of_measure: null
  company_code: null
  deact_date: null
  vol_: null
  class: null
  dep_fye: null
  map: null
  sno_: null
  l_reg__of: null
  quantity: null
  seqno: null
  pltno: null
  department_name: null
  odep_start: null
  inventory_indicator: null
  objectid_1: null
  asset_main_no__text: null
  funds_ctr: null
  entry_by: null
  license_plate: null
  fund: null
  plnt: null
  plnd_dep_: null
  inventory_note: null
  area_unit: null
  asset: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Update,Editing,Uploads

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

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Apply Edits   Update Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata