Name: mcse.DBO.water_customers
Display Field: PersonFName
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: 28659617f7714668bc55c949803a4c7b
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
CustomerID
(
type: esriFieldTypeInteger, alias: CustomerID
)
-
AccountNo
(
type: esriFieldTypeInteger, alias: AccountNo
)
-
CustomerType
(
type: esriFieldTypeString, alias: CustomerType, length: 1073741822
)
-
PersonFName
(
type: esriFieldTypeString, alias: PersonFName, length: 1073741822
)
-
PersonLName_BusinessName
(
type: esriFieldTypeString, alias: PersonLName/BusinessName, length: 1073741822
)
-
CustomerAdrs1
(
type: esriFieldTypeString, alias: CustomerAdrs1, length: 1073741822
)
-
City
(
type: esriFieldTypeString, alias: City, length: 1073741822
)
-
State
(
type: esriFieldTypeString, alias: State, length: 1073741822
)
-
ZIP
(
type: esriFieldTypeString, alias: ZIP, length: 1073741822
)
-
LocationID
(
type: esriFieldTypeInteger, alias: LocationID
)
-
LocationNo
(
type: esriFieldTypeInteger, alias: LocationNo
)
-
ParcelNo
(
type: esriFieldTypeString, alias: ParcelNo, length: 1073741822
)
-
ServiceAddress
(
type: esriFieldTypeString, alias: ServiceAddress, length: 1073741822
)
-
LocationCity
(
type: esriFieldTypeString, alias: LocationCity, length: 1073741822
)
-
LocationState
(
type: esriFieldTypeString, alias: LocationState, length: 1073741822
)
-
LocationZIP
(
type: esriFieldTypeString, alias: LocationZIP, length: 1073741822
)
-
ServiceName
(
type: esriFieldTypeString, alias: ServiceName, length: 1073741822
)
-
Active
(
type: esriFieldTypeString, alias: Active, length: 1073741822
)
-
Status
(
type: esriFieldTypeInteger, alias: Status
)
-
Route
(
type: esriFieldTypeString, alias: Route, length: 1073741822
)
-
BillingCycle
(
type: esriFieldTypeInteger, alias: BillingCycle
)
-
PumpStation
(
type: esriFieldTypeInteger, alias: PumpStation
)
-
WaterSystem
(
type: esriFieldTypeString, alias: WaterSystem, length: 1073741822
)
Supported Operations:
Query
Query Attachments
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata