{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Munis Account Records", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 2, "name": "SDE.Water_Service", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "Account_Number", "composite": false } ], "isDataVersioned": true, "isDataArchived": true, "isDataBranchVersioned": true, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704482000 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "supportsOidReservation": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Primary_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Account_Number", "type": "esriFieldTypeString", "alias": "Account Number", "domain": null, "editable": true, "nullable": false, "length": 30, "defaultValue": null, "modelName": "Account_Number" }, { "name": "Start_Date", "type": "esriFieldTypeDate", "alias": "Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Start_Date" }, { "name": "Stop_Date", "type": "esriFieldTypeDate", "alias": "Stop Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Stop_Date" }, { "name": "Account_Type", "type": "esriFieldTypeString", "alias": "Account Type", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Account_Type" }, { "name": "Parcel_ID", "type": "esriFieldTypeString", "alias": "Parcel ID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Parcel_ID" }, { "name": "Read_Location", "type": "esriFieldTypeString", "alias": "Read Location", "domain": null, "editable": true, "nullable": true, "length": 65, "defaultValue": null, "modelName": "Read_Location" }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "District" }, { "name": "Service_Unit", "type": "esriFieldTypeString", "alias": "Service Unit", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Service_Unit" }, { "name": "Service_City", "type": "esriFieldTypeString", "alias": "Service City", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Service_City" }, { "name": "Service_Lot", "type": "esriFieldTypeString", "alias": "Service Lot", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Service_Lot" }, { "name": "Steet_Number", "type": "esriFieldTypeInteger", "alias": "Steet Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Steet_Number" }, { "name": "Streer_Suffix", "type": "esriFieldTypeString", "alias": "Streer Suffix", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Streer_Suffix" }, { "name": "Streer_Post_Direction", "type": "esriFieldTypeString", "alias": "Street Post Direction", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Streer_Post_Direction" }, { "name": "Streer_Pre_Direction", "type": "esriFieldTypeString", "alias": "Street Pre Direction", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "Streer_Pre_Direction" }, { "name": "Street_Type", "type": "esriFieldTypeString", "alias": "Street Type", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Street_Type" }, { "name": "Service_Street", "type": "esriFieldTypeString", "alias": "Service Street", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Service_Street" }, { "name": "Service_Zip_Code", "type": "esriFieldTypeString", "alias": "Service Zip Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Service_Zip_Code" }, { "name": "Account_Create_Date", "type": "esriFieldTypeDate", "alias": "Account Create Date", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "modelName": "Account_Create_Date" }, { "name": "Read_Sequence", "type": "esriFieldTypeInteger", "alias": "Read Sequence", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Read_Sequence" }, { "name": "Route_Book", "type": "esriFieldTypeString", "alias": "Route Book", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Route_Book" }, { "name": "Backflow_Required", "type": "esriFieldTypeString", "alias": "Backflow Required", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Backflow_Required" }, { "name": "Customer_ID", "type": "esriFieldTypeInteger", "alias": "Customer ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Customer_ID" }, { "name": "Addtional_Adress", "type": "esriFieldTypeSmallInteger", "alias": "Addtional Address", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Addtional_Adress" }, { "name": "Hold_Bill", "type": "esriFieldTypeString", "alias": "Hold Bill", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Hold_Bill" }, { "name": "Phone_Number", "type": "esriFieldTypeString", "alias": "Phone Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Phone_Number" }, { "name": "Billable", "type": "esriFieldTypeString", "alias": "Billable", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Billable" }, { "name": "Delivery_Method", "type": "esriFieldTypeString", "alias": "Delivery Method", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Delivery_Method" }, { "name": "Billing_Comment", "type": "esriFieldTypeString", "alias": "Billing Comment", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Billing_Comment" }, { "name": "Account_Key", "type": "esriFieldTypeInteger", "alias": "Account Key", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Account_Key" }, { "name": "Customer_Start_Date", "type": "esriFieldTypeDate", "alias": "Customer Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Customer_Start_Date" }, { "name": "Meter_Size", "type": "esriFieldTypeString", "alias": "Meter Size", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Meter_Size" }, { "name": "Meter_Serial", "type": "esriFieldTypeString", "alias": "Meter Serial", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Meter_Serial" }, { "name": "Meter_Install", "type": "esriFieldTypeDate", "alias": "Meter Install", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Meter_Install" }, { "name": "Meter_Remote", "type": "esriFieldTypeString", "alias": "Meter Remote", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Meter_Remote" }, { "name": "Service_Status", "type": "esriFieldTypeString", "alias": "Service Status", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Service_Status" }, { "name": "Type_", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type_" }, { "name": "Acitve", "type": "esriFieldTypeString", "alias": "Acitve", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Acitve" }, { "name": "Update_Date", "type": "esriFieldTypeDate", "alias": "Update Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Update_Date" }, { "name": "Update_By", "type": "esriFieldTypeString", "alias": "Update By", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Update_By" }, { "name": "Primary_Name", "type": "esriFieldTypeString", "alias": "Primary Name", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Primary_Name" }, { "name": "Secondary_Name", "type": "esriFieldTypeString", "alias": "Secondary Name", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Secondary_Name" }, { "name": "Mailing_Name_1", "type": "esriFieldTypeString", "alias": "Mailing Address", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Mailing_Name_1" }, { "name": "Mailing_Name_2", "type": "esriFieldTypeString", "alias": "Mailing Address 2", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Mailing_Name_2" }, { "name": "Mailing_Name_3", "type": "esriFieldTypeString", "alias": "Mailing Address 3", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "Mailing_Name_3" }, { "name": "Customer_Phone", "type": "esriFieldTypeString", "alias": "Phone", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Customer_Phone" }, { "name": "Customer_Email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "Customer_Email" }, { "name": "Phone_Type", "type": "esriFieldTypeString", "alias": "Phone Type", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Phone_Type" }, { "name": "Primary_Address", "type": "esriFieldTypeString", "alias": "Primary Address", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Primary_Address" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "UUID_17", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_15_Account_N", "fields": "Account_Number", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Munis Account Records", "description": "", "prototype": { "attributes": { "Primary_Address": null, "Phone_Type": null, "Account_Number": " ", "Start_Date": null, "Stop_Date": null, "Account_Type": null, "Parcel_ID": null, "Read_Location": null, "District": null, "Service_Unit": null, "Service_City": null, "Service_Lot": null, "Steet_Number": null, "Streer_Suffix": null, "Streer_Post_Direction": null, "Streer_Pre_Direction": null, "Street_Type": null, "Service_Street": null, "Service_Zip_Code": null, "Account_Create_Date": -2209161600000, "Read_Sequence": null, "Route_Book": null, "Backflow_Required": null, "Customer_ID": null, "Addtional_Adress": null, "Hold_Bill": null, "Phone_Number": null, "Billable": null, "Delivery_Method": null, "Billing_Comment": null, "Account_Key": null, "Customer_Start_Date": null, "Meter_Size": null, "Meter_Serial": null, "Meter_Install": null, "Meter_Remote": null, "Service_Status": null, "Type_": null, "Acitve": null, "Update_Date": null, "Update_By": null, "Primary_Name": null, "Secondary_Name": null, "Mailing_Name_1": null, "Mailing_Name_2": null, "Mailing_Name_3": null, "Customer_Phone": null, "Customer_Email": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,ChangeTracking", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }