Name: Fortis Material Consumption Report

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 137e8c31f9f94ad6a0de76812c70a964

Copyright Text: null

Default Visibility: false

MaxRecordCount: 5000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: false
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: true
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: null

Fields:

• work_order ( type: esriFieldTypeString, alias: Work Order, length: 255 )
• order_type ( type: esriFieldTypeString, alias: Order Type, length: 255 )
• mat ( type: esriFieldTypeString, alias: MAT, length: 255 )
• DBO.AMI_METERS_FORTIS_MATERIAL_CONSUMPTION.area ( type: esriFieldTypeString, alias: DBO.AMI_METERS_FORTIS_MATERIAL_CONSUMPTION.area, length: 255 )
• street ( type: esriFieldTypeString, alias: Street, length: 255 )
• city ( type: esriFieldTypeString, alias: City, length: 255 )
• mru ( type: esriFieldTypeString, alias: MRU, length: 255 )
• mru_portion ( type: esriFieldTypeString, alias: MRU Portion, length: 255 )
• appointment ( type: esriFieldTypeString, alias: Appointment, length: 255 )
• regulator ( type: esriFieldTypeString, alias: Regulator, length: 255 )
• regulator_changed ( type: esriFieldTypeString, alias: Regulator Changed?, length: 255 )
• regulator_reason ( type: esriFieldTypeString, alias: Reason For Not Changing, length: 255 )
• reg_tag ( type: esriFieldTypeString, alias: Reg Tag, length: 255 )
• inlet_old ( type: esriFieldTypeString, alias: OLD Inlet Valve, length: 255 )
• inlet_valve ( type: esriFieldTypeString, alias: Inlet Bypass Valve, length: 255 )
• inlet_id ( type: esriFieldTypeString, alias: Input Bypass Valve Batch ID, length: 255 )
• inlet_qty ( type: esriFieldTypeSmallInteger, alias: Inlet Bypass Valve QTY )
• outlet_old ( type: esriFieldTypeString, alias: Old Outlet Bypass Valve, length: 255 )
• outlet_valve ( type: esriFieldTypeString, alias: Outlet Bypass Valve, length: 255 )
• outlet_id ( type: esriFieldTypeString, alias: Outlet Bypass Valve Batch ID, length: 255 )
• outet_qty ( type: esriFieldTypeSmallInteger, alias: Outlet Bypass Valve QTY )
• thread_sealant ( type: esriFieldTypeString, alias: Thread Sealant, length: 255 )
• thread_id ( type: esriFieldTypeString, alias: Thread Sealant Batch ID, length: 255 )
• swing_joint ( type: esriFieldTypeString, alias: Swing Joint Upgrade, length: 255 )
• meter_old ( type: esriFieldTypeString, alias: Old Meter, length: 255 )
• meter_new ( type: esriFieldTypeString, alias: Installed New Meter, length: 255 )
• vehicle_id ( type: esriFieldTypeString, alias: Vehicle Id, length: 255 )
• mobile_user_id ( type: esriFieldTypeString, alias: Mobile User ID, length: 255 )
• creation_date ( type: esriFieldTypeDate, alias: Creation Datetime, length: 8 )
• completion_date ( type: esriFieldTypeDate, alias: Completion Datetime, length: 8 )
• enroute_date ( type: esriFieldTypeDate, alias: Enroute Date Time, length: 8 )
• onsite_date ( type: esriFieldTypeDate, alias: Onsite Date Time, length: 8 )
• suspend_date ( type: esriFieldTypeDate, alias: Suspend Date Time, length: 8 )
• skip_date ( type: esriFieldTypeDate, alias: Skip Date Time, length: 8 )
• switched_meter ( type: esriFieldTypeString, alias: Switched Meter, length: 255 )
• switched_meter_notes ( type: esriFieldTypeString, alias: Switched Meter Notes, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• area_name ( type: esriFieldTypeString, alias: Area Name, length: 255 )

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

  Iteminfo   Thumbnail   Metadata