ForecastWorksheets
Create, update, delete, and query the ForecastWorksheets module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the record 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 |
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. |
| Parent_Id | String | False |
The Id of the parent module associated with the worksheet. |
| Parent_Type | String | False |
The type of the parent module associated with the worksheet. |
| Parent_Name | String | False |
The name of the parent module associated with the worksheet. |
| Opportunity_Id | String | False |
The Id of the opportunity associated with the worksheet. |
| Opportunity_Name | String | False |
The name of the opportunity associated with the worksheet. |
| Account_Name | String | False |
The name of the account associated with the worksheet. |
| Account_Id | String | False |
The Id of the account associated with the worksheet. |
| Campaign_Id | String | False |
The Id of the campaign associated with the worksheet. |
| Campaign_Name | String | False |
The name of the campaign associated with the worksheet. |
| Product_Template_Id | String | False |
The Id of the product template associated with the worksheet. |
| Product_Template_Name | String | False |
The name of the product template associated with the worksheet. |
| Category_Id | String | False |
The Id of the category associated with the worksheet. |
| Category_Name | String | False |
The name of the category associated with the worksheet. |
| Sales_Status | String | False |
The sales status of the worksheet. |
| Likely_Case | Double | False |
The likely scenario. |
| Best_Case | Double | False |
The most optimistic scenario. |
| Worst_Case | Double | False |
The least optimistic scenario. |
| Base_Rate | Decimal | False |
The base rate worksheet. |
| Currency_Id | String | False |
The Id of the currency used for display purposes. |
| Currency_Name | String | False |
The name of the currency used for display purposes. |
| Currency_Symbol | String | False |
The symbol of the currency used for display purposes. |
| Date_Closed | Datetime | False |
Expected or actual date the oppportunity will close. |
| Date_Closed_Timestamp | Int | False |
The timestamp of the close date for the opportunity. |
| Sales_Stage | String | False |
The stage that indicates the progression towards closure. |
| Probability | Int | False |
The probability of closure. |
| Commit_Stage | String | False |
The forecast commit range, such as Include, Likely, Omit, etc. |
| Draft | Int | False |
Whether the forecast is a draft. |
| Next_Step | String | False |
The next step in the sales process. |
| Lead_Source | String | False |
The source of the product. |
| Product_Type | String | False |
The type of product. An opportunity type. For example, Existing or New. |
| List_Price | Double | False |
List price of product (List in Quote). |
| Cost_Price | Double | False |
Product cost (Cost in Quote). |
| Discount_Price | Double | False |
Discounted price (Unit Price in Quote). |
| Discount_Amount | Double | False |
Discounted amount. |
| Quantity | Int | False |
Quantity in use. |
| Total_Amount | Double | False |
The total amount. |
| Parent_Deleted | Int | False |
Whether the parent object is deleted. |