ForecastWorksheets
The ForecastWorksheets table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Name | String | False | |
| Date_Entered | Datetime | True |
Date record created |
| Date_Modified | Datetime | True |
Date record last modified |
| Modified_User_Id | String | True |
User who last modified record |
| Modified_By_Name | String | True | |
| Created_By | String | True |
User who created record |
| Created_By_Name | String | True | |
| Description | String | False |
Full text of the note |
| Deleted | Bool | False |
Record deletion indicator |
| Parent_Id | String | False |
Account ID of the parent of this account |
| Parent_Type | String | True |
Sugar module the Worksheet is associated with |
| Parent_Name | String | True | |
| Opportunity_Id | String | False | |
| Opportunity_Name | String | True | |
| Account_Name | String | True | |
| Account_Id | String | False | |
| Campaign_Id | String | False | |
| Campaign_Name | String | True | |
| Product_Template_Id | String | False | |
| Product_Template_Name | String | True | |
| Category_Id | String | False | |
| Category_Name | String | True | |
| Sales_Status | String | False | |
| Likely_Case | Decimal | True | |
| Best_Case | Decimal | True | |
| Worst_Case | Decimal | True | |
| Date_Closed | Date | False |
Expected or actual date the oppportunity will close |
| Date_Closed_Timestamp | String | True | |
| Sales_Stage | String | False |
Indication of progression towards closure |
| Probability | Int | True |
The probability of closure |
| Commit_Stage | String | False |
Forecast commit ranges: Include, Likely, Omit etc. |
| Draft | Int | True |
Is A Draft Version |
| Next_Step | String | False |
The next step in the sales process |
| Lead_Source | String | False |
Source of the product |
| Product_Type | String | False |
Type of product ( from opportunities opportunity_type ex: Existing, New) |
| List_Price | Decimal | True |
List price of product ( |
| Cost_Price | Decimal | True |
Product cost ( |
| Discount_Price | Decimal | True |
Discounted price ( |
| Discount_Amount | Decimal | True |
Discounted amount |
| Quantity | Int | True |
Quantity in use |
| Total_Amount | Decimal | True | |
| Parent_Deleted | Int | True |
Is Parent Deleted |
| Following | Bool | False |
Is user following this record |
| My_Favorite | Bool | False |
Favorite for the user |
| Locked_Fields | String | True | |
| Sync_Key | String | True | |
| Assigned_User_Id | String | False |
User ID assigned to record |
| Assigned_User_Name | String | True | |
| Team_Id | String | False |
Team ID for the account |
| Team_Set_Id | String | False | |
| Acl_Team_Set_Id | String | False | |
| Team_Count | String | False | |
| Team_Name | String | False | |
| Acl_Team_Names | String | True | |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | String | True |