ForecastManagerWorksheets
Create, update, delete, and query the ForecastManagerWorksheets module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the forecast manager worksheet is a favorite for the user. |
| Following | Bool | False |
Whether the user is following the record. |
| Id [KEY] | String | False |
Unique identifier of the worksheet. |
| Name | String | False |
The name of the worksheet. |
| Date_Entered | Datetime | True |
The date the record was created. |
| Date_Modified | Datetime | True |
The date the record was last modified. |
| Modified_User_Id | String | True |
The Id of the user who last modified the record. |
| Modified_By_Name | String | True |
The username of the user who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The username of the user who created the worksheet. |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The user favorites for the worksheet. |
| Description | String | False |
The full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| Assigned_User_Id | String | False |
The Id of the user assigned to the record. |
| Assigned_User_Name | String | False |
The username of the user assigned to the record. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Quota | Double | False |
The quota for the forecast manager worksheet. |
| Best_Case | Double | False |
The most optimistic scenario. |
| Best_Case_Adjusted | Double | False |
The adjusted most optimistic scenario. |
| Likely_Case | Double | False |
The likely scenario. |
| Likely_Case_Adjusted | Double | False |
The adjusted likely scenario. |
| Worst_Case | Double | False |
The least optimistic scenario. |
| Worst_Case_Adjusted | Double | False |
The adjusted least optimistic scenario. |
| Currency_Id | String | False |
The Id of the currency associated with the record. |
| Base_Rate | Decimal | False |
The base rate of the record. |
| Timeperiod_Id | String | False |
The Id of the time period associated with the worksheet. |
| Draft | Bool | False |
Whether the worksheet is a draft. |
| Is_Manager | Bool | False |
Whether the worksheet is visible to the manager. |
| User_Id | String | False |
The Id of the user associated with the worksheet. |
| 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 |
The total of opportunities minus closed won/closed lost represented by this forecast. |
| Closed_Amount | Double | False |
The total of closed/won items in the forecast. |
| Manager_Saved | Bool | False |
Whether the manager has saved the forecast. |
| Show_History_Log | Int | False |
Whether the forecast shows the history log. |
| Draft_Save_Type | String | False |
The draft save type. |