{ "currentVersion": 10.51, "id": 9, "name": "Sales", "type": "Table", "description": "This table contains a list of the two most recent property transactions with descriptions of transaction types for properties in Deschutes County, Oregon. Created from the Deschutes County Assessor Department data which resides in the ORCATs system. Can be related to the taxlots GIS data table. This table has a one to one relationship with taxlots.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Taxlot", "typeIdField": null, "subtypeFieldName": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Taxlot", "type": "esriFieldTypeString", "alias": "Taxlot", "length": 20, "domain": null }, { "name": "Book_Page_1", "type": "esriFieldTypeString", "alias": "Book_Page_1", "length": 20, "domain": null }, { "name": "Reject_Code_1", "type": "esriFieldTypeString", "alias": "Reject_Code_1", "length": 3, "domain": null }, { "name": "Reject_Description_1", "type": "esriFieldTypeString", "alias": "Reject_Description_1", "length": 100, "domain": null }, { "name": "Total_Sales_Price_1", "type": "esriFieldTypeDouble", "alias": "Total_Sales_Price_1", "domain": null }, { "name": "Sales_Date_1", "type": "esriFieldTypeDate", "alias": "Sales_Date_1", "length": 8, "domain": null }, { "name": "Seller_1", "type": "esriFieldTypeString", "alias": "Seller_1", "length": 250, "domain": null }, { "name": "Buyer_1", "type": "esriFieldTypeString", "alias": "Buyer_1", "length": 250, "domain": null }, { "name": "Book_Page_2", "type": "esriFieldTypeString", "alias": "Book_Page_2", "length": 20, "domain": null }, { "name": "Reject_Code_2", "type": "esriFieldTypeString", "alias": "Reject_Code_2", "length": 3, "domain": null }, { "name": "Reject_Description_2", "type": "esriFieldTypeString", "alias": "Reject_Description_2", "length": 100, "domain": null }, { "name": "Total_Sales_Price_2", "type": "esriFieldTypeDouble", "alias": "Total_Sales_Price_2", "domain": null }, { "name": "Sales_Date_2", "type": "esriFieldTypeDate", "alias": "Sales_Date_2", "length": 8, "domain": null }, { "name": "Seller_2", "type": "esriFieldTypeString", "alias": "Seller_2", "length": 250, "domain": null }, { "name": "Buyer_2", "type": "esriFieldTypeString", "alias": "Buyer_2", "length": 250, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 8, "name": "Taxlot", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "Taxlot", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "dateFieldsTimeReference": null }