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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |