{ "currentVersion": 10.91, "id": 10, "name": "GVPUB.GISWEB.ASR_SALES_ALL", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACCOUNTNO", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ACCOUNTNO", "type": "esriFieldTypeString", "alias": "ACCOUNTNO", "length": 30, "domain": null }, { "name": "PARCELNB", "type": "esriFieldTypeString", "alias": "PARCELNB", "length": 20, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "PIN", "length": 20, "domain": null }, { "name": "SALEID", "type": "esriFieldTypeString", "alias": "SALEID", "length": 8, "domain": null }, { "name": "SALEP", "type": "esriFieldTypeDouble", "alias": "SALEP", "domain": null }, { "name": "SALEMONTH", "type": "esriFieldTypeString", "alias": "SALEMONTH", "length": 2, "domain": null }, { "name": "SALEDAY", "type": "esriFieldTypeString", "alias": "SALEDAY", "length": 2, "domain": null }, { "name": "SALEYEAR", "type": "esriFieldTypeString", "alias": "SALEYEAR", "length": 4, "domain": null }, { "name": "DEEDTYPE", "type": "esriFieldTypeString", "alias": "DEEDTYPE", "length": 10, "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 6, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 7, "domain": null }, { "name": "RECEPTION", "type": "esriFieldTypeString", "alias": "RECEPTION", "length": 30, "domain": null }, { "name": "VALIDINV", "type": "esriFieldTypeString", "alias": "VALIDINV", "length": 7, "domain": null } ], "indexes": [ { "name": "idx_asr_sales_all_accountno", "fields": "ACCOUNTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_asr_sales_all_parcelnb", "fields": "PARCELNB", "isAscending": true, "isUnique": false, "description": "" }, { "name": "idx_asr_sales_all_pin", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }