TerritoryResources

The resources resource is used to view the resources, such as owner or sales people associated with a sales territory.

Columns


Name	Type	ReadOnly	References	Description
TerrResourceId [KEY]	Long	False		Identifier of the resource.
TerritoryVersionId [KEY]	String	True	Territories.TerritoryVersionId	TerritoryVersionId
AdministratorFlag	Bool	False		Indicates that the resource is an administrator in the given territory.
CreatedBy	String	True		CreatedBy
CreationDate	Datetime	True		CreationDate
Email	String	True		Email
FunctionCode	String	False		Stores the function of the resource in the Territory.
LastUpdateDate	Datetime	True		LastUpdateDate
LastUpdateLogin	String	True		LastUpdateLogin
LastUpdatedBy	String	True		LastUpdatedBy
ManageForecastFlag	Bool	False		Indicates that a Territory Resource has been given the responsibility to manage the corresponding Territory Forecast on behalf of the owner of the Territory.
Manager	String	True		Name of the Manager.
OrganizationName	String	True		Name of the Organization.
OwnerFlag	Bool	True		OwnerFlag
ResourceId	Long	False		Identifier of the resource from resource manager ie. party model.
ResourceName	String	True		Name of the resource.
ResourceNumber	String	False		ResourceNumber
RoleName	String	True		Role associated to the resource.
UniqueTerritoryNumber	String	False		UniqueTerritoryNumber

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.

JDBC Driver for Oracle Sales

TerritoryResources

Columns

Pseudo-Columns