Name: FINANCIAL

Display Field: FinancialYear

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 773bac6505a54aeaba74a85e57d6a5b7

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• AssetGUID ( type: esriFieldTypeGUID, alias: AssetGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: AssetGUID )
• FinancialYear ( type: esriFieldTypeString, alias: FinancialYear, editable: true, nullable: true, length: 9, defaultValue: null, modelName: FinancialYear )
• Adjustment ( type: esriFieldTypeString, alias: Adjustment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Adjustment )
• Action_ ( type: esriFieldTypeString, alias: Action_, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Action_ )
• Depreciation_Method ( type: esriFieldTypeString, alias: Depreciation_Method, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Depreciation_Method )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Owner )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Type )
• TakeOnDate ( type: esriFieldTypeDate, alias: TakeOnDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TakeOnDate )
• AcquisitionDate ( type: esriFieldTypeDate, alias: AcquisitionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: AcquisitionDate )
• DisposalDate ( type: esriFieldTypeDate, alias: DisposalDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DisposalDate )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• Plant ( type: esriFieldTypeString, alias: Plant, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Plant )
• AcqNote ( type: esriFieldTypeString, alias: AcqNote, editable: true, nullable: true, length: 255, defaultValue: null, modelName: AcqNote )
• AcquistionYear ( type: esriFieldTypeDouble, alias: AcquistionYear, editable: true, nullable: true, defaultValue: null, modelName: AcquistionYear )
• Assumptions ( type: esriFieldTypeString, alias: Assumptions, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Assumptions )
• Project_Phase ( type: esriFieldTypeDate, alias: Project_Phase, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Project_Phase )
• COST_Purchase ( type: esriFieldTypeDouble, alias: COST_Purchase, editable: true, nullable: true, defaultValue: null, modelName: COST_Purchase )
• DATE_Purchase ( type: esriFieldTypeDate, alias: DATE_Purchase, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_Purchase )
• EUL_YEARS ( type: esriFieldTypeDouble, alias: EUL_YEARS, editable: true, nullable: true, defaultValue: null, modelName: EUL_YEARS )
• RUL ( type: esriFieldTypeDouble, alias: RUL, editable: true, nullable: true, defaultValue: null, modelName: RUL )
• Age ( type: esriFieldTypeDouble, alias: Age, editable: true, nullable: true, defaultValue: null, modelName: Age )
• COST_OpeningBalance ( type: esriFieldTypeDouble, alias: COST_OpeningBalance, editable: true, nullable: true, defaultValue: null, modelName: COST_OpeningBalance )
• Cost_Additions ( type: esriFieldTypeDouble, alias: Cost_Additions, editable: true, nullable: true, defaultValue: null, modelName: Cost_Additions )
• Cost_Disposals ( type: esriFieldTypeDouble, alias: Cost_Disposals, editable: true, nullable: true, defaultValue: null, modelName: Cost_Disposals )
• COST_ClosingBalance ( type: esriFieldTypeDouble, alias: COST_ClosingBalance, editable: true, nullable: true, defaultValue: null, modelName: COST_ClosingBalance )
• NEW_ACC_OPENING_DEPR ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR, editable: true, nullable: true, defaultValue: null, modelName: NEW_ACC_OPENING_DEPR )
• NEW_DEPRECIATION ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION, editable: true, nullable: true, defaultValue: null, modelName: NEW_DEPRECIATION )
• NEW_ACC_CLOSING_DEPR ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR, editable: true, nullable: true, defaultValue: null, modelName: NEW_ACC_CLOSING_DEPR )
• NEW_CV ( type: esriFieldTypeDouble, alias: NEW_CV, editable: true, nullable: true, defaultValue: null, modelName: NEW_CV )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: FINANCIAL
  Description:
  Prototype:
  NEW_ACC_CLOSING_DEPR: null
  AssetGUID: null
  FinancialYear: null
  Adjustment: null
  Action_: null
  Depreciation_Method: null
  Owner: null
  Type: null
  TakeOnDate: null
  AcquisitionDate: null
  DisposalDate: null
  Status: null
  Plant: null
  AcqNote: null
  AcquistionYear: null
  Assumptions: null
  Project_Phase: null
  COST_Purchase: null
  DATE_Purchase: null
  EUL_YEARS: null
  RUL: null
  Age: null
  COST_OpeningBalance: null
  Cost_Additions: null
  Cost_Disposals: null
  COST_ClosingBalance: null
  NEW_ACC_OPENING_DEPR: null
  NEW_DEPRECIATION: null
  NEW_CV: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PUMP STATION (1) -- Related To: Pump Station (23)
• RESRVOIRS (2) -- Related To: Reservoir (24)
• WATER PIPES (3) -- Related To: WaterPipes (41)
• Water Meters (0) -- Related To: Water Meters_FAR (44)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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