{ "currentVersion": 10.81, "id": 1, "name": "Parcels.DBO.IAS4SALES", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "JUR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "JUR", "type": "esriFieldTypeString", "alias": "JUR", "length": 6, "domain": null }, { "name": "PARID", "type": "esriFieldTypeString", "alias": "PARID", "length": 30, "domain": null }, { "name": "SALEDT", "type": "esriFieldTypeDate", "alias": "SALEDT", "length": 8, "domain": null }, { "name": "STAMPVAL", "type": "esriFieldTypeDouble", "alias": "STAMPVAL", "domain": null }, { "name": "PRICE", "type": "esriFieldTypeInteger", "alias": "PRICE", "domain": null }, { "name": "SEQ", "type": "esriFieldTypeSmallInteger", "alias": "SEQ", "domain": null }, { "name": "SALEKEY", "type": "esriFieldTypeInteger", "alias": "SALEKEY", "domain": null }, { "name": "CUR", "type": "esriFieldTypeString", "alias": "CUR", "length": 1, "domain": null }, { "name": "WHO", "type": "esriFieldTypeString", "alias": "WHO", "length": 10, "domain": null }, { "name": "WEN", "type": "esriFieldTypeDate", "alias": "WEN", "length": 8, "domain": null }, { "name": "WHOCALC", "type": "esriFieldTypeString", "alias": "WHOCALC", "length": 10, "domain": null }, { "name": "WENCALC", "type": "esriFieldTypeDate", "alias": "WENCALC", "length": 8, "domain": null }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "length": 1, "domain": null }, { "name": "TRANSNO", "type": "esriFieldTypeString", "alias": "TRANSNO", "length": 20, "domain": null }, { "name": "TRANSDT", "type": "esriFieldTypeDate", "alias": "TRANSDT", "length": 8, "domain": null }, { "name": "OLDYR", "type": "esriFieldTypeSmallInteger", "alias": "OLDYR", "domain": null }, { "name": "OLDSEQ", "type": "esriFieldTypeSmallInteger", "alias": "OLDSEQ", "domain": null }, { "name": "NEWYR", "type": "esriFieldTypeSmallInteger", "alias": "NEWYR", "domain": null }, { "name": "NEWSEQ", "type": "esriFieldTypeSmallInteger", "alias": "NEWSEQ", "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 8, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 8, "domain": null }, { "name": "OLDOWN", "type": "esriFieldTypeString", "alias": "OLDOWN", "length": 205, "domain": null }, { "name": "OWN1", "type": "esriFieldTypeString", "alias": "OWN1", "length": 205, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "SOURCE", "length": 1, "domain": null }, { "name": "SALETYPE", "type": "esriFieldTypeString", "alias": "SALETYPE", "length": 1, "domain": null }, { "name": "SALEVAL", "type": "esriFieldTypeString", "alias": "SALEVAL", "length": 2, "domain": null }, { "name": "MKTVALID", "type": "esriFieldTypeString", "alias": "MKTVALID", "length": 2, "domain": null }, { "name": "NOTE1", "type": "esriFieldTypeString", "alias": "NOTE1", "length": 80, "domain": null }, { "name": "NOTE2", "type": "esriFieldTypeString", "alias": "NOTE2", "length": 80, "domain": null }, { "name": "NOTE3", "type": "esriFieldTypeString", "alias": "NOTE3", "length": 80, "domain": null }, { "name": "NOTE4", "type": "esriFieldTypeString", "alias": "NOTE4", "length": 80, "domain": null }, { "name": "NOTE5", "type": "esriFieldTypeString", "alias": "NOTE5", "length": 80, "domain": null }, { "name": "NOTE6", "type": "esriFieldTypeString", "alias": "NOTE6", "length": 80, "domain": null }, { "name": "STEB", "type": "esriFieldTypeString", "alias": "STEB", "length": 3, "domain": null }, { "name": "ASMT", "type": "esriFieldTypeInteger", "alias": "ASMT", "domain": null }, { "name": "STFLAG", "type": "esriFieldTypeString", "alias": "STFLAG", "length": 1, "domain": null }, { "name": "NOPAR", "type": "esriFieldTypeSmallInteger", "alias": "NOPAR", "domain": null }, { "name": "INSTRUNO", "type": "esriFieldTypeString", "alias": "INSTRUNO", "length": 20, "domain": null }, { "name": "INSTRTYP", "type": "esriFieldTypeString", "alias": "INSTRTYP", "length": 6, "domain": null }, { "name": "IMAGENO", "type": "esriFieldTypeString", "alias": "IMAGENO", "length": 12, "domain": null }, { "name": "ADJAMT", "type": "esriFieldTypeInteger", "alias": "ADJAMT", "domain": null }, { "name": "ADJPRICE", "type": "esriFieldTypeInteger", "alias": "ADJPRICE", "domain": null }, { "name": "ADJREAS", "type": "esriFieldTypeString", "alias": "ADJREAS", "length": 3, "domain": null }, { "name": "RECORDDT", "type": "esriFieldTypeDate", "alias": "RECORDDT", "length": 8, "domain": null }, { "name": "APRTOT", "type": "esriFieldTypeInteger", "alias": "APRTOT", "domain": null }, { "name": "ASR", "type": "esriFieldTypeDouble", "alias": "ASR", "domain": null }, { "name": "LINKNO", "type": "esriFieldTypeString", "alias": "LINKNO", "length": 20, "domain": null }, { "name": "USER1", "type": "esriFieldTypeString", "alias": "USER1", "length": 40, "domain": null }, { "name": "USER2", "type": "esriFieldTypeString", "alias": "USER2", "length": 40, "domain": null }, { "name": "USER3", "type": "esriFieldTypeString", "alias": "USER3", "length": 40, "domain": null }, { "name": "USER4", "type": "esriFieldTypeString", "alias": "USER4", "length": 40, "domain": null }, { "name": "USER5", "type": "esriFieldTypeString", "alias": "USER5", "length": 40, "domain": null }, { "name": "USER6", "type": "esriFieldTypeString", "alias": "USER6", "length": 40, "domain": null }, { "name": "USER7", "type": "esriFieldTypeString", "alias": "USER7", "length": 40, "domain": null }, { "name": "USER8", "type": "esriFieldTypeString", "alias": "USER8", "length": 40, "domain": null }, { "name": "USER9", "type": "esriFieldTypeString", "alias": "USER9", "length": 40, "domain": null }, { "name": "USER10", "type": "esriFieldTypeString", "alias": "USER10", "length": 40, "domain": null }, { "name": "USER11", "type": "esriFieldTypeString", "alias": "USER11", "length": 40, "domain": null }, { "name": "USER12", "type": "esriFieldTypeString", "alias": "USER12", "length": 40, "domain": null }, { "name": "USER13", "type": "esriFieldTypeString", "alias": "USER13", "length": 40, "domain": null }, { "name": "USER14", "type": "esriFieldTypeString", "alias": "USER14", "length": 40, "domain": null }, { "name": "USER15", "type": "esriFieldTypeString", "alias": "USER15", "length": 40, "domain": null }, { "name": "USER16", "type": "esriFieldTypeString", "alias": "USER16", "length": 40, "domain": null }, { "name": "USER17", "type": "esriFieldTypeString", "alias": "USER17", "length": 40, "domain": null }, { "name": "USER18", "type": "esriFieldTypeString", "alias": "USER18", "length": 40, "domain": null }, { "name": "USER19", "type": "esriFieldTypeString", "alias": "USER19", "length": 40, "domain": null }, { "name": "USER20", "type": "esriFieldTypeString", "alias": "USER20", "length": 40, "domain": null }, { "name": "USER21", "type": "esriFieldTypeString", "alias": "USER21", "length": 40, "domain": null }, { "name": "USER22", "type": "esriFieldTypeString", "alias": "USER22", "length": 40, "domain": null }, { "name": "USER23", "type": "esriFieldTypeString", "alias": "USER23", "length": 40, "domain": null }, { "name": "USER24", "type": "esriFieldTypeString", "alias": "USER24", "length": 40, "domain": null }, { "name": "IASW_ID", "type": "esriFieldTypeDouble", "alias": "IASW_ID", "domain": null }, { "name": "TRANS_ID", "type": "esriFieldTypeInteger", "alias": "TRANS_ID", "domain": null }, { "name": "UPD_STATUS", "type": "esriFieldTypeString", "alias": "UPD_STATUS", "length": 1, "domain": null }, { "name": "DEACTIVAT", "type": "esriFieldTypeDate", "alias": "DEACTIVAT", "length": 8, "domain": null }, { "name": "OLDOWN2", "type": "esriFieldTypeString", "alias": "OLDOWN2", "length": 205, "domain": null }, { "name": "OWN2", "type": "esriFieldTypeString", "alias": "OWN2", "length": 205, "domain": null }, { "name": "USER25", "type": "esriFieldTypeString", "alias": "USER25", "length": 40, "domain": null }, { "name": "USER26", "type": "esriFieldTypeString", "alias": "USER26", "length": 40, "domain": null }, { "name": "USER27", "type": "esriFieldTypeString", "alias": "USER27", "length": 40, "domain": null }, { "name": "USER28", "type": "esriFieldTypeString", "alias": "USER28", "length": 40, "domain": null }, { "name": "USER29", "type": "esriFieldTypeString", "alias": "USER29", "length": 40, "domain": null }, { "name": "USER30", "type": "esriFieldTypeString", "alias": "USER30", "length": 40, "domain": null }, { "name": "USER31", "type": "esriFieldTypeString", "alias": "USER31", "length": 40, "domain": null }, { "name": "USER32", "type": "esriFieldTypeString", "alias": "USER32", "length": 40, "domain": null }, { "name": "USER33", "type": "esriFieldTypeString", "alias": "USER33", "length": 40, "domain": null }, { "name": "USER34", "type": "esriFieldTypeString", "alias": "USER34", "length": 40, "domain": null }, { "name": "USER35", "type": "esriFieldTypeString", "alias": "USER35", "length": 40, "domain": null }, { "name": "USER36", "type": "esriFieldTypeString", "alias": "USER36", "length": 40, "domain": null }, { "name": "USER37", "type": "esriFieldTypeString", "alias": "USER37", "length": 40, "domain": null }, { "name": "USER38", "type": "esriFieldTypeString", "alias": "USER38", "length": 40, "domain": null }, { "name": "USER39", "type": "esriFieldTypeString", "alias": "USER39", "length": 40, "domain": null }, { "name": "USER40", "type": "esriFieldTypeString", "alias": "USER40", "length": 40, "domain": null }, { "name": "USER41", "type": "esriFieldTypeString", "alias": "USER41", "length": 40, "domain": null }, { "name": "USER42", "type": "esriFieldTypeString", "alias": "USER42", "length": 40, "domain": null }, { "name": "USER43", "type": "esriFieldTypeString", "alias": "USER43", "length": 40, "domain": null }, { "name": "USER44", "type": "esriFieldTypeString", "alias": "USER44", "length": 40, "domain": null }, { "name": "USER45", "type": "esriFieldTypeString", "alias": "USER45", "length": 40, "domain": null }, { "name": "USER46", "type": "esriFieldTypeString", "alias": "USER46", "length": 40, "domain": null }, { "name": "USER47", "type": "esriFieldTypeString", "alias": "USER47", "length": 40, "domain": null }, { "name": "USER48", "type": "esriFieldTypeString", "alias": "USER48", "length": 40, "domain": null }, { "name": "USER49", "type": "esriFieldTypeString", "alias": "USER49", "length": 40, "domain": null }, { "name": "USER50", "type": "esriFieldTypeString", "alias": "USER50", "length": 40, "domain": null }, { "name": "USER51", "type": "esriFieldTypeString", "alias": "USER51", "length": 40, "domain": null }, { "name": "USER52", "type": "esriFieldTypeString", "alias": "USER52", "length": 40, "domain": null }, { "name": "USER53", "type": "esriFieldTypeString", "alias": "USER53", "length": 40, "domain": null }, { "name": "USER54", "type": "esriFieldTypeString", "alias": "USER54", "length": 40, "domain": null }, { "name": "USER55", "type": "esriFieldTypeString", "alias": "USER55", "length": 40, "domain": null }, { "name": "USER56", "type": "esriFieldTypeString", "alias": "USER56", "length": 40, "domain": null }, { "name": "USER57", "type": "esriFieldTypeString", "alias": "USER57", "length": 40, "domain": null }, { "name": "USER58", "type": "esriFieldTypeString", "alias": "USER58", "length": 40, "domain": null }, { "name": "USER59", "type": "esriFieldTypeString", "alias": "USER59", "length": 40, "domain": null }, { "name": "USER60", "type": "esriFieldTypeString", "alias": "USER60", "length": 40, "domain": null }, { "name": "USER61", "type": "esriFieldTypeString", "alias": "USER61", "length": 40, "domain": null }, { "name": "USER62", "type": "esriFieldTypeString", "alias": "USER62", "length": 40, "domain": null }, { "name": "USER63", "type": "esriFieldTypeString", "alias": "USER63", "length": 40, "domain": null }, { "name": "USER64", "type": "esriFieldTypeString", "alias": "USER64", "length": 40, "domain": null }, { "name": "USER65", "type": "esriFieldTypeString", "alias": "USER65", "length": 40, "domain": null }, { "name": "USER66", "type": "esriFieldTypeString", "alias": "USER66", "length": 40, "domain": null }, { "name": "USER67", "type": "esriFieldTypeString", "alias": "USER67", "length": 40, "domain": null }, { "name": "USER68", "type": "esriFieldTypeString", "alias": "USER68", "length": 40, "domain": null }, { "name": "USER69", "type": "esriFieldTypeString", "alias": "USER69", "length": 40, "domain": null }, { "name": "USER70", "type": "esriFieldTypeString", "alias": "USER70", "length": 40, "domain": null }, { "name": "ECRV", "type": "esriFieldTypeString", "alias": "ECRV", "length": 10, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "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 }