{ "currentVersion": 10.91, "id": 15, "name": "EasyProjects.dbo.TT_Tasks", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "AccountId", "type": "esriFieldTypeInteger", "alias": "AccountId", "domain": null }, { "name": "TaskID", "type": "esriFieldTypeInteger", "alias": "TaskID", "domain": null }, { "name": "ProjectID", "type": "esriFieldTypeInteger", "alias": "ProjectID", "domain": null }, { "name": "ParentID", "type": "esriFieldTypeInteger", "alias": "ParentID", "domain": null }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "length": 400, "domain": null }, { "name": "TaskTypeID", "type": "esriFieldTypeInteger", "alias": "TaskTypeID", "domain": null }, { "name": "TaskStatusID", "type": "esriFieldTypeInteger", "alias": "TaskStatusID", "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "StartDate", "type": "esriFieldTypeDate", "alias": "StartDate", "length": 8, "domain": null }, { "name": "EndDate", "type": "esriFieldTypeDate", "alias": "EndDate", "length": 8, "domain": null }, { "name": "Duration", "type": "esriFieldTypeInteger", "alias": "Duration", "domain": null }, { "name": "EstimatedHours", "type": "esriFieldTypeDouble", "alias": "EstimatedHours", "domain": null }, { "name": "CreatorID", "type": "esriFieldTypeInteger", "alias": "CreatorID", "domain": null }, { "name": "CategoryID", "type": "esriFieldTypeInteger", "alias": "CategoryID", "domain": null }, { "name": "BillingType", "type": "esriFieldTypeInteger", "alias": "BillingType", "domain": null }, { "name": "BillingAmount", "type": "esriFieldTypeDouble", "alias": "BillingAmount", "domain": null }, { "name": "Progress", "type": "esriFieldTypeInteger", "alias": "Progress", "domain": null }, { "name": "PriorityID", "type": "esriFieldTypeInteger", "alias": "PriorityID", "domain": null }, { "name": "ActualCompletionDate", "type": "esriFieldTypeDate", "alias": "ActualCompletionDate", "length": 8, "domain": null }, { "name": "IsMilestone", "type": "esriFieldTypeSmallInteger", "alias": "IsMilestone", "domain": null }, { "name": "Approved", "type": "esriFieldTypeSmallInteger", "alias": "Approved", "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 1073741822, "domain": null }, { "name": "LastModificationDate", "type": "esriFieldTypeDate", "alias": "LastModificationDate", "length": 8, "domain": null }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null }, { "name": "HoursLeft", "type": "esriFieldTypeDouble", "alias": "HoursLeft", "domain": null }, { "name": "WBSNumber", "type": "esriFieldTypeDouble", "alias": "WBSNumber", "domain": null }, { "name": "IsEndDateSelected", "type": "esriFieldTypeSmallInteger", "alias": "IsEndDateSelected", "domain": null }, { "name": "Billed", "type": "esriFieldTypeSmallInteger", "alias": "Billed", "domain": null }, { "name": "HasDescription", "type": "esriFieldTypeSmallInteger", "alias": "HasDescription", "domain": null }, { "name": "StartDateForGantt", "type": "esriFieldTypeDate", "alias": "StartDateForGantt", "length": 8, "domain": null }, { "name": "EndDateForGantt", "type": "esriFieldTypeDate", "alias": "EndDateForGantt", "length": 8, "domain": null }, { "name": "DurationHours", "type": "esriFieldTypeSingle", "alias": "DurationHours", "domain": null }, { "name": "StartDateLag", "type": "esriFieldTypeSingle", "alias": "StartDateLag", "domain": null }, { "name": "EndDateLag", "type": "esriFieldTypeSingle", "alias": "EndDateLag", "domain": null }, { "name": "LagForGantt", "type": "esriFieldTypeSingle", "alias": "LagForGantt", "domain": null }, { "name": "BaselineStartDate", "type": "esriFieldTypeDate", "alias": "BaselineStartDate", "length": 8, "domain": null }, { "name": "BaselineEndDate", "type": "esriFieldTypeDate", "alias": "BaselineEndDate", "length": 8, "domain": null }, { "name": "BaselineStartLag", "type": "esriFieldTypeSingle", "alias": "BaselineStartLag", "domain": null }, { "name": "BaselineEndLag", "type": "esriFieldTypeSingle", "alias": "BaselineEndLag", "domain": null }, { "name": "StartDateVariance", "type": "esriFieldTypeInteger", "alias": "StartDateVariance", "domain": null }, { "name": "EndDateVariance", "type": "esriFieldTypeInteger", "alias": "EndDateVariance", "domain": null }, { "name": "SourceRepeatTaskId", "type": "esriFieldTypeInteger", "alias": "SourceRepeatTaskId", "domain": null }, { "name": "IsRepeatSource", "type": "esriFieldTypeSmallInteger", "alias": "IsRepeatSource", "domain": null }, { "name": "RepeatWrapperForTaskId", "type": "esriFieldTypeInteger", "alias": "RepeatWrapperForTaskId", "domain": null }, { "name": "CustomFields", "type": "esriFieldTypeString", "alias": "CustomFields", "length": 1073741822, "domain": null }, { "name": "BaselineBudget", "type": "esriFieldTypeDouble", "alias": "BaselineBudget", "domain": null }, { "name": "BaselineOwnEstimatedHours", "type": "esriFieldTypeDouble", "alias": "BaselineOwnEstimatedHours", "domain": null }, { "name": "RateCardId", "type": "esriFieldTypeInteger", "alias": "RateCardId", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R73_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_73", "fields": "GlobalID", "isAscending": true, "isUnique": false, "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 }