Name: Utilities_Water.DBO.CustInfo
Display Field: CUSTNAME
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: ec469f334ff14ea7870ebbfc891d2891
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
)
-
DESCRIPT_1
(
type: esriFieldTypeString, alias: DESCRIPT_1, length: 25
)
-
OLDACCTNBR
(
type: esriFieldTypeString, alias: OLDACCTNBR, length: 18
)
-
COUNTRY
(
type: esriFieldTypeString, alias: COUNTRY, length: 15
)
-
COLLBAL
(
type: esriFieldTypeDouble, alias: COLLBAL
)
-
WORKPHONE
(
type: esriFieldTypeDouble, alias: WORKPHONE
)
-
TAX_PCT_I
(
type: esriFieldTypeSingle, alias: TAX_PCT_I
)
-
STREETPRF2
(
type: esriFieldTypeString, alias: STREETPRF2, length: 2
)
-
ZIPCODE
(
type: esriFieldTypeString, alias: ZIPCODE, length: 10
)
-
STREETDIR2
(
type: esriFieldTypeString, alias: STREETDIR2, length: 2
)
-
PHONETIC
(
type: esriFieldTypeString, alias: PHONETIC, length: 5
)
-
WOFFAMOUNT
(
type: esriFieldTypeDouble, alias: WOFFAMOUNT
)
-
PYMTDTE
(
type: esriFieldTypeInteger, alias: PYMTDTE
)
-
COLLAGENCY
(
type: esriFieldTypeString, alias: COLLAGENCY, length: 5
)
-
BUDAMT
(
type: esriFieldTypeDouble, alias: BUDAMT
)
-
DRVLICNO2
(
type: esriFieldTypeString, alias: DRVLICNO2, length: 15
)
-
REMSWDISC
(
type: esriFieldTypeDouble, alias: REMSWDISC
)
-
SEWRUSG
(
type: esriFieldTypeInteger, alias: SEWRUSG
)
-
PYMTDTNUM
(
type: esriFieldTypeInteger, alias: PYMTDTNUM
)
-
RELATION
(
type: esriFieldTypeString, alias: RELATION, length: 10
)
-
EXEMPT
(
type: esriFieldTypeString, alias: EXEMPT, length: 1
)
-
USERTYPE
(
type: esriFieldTypeString, alias: USERTYPE, length: 5
)
-
HOLDBILL
(
type: esriFieldTypeString, alias: HOLDBILL, length: 1
)
-
HOLDDEP
(
type: esriFieldTypeString, alias: HOLDDEP, length: 1
)
-
AIDAMT
(
type: esriFieldTypeSingle, alias: AIDAMT
)
-
ORG_NBR
(
type: esriFieldTypeSmallInteger, alias: ORG_NBR
)
-
TAX_PCT
(
type: esriFieldTypeSingle, alias: TAX_PCT
)
-
XSTATUS
(
type: esriFieldTypeString, alias: XSTATUS, length: 2
)
-
ACHACCTNBR
(
type: esriFieldTypeString, alias: ACHACCTNBR, length: 17
)
-
COLLDATNUM
(
type: esriFieldTypeInteger, alias: COLLDATNUM
)
-
SURETYAMT
(
type: esriFieldTypeDouble, alias: SURETYAMT
)
-
OUTSIDER
(
type: esriFieldTypeString, alias: OUTSIDER, length: 1
)
-
STREETTYP2
(
type: esriFieldTypeString, alias: STREETTYP2, length: 5
)
-
CITY
(
type: esriFieldTypeString, alias: CITY, length: 25
)
-
RETCHDT
(
type: esriFieldTypeInteger, alias: RETCHDT
)
-
PHONENBR
(
type: esriFieldTypeDouble, alias: PHONENBR
)
-
OPENDATE
(
type: esriFieldTypeInteger, alias: OPENDATE
)
-
CUSTNAME
(
type: esriFieldTypeString, alias: CUSTNAME, length: 25
)
-
SURETYEXP
(
type: esriFieldTypeInteger, alias: SURETYEXP
)
-
ACHBANKNBR
(
type: esriFieldTypeInteger, alias: ACHBANKNBR
)
-
COLLDATE
(
type: esriFieldTypeInteger, alias: COLLDATE
)
-
CLOSEDATE
(
type: esriFieldTypeInteger, alias: CLOSEDATE
)
-
CLSEDATNUM
(
type: esriFieldTypeInteger, alias: CLSEDATNUM
)
-
CUSTNAME2
(
type: esriFieldTypeString, alias: CUSTNAME2, length: 25
)
-
ACCTBAL
(
type: esriFieldTypeDouble, alias: ACCTBAL
)
-
AUTOPAYFL
(
type: esriFieldTypeString, alias: AUTOPAYFL, length: 1
)
-
SSN
(
type: esriFieldTypeInteger, alias: SSN
)
-
BUDSETDTE
(
type: esriFieldTypeInteger, alias: BUDSETDTE
)
-
STATE
(
type: esriFieldTypeString, alias: STATE, length: 2
)
-
MAILSUITE
(
type: esriFieldTypeString, alias: MAILSUITE, length: 10
)
-
CARRIERRTE
(
type: esriFieldTypeString, alias: CARRIERRTE, length: 4
)
-
ACCT_STAT
(
type: esriFieldTypeString, alias: ACCT_STAT, length: 5
)
-
STREET2
(
type: esriFieldTypeString, alias: STREET2, length: 25
)
-
STREETNBR2
(
type: esriFieldTypeInteger, alias: STREETNBR2
)
-
REASON
(
type: esriFieldTypeString, alias: REASON, length: 67
)
-
BUDTYP
(
type: esriFieldTypeString, alias: BUDTYP, length: 6
)
-
REL_DATE
(
type: esriFieldTypeInteger, alias: REL_DATE
)
-
SSN2
(
type: esriFieldTypeInteger, alias: SSN2
)
-
O_R
(
type: esriFieldTypeString, alias: O_R, length: 1
)
-
DOLLARAID
(
type: esriFieldTypeString, alias: DOLLARAID, length: 1
)
-
ADDLNAME
(
type: esriFieldTypeString, alias: ADDLNAME, length: 25
)
-
DOB
(
type: esriFieldTypeInteger, alias: DOB
)
-
BILL
(
type: esriFieldTypeString, alias: BILL, length: 1
)
-
LASTBILL
(
type: esriFieldTypeInteger, alias: LASTBILL
)
-
ACHACCTYPE
(
type: esriFieldTypeString, alias: ACHACCTYPE, length: 1
)
-
APPLYDEPIN
(
type: esriFieldTypeString, alias: APPLYDEPIN, length: 1
)
-
CHECKDIGIT
(
type: esriFieldTypeSmallInteger, alias: CHECKDIGIT
)
-
WORD4
(
type: esriFieldTypeString, alias: WORD4, length: 25
)
-
WORD3
(
type: esriFieldTypeString, alias: WORD3, length: 25
)
-
MAINT
(
type: esriFieldTypeString, alias: MAINT, length: 1
)
-
WORD2
(
type: esriFieldTypeString, alias: WORD2, length: 25
)
-
WORD1
(
type: esriFieldTypeString, alias: WORD1, length: 25
)
-
SPECHANDFL
(
type: esriFieldTypeString, alias: SPECHANDFL, length: 5
)
-
EXPIRDATE
(
type: esriFieldTypeInteger, alias: EXPIRDATE
)
-
COMPANY
(
type: esriFieldTypeString, alias: COMPANY, length: 22
)
-
APPLYDEP
(
type: esriFieldTypeString, alias: APPLYDEP, length: 1
)
-
EXEMPTDIS
(
type: esriFieldTypeString, alias: EXEMPTDIS, length: 1
)
-
ADDRESS1
(
type: esriFieldTypeString, alias: ADDRESS1, length: 25
)
-
BUDBILDTE
(
type: esriFieldTypeInteger, alias: BUDBILDTE
)
-
AUTHCD
(
type: esriFieldTypeString, alias: AUTHCD, length: 5
)
-
LSTDELQDT
(
type: esriFieldTypeInteger, alias: LSTDELQDT
)
-
DRVLICNO
(
type: esriFieldTypeString, alias: DRVLICNO, length: 15
)
-
HOLDPRNT
(
type: esriFieldTypeString, alias: HOLDPRNT, length: 1
)
-
LIENDT
(
type: esriFieldTypeInteger, alias: LIENDT
)
-
REMWADISC
(
type: esriFieldTypeDouble, alias: REMWADISC
)
-
OWNERSNAME
(
type: esriFieldTypeDouble, alias: OWNERSNAME
)
-
CUSTNO
(
type: esriFieldTypeDouble, alias: CUSTNO
)
-
WOFFDATE
(
type: esriFieldTypeInteger, alias: WOFFDATE
)
-
EXEMPTCOL
(
type: esriFieldTypeString, alias: EXEMPTCOL, length: 1
)
-
REQTIME
(
type: esriFieldTypeInteger, alias: REQTIME
)
-
MESSAGENBR
(
type: esriFieldTypeSmallInteger, alias: MESSAGENBR
)
-
SRVCKY
(
type: esriFieldTypeInteger, alias: SRVCKY
)
-
ADDRSNBR
(
type: esriFieldTypeSmallInteger, alias: ADDRSNBR
)
-
FRAHOUSE2
(
type: esriFieldTypeString, alias: FRAHOUSE2, length: 5
)
-
PRVCLSDTNM
(
type: esriFieldTypeInteger, alias: PRVCLSDTNM
)
-
INQBUT
(
type: esriFieldTypeString, alias: INQBUT, length: 1
)
-
OPENDATNUM
(
type: esriFieldTypeInteger, alias: OPENDATNUM
)
-
CONTFLOW
(
type: esriFieldTypeString, alias: CONTFLOW, length: 1
)
-
EMAILADDR
(
type: esriFieldTypeString, alias: EMAILADDR, length: 40
)
-
PRVCLSDATE
(
type: esriFieldTypeInteger, alias: PRVCLSDATE
)
-
SPHFREQ
(
type: esriFieldTypeSmallInteger, alias: SPHFREQ
)
-
EXEMPTLTE
(
type: esriFieldTypeString, alias: EXEMPTLTE, length: 1
)
-
TRCODE
(
type: esriFieldTypeString, alias: TRCODE, length: 6
)
-
QUANTITY
(
type: esriFieldTypeDouble, alias: QUANTITY
)
-
STREETPREF
(
type: esriFieldTypeString, alias: STREETPREF, length: 2
)
-
STREETNBR
(
type: esriFieldTypeInteger, alias: STREETNBR
)
-
STREET
(
type: esriFieldTypeString, alias: STREET, length: 25
)
-
STREETTYPE
(
type: esriFieldTypeString, alias: STREETTYPE, length: 5
)
-
STREETDIR
(
type: esriFieldTypeString, alias: STREETDIR, length: 2
)
-
SUITE
(
type: esriFieldTypeString, alias: SUITE, length: 10
)
-
FRAHOUSE
(
type: esriFieldTypeString, alias: FRAHOUSE, length: 5
)
-
ADKEY
(
type: esriFieldTypeInteger, alias: ADKEY
)
-
PROP_ID
(
type: esriFieldTypeString, alias: PROP_ID, length: 40
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata