Excel Add-In for Oracle Sales

Build 24.0.9060

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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060