TerritoryForecasts
The forecasts resource is used to view or modify a forecast territory.
Columns
| Name | Type | ReadOnly | References | Description |
| ForecastParticipantId [KEY] | Long | False |
The unique identifier of the territory forecast. | |
| AdjustedBestCase | Double | False |
The best case value of the forecast after adjustments. | |
| AdjustedForecast | Double | False |
The value of the territory forecast after adjustments. | |
| AdjustedQuantity | Double | False |
The value of the adjusted quantity. | |
| AdjustedWorstCase | Double | False |
The worst case value of the forecast after adjustments. | |
| DueDate | Date | False |
The due date for the forecast. | |
| EndDate | Date | False |
The end date for the forecast. | |
| ForecastHeaderId | Long | False |
The unique identifier of the forecast. | |
| ForecastName | String | False |
The name of the forecast. | |
| ForecastParticipationCode | String | False |
The participation code for the forecast. The accepted values are: Revenue and Non-Revenue, Revenue (for revenue forecasts), and Non-Revenue (for overlay forecasts). | |
| ForecastType | String | False |
The type of the forecast. The accepted values are: Revenue and Overlay. | |
| Meaning | String | False |
The status of the forecast. The accepted values are: Submitted, Unsubmitted, and Rejected. | |
| OwnerResourceId | Long | False |
The unique identifier of the party that owns the territory. | |
| ParentTerritoryOwnerResourceId | Long | False |
The resource identifier of the parent territory owner. | |
| PseudoTerritoryFlag | Boolean | False |
Indicates if the territory is a manager territory. | |
| StartDate | Date | False |
The start date for the forecast. | |
| StatusCode | String | False |
The status code of the forecast. The accepted values are: SUBMITTED, UNSUBMITTED, and REJECTED. | |
| SubmittedBy | String | False |
The name of the user who submitted the forecast. | |
| SubmittedOn | Datetime | False |
The submission date of the forecast. | |
| TerritoryHierarchyFreezeDate | Date | False |
The date on which the territory hierarchy is frozen. The forecast for a period is editable only after the territory hierarchy has been frozen for that forecasting period. | |
| TerritoryId | Long | False |
The unique identifier of the territory. | |
| TerritoryLevel | Number | False |
The level of the territory in the territory hierarchy. | |
| TerritoryName | String | False |
The name of the forecast territory. | |
| TerritoryVersionId | Long | False |
The unique identifier of the territory version. | |
| UpdateFlag | Boolean | False |
Indicates if the user has access to update the record. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |
| TrStatus | String |
The accepted values for TrStatus are ACTIVE, PAST, and FUTURE. The forecast records for the given user are filtered based on the specified territory forecast status value. The allowed values are ACTIVE, PAST, FUTURE. |