{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Munis Account Records", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Primary_Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Account_Number", "type": "esriFieldTypeString", "alias": "Account Number", "length": 30, "domain": null }, { "name": "Start_Date", "type": "esriFieldTypeDate", "alias": "Start Date", "length": 8, "domain": null }, { "name": "Stop_Date", "type": "esriFieldTypeDate", "alias": "Stop Date", "length": 8, "domain": null }, { "name": "Account_Type", "type": "esriFieldTypeString", "alias": "Account Type", "length": 2, "domain": null }, { "name": "Parcel_ID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 30, "domain": null }, { "name": "Read_Location", "type": "esriFieldTypeString", "alias": "Read Location", "length": 65, "domain": null }, { "name": "District", "type": "esriFieldTypeString", "alias": "District", "length": 2, "domain": null }, { "name": "Service_Unit", "type": "esriFieldTypeString", "alias": "Service Unit", "length": 5, "domain": null }, { "name": "Service_City", "type": "esriFieldTypeString", "alias": "Service City", "length": 4, "domain": null }, { "name": "Service_Lot", "type": "esriFieldTypeString", "alias": "Service Lot", "length": 10, "domain": null }, { "name": "Steet_Number", "type": "esriFieldTypeInteger", "alias": "Steet Number", "domain": null }, { "name": "Streer_Suffix", "type": "esriFieldTypeString", "alias": "Streer Suffix", "length": 5, "domain": null }, { "name": "Streer_Post_Direction", "type": "esriFieldTypeString", "alias": "Street Post Direction", "length": 4, "domain": null }, { "name": "Streer_Pre_Direction", "type": "esriFieldTypeString", "alias": "Street Pre Direction", "length": 4, "domain": null }, { "name": "Street_Type", "type": "esriFieldTypeString", "alias": "Street Type", "length": 10, "domain": null }, { "name": "Service_Street", "type": "esriFieldTypeString", "alias": "Service Street", "length": 25, "domain": null }, { "name": "Service_Zip_Code", "type": "esriFieldTypeString", "alias": "Service Zip Code", "length": 10, "domain": null }, { "name": "Account_Create_Date", "type": "esriFieldTypeDate", "alias": "Account Create Date", "length": 8, "domain": null }, { "name": "Read_Sequence", "type": "esriFieldTypeInteger", "alias": "Read Sequence", "domain": null }, { "name": "Route_Book", "type": "esriFieldTypeString", "alias": "Route Book", "length": 6, "domain": null }, { "name": "Backflow_Required", "type": "esriFieldTypeString", "alias": "Backflow Required", "length": 1, "domain": null }, { "name": "Customer_ID", "type": "esriFieldTypeInteger", "alias": "Customer ID", "domain": null }, { "name": "Addtional_Adress", "type": "esriFieldTypeSmallInteger", "alias": "Addtional Address", "domain": null }, { "name": "Hold_Bill", "type": "esriFieldTypeString", "alias": "Hold Bill", "length": 1, "domain": null }, { "name": "Phone_Number", "type": "esriFieldTypeString", "alias": "Phone Number", "length": 20, "domain": null }, { "name": "Billable", "type": "esriFieldTypeString", "alias": "Billable", "length": 1, "domain": null }, { "name": "Delivery_Method", "type": "esriFieldTypeString", "alias": "Delivery Method", "length": 1, "domain": null }, { "name": "Billing_Comment", "type": "esriFieldTypeString", "alias": "Billing Comment", "length": 30, "domain": null }, { "name": "Account_Key", "type": "esriFieldTypeInteger", "alias": "Account Key", "domain": null }, { "name": "Customer_Start_Date", "type": "esriFieldTypeDate", "alias": "Customer Start Date", "length": 8, "domain": null }, { "name": "Meter_Size", "type": "esriFieldTypeString", "alias": "Meter Size", "length": 10, "domain": null }, { "name": "Meter_Serial", "type": "esriFieldTypeString", "alias": "Meter Serial", "length": 15, "domain": null }, { "name": "Meter_Install", "type": "esriFieldTypeDate", "alias": "Meter Install", "length": 8, "domain": null }, { "name": "Meter_Remote", "type": "esriFieldTypeString", "alias": "Meter Remote", "length": 15, "domain": null }, { "name": "Service_Status", "type": "esriFieldTypeString", "alias": "Service Status", "length": 1, "domain": null }, { "name": "Type_", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "Acitve", "type": "esriFieldTypeString", "alias": "Acitve", "length": 1, "domain": null }, { "name": "Update_Date", "type": "esriFieldTypeDate", "alias": "Update Date", "length": 8, "domain": null }, { "name": "Update_By", "type": "esriFieldTypeString", "alias": "Update By", "length": 20, "domain": null }, { "name": "Primary_Name", "type": "esriFieldTypeString", "alias": "Primary Name", "length": 64, "domain": null }, { "name": "Secondary_Name", "type": "esriFieldTypeString", "alias": "Secondary Name", "length": 64, "domain": null }, { "name": "Mailing_Name_1", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 64, "domain": null }, { "name": "Mailing_Name_2", "type": "esriFieldTypeString", "alias": "Mailing Address 2", "length": 64, "domain": null }, { "name": "Mailing_Name_3", "type": "esriFieldTypeString", "alias": "Mailing Address 3", "length": 64, "domain": null }, { "name": "Customer_Phone", "type": "esriFieldTypeString", "alias": "Phone", "length": 20, "domain": null }, { "name": "Customer_Email", "type": "esriFieldTypeString", "alias": "Email", "length": 254, "domain": null }, { "name": "Phone_Type", "type": "esriFieldTypeString", "alias": "Phone Type", "length": 20, "domain": null }, { "name": "Primary_Address", "type": "esriFieldTypeString", "alias": "Primary Address", "length": 1, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "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": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "SDE.Water_Service", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Account_Number", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1746704482000 } }