TDV Adapter for Oracle Sales

Build 22.0.8462

OpportunityRevenueTerritories

The opportunity revenue territories resource is used to view, create, and update the revenue territories of an opportunity. The territories assigned to an opportunity revenue line. The territories provide the rules for automatically assigning salespeople and other resources to customers, partners, leads, and opportunity line items.

Columns

Name Type ReadOnly References Description
RevnTerrId [KEY] String False

This is the primary key of the revenue territories table.

RevnId Long False

OptyNumber String False

AssignmentType String False

The type of assignment used to assign the territory to the opportunity.

CreatedBy String False

The user who created the revenue territory record.

CreationDate Datetime False

The date when the record was created.

EffectiveEndDate Datetime False

The date when the resource organization assignment to the territory ends.

EffectiveStartDate Datetime False

The date when the resource organization for the territory was assigned to the revenue line.

ForecastParticipationCode String False

The code to identify the forecast type that the territory participates in. For example, Revenue, Nonrevenue, Revenue and Nonrevenue, or Nonforecasting.

LastUpdateDate Datetime False

The date when the record was last updated.

LastUpdatedBy String False

The user who last updated the record.

LastUpdateLogin String False

The login of the user who last updated the record.

Name String False

The name of the territory that the opportunity belongs to.

Name1 String False

The name of the organization that the territory resource belongs to.

PartyId Long False

The unique identifier of the resource who owns the territory.

PartyName String False

The name of the territory owner for the opportunity.

RoleId Long False

The unique identifier of the resource's role.

RoleName String False

The name of the resource's role.

TerritoryId Long False

Territory identifier.

TerritoryVersionId Long False

Territory version identifier.

TypeCode String False

The type of territory assigned to the opportunity.

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
RecordSet String

Input specifying the resource type.

Finder String

Input specifying the Finder type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462