{ "currentVersion": 10.71, "id": 12, "name": "Supplemental Roll Values New", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NSUP_PARCEL_NBR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "NSUP_PARCEL_NBR", "type": "esriFieldTypeString", "alias": "Parcel Number", "length": 13, "domain": null }, { "name": "NSUP_SUPPLEMENT", "type": "esriFieldTypeDate", "alias": "Supplement", "length": 8, "domain": null }, { "name": "RollType", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 3, "domain": null }, { "name": "RollTypeDesc", "type": "esriFieldTypeString", "alias": "Roll Type", "length": 255, "domain": null }, { "name": "SuppYear", "type": "esriFieldTypeString", "alias": "Supplement Year", "length": 4, "domain": null }, { "name": "SuppType", "type": "esriFieldTypeString", "alias": "Supplement Type", "length": 3, "domain": null }, { "name": "SuppTypeDesc", "type": "esriFieldTypeString", "alias": "Supplement Type", "length": 255, "domain": null }, { "name": "NSUP_BIL_OWN_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Billed Owner Sequence", "domain": null }, { "name": "NSUP_JNT_OWN_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Joint Owner Sequence", "domain": null }, { "name": "NSUP_NEW_VAL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "New Value Sequence", "domain": null }, { "name": "NSUP_OLD_VAL_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "Old Value Sequence", "domain": null }, { "name": "NSUP_LAND_VALUE", "type": "esriFieldTypeDouble", "alias": "Land Value", "domain": null }, { "name": "NewImprovement", "type": "esriFieldTypeDouble", "alias": "New Improvement", "domain": null }, { "name": "OldLand", "type": "esriFieldTypeDouble", "alias": "Old Land", "domain": null }, { "name": "OldImprovement", "type": "esriFieldTypeDouble", "alias": "Old Improvement", "domain": null }, { "name": "NewHOX", "type": "esriFieldTypeDouble", "alias": "New HOX", "domain": null }, { "name": "OldHOX", "type": "esriFieldTypeDouble", "alias": "Old HOX", "domain": null }, { "name": "SuppHOX", "type": "esriFieldTypeDouble", "alias": "Supp HOX", "domain": null }, { "name": "SpclExmAmt1", "type": "esriFieldTypeDouble", "alias": "Special Exemption Amount 1", "domain": null }, { "name": "SpclExmType1", "type": "esriFieldTypeString", "alias": "Special Exemption Type 1", "length": 2, "domain": null }, { "name": "Exem1TypeDesc", "type": "esriFieldTypeString", "alias": "Exemption 1 Description", "length": 255, "domain": null }, { "name": "SpclExmAmt2", "type": "esriFieldTypeDouble", "alias": "Special Exemption Amount 2", "domain": null }, { "name": "SpclExmType2", "type": "esriFieldTypeString", "alias": "Special Exemption Type 2", "length": 2, "domain": null }, { "name": "Exem2TypeDesc", "type": "esriFieldTypeString", "alias": "Exemption 2 Description", "length": 255, "domain": null }, { "name": "PriorSupps", "type": "esriFieldTypeDouble", "alias": "Prior Supplements", "domain": null }, { "name": "NetValue", "type": "esriFieldTypeDouble", "alias": "Net Value", "domain": null }, { "name": "NetChange", "type": "esriFieldTypeDouble", "alias": "Net Change", "domain": null }, { "name": "NSUP_LAST_CHANGE", "type": "esriFieldTypeDate", "alias": "Last Change Date", "length": 8, "domain": null }, { "name": "NSUP_BUILT", "type": "esriFieldTypeDate", "alias": "Built", "length": 8, "domain": null }, { "name": "NOPICDate", "type": "esriFieldTypeDate", "alias": "NOPIC Date", "length": 8, "domain": null }, { "name": "NSUP_NOPIC_SEQ", "type": "esriFieldTypeSmallInteger", "alias": "NOPIC Sequence", "domain": null }, { "name": "ConstructionInProgress", "type": "esriFieldTypeDouble", "alias": "Construction In Progress", "domain": null }, { "name": "BilledOwner", "type": "esriFieldTypeString", "alias": "Billed Owner", "length": 255, "domain": null }, { "name": "SuppValue", "type": "esriFieldTypeDouble", "alias": "Supp Value", "domain": null }, { "name": "JointOwner", "type": "esriFieldTypeString", "alias": "Joint Owner", "length": 255, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [ { "id": 10, "name": "SBC_PUB.DBO.PAT_PropertyInfo_INTERNAL", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "NSUP_PARCEL_NBR", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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 }