CData Power BI Connector for SugarCRM 2019 - Online Help
Questions / Feedback?

Forecasts

CData Power BI Connector for SugarCRM 2019 - Build 19.0.7354

Create, update, delete, and query the Forecasts module in SugarCRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the forecast.

Timeperiod_Id String False

The Id of the associated time period for this forecast.

Commit_Type String False

The commit type of the worksheet.

Forecast_Type String False

The type of the forecast. Valid values: direct or rollup.

Opp_Count Int False

The number of opportunities represented by this forecast.

Pipeline_Opp_Count Int False

The number of opportunities minus closed won/closed lost represented by this forecast.

Pipeline_Amount Double False

Total of opportunities minus closed won/closed lost represented by this forecast.

Closed_Amount Double False

Total of closed/won items in the forecast.

Opp_Weigh_Value Int False

The weighted amount of all opportunities represented by this forecast.

Currency_Id String False

The Id of the currency associated with the forecast.

Base_Rate Decimal False

The base rate of the forecast.

Best_Case Double False

The most optimistic scenario.

Likely_Case Double False

The likely scenario.

Worst_Case Double False

The least optimistic scenario.

User_Id String False

The user to which this forecast pertains.

Date_Entered Datetime False

The date the record was created.

Date_Modified Datetime False

The date the record was modified.

Deleted Bool False

The record deletion indicator.

User_Name String False

The username of the user associated with the forecast.

Reports_To_User_Name String False

The username of who the user reports to.

Start_Date Datetime False

The start date of the forecast.

End_Date Datetime False

The end date of the forecast.

Name String False

The name of the forecast.

Closed_Count Int False

How many closed opportunities exist for the pipeline.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0