Name: vectorGIS_prd.DBO.WR_BillingData
Display Field: CustomerName
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
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:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
UTAcctNum
(
type: esriFieldTypeString, alias: UTAcctNum, length: 9
)
-
CustomerName
(
type: esriFieldTypeString, alias: CustomerName, length: 60
)
-
ServiceAddress
(
type: esriFieldTypeString, alias: ServiceAddress, length: 50
)
-
ServiceCity
(
type: esriFieldTypeString, alias: ServiceCity, length: 30
)
-
ServiceState
(
type: esriFieldTypeString, alias: ServiceState, length: 2
)
-
ServiceZip
(
type: esriFieldTypeString, alias: ServiceZip, length: 10
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
)
-
AccountServices
(
type: esriFieldTypeString, alias: AccountServices, length: 300
)
-
CustomerType
(
type: esriFieldTypeString, alias: CustomerType, length: 50
)
-
ParcelID
(
type: esriFieldTypeString, alias: ParcelID, length: 50
)
-
WaterAvailable
(
type: esriFieldTypeSmallInteger, alias: WaterAvailable
)
-
SewerAvailable
(
type: esriFieldTypeSmallInteger, alias: SewerAvailable
)
-
SFU_Rate
(
type: esriFieldTypeDouble, alias: SFU_Rate
)
-
Route
(
type: esriFieldTypeString, alias: Route, length: 32
)
-
TrashRateCode
(
type: esriFieldTypeString, alias: TrashRateCode, length: 50
)
-
TrashRateDescription
(
type: esriFieldTypeString, alias: TrashRateDescription, length: 150
)
-
HouseNumber
(
type: esriFieldTypeString, alias: HouseNumber, length: 50
)
-
Street
(
type: esriFieldTypeString, alias: Street, length: 150
)
-
Street_Type
(
type: esriFieldTypeString, alias: Street_Type, length: 10
)
-
Apartment
(
type: esriFieldTypeString, alias: Apartment, length: 10
)
-
Date_Account_Opened
(
type: esriFieldTypeDate, alias: Date_Account_Opened, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata