Name: Finance_Rporting
Display Field: month_
Type: Table
Geometry Type: N/A
Description:
Service Item Id: 79c90b51401a4d70abfc353db53a733e
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
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:
Feature Draw Order:
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
)
-
month_
(
modelName: month_, nullable: true, editable: true, defaultValue: null, length: 8000, alias: Month, type: esriFieldTypeString
)
-
budgeted_revenues
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: budgeted_revenues, alias: Actual Revenue
)
-
budgeted_expenses
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: budgeted_expenses, alias: Actual Expense
)
-
net_budgeted
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: net_budgeted, alias: Net Actual
)
-
actual_revenues
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: actual_revenues, alias: Budgeted Revenue
)
-
actual_expenses
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: actual_expenses, alias: Budgeted Expense
)
-
transfer_to_capital
(
modelName: transfer_to_capital, nullable: true, editable: true, defaultValue: null, alias: Transfer to Capital, type: esriFieldTypeDouble
)
-
net_actual
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: net_actual, alias: Net Budgeted
)
-
budgeted_recovery_ratio
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: budgeted_recovery_ratio, alias: Actual Recovery Ratio
)
-
actual_recovery_ratio
(
nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: actual_recovery_ratio, alias: Budgeted Recovery Ratio
)
Templates:
-
Name: Finance_Rporting
Description:
Prototype:
actual_recovery_ratio: null
budgeted_expenses: null
actual_revenues: null
transfer_to_capital: null
net_actual: null
budgeted_recovery_ratio: null
actual_expenses: null
net_budgeted: null
month_: null
budgeted_revenues: null
Drawing Tool: esriFeatureEditToolNone
Capabilities: Query
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
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata