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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. 使用できる値は次のとおりです。ACTIVE, PAST, FUTURE |