{ "currentVersion": 10.7, "id": 18, "name": "CAW_DATA.dbo.Meter_Loc_Acct_CayProd", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CUSTOMER_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 149, "domain": null }, { "name": "METER", "type": "esriFieldTypeString", "alias": "METER", "length": 17, "domain": null }, { "name": "METER_NO", "type": "esriFieldTypeDouble", "alias": "METER_NO", "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeString", "alias": "InstallDate", "length": 10, "domain": null }, { "name": "CSERVICE", "type": "esriFieldTypeString", "alias": "CSERVICE", "length": 83, "domain": null }, { "name": "METERLOCATION", "type": "esriFieldTypeString", "alias": "METERLOCATION", "length": 2000, "domain": null }, { "name": "ROUTE", "type": "esriFieldTypeInteger", "alias": "ROUTE", "domain": null }, { "name": "SEQUENCE", "type": "esriFieldTypeInteger", "alias": "SEQUENCE", "domain": null }, { "name": "SERV_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "SERV_SEQ", "domain": null }, { "name": "METER_BASE_ID", "type": "esriFieldTypeString", "alias": "METER_BASE_ID", "length": 125, "domain": null }, { "name": "LOC_SERV", "type": "esriFieldTypeString", "alias": "LOC_SERV", "length": 33, "domain": null }, { "name": "CONNECTION_NO", "type": "esriFieldTypeDouble", "alias": "CONNECTION_NO", "domain": null }, { "name": "PREMISE_NO", "type": "esriFieldTypeString", "alias": "PREMISE_NO", "length": 15, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 105, "domain": null }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "UNIT", "length": 18, "domain": null }, { "name": "UNIT_TYPE", "type": "esriFieldTypeString", "alias": "UNIT_TYPE", "length": 5, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 30, "domain": null }, { "name": "ZIP_CODE", "type": "esriFieldTypeString", "alias": "ZIP_CODE", "length": 13, "domain": null }, { "name": "BASIN", "type": "esriFieldTypeString", "alias": "BASIN", "length": 100, "domain": null }, { "name": "SANIT_DISTRICT", "type": "esriFieldTypeString", "alias": "SANIT_DISTRICT", "length": 15, "domain": null }, { "name": "SEWER_DISTRICT", "type": "esriFieldTypeString", "alias": "SEWER_DISTRICT", "length": 15, "domain": null }, { "name": "SO_ZONE", "type": "esriFieldTypeString", "alias": "SO_ZONE", "length": 5, "domain": null }, { "name": "TAX_DISTRICT", "type": "esriFieldTypeString", "alias": "TAX_DISTRICT", "length": 15, "domain": null }, { "name": "WATER_DISTRICT", "type": "esriFieldTypeString", "alias": "WATER_DISTRICT", "length": 15, "domain": null }, { "name": "ACTIVE_CD", "type": "esriFieldTypeString", "alias": "ACTIVE_CD", "length": 5, "domain": null }, { "name": "CIS_NUMBER", "type": "esriFieldTypeDouble", "alias": "CIS_NUMBER", "domain": null }, { "name": "FINAL_BILL_DATE", "type": "esriFieldTypeString", "alias": "FINAL_BILL_DATE", "length": 10, "domain": null }, { "name": "LAST_BILL_DATE", "type": "esriFieldTypeString", "alias": "LAST_BILL_DATE", "length": 10, "domain": null }, { "name": "STATUS_CD", "type": "esriFieldTypeString", "alias": "STATUS_CD", "length": 5, "domain": null }, { "name": "Main_Size", "type": "esriFieldTypeString", "alias": "Main_Size", "length": 200, "domain": null }, { "name": "Pipe_Matl", "type": "esriFieldTypeString", "alias": "Pipe_Matl", "length": 200, "domain": null }, { "name": "Pipe_Size", "type": "esriFieldTypeString", "alias": "Pipe_Size", "length": 200, "domain": null }, { "name": "Service_Instal_Date", "type": "esriFieldTypeDate", "alias": "Service_Instal_Date", "length": 8, "domain": null }, { "name": "SERVICE_TP", "type": "esriFieldTypeString", "alias": "SERVICE_TP", "length": 5, "domain": null }, { "name": "Service_Type", "type": "esriFieldTypeString", "alias": "Service_Type", "length": 200, "domain": null }, { "name": "ServiceLen", "type": "esriFieldTypeDouble", "alias": "ServiceLen", "domain": null }, { "name": "LOCATION_NO", "type": "esriFieldTypeDouble", "alias": "LOCATION_NO", "domain": null }, { "name": "METER_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "METER_SEQ", "domain": null }, { "name": "LocationNo_MeterSEQ", "type": "esriFieldTypeString", "alias": "LocationNo_MeterSEQ", "length": 82, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }