{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 27, "name": "AA_AllCustomerView", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CUSTOMER_FIRSTNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SVC_HOUSENUMBER", "type": "esriFieldTypeDouble", "alias": "SVC_HOUSENUMBER", "domain": null }, { "name": "SVC_address", "type": "esriFieldTypeString", "alias": "SVC_address", "length": 40, "domain": null }, { "name": "ACCOUNT_NUMBER", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_NUMBER", "domain": null }, { "name": "CUSTOMER_NUMBER", "type": "esriFieldTypeDouble", "alias": "CUSTOMER_NUMBER", "domain": null }, { "name": "SERVICE_TYPE", "type": "esriFieldTypeString", "alias": "SERVICE_TYPE", "length": 5, "domain": null }, { "name": "STATUS_NUMBER", "type": "esriFieldTypeSmallInteger", "alias": "STATUS_NUMBER", "domain": null }, { "name": "STATUS_CODE", "type": "esriFieldTypeString", "alias": "STATUS_CODE", "length": 1, "domain": null }, { "name": "PRT_CODE", "type": "esriFieldTypeSmallInteger", "alias": "PRT_CODE", "domain": null }, { "name": "CUSTOMER_ADDRESS", "type": "esriFieldTypeString", "alias": "CUSTOMER_ADDRESS", "length": 122, "domain": null }, { "name": "CUSTOMER_CITY", "type": "esriFieldTypeString", "alias": "CUSTOMER_CITY", "length": 18, "domain": null }, { "name": "CUSTOMER_STATE", "type": "esriFieldTypeString", "alias": "CUSTOMER_STATE", "length": 2, "domain": null }, { "name": "CUSTOMER_ZIP", "type": "esriFieldTypeString", "alias": "CUSTOMER_ZIP", "length": 6, "domain": null }, { "name": "CUSTOMER_EMAIL", "type": "esriFieldTypeString", "alias": "CUSTOMER_EMAIL", "length": 50, "domain": null }, { "name": "CYCLE_CODE", "type": "esriFieldTypeSmallInteger", "alias": "CYCLE_CODE", "domain": null }, { "name": "NEWS_CODE", "type": "esriFieldTypeSmallInteger", "alias": "NEWS_CODE", "domain": null }, { "name": "CUSTOMER_FIRSTNAME", "type": "esriFieldTypeString", "alias": "CUSTOMER_FIRSTNAME", "length": 13, "domain": null }, { "name": "CUSTOMER_LASTNAME", "type": "esriFieldTypeString", "alias": "CUSTOMER_LASTNAME", "length": 17, "domain": null }, { "name": "CUSTOMER_MIDDLENAME", "type": "esriFieldTypeString", "alias": "CUSTOMER_MIDDLENAME", "length": 9, "domain": null }, { "name": "CUSTOMER_FULLNAME", "type": "esriFieldTypeString", "alias": "CUSTOMER_FULLNAME", "length": 36, "domain": null }, { "name": "CUSTOMER_HOMEPHONE", "type": "esriFieldTypeString", "alias": "CUSTOMER_HOMEPHONE", "length": 10, "domain": null }, { "name": "CUSTOMER_MOBILEPHONE", "type": "esriFieldTypeString", "alias": "CUSTOMER_MOBILEPHONE", "length": 10, "domain": null }, { "name": "CUSTOMER_BUSINESSPHONE", "type": "esriFieldTypeString", "alias": "CUSTOMER_BUSINESSPHONE", "length": 10, "domain": null }, { "name": "SERVICE_HOUSENUMBER", "type": "esriFieldTypeString", "alias": "SERVICE_HOUSENUMBER", "length": 10, "domain": null }, { "name": "SERVICE_HOMEADDRESS1", "type": "esriFieldTypeString", "alias": "SERVICE_HOMEADDRESS1", "length": 40, "domain": null }, { "name": "SERVICE_CITY", "type": "esriFieldTypeString", "alias": "SERVICE_CITY", "length": 18, "domain": null }, { "name": "SERVICE_STATE", "type": "esriFieldTypeString", "alias": "SERVICE_STATE", "length": 2, "domain": null }, { "name": "SERVICE_ZIP", "type": "esriFieldTypeString", "alias": "SERVICE_ZIP", "length": 6, "domain": null }, { "name": "VOTING_DISTRICT", "type": "esriFieldTypeString", "alias": "VOTING_DISTRICT", "length": 3, "domain": null }, { "name": "CAN_VOTE", "type": "esriFieldTypeString", "alias": "CAN_VOTE", "length": 1, "domain": null }, { "name": "CURRENT_TRUSTEE", "type": "esriFieldTypeString", "alias": "CURRENT_TRUSTEE", "length": 30, "domain": null }, { "name": "CONNECT_DATE", "type": "esriFieldTypeDate", "alias": "CONNECT_DATE", "length": 8, "domain": null }, { "name": "DISCONNECT_DATE", "type": "esriFieldTypeDate", "alias": "DISCONNECT_DATE", "length": 8, "domain": null }, { "name": "CUSTOMER_COUNTY", "type": "esriFieldTypeString", "alias": "CUSTOMER_COUNTY", "length": 30, "domain": null }, { "name": "SERVICE_COUNTY", "type": "esriFieldTypeString", "alias": "SERVICE_COUNTY", "length": 30, "domain": null }, { "name": "SERVICE_COUNTY_CD", "type": "esriFieldTypeString", "alias": "SERVICE_COUNTY_CD", "length": 3, "domain": null }, { "name": "PRIMARY_RATE_SCHEDULE", "type": "esriFieldTypeString", "alias": "PRIMARY_RATE_SCHEDULE", "length": 5, "domain": null }, { "name": "SERVICE_SUBDIVISION", "type": "esriFieldTypeString", "alias": "SERVICE_SUBDIVISION", "length": 40, "domain": null }, { "name": "ACCOUNT_NUMBER_STR", "type": "esriFieldTypeString", "alias": "ACCOUNT_NUMBER_STR", "length": 50, "domain": null }, { "name": "BI_SRV_PT_SW", "type": "esriFieldTypeString", "alias": "BI_SRV_PT_SW", "length": 1, "domain": null }, { "name": "BI_REV_CLASS_CD", "type": "esriFieldTypeSmallInteger", "alias": "BI_REV_CLASS_CD", "domain": null }, { "name": "BI_SRV_LOC_NBR", "type": "esriFieldTypeDouble", "alias": "BI_SRV_LOC_NBR", "domain": null }, { "name": "BI_ADDR1", "type": "esriFieldTypeString", "alias": "BI_ADDR1", "length": 40, "domain": null }, { "name": "BI_ADDR2", "type": "esriFieldTypeString", "alias": "BI_ADDR2", "length": 40, "domain": null }, { "name": "BI_ADDR3", "type": "esriFieldTypeString", "alias": "BI_ADDR3", "length": 40, "domain": null }, { "name": "BI_CONS_CLASS_CD", "type": "esriFieldTypeString", "alias": "BI_CONS_CLASS_CD", "length": 1, "domain": null }, { "name": "SERVICELOCATIONADDR", "type": "esriFieldTypeString", "alias": "SERVICELOCATIONADDR", "length": 40, "domain": null }, { "name": "BI_EBILL_SW", "type": "esriFieldTypeString", "alias": "BI_EBILL_SW", "length": 1, "domain": null }, { "name": "BI_SAL", "type": "esriFieldTypeString", "alias": "BI_SAL", "length": 6, "domain": null }, { "name": "BI_GEN", "type": "esriFieldTypeString", "alias": "BI_GEN", "length": 3, "domain": null }, { "name": "BI_CNTY_CD", "type": "esriFieldTypeString", "alias": "BI_CNTY_CD", "length": 3, "domain": null }, { "name": "SERVICEADDRESS2", "type": "esriFieldTypeString", "alias": "SERVICEADDRESS2", "length": 40, "domain": null }, { "name": "SERVICEADDRESS3", "type": "esriFieldTypeString", "alias": "SERVICEADDRESS3", "length": 40, "domain": null }, { "name": "BI_X_COORD", "type": "esriFieldTypeString", "alias": "BI_X_COORD", "length": 15, "domain": null }, { "name": "BI_Y_COORD", "type": "esriFieldTypeString", "alias": "BI_Y_COORD", "length": 15, "domain": null }, { "name": "BI_TAX_EXEMPT_SW", "type": "esriFieldTypeString", "alias": "BI_TAX_EXEMPT_SW", "length": 1, "domain": null }, { "name": "BI_BUDG_START_DT", "type": "esriFieldTypeDate", "alias": "BI_BUDG_START_DT", "length": 8, "domain": null }, { "name": "BI_MO_BUDG_AMT", "type": "esriFieldTypeDouble", "alias": "BI_MO_BUDG_AMT", "domain": null }, { "name": "BI_SRV_DESC", "type": "esriFieldTypeString", "alias": "BI_SRV_DESC", "length": 40, "domain": null }, { "name": "BI_SUBD_NAME", "type": "esriFieldTypeString", "alias": "BI_SUBD_NAME", "length": 40, "domain": null }, { "name": "BI_ROUTE_CD", "type": "esriFieldTypeInteger", "alias": "BI_ROUTE_CD", "domain": null }, { "name": "BI_OWNER_CUST_NBR", "type": "esriFieldTypeDouble", "alias": "BI_OWNER_CUST_NBR", "domain": null }, { "name": "BI_SRV_MAP_LOC", "type": "esriFieldTypeString", "alias": "BI_SRV_MAP_LOC", "length": 30, "domain": null }, { "name": "MEMBER_NUMBER", "type": "esriFieldTypeDouble", "alias": "MEMBER_NUMBER", "domain": null }, { "name": "SMARTHUBUSER", "type": "esriFieldTypeString", "alias": "SMARTHUBUSER", "length": 3, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }