{ "currentVersion": 10.91, "id": 19, "name": "Water.GIS.umCustomers", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "Water.GIS.wMeter", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "umLocationID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "umFirstName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CUSTNMBR", "type": "esriFieldTypeString", "alias": "CUSTNMBR", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "CUSTNMBR" }, { "name": "umFirstName", "type": "esriFieldTypeString", "alias": "umFirstName", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umFirstName" }, { "name": "umLastName", "type": "esriFieldTypeString", "alias": "umLastName", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umLastName" }, { "name": "umPlaceOfWork", "type": "esriFieldTypeString", "alias": "umPlaceOfWork", "domain": null, "editable": true, "nullable": false, "length": 41, "defaultValue": null, "modelName": "umPlaceOfWork" }, { "name": "FullCustomerName", "type": "esriFieldTypeString", "alias": "FullCustomerName", "domain": null, "editable": true, "nullable": true, "length": 63, "defaultValue": null, "modelName": "FullCustomerName" }, { "name": "umCustClassID", "type": "esriFieldTypeString", "alias": "umCustClassID", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umCustClassID" }, { "name": "umIndividual", "type": "esriFieldTypeSmallInteger", "alias": "umIndividual", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umIndividual" }, { "name": "umDateCreated", "type": "esriFieldTypeDate", "alias": "umDateCreated", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umDateCreated" }, { "name": "umDateModified", "type": "esriFieldTypeDate", "alias": "umDateModified", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "umDateModified" }, { "name": "umContactPerson", "type": "esriFieldTypeString", "alias": "umContactPerson", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umContactPerson" }, { "name": "PHONE1", "type": "esriFieldTypeString", "alias": "PHONE1", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "PHONE1" }, { "name": "PHONE2", "type": "esriFieldTypeString", "alias": "PHONE2", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "PHONE2" }, { "name": "PHONE3", "type": "esriFieldTypeString", "alias": "PHONE3", "domain": null, "editable": true, "nullable": false, "length": 21, "defaultValue": null, "modelName": "PHONE3" }, { "name": "umAddressCateg", "type": "esriFieldTypeSmallInteger", "alias": "umAddressCateg", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umAddressCateg" }, { "name": "umStreetNumber", "type": "esriFieldTypeString", "alias": "umStreetNumber", "domain": null, "editable": true, "nullable": false, "length": 7, "defaultValue": null, "modelName": "umStreetNumber" }, { "name": "umStreetNumberINT", "type": "esriFieldTypeInteger", "alias": "umStreetNumberINT", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "umStreetNumberINT" }, { "name": "umStrNumberSuffix", "type": "esriFieldTypeString", "alias": "umStrNumberSuffix", "domain": null, "editable": true, "nullable": false, "length": 3, "defaultValue": null, "modelName": "umStrNumberSuffix" }, { "name": "umStreetName", "type": "esriFieldTypeString", "alias": "umStreetName", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "umStreetName" }, { "name": "umAptNumber", "type": "esriFieldTypeString", "alias": "umAptNumber", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umAptNumber" }, { "name": "umAptDescription", "type": "esriFieldTypeString", "alias": "umAptDescription", "domain": null, "editable": true, "nullable": false, "length": 15, "defaultValue": null, "modelName": "umAptDescription" }, { "name": "umZipCode", "type": "esriFieldTypeString", "alias": "umZipCode", "domain": null, "editable": true, "nullable": false, "length": 11, "defaultValue": null, "modelName": "umZipCode" }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": false, "length": 31, "defaultValue": null, "modelName": "City" }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": false, "length": 29, "defaultValue": null, "modelName": "State" }, { "name": "Country", "type": "esriFieldTypeString", "alias": "Country", "domain": null, "editable": true, "nullable": false, "length": 61, "defaultValue": null, "modelName": "Country" }, { "name": "OBJECTID_1", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "umLocationID", "type": "esriFieldTypeString", "alias": "umLocationID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umLocationID" }, { "name": "umLocClass", "type": "esriFieldTypeString", "alias": "umLocClass", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umLocClass" }, { "name": "umZoneID", "type": "esriFieldTypeString", "alias": "umZoneID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umZoneID" }, { "name": "umBillToCust", "type": "esriFieldTypeString", "alias": "umBillToCust", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umBillToCust" }, { "name": "umStreetNumber_1", "type": "esriFieldTypeString", "alias": "umStreetNumber", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "umStreetNumber" }, { "name": "umStreetNumberINT_1", "type": "esriFieldTypeInteger", "alias": "umStreetNumberINT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "umStreetNumberINT" }, { "name": "umStrNumberSuffix_1", "type": "esriFieldTypeString", "alias": "umStrNumberSuffix", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "umStrNumberSuffix" }, { "name": "umStreetName_1", "type": "esriFieldTypeString", "alias": "umStreetName", "domain": null, "editable": true, "nullable": true, "length": 31, "defaultValue": null, "modelName": "umStreetName" }, { "name": "umAptNumber_1", "type": "esriFieldTypeString", "alias": "umAptNumber", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umAptNumber" }, { "name": "umAptDescription_1", "type": "esriFieldTypeString", "alias": "umAptDescription", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "umAptDescription" }, { "name": "umZipCode_1", "type": "esriFieldTypeString", "alias": "umZipCode", "domain": null, "editable": true, "nullable": true, "length": 11, "defaultValue": null, "modelName": "umZipCode" }, { "name": "City_1", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 31, "defaultValue": null, "modelName": "City" }, { "name": "State_1", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 29, "defaultValue": null, "modelName": "State" } ], "indexes": [ { "name": "R181_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_606_umLocati", "fields": "umLocationID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Water.GIS.umCustomers", "description": "", "prototype": { "attributes": { "City_1": null, "State_1": null, "CUSTNMBR": " ", "umFirstName": " ", "umLastName": " ", "umPlaceOfWork": " ", "FullCustomerName": null, "umCustClassID": " ", "umIndividual": 0, "umDateCreated": -2209161600000, "umDateModified": -2209161600000, "umContactPerson": " ", "PHONE1": " ", "PHONE2": " ", "PHONE3": " ", "umAddressCateg": 0, "umStreetNumber": " ", "umStreetNumberINT": 0, "umStrNumberSuffix": " ", "umStreetName": " ", "umAptNumber": " ", "umAptDescription": " ", "umZipCode": " ", "City": " ", "State": " ", "Country": " ", "OBJECTID_1": null, "umLocationID": null, "umLocClass": null, "umZoneID": null, "umBillToCust": null, "umStreetNumber_1": null, "umStreetNumberINT_1": null, "umStrNumberSuffix_1": null, "umStreetName_1": null, "umAptNumber_1": null, "umAptDescription_1": null, "umZipCode_1": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 30000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 30000, "maxRecordCountFactor": 1 }