{ "currentVersion": 10.91, "id": 20, "name": "EasyProjects.dbo.VV_TaskAggregatedValues", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AccountId", "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": "ChildsActualHours", "type": "esriFieldTypeDouble", "alias": "ChildsActualHours", "domain": null }, { "name": "ActualHours", "type": "esriFieldTypeDouble", "alias": "ActualHours", "domain": null }, { "name": "BillableHours", "type": "esriFieldTypeDouble", "alias": "BillableHours", "domain": null }, { "name": "ChildsBillableHours", "type": "esriFieldTypeDouble", "alias": "ChildsBillableHours", "domain": null }, { "name": "NonBillableHours", "type": "esriFieldTypeDouble", "alias": "NonBillableHours", "domain": null }, { "name": "ChildsNonBillableHours", "type": "esriFieldTypeDouble", "alias": "ChildsNonBillableHours", "domain": null }, { "name": "ChildsEstimatedHours", "type": "esriFieldTypeDouble", "alias": "ChildsEstimatedHours", "domain": null }, { "name": "EstimatedHours", "type": "esriFieldTypeDouble", "alias": "EstimatedHours", "domain": null }, { "name": "OwnEstimatedHours", "type": "esriFieldTypeDouble", "alias": "OwnEstimatedHours", "domain": null }, { "name": "Budget", "type": "esriFieldTypeDouble", "alias": "Budget", "domain": null }, { "name": "ChildsBudget", "type": "esriFieldTypeDouble", "alias": "ChildsBudget", "domain": null }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "OwnCost", "type": "esriFieldTypeDouble", "alias": "OwnCost", "domain": null }, { "name": "InternalCost", "type": "esriFieldTypeDouble", "alias": "InternalCost", "domain": null }, { "name": "OwnInternalCost", "type": "esriFieldTypeDouble", "alias": "OwnInternalCost", "domain": null }, { "name": "OwnBilledTimeEntriesCost", "type": "esriFieldTypeDouble", "alias": "OwnBilledTimeEntriesCost", "domain": null }, { "name": "OwnInternalEstimatedCost", "type": "esriFieldTypeDouble", "alias": "OwnInternalEstimatedCost", "domain": null }, { "name": "OwnEstimatedCost", "type": "esriFieldTypeDouble", "alias": "OwnEstimatedCost", "domain": null }, { "name": "EstimatedCost", "type": "esriFieldTypeDouble", "alias": "EstimatedCost", "domain": null }, { "name": "InternalEstimatedCost", "type": "esriFieldTypeDouble", "alias": "InternalEstimatedCost", "domain": null }, { "name": "ChildsHoursLeft", "type": "esriFieldTypeDouble", "alias": "ChildsHoursLeft", "domain": null }, { "name": "OwnPlannedCost", "type": "esriFieldTypeDouble", "alias": "OwnPlannedCost", "domain": null }, { "name": "OwnPlannedInternalCostByUserRate", "type": "esriFieldTypeDouble", "alias": "OwnPlannedInternalCostByUserRate", "domain": null }, { "name": "ExpensesAmount", "type": "esriFieldTypeDouble", "alias": "ExpensesAmount", "domain": null }, { "name": "PlannedExpenses", "type": "esriFieldTypeDouble", "alias": "PlannedExpenses", "domain": null }, { "name": "ExpensesBillableAmount", "type": "esriFieldTypeDouble", "alias": "ExpensesBillableAmount", "domain": null }, { "name": "ExpensesBilledAmount", "type": "esriFieldTypeDouble", "alias": "ExpensesBilledAmount", "domain": null }, { "name": "EstimatedExpensesAmount", "type": "esriFieldTypeDouble", "alias": "EstimatedExpensesAmount", "domain": null }, { "name": "EstimatedExpensesBillableAmount", "type": "esriFieldTypeDouble", "alias": "EstimatedExpensesBillableAmount", "domain": null }, { "name": "EACExpenses", "type": "esriFieldTypeDouble", "alias": "EACExpenses", "domain": null }, { "name": "EACBillableExpenses", "type": "esriFieldTypeDouble", "alias": "EACBillableExpenses", "domain": null }, { "name": "ExpensesNonBillableAmount", "type": "esriFieldTypeDouble", "alias": "ExpensesNonBillableAmount", "domain": null }, { "name": "EstimatedExpensesNonBillableAmount", "type": "esriFieldTypeDouble", "alias": "EstimatedExpensesNonBillableAmount", "domain": null }, { "name": "OwnBilling", "type": "esriFieldTypeDouble", "alias": "OwnBilling", "domain": null }, { "name": "OwnEstimatedBilling", "type": "esriFieldTypeDouble", "alias": "OwnEstimatedBilling", "domain": null }, { "name": "OwnActualCost", "type": "esriFieldTypeDouble", "alias": "OwnActualCost", "domain": null }, { "name": "OwnETCCost", "type": "esriFieldTypeDouble", "alias": "OwnETCCost", "domain": null }, { "name": "OwnBilledLabor", "type": "esriFieldTypeDouble", "alias": "OwnBilledLabor", "domain": null }, { "name": "OwnFlatFee", "type": "esriFieldTypeDouble", "alias": "OwnFlatFee", "domain": null }, { "name": "AggrExpensesAmount", "type": "esriFieldTypeDouble", "alias": "AggrExpensesAmount", "domain": null }, { "name": "AggrExpensesBillableAmount", "type": "esriFieldTypeDouble", "alias": "AggrExpensesBillableAmount", "domain": null }, { "name": "AggrExpensesBilledAmount", "type": "esriFieldTypeDouble", "alias": "AggrExpensesBilledAmount", "domain": null }, { "name": "AggrExpensesNonBillableAmount", "type": "esriFieldTypeDouble", "alias": "AggrExpensesNonBillableAmount", "domain": null }, { "name": "AggrEstimatedExpensesAmount", "type": "esriFieldTypeDouble", "alias": "AggrEstimatedExpensesAmount", "domain": null }, { "name": "AggrEstimatedExpensesBillableAmount", "type": "esriFieldTypeDouble", "alias": "AggrEstimatedExpensesBillableAmount", "domain": null }, { "name": "AggrEstimatedExpensesNonBillableAmount", "type": "esriFieldTypeDouble", "alias": "AggrEstimatedExpensesNonBillableAmount", "domain": null }, { "name": "AggrEACExpenses", "type": "esriFieldTypeDouble", "alias": "AggrEACExpenses", "domain": null }, { "name": "AggrEACBillableExpenses", "type": "esriFieldTypeDouble", "alias": "AggrEACBillableExpenses", "domain": null }, { "name": "AggrActualLaborBilling", "type": "esriFieldTypeDouble", "alias": "AggrActualLaborBilling", "domain": null }, { "name": "AggrActualLaborCost", "type": "esriFieldTypeDouble", "alias": "AggrActualLaborCost", "domain": null }, { "name": "AggrETCLaborBilling", "type": "esriFieldTypeDouble", "alias": "AggrETCLaborBilling", "domain": null }, { "name": "AggrETCLaborCost", "type": "esriFieldTypeDouble", "alias": "AggrETCLaborCost", "domain": null }, { "name": "AggrBilledLabor", "type": "esriFieldTypeDouble", "alias": "AggrBilledLabor", "domain": null }, { "name": "EACNonBillableExpenses", "type": "esriFieldTypeDouble", "alias": "EACNonBillableExpenses", "domain": null }, { "name": "AggrEACNonBillableExpenses", "type": "esriFieldTypeDouble", "alias": "AggrEACNonBillableExpenses", "domain": null }, { "name": "OwnProfit", "type": "esriFieldTypeDouble", "alias": "OwnProfit", "domain": null }, { "name": "OwnEACCost", "type": "esriFieldTypeDouble", "alias": "OwnEACCost", "domain": null }, { "name": "OwnEACBilling", "type": "esriFieldTypeDouble", "alias": "OwnEACBilling", "domain": null }, { "name": "OwnBilled", "type": "esriFieldTypeDouble", "alias": "OwnBilled", "domain": null }, { "name": "CostVariance", "type": "esriFieldTypeDouble", "alias": "CostVariance", "domain": null }, { "name": "Profit", "type": "esriFieldTypeDouble", "alias": "Profit", "domain": null }, { "name": "ProfitHealth", "type": "esriFieldTypeInteger", "alias": "ProfitHealth", "domain": null }, { "name": "ETCBilling", "type": "esriFieldTypeDouble", "alias": "ETCBilling", "domain": null }, { "name": "ETCCost", "type": "esriFieldTypeDouble", "alias": "ETCCost", "domain": null }, { "name": "EACBilling", "type": "esriFieldTypeDouble", "alias": "EACBilling", "domain": null }, { "name": "EACCost", "type": "esriFieldTypeDouble", "alias": "EACCost", "domain": null }, { "name": "OwnRemainingInternalBudget", "type": "esriFieldTypeDouble", "alias": "OwnRemainingInternalBudget", "domain": null }, { "name": "OwnProfitPercentage", "type": "esriFieldTypeDouble", "alias": "OwnProfitPercentage", "domain": null }, { "name": "OwnEstimatedProfit", "type": "esriFieldTypeDouble", "alias": "OwnEstimatedProfit", "domain": null }, { "name": "OwnEstimatedProfitPercentage", "type": "esriFieldTypeDouble", "alias": "OwnEstimatedProfitPercentage", "domain": null }, { "name": "OwnBilledPercentage", "type": "esriFieldTypeDouble", "alias": "OwnBilledPercentage", "domain": null }, { "name": "ProfitPercentage", "type": "esriFieldTypeDouble", "alias": "ProfitPercentage", "domain": null }, { "name": "ExpectedProfit", "type": "esriFieldTypeDouble", "alias": "ExpectedProfit", "domain": null }, { "name": "ExpectedProfitPercentage", "type": "esriFieldTypeDouble", "alias": "ExpectedProfitPercentage", "domain": null }, { "name": "Billed", "type": "esriFieldTypeDouble", "alias": "Billed", "domain": null }, { "name": "BilledPercentage", "type": "esriFieldTypeDouble", "alias": "BilledPercentage", "domain": null }, { "name": "BudgetVariance", "type": "esriFieldTypeDouble", "alias": "BudgetVariance", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R78_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_78", "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 }