{ "currentVersion": 10.91, "id": 49, "name": "SDE.MunisUBData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "SDE.Meters", "relatedTableId": 42, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "ACCOUNTID", "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": "FULLNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNTID", "type": "esriFieldTypeString", "alias": "ACCOUNTID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ACCOUNTID" }, { "name": "CUSTOMERID", "type": "esriFieldTypeInteger", "alias": "CUSTOMERID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CUSTOMERID" }, { "name": "METERSN", "type": "esriFieldTypeString", "alias": "METERSN", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "METERSN" }, { "name": "TRANSPONDERSN", "type": "esriFieldTypeString", "alias": "TRANSPONDERSN", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "TRANSPONDERSN" }, { "name": "REGISTERSN", "type": "esriFieldTypeString", "alias": "REGISTERSN", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "REGISTERSN" }, { "name": "MeterId", "type": "esriFieldTypeInteger", "alias": "MeterId", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MeterId" }, { "name": "SERVICEID", "type": "esriFieldTypeInteger", "alias": "SERVICEID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SERVICEID" }, { "name": "COMPOUNDKEY", "type": "esriFieldTypeInteger", "alias": "COMPOUNDKEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COMPOUNDKEY" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "STATUS" }, { "name": "BILLINGCYCLE", "type": "esriFieldTypeSmallInteger", "alias": "BILLINGCYCLE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLINGCYCLE" }, { "name": "SEQUENCE", "type": "esriFieldTypeInteger", "alias": "SEQUENCE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEQUENCE" }, { "name": "ROUTE", "type": "esriFieldTypeString", "alias": "ROUTE", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "ROUTE" }, { "name": "PREVIOUSREAD", "type": "esriFieldTypeInteger", "alias": "PREVIOUSREAD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PREVIOUSREAD" }, { "name": "PREVIOUSREADDATE", "type": "esriFieldTypeDate", "alias": "PREVIOUSREADDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PREVIOUSREADDATE" }, { "name": "ServiceStopDate", "type": "esriFieldTypeDate", "alias": "ServiceStopDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ServiceStopDate" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "INSTALLDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "INSTALLYEAR", "type": "esriFieldTypeInteger", "alias": "INSTALLYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSTALLYEAR" }, { "name": "FLOWTYPE", "type": "esriFieldTypeString", "alias": "FLOWTYPE", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "FLOWTYPE" }, { "name": "SIZE", "type": "esriFieldTypeString", "alias": "SIZE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SIZE" }, { "name": "PHYSICALADDRESS", "type": "esriFieldTypeString", "alias": "PHYSICALADDRESS", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "PHYSICALADDRESS" }, { "name": "FULLNAME", "type": "esriFieldTypeString", "alias": "FULLNAME", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "FULLNAME" }, { "name": "PHONENUMBER", "type": "esriFieldTypeString", "alias": "PHONENUMBER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PHONENUMBER" }, { "name": "EMAILADDRESS", "type": "esriFieldTypeString", "alias": "EMAILADDRESS", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "EMAILADDRESS" }, { "name": "BILLINGADDRESS", "type": "esriFieldTypeString", "alias": "BILLINGADDRESS", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "BILLINGADDRESS" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 65, "defaultValue": null, "modelName": "Notes" }, { "name": "BILLED4WATER", "type": "esriFieldTypeInteger", "alias": "BILLED4WATER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4WATER" }, { "name": "BILLED4SEWER", "type": "esriFieldTypeInteger", "alias": "BILLED4SEWER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4SEWER" }, { "name": "BILLED4REFUSE", "type": "esriFieldTypeInteger", "alias": "BILLED4REFUSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4REFUSE" }, { "name": "BILLED4BULKMETER", "type": "esriFieldTypeInteger", "alias": "BILLED4BULKMETER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4BULKMETER" }, { "name": "BILLED4REFUSETAX", "type": "esriFieldTypeInteger", "alias": "BILLED4REFUSETAX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4REFUSETAX" }, { "name": "BILLED4STORMWATER", "type": "esriFieldTypeInteger", "alias": "BILLED4STORMWATER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BILLED4STORMWATER" }, { "name": "RowID", "type": "esriFieldTypeString", "alias": "RowID", "domain": null, "editable": true, "nullable": true, "length": 31, "defaultValue": null, "modelName": "RowID" } ], "indexes": [ { "name": "R897_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4641_ACCOUNT", "fields": "ACCOUNTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SDE.MunisUBData", "description": "", "prototype": { "attributes": { "BILLED4STORMWATER": null, "RowID": null, "ACCOUNTID": null, "CUSTOMERID": null, "METERSN": null, "TRANSPONDERSN": null, "REGISTERSN": null, "MeterId": null, "SERVICEID": null, "COMPOUNDKEY": null, "STATUS": null, "BILLINGCYCLE": null, "SEQUENCE": null, "ROUTE": null, "PREVIOUSREAD": null, "PREVIOUSREADDATE": null, "ServiceStopDate": null, "INSTALLDATE": null, "INSTALLYEAR": null, "FLOWTYPE": null, "SIZE": null, "PHYSICALADDRESS": null, "FULLNAME": null, "PHONENUMBER": null, "EMAILADDRESS": null, "BILLINGADDRESS": null, "Notes": null, "BILLED4WATER": null, "BILLED4SEWER": null, "BILLED4REFUSE": null, "BILLED4BULKMETER": null, "BILLED4REFUSETAX": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }