{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "Utilities_Water.dbo.vCustInfo_GIS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CUSTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "UniqIDs", "type": "esriFieldTypeOID", "alias": "UniqIDs", "domain": null }, { "name": "DESCRIPT_1", "type": "esriFieldTypeString", "alias": "DESCRIPT_1", "length": 25, "domain": null }, { "name": "OLDACCTNBR", "type": "esriFieldTypeString", "alias": "OLDACCTNBR", "length": 18, "domain": null }, { "name": "COUNTRY", "type": "esriFieldTypeString", "alias": "COUNTRY", "length": 15, "domain": null }, { "name": "COLLBAL", "type": "esriFieldTypeDouble", "alias": "COLLBAL", "domain": null }, { "name": "WORKPHONE", "type": "esriFieldTypeDouble", "alias": "WORKPHONE", "domain": null }, { "name": "TAX_PCT_I", "type": "esriFieldTypeSingle", "alias": "TAX_PCT_I", "domain": null }, { "name": "STREETPRF2", "type": "esriFieldTypeString", "alias": "STREETPRF2", "length": 2, "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIPCODE", "length": 10, "domain": null }, { "name": "STREETDIR2", "type": "esriFieldTypeString", "alias": "STREETDIR2", "length": 2, "domain": null }, { "name": "PHONETIC", "type": "esriFieldTypeString", "alias": "PHONETIC", "length": 5, "domain": null }, { "name": "WOFFAMOUNT", "type": "esriFieldTypeDouble", "alias": "WOFFAMOUNT", "domain": null }, { "name": "PYMTDTE", "type": "esriFieldTypeInteger", "alias": "PYMTDTE", "domain": null }, { "name": "COLLAGENCY", "type": "esriFieldTypeString", "alias": "COLLAGENCY", "length": 5, "domain": null }, { "name": "BUDAMT", "type": "esriFieldTypeDouble", "alias": "BUDAMT", "domain": null }, { "name": "DRVLICNO2", "type": "esriFieldTypeString", "alias": "DRVLICNO2", "length": 15, "domain": null }, { "name": "REMSWDISC", "type": "esriFieldTypeDouble", "alias": "REMSWDISC", "domain": null }, { "name": "SEWRUSG", "type": "esriFieldTypeInteger", "alias": "SEWRUSG", "domain": null }, { "name": "PYMTDTNUM", "type": "esriFieldTypeInteger", "alias": "PYMTDTNUM", "domain": null }, { "name": "RELATION", "type": "esriFieldTypeString", "alias": "RELATION", "length": 10, "domain": null }, { "name": "EXEMPT", "type": "esriFieldTypeString", "alias": "EXEMPT", "length": 1, "domain": null }, { "name": "USERTYPE", "type": "esriFieldTypeString", "alias": "USERTYPE", "length": 5, "domain": null }, { "name": "HOLDBILL", "type": "esriFieldTypeString", "alias": "HOLDBILL", "length": 1, "domain": null }, { "name": "HOLDDEP", "type": "esriFieldTypeString", "alias": "HOLDDEP", "length": 1, "domain": null }, { "name": "AIDAMT", "type": "esriFieldTypeSingle", "alias": "AIDAMT", "domain": null }, { "name": "ORG_NBR", "type": "esriFieldTypeSmallInteger", "alias": "ORG_NBR", "domain": null }, { "name": "TAX_PCT", "type": "esriFieldTypeSingle", "alias": "TAX_PCT", "domain": null }, { "name": "XSTATUS", "type": "esriFieldTypeString", "alias": "XSTATUS", "length": 2, "domain": null }, { "name": "ACHACCTNBR", "type": "esriFieldTypeString", "alias": "ACHACCTNBR", "length": 17, "domain": null }, { "name": "COLLDATNUM", "type": "esriFieldTypeInteger", "alias": "COLLDATNUM", "domain": null }, { "name": "SURETYAMT", "type": "esriFieldTypeDouble", "alias": "SURETYAMT", "domain": null }, { "name": "OUTSIDER", "type": "esriFieldTypeString", "alias": "OUTSIDER", "length": 1, "domain": null }, { "name": "STREETTYP2", "type": "esriFieldTypeString", "alias": "STREETTYP2", "length": 5, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 25, "domain": null }, { "name": "RETCHDT", "type": "esriFieldTypeInteger", "alias": "RETCHDT", "domain": null }, { "name": "PHONENBR", "type": "esriFieldTypeDouble", "alias": "PHONENBR", "domain": null }, { "name": "OPENDATE", "type": "esriFieldTypeInteger", "alias": "OPENDATE", "domain": null }, { "name": "CUSTNAME", "type": "esriFieldTypeString", "alias": "CUSTNAME", "length": 25, "domain": null }, { "name": "SURETYEXP", "type": "esriFieldTypeInteger", "alias": "SURETYEXP", "domain": null }, { "name": "ACHBANKNBR", "type": "esriFieldTypeInteger", "alias": "ACHBANKNBR", "domain": null }, { "name": "COLLDATE", "type": "esriFieldTypeInteger", "alias": "COLLDATE", "domain": null }, { "name": "CLOSEDATE", "type": "esriFieldTypeInteger", "alias": "CLOSEDATE", "domain": null }, { "name": "CLSEDATNUM", "type": "esriFieldTypeInteger", "alias": "CLSEDATNUM", "domain": null }, { "name": "CUSTNAME2", "type": "esriFieldTypeString", "alias": "CUSTNAME2", "length": 25, "domain": null }, { "name": "ACCTBAL", "type": "esriFieldTypeDouble", "alias": "ACCTBAL", "domain": null }, { "name": "AUTOPAYFL", "type": "esriFieldTypeString", "alias": "AUTOPAYFL", "length": 1, "domain": null }, { "name": "SSN", "type": "esriFieldTypeInteger", "alias": "SSN", "domain": null }, { "name": "BUDSETDTE", "type": "esriFieldTypeInteger", "alias": "BUDSETDTE", "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 2, "domain": null }, { "name": "MAILSUITE", "type": "esriFieldTypeString", "alias": "MAILSUITE", "length": 10, "domain": null }, { "name": "CARRIERRTE", "type": "esriFieldTypeString", "alias": "CARRIERRTE", "length": 4, "domain": null }, { "name": "ACCT_STAT", "type": "esriFieldTypeString", "alias": "ACCT_STAT", "length": 5, "domain": null }, { "name": "STREET2", "type": "esriFieldTypeString", "alias": "STREET2", "length": 25, "domain": null }, { "name": "STREETNBR2", "type": "esriFieldTypeInteger", "alias": "STREETNBR2", "domain": null }, { "name": "REASON", "type": "esriFieldTypeString", "alias": "REASON", "length": 67, "domain": null }, { "name": "BUDTYP", "type": "esriFieldTypeString", "alias": "BUDTYP", "length": 6, "domain": null }, { "name": "REL_DATE", "type": "esriFieldTypeInteger", "alias": "REL_DATE", "domain": null }, { "name": "SSN2", "type": "esriFieldTypeInteger", "alias": "SSN2", "domain": null }, { "name": "O_R", "type": "esriFieldTypeString", "alias": "O_R", "length": 1, "domain": null }, { "name": "DOLLARAID", "type": "esriFieldTypeString", "alias": "DOLLARAID", "length": 1, "domain": null }, { "name": "ADDLNAME", "type": "esriFieldTypeString", "alias": "ADDLNAME", "length": 25, "domain": null }, { "name": "DOB", "type": "esriFieldTypeInteger", "alias": "DOB", "domain": null }, { "name": "BILL", "type": "esriFieldTypeString", "alias": "BILL", "length": 1, "domain": null }, { "name": "LASTBILL", "type": "esriFieldTypeInteger", "alias": "LASTBILL", "domain": null }, { "name": "ACHACCTYPE", "type": "esriFieldTypeString", "alias": "ACHACCTYPE", "length": 1, "domain": null }, { "name": "APPLYDEPIN", "type": "esriFieldTypeString", "alias": "APPLYDEPIN", "length": 1, "domain": null }, { "name": "CHECKDIGIT", "type": "esriFieldTypeSmallInteger", "alias": "CHECKDIGIT", "domain": null }, { "name": "WORD4", "type": "esriFieldTypeString", "alias": "WORD4", "length": 25, "domain": null }, { "name": "WORD3", "type": "esriFieldTypeString", "alias": "WORD3", "length": 25, "domain": null }, { "name": "MAINT", "type": "esriFieldTypeString", "alias": "MAINT", "length": 1, "domain": null }, { "name": "WORD2", "type": "esriFieldTypeString", "alias": "WORD2", "length": 25, "domain": null }, { "name": "WORD1", "type": "esriFieldTypeString", "alias": "WORD1", "length": 25, "domain": null }, { "name": "SPECHANDFL", "type": "esriFieldTypeString", "alias": "SPECHANDFL", "length": 5, "domain": null }, { "name": "EXPIRDATE", "type": "esriFieldTypeInteger", "alias": "EXPIRDATE", "domain": null }, { "name": "COMPANY", "type": "esriFieldTypeString", "alias": "COMPANY", "length": 22, "domain": null }, { "name": "APPLYDEP", "type": "esriFieldTypeString", "alias": "APPLYDEP", "length": 1, "domain": null }, { "name": "EXEMPTDIS", "type": "esriFieldTypeString", "alias": "EXEMPTDIS", "length": 1, "domain": null }, { "name": "ADDRESS1", "type": "esriFieldTypeString", "alias": "ADDRESS1", "length": 25, "domain": null }, { "name": "BUDBILDTE", "type": "esriFieldTypeInteger", "alias": "BUDBILDTE", "domain": null }, { "name": "AUTHCD", "type": "esriFieldTypeString", "alias": "AUTHCD", "length": 5, "domain": null }, { "name": "LSTDELQDT", "type": "esriFieldTypeInteger", "alias": "LSTDELQDT", "domain": null }, { "name": "DRVLICNO", "type": "esriFieldTypeString", "alias": "DRVLICNO", "length": 15, "domain": null }, { "name": "HOLDPRNT", "type": "esriFieldTypeString", "alias": "HOLDPRNT", "length": 1, "domain": null }, { "name": "LIENDT", "type": "esriFieldTypeInteger", "alias": "LIENDT", "domain": null }, { "name": "REMWADISC", "type": "esriFieldTypeDouble", "alias": "REMWADISC", "domain": null }, { "name": "OWNERSNAME", "type": "esriFieldTypeDouble", "alias": "OWNERSNAME", "domain": null }, { "name": "CUSTNO", "type": "esriFieldTypeDouble", "alias": "CUSTNO", "domain": null }, { "name": "WOFFDATE", "type": "esriFieldTypeInteger", "alias": "WOFFDATE", "domain": null }, { "name": "EXEMPTCOL", "type": "esriFieldTypeString", "alias": "EXEMPTCOL", "length": 1, "domain": null }, { "name": "REQTIME", "type": "esriFieldTypeInteger", "alias": "REQTIME", "domain": null }, { "name": "MESSAGENBR", "type": "esriFieldTypeSmallInteger", "alias": "MESSAGENBR", "domain": null }, { "name": "SRVCKY", "type": "esriFieldTypeInteger", "alias": "SRVCKY", "domain": null }, { "name": "ADDRSNBR", "type": "esriFieldTypeSmallInteger", "alias": "ADDRSNBR", "domain": null }, { "name": "FRAHOUSE2", "type": "esriFieldTypeString", "alias": "FRAHOUSE2", "length": 5, "domain": null }, { "name": "PRVCLSDTNM", "type": "esriFieldTypeInteger", "alias": "PRVCLSDTNM", "domain": null }, { "name": "INQBUT", "type": "esriFieldTypeString", "alias": "INQBUT", "length": 1, "domain": null }, { "name": "OPENDATNUM", "type": "esriFieldTypeInteger", "alias": "OPENDATNUM", "domain": null }, { "name": "CONTFLOW", "type": "esriFieldTypeString", "alias": "CONTFLOW", "length": 1, "domain": null }, { "name": "EMAILADDR", "type": "esriFieldTypeString", "alias": "EMAILADDR", "length": 40, "domain": null }, { "name": "PRVCLSDATE", "type": "esriFieldTypeInteger", "alias": "PRVCLSDATE", "domain": null }, { "name": "SPHFREQ", "type": "esriFieldTypeSmallInteger", "alias": "SPHFREQ", "domain": null }, { "name": "EXEMPTLTE", "type": "esriFieldTypeString", "alias": "EXEMPTLTE", "length": 1, "domain": null }, { "name": "TRCODE", "type": "esriFieldTypeString", "alias": "TRCODE", "length": 6, "domain": null }, { "name": "QUANTITY", "type": "esriFieldTypeDouble", "alias": "QUANTITY", "domain": null }, { "name": "STREETPREF", "type": "esriFieldTypeString", "alias": "STREETPREF", "length": 2, "domain": null }, { "name": "STREETNBR", "type": "esriFieldTypeInteger", "alias": "STREETNBR", "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "STREET", "length": 25, "domain": null }, { "name": "STREETTYPE", "type": "esriFieldTypeString", "alias": "STREETTYPE", "length": 5, "domain": null }, { "name": "STREETDIR", "type": "esriFieldTypeString", "alias": "STREETDIR", "length": 2, "domain": null }, { "name": "SUITE", "type": "esriFieldTypeString", "alias": "SUITE", "length": 10, "domain": null }, { "name": "FRAHOUSE", "type": "esriFieldTypeString", "alias": "FRAHOUSE", "length": 5, "domain": null }, { "name": "ADKEY", "type": "esriFieldTypeInteger", "alias": "ADKEY", "domain": null }, { "name": "PROP_ID", "type": "esriFieldTypeString", "alias": "PROP_ID", "length": 40, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "fe991c69a9f44f0da5b97a0eead93cfc" }