Territories
The sales territories resource represents the list of sales territories that the logged-in user can view. A sales territory is an organizational domain with boundaries defined by attributes of customers, products, services, resources, and so on. Sales territories can be created based on multiple criteria including postal code, area code, country, vertical market, size of company, product expertise, and geographical location. Sales territories form the fundamental infrastructure of sales management as they define the jurisdiction that salespeople have over sales accounts, or the jurisdiction that channel sales managers have over partners and partner transactions.
Columns
| Name | Type | ReadOnly | References | Description |
| TerritoryVersionId [KEY] | Long | False |
The unique identifier of the territory version. | |
| CoverageModel | String | False |
Indicates if the dimensions of the territory are based on account attributes or partner attributes. | |
| DeleteFlag | Boolean | False |
Indicates if the logged-in user can delete the territory. | |
| Description | String | False |
The description of the territory. | |
| EffectiveEndDate | Date | False |
The date and time when the territory version becomes active. | |
| EffectiveStartDate | Date | False |
The date and time when the territory version becomes active. | |
| EligibleForQuotaFlag | Boolean | False |
Indicates whether the territory is going to change during a territory realignment. If the value is True, then the territory is unlikely to change during a major realignment and therefore a quota can be entered against the proposed definition. | |
| ForecastedByParentTerritoryFlag | Boolean | False |
Indicates if the forecast for the territory is made by its parent territory. | |
| ForecastParticipationCode | String | False |
The code for the forecast participation. The accepted values are: REVENUE, NONREVENUE, REVENUE_AND_NONREVENUE, and NON_FORECASTING. | |
| LatestVersionFlag | Boolean | False |
Indicates the latest active version of the territory. If the value is True, then the territory version is the latest active version of the territory. | |
| Name | String | False |
The name of the territory. | |
| OrganizationName | String | False |
The name of the organization to which the owner belongs. | |
| OwnerResourceId | Long | False |
The unique identifier of the owner resource. | |
| ParentTerritoryId | Long | False |
The unique identifier of the parent territory. | |
| PartnerId | Long | False |
The unique identifier of the partner associated with the territory. | |
| PartnerProgramId | Long | False |
The unique identifier of the partner program to which the partner is enrolled. | |
| ProgramName | String | False |
The name of the partner program to which the partner is enrolled. | |
| ReviseQuotaFlag | Boolean | False |
Indicates whether a submitted quota needs to be revised. | |
| RevisionDescription | String | False |
The description of the reason for revising the quota. | |
| RevisionReason | String | False |
The user-defined reason for revising the quota. | |
| SourceTerrId | Long | False |
The identifier of the territory from which the dimensions are inherited. | |
| SourceTerrLastUpdateDate | Datetime | False |
The date and time when the source territory was last updated. This attribute is related to the inheritance of dimensions by recipient territories from source territories. | |
| SourceTerrName | String | False |
The name of the territory from which the selected dimensions are inherited. | |
| SourceTerrVersionId | Long | False |
The unique identifier of the source territory version. | |
| StatusCode | String | False |
The code for the territory status. | |
| TerritoryId | Long | False |
The unique identifier of the territory. | |
| TerritoryLevel | Long | False |
The level of the territory in the territory hierarchy. | |
| TerritoryNumber | String | False |
The unique alternate identification number for the territory. | |
| TerrProposalId | Long | False |
The unique identifier of the territory proposal. | |
| TypeCode | String | False |
The code for the territory type. | |
| UpdateFlag | Boolean | False |
Indicates if the logged-in user can update the territory. | |
| UniqueTerritoryNumber | String | False |
The unique territory number of the territory. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String |
Input specifying the Finder type. |