Opportunity Revenue Territory

The territories assigned to an opportunity revenue line.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/}RevenueTerritory

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contained by

Opportunity

Contained by

Opportunity Revenue

Handled by

Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AssignmentType

string

Identifies how the territory resource was assigned.

ConflictId

long

The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

EffectiveEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the end of the date range within which the row is effective.
  • Primary Key

EffectiveStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the beginning of the date range within which the row is effective.
  • Primary Key

ForecastParticipationCode

string

The type of forecast this territory participates in (Revenue, Nonrevenue, Revenue and Nonrevenue, or Nonforecasting).

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

Name

string

The name of the territory.

Name1

string

The resource organization of the territory resource.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

RevnId

long

Revenue identifier.

RevnTerrId

long

Revenue territory identifier.
  • Primary Key

RoleId

long

Resource role identifier of the territory resource.

RoleName

string

Resource role of the territory resource.

TerritoryId

long

The Territory identifier.

TerritoryVersionId

long

The Territory version identifier.

TypeCode

string

Identifies the type of the assigned territory.

UserLastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the row was last updated.