Name: EasyProjects.dbo.VV_TaskAggregatedValues

Display Field: AccountId

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• AccountId ( type: esriFieldTypeInteger, alias: AccountId )
• TaskID ( type: esriFieldTypeInteger, alias: TaskID )
• ProjectID ( type: esriFieldTypeInteger, alias: ProjectID )
• ChildsActualHours ( type: esriFieldTypeDouble, alias: ChildsActualHours )
• ActualHours ( type: esriFieldTypeDouble, alias: ActualHours )
• BillableHours ( type: esriFieldTypeDouble, alias: BillableHours )
• ChildsBillableHours ( type: esriFieldTypeDouble, alias: ChildsBillableHours )
• NonBillableHours ( type: esriFieldTypeDouble, alias: NonBillableHours )
• ChildsNonBillableHours ( type: esriFieldTypeDouble, alias: ChildsNonBillableHours )
• ChildsEstimatedHours ( type: esriFieldTypeDouble, alias: ChildsEstimatedHours )
• EstimatedHours ( type: esriFieldTypeDouble, alias: EstimatedHours )
• OwnEstimatedHours ( type: esriFieldTypeDouble, alias: OwnEstimatedHours )
• Budget ( type: esriFieldTypeDouble, alias: Budget )
• ChildsBudget ( type: esriFieldTypeDouble, alias: ChildsBudget )
• Cost ( type: esriFieldTypeDouble, alias: Cost )
• OwnCost ( type: esriFieldTypeDouble, alias: OwnCost )
• InternalCost ( type: esriFieldTypeDouble, alias: InternalCost )
• OwnInternalCost ( type: esriFieldTypeDouble, alias: OwnInternalCost )
• OwnBilledTimeEntriesCost ( type: esriFieldTypeDouble, alias: OwnBilledTimeEntriesCost )
• OwnInternalEstimatedCost ( type: esriFieldTypeDouble, alias: OwnInternalEstimatedCost )
• OwnEstimatedCost ( type: esriFieldTypeDouble, alias: OwnEstimatedCost )
• EstimatedCost ( type: esriFieldTypeDouble, alias: EstimatedCost )
• InternalEstimatedCost ( type: esriFieldTypeDouble, alias: InternalEstimatedCost )
• ChildsHoursLeft ( type: esriFieldTypeDouble, alias: ChildsHoursLeft )
• OwnPlannedCost ( type: esriFieldTypeDouble, alias: OwnPlannedCost )
• OwnPlannedInternalCostByUserRate ( type: esriFieldTypeDouble, alias: OwnPlannedInternalCostByUserRate )
• ExpensesAmount ( type: esriFieldTypeDouble, alias: ExpensesAmount )
• PlannedExpenses ( type: esriFieldTypeDouble, alias: PlannedExpenses )
• ExpensesBillableAmount ( type: esriFieldTypeDouble, alias: ExpensesBillableAmount )
• ExpensesBilledAmount ( type: esriFieldTypeDouble, alias: ExpensesBilledAmount )
• EstimatedExpensesAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesAmount )
• EstimatedExpensesBillableAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesBillableAmount )
• EACExpenses ( type: esriFieldTypeDouble, alias: EACExpenses )
• EACBillableExpenses ( type: esriFieldTypeDouble, alias: EACBillableExpenses )
• ExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: ExpensesNonBillableAmount )
• EstimatedExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesNonBillableAmount )
• OwnBilling ( type: esriFieldTypeDouble, alias: OwnBilling )
• OwnEstimatedBilling ( type: esriFieldTypeDouble, alias: OwnEstimatedBilling )
• OwnActualCost ( type: esriFieldTypeDouble, alias: OwnActualCost )
• OwnETCCost ( type: esriFieldTypeDouble, alias: OwnETCCost )
• OwnBilledLabor ( type: esriFieldTypeDouble, alias: OwnBilledLabor )
• OwnFlatFee ( type: esriFieldTypeDouble, alias: OwnFlatFee )
• AggrExpensesAmount ( type: esriFieldTypeDouble, alias: AggrExpensesAmount )
• AggrExpensesBillableAmount ( type: esriFieldTypeDouble, alias: AggrExpensesBillableAmount )
• AggrExpensesBilledAmount ( type: esriFieldTypeDouble, alias: AggrExpensesBilledAmount )
• AggrExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: AggrExpensesNonBillableAmount )
• AggrEstimatedExpensesAmount ( type: esriFieldTypeDouble, alias: AggrEstimatedExpensesAmount )
• AggrEstimatedExpensesBillableAmount ( type: esriFieldTypeDouble, alias: AggrEstimatedExpensesBillableAmount )
• AggrEstimatedExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: AggrEstimatedExpensesNonBillableAmount )
• AggrEACExpenses ( type: esriFieldTypeDouble, alias: AggrEACExpenses )
• AggrEACBillableExpenses ( type: esriFieldTypeDouble, alias: AggrEACBillableExpenses )
• AggrActualLaborBilling ( type: esriFieldTypeDouble, alias: AggrActualLaborBilling )
• AggrActualLaborCost ( type: esriFieldTypeDouble, alias: AggrActualLaborCost )
• AggrETCLaborBilling ( type: esriFieldTypeDouble, alias: AggrETCLaborBilling )
• AggrETCLaborCost ( type: esriFieldTypeDouble, alias: AggrETCLaborCost )
• AggrBilledLabor ( type: esriFieldTypeDouble, alias: AggrBilledLabor )
• EACNonBillableExpenses ( type: esriFieldTypeDouble, alias: EACNonBillableExpenses )
• AggrEACNonBillableExpenses ( type: esriFieldTypeDouble, alias: AggrEACNonBillableExpenses )
• OwnProfit ( type: esriFieldTypeDouble, alias: OwnProfit )
• OwnEACCost ( type: esriFieldTypeDouble, alias: OwnEACCost )
• OwnEACBilling ( type: esriFieldTypeDouble, alias: OwnEACBilling )
• OwnBilled ( type: esriFieldTypeDouble, alias: OwnBilled )
• CostVariance ( type: esriFieldTypeDouble, alias: CostVariance )
• Profit ( type: esriFieldTypeDouble, alias: Profit )
• ProfitHealth ( type: esriFieldTypeInteger, alias: ProfitHealth )
• ETCBilling ( type: esriFieldTypeDouble, alias: ETCBilling )
• ETCCost ( type: esriFieldTypeDouble, alias: ETCCost )
• EACBilling ( type: esriFieldTypeDouble, alias: EACBilling )
• EACCost ( type: esriFieldTypeDouble, alias: EACCost )
• OwnRemainingInternalBudget ( type: esriFieldTypeDouble, alias: OwnRemainingInternalBudget )
• OwnProfitPercentage ( type: esriFieldTypeDouble, alias: OwnProfitPercentage )
• OwnEstimatedProfit ( type: esriFieldTypeDouble, alias: OwnEstimatedProfit )
• OwnEstimatedProfitPercentage ( type: esriFieldTypeDouble, alias: OwnEstimatedProfitPercentage )
• OwnBilledPercentage ( type: esriFieldTypeDouble, alias: OwnBilledPercentage )
• ProfitPercentage ( type: esriFieldTypeDouble, alias: ProfitPercentage )
• ExpectedProfit ( type: esriFieldTypeDouble, alias: ExpectedProfit )
• ExpectedProfitPercentage ( type: esriFieldTypeDouble, alias: ExpectedProfitPercentage )
• Billed ( type: esriFieldTypeDouble, alias: Billed )
• BilledPercentage ( type: esriFieldTypeDouble, alias: BilledPercentage )
• BudgetVariance ( type: esriFieldTypeDouble, alias: BudgetVariance )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata