{ "currentVersion": 10.91, "id": 6, "name": "TASK_TRANSACTION_HISTORY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FromUser", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.RequestNumber", "type": "esriFieldTypeInteger", "alias": "RequestNumber", "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.FromUser", "type": "esriFieldTypeString", "alias": "FromUser", "length": 50, "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.ToUser", "type": "esriFieldTypeString", "alias": "ToUser", "length": 50, "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.ReceivedDate", "type": "esriFieldTypeDate", "alias": "ReceivedDate", "length": 8, "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.Remark", "type": "esriFieldTypeString", "alias": "Remark", "length": 500, "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.RowNumber", "type": "esriFieldTypeInteger", "alias": "RowNumber", "domain": null }, { "name": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.Attachment", "type": "esriFieldTypeString", "alias": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.Attachment", "length": 1, "domain": null }, { "name": "MASTER_TASK_STATUS.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "MASTER_TASK_STATUS.StatusID", "type": "esriFieldTypeInteger", "alias": "StatusID", "domain": null }, { "name": "MASTER_TASK_STATUS.Status", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": null }, { "name": "Master_Task.OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "Master_Task.TaskID", "type": "esriFieldTypeInteger", "alias": "TASK_ID", "domain": null }, { "name": "Master_Task.TaskName", "type": "esriFieldTypeString", "alias": "TaskName", "length": 100, "domain": null } ], "indexes": [ { "name": "R113_SDE_ROWID_UK", "fields": "MIDC_DATA.GIS.TASK_TRANSACTION_HISTORY.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_OBJECTID", "fields": "MASTER_TASK_STATUS.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I47StatusID", "fields": "MASTER_TASK_STATUS.StatusID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_OBJECTID", "fields": "Master_Task.OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I48TaskName", "fields": "Master_Task.TaskName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I48TaskID", "fields": "Master_Task.TaskID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": false, "supportsAdvancedQueries": false, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": false, "supportsHavingClause": false, "supportsCountDistinct": false, "supportsOrderBy": false, "supportsDistinct": false, "supportsPagination": false, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": false }, "dateFieldsTimeReference": null, "serviceItemId": "676926908793427ab3441ccff1a4e50a" }