{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 9, "name": "SALES", "type": "Table", "description": "Description: Contains sales information (MULT)\n\n Name Null? Type Description\n ------------------------ ------------ --------------------------------------------\n*PARID NOT NULL VARCHAR2(18) Parcel Id\n TRANSNO VARCHAR2(20) Instr. number\n SALEDT DATE Sale date\n PRICE NUMBER(10) Sale price\n!SALETYPE VARCHAR2(1) Sale type\n!SALEVAL VARCHAR2(2) Valid sales\n NOTE1 VARCHAR2(40) Notes line 1\n NOTE2 VARCHAR2(40) Notes line 2\n!INSTRTYP VARCHAR2(6) Instrument type\n NUMPARS NUMBER(4) Number of parcels included in sale\n", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PARID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARID", "type": "esriFieldTypeString", "alias": "PARID", "length": 1073741822, "domain": null }, { "name": "CARD", "type": "esriFieldTypeInteger", "alias": "CARD", "domain": null }, { "name": "LLINE", "type": "esriFieldTypeInteger", "alias": "LLINE", "domain": null }, { "name": "LOWER", "type": "esriFieldTypeString", "alias": "LOWER", "length": 1073741822, "domain": null }, { "name": "FIRST", "type": "esriFieldTypeString", "alias": "FIRST", "length": 1073741822, "domain": null }, { "name": "SECOND", "type": "esriFieldTypeString", "alias": "SECOND", "length": 1073741822, "domain": null }, { "name": "THIRD", "type": "esriFieldTypeString", "alias": "THIRD", "length": 1073741822, "domain": null }, { "name": "GISADMIN.COM_Landbase_SALES.AREA", "type": "esriFieldTypeInteger", "alias": "GISADMIN.COM_Landbase_SALES.AREA", "domain": null } ], "indexes": [ { "name": "R123_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "285c499449fa491cb99d8121083e1c34" }