Name: SWSBU.dbo.CUSTOMERINQUIRIESviewQL
Display Field: CUSTOMERNAME
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: a1ec52d2d60d4f969b232c5006dd8c14
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:
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:
-
ID
(
type: esriFieldTypeOID, alias: ID
)
-
TYPE
(
type: esriFieldTypeString, alias: TYPE, length: 255
)
-
CONTACTDATE
(
type: esriFieldTypeDate, alias: CONTACTDATE, length: 8
)
-
HANDLEDBY
(
type: esriFieldTypeString, alias: HANDLEDBY, length: 255
)
-
CALLER
(
type: esriFieldTypeString, alias: CALLER, length: 255
)
-
PHONE
(
type: esriFieldTypeString, alias: PHONE, length: 255
)
-
ACCOUNT
(
type: esriFieldTypeInteger, alias: ACCOUNT
)
-
SITEADDRESS
(
type: esriFieldTypeString, alias: SITEADDRESS, length: 255
)
-
CUSTOMERID
(
type: esriFieldTypeInteger, alias: CUSTOMERID
)
-
CUSTOMERCONCERN
(
type: esriFieldTypeString, alias: CUSTOMERCONCERN, length: 255
)
-
ACCOUNTADJUSTMENT
(
type: esriFieldTypeSmallInteger, alias: ACCOUNTADJUSTMENT
)
-
REVENUEADJUSTMENT
(
type: esriFieldTypeSmallInteger, alias: REVENUEADJUSTMENT
)
-
COMMENTS
(
type: esriFieldTypeString, alias: COMMENTS, length: 255
)
-
DATEOFCONTACT
(
type: esriFieldTypeDate, alias: DATEOFCONTACT, length: 8
)
-
ADDRESSPOINT
(
type: esriFieldTypeString, alias: ADDRESSPOINT, length: 6
)
-
Revenue_Adjustment
(
type: esriFieldTypeDouble, alias: Revenue_Adjustment
)
-
RESIDENTIAL
(
type: esriFieldTypeSmallInteger, alias: RESIDENTIAL
)
-
NONRESIDENTIAL
(
type: esriFieldTypeSmallInteger, alias: NONRESIDENTIAL
)
-
PARCELID
(
type: esriFieldTypeInteger, alias: PARCELID
)
-
CUSTOMERNAME
(
type: esriFieldTypeString, alias: CUSTOMERNAME, length: 255
)
-
RESHOANONRES
(
type: esriFieldTypeString, alias: RESHOANONRES, length: 255
)
-
Email
(
type: esriFieldTypeString, alias: Email, length: 255
)
-
ServiceRequest
(
type: esriFieldTypeString, alias: ServiceRequest, length: 255
)
-
upsize_ts
(
type: esriFieldTypeBlob, alias: upsize_ts
)
-
MapSent
(
type: esriFieldTypeDate, alias: MapSent, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata