Opportunity Competitor

The organization that competes with the deploying organization in the sales opportunity.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}OpportunityCompetitor

Logical Business Objects

  • CRM : Opportunity Management : Opportunity

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

Handled by

Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AnnualRevenueAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The competitor company's annual revenue.

CmptPartyId

long

Party ID with competitor party usage.

Comments

string

The comments for the record.

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.

EffectiveDate

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

The estimated close date for the opportunity.

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 opportunity.

Name1

string

The name of the opportunity.

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.

ObjectVersionNumber1

int

The attribute is used to implement optimistic 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 detect whether another session has updated the row since it was last queried.

ObjectVersionNumber2

int

The attribute is used to implement optimistic 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 detect whether another session has updated the row since it was queried.

OptyCompetitorId

long

The identifier of the opportunity's competitor.
  • Primary Key

OptyId

long

The unique identifier of the opportunity.

PartyName

string

The name of the party.

PartyName1

string

The name of the party.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PartyUniqueName1

string

The unique name of the opportunity competitor.

PrimaryContactPartyName

string

The attribute for the name of primary contact.

PrimaryFlg

string

The flag identifying the primary competitor for the opportunity.

RevnAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The revenue amount.

RevnAmountCurcyCode

string

The currency that the amount on this revenue line is based on.

SalesAccountId

long

The identifier of the opportunity sales account.

SalesAccountUniqueName

string

The name of the sales account.

StgId

long

The current sales stage identifier for opportunity.

ThreatLevelCode

string

Threat level code. Out of the box values are Low, Medium and High. This field refers to the ZBS lookup type for Competitor Threat Level.

WinProb

decimal

The win-probability percentage.