Name: EasyProjects.dbo.VV_ProjectFinancials

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 )
• ProjectID ( type: esriFieldTypeInteger, alias: ProjectID )
• Cost ( type: esriFieldTypeDouble, alias: Cost )
• ETCBilling ( type: esriFieldTypeDouble, alias: ETCBilling )
• EACBilling ( type: esriFieldTypeDouble, alias: EACBilling )
• ActualLaborCost ( type: esriFieldTypeDouble, alias: ActualLaborCost )
• ETCLaborCost ( type: esriFieldTypeDouble, alias: ETCLaborCost )
• EACLaborCost ( type: esriFieldTypeDouble, alias: EACLaborCost )
• ActualLaborBilling ( type: esriFieldTypeDouble, alias: ActualLaborBilling )
• ETCLaborBilling ( type: esriFieldTypeDouble, alias: ETCLaborBilling )
• EACLaborBilling ( type: esriFieldTypeDouble, alias: EACLaborBilling )
• InternalCost ( type: esriFieldTypeDouble, alias: InternalCost )
• ETCCost ( type: esriFieldTypeDouble, alias: ETCCost )
• EACCost ( type: esriFieldTypeDouble, alias: EACCost )
• ProjectProfit ( type: esriFieldTypeDouble, alias: ProjectProfit )
• ProjectProfitHealth ( type: esriFieldTypeInteger, alias: ProjectProfitHealth )
• ProjectProfitability ( type: esriFieldTypeDouble, alias: ProjectProfitability )
• ProjectProfitPercentage ( type: esriFieldTypeDouble, alias: ProjectProfitPercentage )
• ChildsBudget ( type: esriFieldTypeDouble, alias: ChildsBudget )
• BudgetedCost ( type: esriFieldTypeDouble, alias: BudgetedCost )
• ProjectCostVariance ( type: esriFieldTypeDouble, alias: ProjectCostVariance )
• PlannedExpenses ( type: esriFieldTypeDouble, alias: PlannedExpenses )
• ExpensesPlannedBillableAmount ( type: esriFieldTypeDouble, alias: ExpensesPlannedBillableAmount )
• TotalPayments ( type: esriFieldTypeDouble, alias: TotalPayments )
• ReceivedPayments ( type: esriFieldTypeDouble, alias: ReceivedPayments )
• ScheduledPayments ( type: esriFieldTypeDouble, alias: ScheduledPayments )
• ProjectExpectedRevenue ( type: esriFieldTypeDouble, alias: ProjectExpectedRevenue )
• ProjectBudget ( type: esriFieldTypeDouble, alias: ProjectBudget )
• PercentageOfProjectBilled ( type: esriFieldTypeDouble, alias: PercentageOfProjectBilled )
• WorkInProgress ( type: esriFieldTypeDouble, alias: WorkInProgress )
• TotalBilled ( type: esriFieldTypeDouble, alias: TotalBilled )
• ProjectTimeUsage ( type: esriFieldTypeDouble, alias: ProjectTimeUsage )
• BillingUtilization ( type: esriFieldTypeDouble, alias: BillingUtilization )
• InternalEstimatedCost ( type: esriFieldTypeDouble, alias: InternalEstimatedCost )
• EstimatedCostVariance ( type: esriFieldTypeDouble, alias: EstimatedCostVariance )
• EstimatedBudgetProfitability ( type: esriFieldTypeDouble, alias: EstimatedBudgetProfitability )
• ActualBudgetProfitability ( type: esriFieldTypeDouble, alias: ActualBudgetProfitability )
• BilledLabor ( type: esriFieldTypeDouble, alias: BilledLabor )
• ExpectedProfit ( type: esriFieldTypeDouble, alias: ExpectedProfit )
• BilledPercentage ( type: esriFieldTypeDouble, alias: BilledPercentage )
• ExpectedProfitPercentage ( type: esriFieldTypeDouble, alias: ExpectedProfitPercentage )
• ExpensesAmount ( type: esriFieldTypeDouble, alias: ExpensesAmount )
• ExpensesBillableAmount ( type: esriFieldTypeDouble, alias: ExpensesBillableAmount )
• ExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: ExpensesNonBillableAmount )
• ExpensesBilledAmount ( type: esriFieldTypeDouble, alias: ExpensesBilledAmount )
• EstimatedExpensesAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesAmount )
• EstimatedExpensesBillableAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesBillableAmount )
• EstimatedExpensesNonBillableAmount ( type: esriFieldTypeDouble, alias: EstimatedExpensesNonBillableAmount )
• EACExpenses ( type: esriFieldTypeDouble, alias: EACExpenses )
• EACBillableExpenses ( type: esriFieldTypeDouble, alias: EACBillableExpenses )
• EACNonBillableExpenses ( type: esriFieldTypeDouble, alias: EACNonBillableExpenses )
• ExceedByCost ( type: esriFieldTypeSmallInteger, alias: ExceedByCost )
• TasksFlatFee ( type: esriFieldTypeDouble, alias: TasksFlatFee )
• TotalRevenue ( type: esriFieldTypeDouble, alias: TotalRevenue )
• BudgetVariance ( type: esriFieldTypeDouble, alias: BudgetVariance )
• RevenueVariance ( type: esriFieldTypeDouble, alias: RevenueVariance )
• ProfitVariance ( type: esriFieldTypeDouble, alias: ProfitVariance )
• ProfitVariancePercentage ( type: esriFieldTypeDouble, alias: ProfitVariancePercentage )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata