ODBC Driver for Oracle Sales

Build 21.0.7930


The opportunity competitor resource is used to view, create, and update the competitors for an opportunity. The opportunity competitors is used to store information about the competitors associated with the opportunity.


Name Type ReadOnly References Description
OptyCompetitorId [KEY] Long False

This is the primary key of the opportunity competitors table.

OptyNumber [KEY] String False


CmptPartyId Long False

The unique identifier for the competitor party.

Comments String False

The user-provided comments about the opportunity's competitor.

CreatedBy String False

The user who created the record.

CreationDate Datetime False

The date and time when the contact record was created.

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 session login associated to the user who last updated the record.

Name String False

The name of the opportunity.

OptyId Long False

The unique identifier for the opportunity.

PartyName String False

The name of the party.

PrimaryFlg String False

Indicates if the competitor is the primary competitor for the opportunity. If True, then the competitor is the primary competitor. The default value is False.

ThreatLevelCode String False

The level of threat or risk from the competitor. The list of valid values are Low, Medium and High. A list of accepted values are defined in the lookup Competitor Threat Level. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Trading Community Common Lookups task.


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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930