{ "currentVersion": 10.91, "id": 5, "name": "Water.GIS.umCustomers", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "umFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CUSTNMBR", "type": "esriFieldTypeString", "alias": "CUSTNMBR", "length": 15, "domain": null }, { "name": "umFirstName", "type": "esriFieldTypeString", "alias": "umFirstName", "length": 31, "domain": null }, { "name": "umLastName", "type": "esriFieldTypeString", "alias": "umLastName", "length": 31, "domain": null }, { "name": "umPlaceOfWork", "type": "esriFieldTypeString", "alias": "umPlaceOfWork", "length": 41, "domain": null }, { "name": "FullCustomerName", "type": "esriFieldTypeString", "alias": "FullCustomerName", "length": 63, "domain": null }, { "name": "umCustClassID", "type": "esriFieldTypeString", "alias": "umCustClassID", "length": 15, "domain": null }, { "name": "umIndividual", "type": "esriFieldTypeSmallInteger", "alias": "umIndividual", "domain": null }, { "name": "umDateCreated", "type": "esriFieldTypeDate", "alias": "umDateCreated", "length": 8, "domain": null }, { "name": "umDateModified", "type": "esriFieldTypeDate", "alias": "umDateModified", "length": 8, "domain": null }, { "name": "umContactPerson", "type": "esriFieldTypeString", "alias": "umContactPerson", "length": 31, "domain": null }, { "name": "PHONE1", "type": "esriFieldTypeString", "alias": "PHONE1", "length": 21, "domain": null }, { "name": "PHONE2", "type": "esriFieldTypeString", "alias": "PHONE2", "length": 21, "domain": null }, { "name": "PHONE3", "type": "esriFieldTypeString", "alias": "PHONE3", "length": 21, "domain": null }, { "name": "umAddressCateg", "type": "esriFieldTypeSmallInteger", "alias": "umAddressCateg", "domain": null }, { "name": "umStreetNumber", "type": "esriFieldTypeString", "alias": "umStreetNumber", "length": 7, "domain": null }, { "name": "umStreetNumberINT", "type": "esriFieldTypeInteger", "alias": "umStreetNumberINT", "domain": null }, { "name": "umStrNumberSuffix", "type": "esriFieldTypeString", "alias": "umStrNumberSuffix", "length": 3, "domain": null }, { "name": "umStreetName", "type": "esriFieldTypeString", "alias": "umStreetName", "length": 31, "domain": null }, { "name": "umAptNumber", "type": "esriFieldTypeString", "alias": "umAptNumber", "length": 15, "domain": null }, { "name": "umAptDescription", "type": "esriFieldTypeString", "alias": "umAptDescription", "length": 15, "domain": null }, { "name": "umZipCode", "type": "esriFieldTypeString", "alias": "umZipCode", "length": 11, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 31, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 29, "domain": null }, { "name": "Country", "type": "esriFieldTypeString", "alias": "Country", "length": 61, "domain": null }, { "name": "OBJECTID_1", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "umLocationID", "type": "esriFieldTypeString", "alias": "umLocationID", "length": 15, "domain": null }, { "name": "umLocClass", "type": "esriFieldTypeString", "alias": "umLocClass", "length": 15, "domain": null }, { "name": "umZoneID", "type": "esriFieldTypeString", "alias": "umZoneID", "length": 15, "domain": null }, { "name": "umBillToCust", "type": "esriFieldTypeString", "alias": "umBillToCust", "length": 15, "domain": null }, { "name": "umStreetNumber_1", "type": "esriFieldTypeString", "alias": "umStreetNumber", "length": 7, "domain": null }, { "name": "umStreetNumberINT_1", "type": "esriFieldTypeInteger", "alias": "umStreetNumberINT", "domain": null }, { "name": "umStrNumberSuffix_1", "type": "esriFieldTypeString", "alias": "umStrNumberSuffix", "length": 3, "domain": null }, { "name": "umStreetName_1", "type": "esriFieldTypeString", "alias": "umStreetName", "length": 31, "domain": null }, { "name": "umAptNumber_1", "type": "esriFieldTypeString", "alias": "umAptNumber", "length": 15, "domain": null }, { "name": "umAptDescription_1", "type": "esriFieldTypeString", "alias": "umAptDescription", "length": 15, "domain": null }, { "name": "umZipCode_1", "type": "esriFieldTypeString", "alias": "umZipCode", "length": 11, "domain": null }, { "name": "City_1", "type": "esriFieldTypeString", "alias": "City", "length": 31, "domain": null }, { "name": "State_1", "type": "esriFieldTypeString", "alias": "State", "length": 29, "domain": null } ], "indexes": [ { "name": "R181_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_606_umLocati", "fields": "umLocationID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 30000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "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 }