{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [ { "name": "R23_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_23", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "GDB_29_AccountID", "isUnique": false, "description": "", "fields": "AccountID", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "4cf33e1915f3451dad37736030f28714", "capabilities": "Query,Map,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Comments", "displayField": "AccountID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "AccountID", "alias": "Billing Account ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "CommentSequenceNum", "alias": "Comment Sequence Number", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "CommentDate", "length": 8, "alias": "Comment Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CommentCodes", "description": "Comment Code Descriptions", "type": "codedValue", "codedValues": [ { "code": "AB", "name": "ABATEMENT DESCRIPTION" }, { "code": "AC", "name": "Mail Address Change" }, { "code": "AP", "name": "Admin Prin Adjustment" }, { "code": "AR", "name": "Advanced Pymt Refund" }, { "code": "AX", "name": "Annexation" }, { "code": "AY", "name": "Refered to Attorney" }, { "code": "CO", "name": "Pay city owned assessment" }, { "code": "CR", "name": "Certified Receipt" }, { "code": "FQ", "name": "Fax Quote" }, { "code": "GC", "name": "General Comment" }, { "code": "IA", "name": "Interest Date Adjustment" }, { "code": "ID", "name": "Property ID Note" }, { "code": "NR", "name": "Not Refered to Attorney" }, { "code": "OC", "name": "Ownership Change" }, { "code": "PB", "name": "PAID BY BANK GARNISHMENT" }, { "code": "PC", "name": "Changed JV Num, Post Date" }, { "code": "PI", "name": "Paid In Permits" }, { "code": "PQ", "name": "Phone Quote" }, { "code": "PR", "name": "Overpaid Closing Refund" }, { "code": "PW", "name": "PAID BY WAGE GARNISHMENT" }, { "code": "RA", "name": "Reversal - ABS" }, { "code": "RC", "name": "Reversal - Rev Collector" }, { "code": "RM", "name": "Returned Mail" }, { "code": "SC", "name": "Status Change" }, { "code": "TA", "name": "Transfer PrePayment" }, { "code": "TC", "name": "Talked to Customer" }, { "code": "VM", "name": "Left Voice Mail" }, { "code": "WA", "name": "Waived Account" }, { "code": "WO", "name": "Write-Off Account" }, { "code": "WQ", "name": "Written Quote" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CommentCode", "length": 2, "alias": "Comment Code", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Comment", "length": 1000, "alias": "Comment", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes No", "description": "Yes No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PaymentPlan", "length": 1, "alias": "Payment Plan", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" } }