Forecasts
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. |