ADO.NET Provider for Oracle Sales

Build 24.0.9060

OpportunityCompetitors

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.

Columns

Name Type ReadOnly References Description
OptyCompetitorId [KEY] Long False

This is the primary key of the opportunity competitors table.

OptyNumber [KEY] String False

Opportunities.OptyNumber

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.

OpportunityLastUpdateDate Datetime False

The date and time when the opportunity was last updated.

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.

PartyId String

Input specifying the Party Id.

PartyIdAttribute String

Input specifying the Party Id Attribute.

AttributeName String

Input specifying the Attribute Name.

RollUpId String

Input specifying the RollUp Id.

SourceObject String

Input specifying the Source Object.

SourceObjectId String

Input specifying the Source Object Id.

ClosePeriod String

Input specifying the Close Period.

ContactPartyId String

Input specifying the Contact Party Id.

EffectiveBeginDate String

Input specifying the Effective BeginDate.

EffectiveEndDate String

Input specifying the Effective EndDate.

LeadNumber String

Input specifying the Lead Number.

LookupCategory String

Input specifying the Lookup Category.

OpportunityContactName String

Input specifying the Opportunity Contact Name.

OptyStatusCode String

Input specifying the Opty StatusCode.

Partner String

Input specifying the Partner.

PartnerPartyId String

Input specifying the Partner Party Id.

Product String

Input specifying the Product.

ProductGroup String

Input specifying the Product Group.

ReferenceName String

Input specifying the Reference Name.

ResourcePartyId String

Input specifying the Resource Party Id.

TeamMember String

Input specifying the Team Member.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060