Name: EasyProjects.dbo.TT_Projects

Display Field: Name

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 )
• Name ( type: esriFieldTypeString, alias: Name, length: 255 )
• EndDate ( type: esriFieldTypeDate, alias: EndDate, length: 8 )
• ActCompletionDate ( type: esriFieldTypeDate, alias: ActCompletionDate, length: 8 )
• Duration ( type: esriFieldTypeInteger, alias: Duration )
• StartDate ( type: esriFieldTypeDate, alias: StartDate, length: 8 )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• ProjectStatusID ( type: esriFieldTypeInteger, alias: ProjectStatusID )
• BillingType ( type: esriFieldTypeInteger, alias: BillingType )
• BillingAmount ( type: esriFieldTypeDouble, alias: BillingAmount )
• PriorityID ( type: esriFieldTypeInteger, alias: PriorityID )
• Progress ( type: esriFieldTypeInteger, alias: Progress )
• CustomerID ( type: esriFieldTypeInteger, alias: CustomerID )
• CreatorID ( type: esriFieldTypeInteger, alias: CreatorID )
• EstimatedHours ( type: esriFieldTypeDouble, alias: EstimatedHours )
• Description ( type: esriFieldTypeString, alias: Description, length: 1073741822 )
• Budget ( type: esriFieldTypeDouble, alias: Budget )
• PortfolioID ( type: esriFieldTypeInteger, alias: PortfolioID )
• LastModificationDate ( type: esriFieldTypeDate, alias: LastModificationDate, length: 8 )
• CurrencyID ( type: esriFieldTypeInteger, alias: CurrencyID )
• Billed ( type: esriFieldTypeSmallInteger, alias: Billed )
• IsEndDateSelected ( type: esriFieldTypeSmallInteger, alias: IsEndDateSelected )
• HasDescription ( type: esriFieldTypeSmallInteger, alias: HasDescription )
• DurationHours ( type: esriFieldTypeSingle, alias: DurationHours )
• StartDateLag ( type: esriFieldTypeSingle, alias: StartDateLag )
• EndDateLag ( type: esriFieldTypeSingle, alias: EndDateLag )
• BaselineDate ( type: esriFieldTypeDate, alias: BaselineDate, length: 8 )
• BaselineStartDate ( type: esriFieldTypeDate, alias: BaselineStartDate, length: 8 )
• BaselineEndDate ( type: esriFieldTypeDate, alias: BaselineEndDate, length: 8 )
• BaselineStartLag ( type: esriFieldTypeSingle, alias: BaselineStartLag )
• BaselineEndLag ( type: esriFieldTypeSingle, alias: BaselineEndLag )
• StartDateVariance ( type: esriFieldTypeInteger, alias: StartDateVariance )
• EndDateVariance ( type: esriFieldTypeInteger, alias: EndDateVariance )
• RateCardId ( type: esriFieldTypeInteger, alias: RateCardId )
• CustomFields ( type: esriFieldTypeString, alias: CustomFields, length: 1073741822 )
• IsBudgetTrackingOn ( type: esriFieldTypeSmallInteger, alias: IsBudgetTrackingOn )
• UseTasksInTotalBudget ( type: esriFieldTypeSmallInteger, alias: UseTasksInTotalBudget )
• UseExpensesInTotalBudget ( type: esriFieldTypeSmallInteger, alias: UseExpensesInTotalBudget )
• IsRevenueTrackingOn ( type: esriFieldTypeSmallInteger, alias: IsRevenueTrackingOn )
• TargetRevenue ( type: esriFieldTypeDouble, alias: TargetRevenue )
• UseTasksInTotalRevenue ( type: esriFieldTypeSmallInteger, alias: UseTasksInTotalRevenue )
• UseExpensesInTotalRevenue ( type: esriFieldTypeSmallInteger, alias: UseExpensesInTotalRevenue )
• IsProfitTrackingOn ( type: esriFieldTypeSmallInteger, alias: IsProfitTrackingOn )
• IsPercentagesProfitTracking ( type: esriFieldTypeSmallInteger, alias: IsPercentagesProfitTracking )
• TargetProfitPercentages ( type: esriFieldTypeDouble, alias: TargetProfitPercentages )
• TargetProfitAmount ( type: esriFieldTypeDouble, alias: TargetProfitAmount )
• BaselineBudgetedCost ( type: esriFieldTypeDouble, alias: BaselineBudgetedCost )
• BaselineBudget ( type: esriFieldTypeDouble, alias: BaselineBudget )
• BaselineEstimatedHours ( type: esriFieldTypeDouble, alias: BaselineEstimatedHours )
• BudgetPadding ( type: esriFieldTypeDouble, alias: BudgetPadding )
• WorkflowId ( type: esriFieldTypeInteger, alias: WorkflowId )
• IsArchived ( type: esriFieldTypeSmallInteger, alias: IsArchived )
• IsDatesRollupEnabled ( type: esriFieldTypeSmallInteger, alias: IsDatesRollupEnabled )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata