{ "currentVersion": 10.91, "id": 1, "name": "customer", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "umFirstName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "LocID", "type": "esriFieldTypeString", "alias": "LocID", "length": 50, "domain": null }, { "name": "Shape", "type": "esriFieldTypeInteger", "alias": "Shape", "domain": null }, { "name": "umFirstName", "type": "esriFieldTypeString", "alias": "umFirstName", "length": 31, "domain": null }, { "name": "umLastName", "type": "esriFieldTypeString", "alias": "umLastName", "length": 31, "domain": null }, { "name": "CUSTNMBR", "type": "esriFieldTypeString", "alias": "CUSTNMBR", "length": 15, "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": "LocationStreetNum", "type": "esriFieldTypeString", "alias": "LocationStreetNum", "length": 7, "domain": null }, { "name": "LocationStreetName", "type": "esriFieldTypeString", "alias": "LocationStreetName", "length": 31, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 0, "name": "Landbase.GIS.Locations", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "LocID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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 }