{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "SewerBilling", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "NSACCTNO", "type": "esriFieldTypeInteger", "alias": "Northstar Number", "domain": null }, { "name": "NSOCCPNT", "type": "esriFieldTypeSmallInteger", "alias": "Northstar Occupant Code", "domain": null }, { "name": "DSBL", "type": "esriFieldTypeString", "alias": "Tax Map Number", "length": 30, "domain": null }, { "name": "ACCTNUM", "type": "esriFieldTypeString", "alias": "Account Number", "length": 10, "domain": null }, { "name": "CUSTNUM", "type": "esriFieldTypeString", "alias": "Customer Number", "length": 10, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Customer Name", "length": 100, "domain": null }, { "name": "ADDRNUM", "type": "esriFieldTypeString", "alias": "Address Number", "length": 15, "domain": null }, { "name": "ADDRSUF", "type": "esriFieldTypeString", "alias": "Address Suffix", "length": 10, "domain": null }, { "name": "STREET", "type": "esriFieldTypeString", "alias": "Street", "length": 70, "domain": null }, { "name": "SUBADDR", "type": "esriFieldTypeString", "alias": "Subaddress", "length": 12, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 40, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "ZIP Code", "length": 12, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "Sewer District", "length": 15, "domain": null }, { "name": "BILLDATE", "type": "esriFieldTypeDate", "alias": "Last Billed Date", "length": 8, "domain": null }, { "name": "BILLAMT", "type": "esriFieldTypeDouble", "alias": "Last Billed Amount", "domain": null }, { "name": "BILLDUE", "type": "esriFieldTypeDate", "alias": "Last Billed Due Date", "length": 8, "domain": null }, { "name": "PAIDAMT", "type": "esriFieldTypeDouble", "alias": "Last Payment Amount", "domain": null }, { "name": "PAIDDATE", "type": "esriFieldTypeDate", "alias": "Last Payment Date", "length": 8, "domain": null }, { "name": "ACCTBAL", "type": "esriFieldTypeDouble", "alias": "Total Balance Due", "domain": null }, { "name": "CURNTBAL", "type": "esriFieldTypeDouble", "alias": "Current Balance", "domain": null }, { "name": "OVRDUEBAL", "type": "esriFieldTypeDouble", "alias": "Overdue Balance", "domain": null }, { "name": "LATECHGBAL", "type": "esriFieldTypeDouble", "alias": "Late Charge Balance", "domain": null }, { "name": "INTBAL", "type": "esriFieldTypeDouble", "alias": "Interest Balance", "domain": null }, { "name": "FULLADDR", "type": "esriFieldTypeString", "alias": "Full Address", "length": 170, "domain": null }, { "name": "ASOFDATE", "type": "esriFieldTypeDate", "alias": "As of Date", "length": 8, "domain": null } ], "indexes": [ { "name": "R9905_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 4000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "1bc30fced47748918094ab1692524d85" }