Name: Financial

Display Field: AssetGuidG

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: c52f93eec96944819a94c01bd183ad1d

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: null

Fields:

• AssetGuidG ( type: esriFieldTypeString, alias: AssetGuidG, length: 255 )
• TakeOnDate ( type: esriFieldTypeDate, alias: TakeOnDate, length: 8 )
• AcquisitionDate ( type: esriFieldTypeDate, alias: AcquisitionDate, length: 8 )
• Plant ( type: esriFieldTypeString, alias: Plant, length: 255 )
• GiscoeValuationQuerry ( type: esriFieldTypeString, alias: GiscoeValuationQuerry, length: 255 )
• AcqNote ( type: esriFieldTypeString, alias: AcqNote, length: 255 )
• AcquistionYear ( type: esriFieldTypeDouble, alias: AcquistionYear )
• F41 ( type: esriFieldTypeString, alias: F41, length: 255 )
• Phase ( type: esriFieldTypeString, alias: Phase, length: 255 )
• Assumptions ( type: esriFieldTypeString, alias: Assumptions, length: 255 )
• COST_Purchase ( type: esriFieldTypeDouble, alias: COST_Purchase )
• DATE_Purchase ( type: esriFieldTypeDate, alias: DATE_Purchase, length: 8 )
• EUL_YEARS ( type: esriFieldTypeDouble, alias: EUL_YEARS )
• RUL_30June2008__Year ( type: esriFieldTypeDouble, alias: RUL_30June2008__Year )
• RUL_30June2009_Year ( type: esriFieldTypeDouble, alias: RUL_30June2009_Year )
• RUL_30June2010_Year ( type: esriFieldTypeDouble, alias: RUL_30June2010_Year )
• RUL_30June2011_Year ( type: esriFieldTypeDouble, alias: RUL_30June2011_Year )
• RUL_30June2012Year ( type: esriFieldTypeDouble, alias: RUL_30June2012Year )
• RUL_30June2013_Year ( type: esriFieldTypeDouble, alias: RUL_30June2013_Year )
• RUL_30June2014_Year ( type: esriFieldTypeDouble, alias: RUL_30June2014_Year )
• RUL_30June2015_Year ( type: esriFieldTypeDouble, alias: RUL_30June2015_Year )
• RUL_30June2016_Year ( type: esriFieldTypeDouble, alias: RUL_30June2016_Year )
• Age_2007_2008 ( type: esriFieldTypeDouble, alias: Age_2007_2008 )
• Age_2008_2009 ( type: esriFieldTypeDouble, alias: Age_2008_2009 )
• Age_2009_2010 ( type: esriFieldTypeDouble, alias: Age_2009_2010 )
• Age_2010_2011 ( type: esriFieldTypeDouble, alias: Age_2010_2011 )
• Age_2011_2012 ( type: esriFieldTypeDouble, alias: Age_2011_2012 )
• Age_2012_2013 ( type: esriFieldTypeDouble, alias: Age_2012_2013 )
• Age_2013_2014 ( type: esriFieldTypeDouble, alias: Age_2013_2014 )
• Age_2014_2015 ( type: esriFieldTypeDouble, alias: Age_2014_2015 )
• Age_2015_2016 ( type: esriFieldTypeDouble, alias: Age_2015_2016 )
• COST_OpeningBalance_2008 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2008 )
• Cost_Addition_2007_2008 ( type: esriFieldTypeDouble, alias: Cost_Addition_2007_2008 )
• COST_ClosingBalance_2008 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2008 )
• NEW_ACC_OPENING_DEPR_2007_2008 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2007_2008 )
• NEW_DEPRECIATION_2007_2008 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2007_2008 )
• NEW_ACC_CLOSING_DEPR_2007_2008 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2007_2008 )
• NEW_CV_2007_2008 ( type: esriFieldTypeDouble, alias: NEW_CV_2007_2008 )
• COST_OpeningBalance_2009 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2009 )
• Cost_Addition_2008_2009 ( type: esriFieldTypeDouble, alias: Cost_Addition_2008_2009 )
• COST_ClosingBalance_2009 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2009 )
• NEW_ACC_OPENING_DEPR_2008_2009 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2008_2009 )
• NEW_DEPRECIATION_2008_2009 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2008_2009 )
• NEW_ACC_CLOSING_DEPR_2008_2009 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2008_2009 )
• NEW_CV_2008_2009 ( type: esriFieldTypeDouble, alias: NEW_CV_2008_2009 )
• COST_OpeningBalance_2010 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2010 )
• Cost_Addition_2009_2010 ( type: esriFieldTypeDouble, alias: Cost_Addition_2009_2010 )
• COST_ClosingBalance_2010 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2010 )
• NEW_ACC_OPENING_DEPR_2009_2010 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2009_2010 )
• NEW_DEPRECIATION_2009_2010 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2009_2010 )
• NEW_ACC_CLOSING_DEPR_2009_2010 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2009_2010 )
• NEW_CV_2009_2010 ( type: esriFieldTypeDouble, alias: NEW_CV_2009_2010 )
• COST_OpeningBalance_2011 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2011 )
• Cost_Addition_2010_2011 ( type: esriFieldTypeDouble, alias: Cost_Addition_2010_2011 )
• COST_ClosingBalance_2011 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2011 )
• NEW_ACC_OPENING_DEPR_2010_2011 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2010_2011 )
• NEW_DEPRECIATION_2010_2011 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2010_2011 )
• NEW_ACC_CLOSING_DEPR_2010_2011 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2010_2011 )
• NEW_CV_2010_2011 ( type: esriFieldTypeDouble, alias: NEW_CV_2010_2011 )
• COST_OpeningBalance_2012 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2012 )
• Cost_Addition_2011_2012 ( type: esriFieldTypeDouble, alias: Cost_Addition_2011_2012 )
• COST_ClosingBalance_2012 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2012 )
• NEW_ACC_OPENING_DEPR_2011_2012 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2011_2012 )
• NEW_DEPRECIATION_2011_2012 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2011_2012 )
• NEW_ACC_CLOSING_DEPR_2011_2012 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2011_2012 )
• NEW_CV_2011_2012 ( type: esriFieldTypeDouble, alias: NEW_CV_2011_2012 )
• COST_OpeningBalance_2013 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2013 )
• Cost_Addition_2012_2013 ( type: esriFieldTypeDouble, alias: Cost_Addition_2012_2013 )
• COST_ClosingBalance_2013 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2013 )
• NEW_ACC_OPENING_DEPR_2012_2013 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2012_2013 )
• NEW_DEPRECIATION_2012_2013 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2012_2013 )
• NEW_ACC_CLOSING_DEPR_2012_2013 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2012_2013 )
• NEW_CV_2012_2013 ( type: esriFieldTypeDouble, alias: NEW_CV_2012_2013 )
• COST_OpeningBalance_2014 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2014 )
• Cost_Addition_2013_2014 ( type: esriFieldTypeDouble, alias: Cost_Addition_2013_2014 )
• COST_ClosingBalance_2014 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2014 )
• NEW_ACC_OPENING_DEPR_2013_2014 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2013_2014 )
• NEW_DEPRECIATION_2013_2014 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2013_2014 )
• NEW_ACC_CLOSING_DEPR_2013_2014 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2013_2014 )
• NEW_CV_2013_2014 ( type: esriFieldTypeDouble, alias: NEW_CV_2013_2014 )
• COST_OpeningBalance_2015 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2015 )
• Cost_Addition_2014_2015 ( type: esriFieldTypeDouble, alias: Cost_Addition_2014_2015 )
• COST_ClosingBalance_2015 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2015 )
• NEW_ACC_OPENING_DEPR_2014_2015 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2014_2015 )
• NEW_DEPRECIATION_2014_2015 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2014_2015 )
• NEW_ACC_CLOSING_DEPR_2014_2015 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2014_2015 )
• NEW_CV_2014_2015 ( type: esriFieldTypeDouble, alias: NEW_CV_2014_2015 )
• COST_OpeningBalance_2015_2016 ( type: esriFieldTypeDouble, alias: COST_OpeningBalance_2015_2016 )
• Cost_Addition_2015_2016 ( type: esriFieldTypeString, alias: Cost_Addition_2015_2016, length: 255 )
• Cost_Disposal ( type: esriFieldTypeString, alias: Cost_Disposal, length: 255 )
• COST_ClosingBalance_2015_2016 ( type: esriFieldTypeDouble, alias: COST_ClosingBalance_2015_2016 )
• NEW_ACC_OPENING_DEPR_2015_2016 ( type: esriFieldTypeDouble, alias: NEW_ACC_OPENING_DEPR_2015_2016 )
• NEW_DEPRECIATION_2015_2016 ( type: esriFieldTypeDouble, alias: NEW_DEPRECIATION_2015_2016 )
• NEW_ACC_CLOSING_DEPR_2015_2016 ( type: esriFieldTypeDouble, alias: NEW_ACC_CLOSING_DEPR_2015_2016 )
• Disposal_2015_2016 ( type: esriFieldTypeString, alias: Disposal_2015_2016, length: 255 )
• NEW_CV_2015_2016 ( type: esriFieldTypeDouble, alias: NEW_CV_2015_2016 )
• AssetGUID ( type: esriFieldTypeGUID, alias: AssetGUID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Relationships:

• Electrical (0) -- Related To: Publilc Lighting (0)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata