Forecasts
The Forecasts table.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier |
| Timeperiod_Id | String | False |
ID of the associated time period for this forecast |
| Commit_Type | String | True |
This is used by the commit code to figure out what type of worksheet we are committing |
| Forecast_Type | String | False |
Indicator of whether forecast is direct or rollup |
| Opp_Count | Int | True |
Number of opportunities represented by this forecast |
| Pipeline_Opp_Count | Int | True |
Number of opportunities minus closed won/closed lost represented by this forecast |
| Pipeline_Amount | Decimal | True |
Total of opportunities minus closed won/closed lost represented by this forecast |
| Closed_Amount | Decimal | True |
Total of closed won items in the forecast |
| Opp_Weigh_Value | Int | True |
Weighted amount of all opportunities represented by this forecast |
| Best_Case | Decimal | True |
Best case forecast amount |
| Likely_Case | Decimal | True |
Likely case forecast amount |
| Worst_Case | Decimal | True |
Worst case likely amount |
| User_Id | String | False |
User to which this forecast pertains |
| Date_Entered | Datetime | False |
Date record created |
| Date_Modified | Datetime | False |
Date record modified |
| Deleted | Bool | False |
Record deletion indicator |
| User_Name | String | True | |
| Reports_To_User_Name | String | True | |
| Start_Date | Date | False | |
| End_Date | Date | False | |
| Name | String | False | |
| Closed_Count | Int | True |
This is used by the commit code to determine how many closed opps exist for the pipeline calc |
| Currency_Id | String | False | |
| Base_Rate | String | False | |
| Currency_Name | String | True | |
| Currency_Symbol | String | True |