OpportunityCompetitor
Stores details of competitors associated with an opportunity, helping track competitive insights.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
Unique identifier of the opportunity competitor record. | |
| OpportunityId | String | False |
Opportunity.Id |
Reference to the opportunity associated with this competitor. |
| CompetitorName | String | False |
Name of the competing company or product. | |
| Strengths | String | False |
Identified strengths of the competitor relevant to the opportunity. | |
| Weaknesses | String | False |
Identified weaknesses of the competitor relevant to the opportunity. | |
| CreatedById | String | True |
User.Id |
ID of the user who created the opportunity competitor record. |
| CreatedDate | Datetime | True |
Date and time when the opportunity competitor record was created. | |
| LastModifiedById | String | True |
User.Id |
ID of the user who last modified the opportunity competitor record. |
| IsDeleted | Bool | True |
Indicates whether the opportunity competitor record has been deleted. | |
| SystemModstamp | Datetime | True |
System-generated timestamp for the last modification of the record. | |
| LastModifiedDate | Datetime | True |
Date and time when the opportunity competitor record was last modified. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| SOQL | String |
Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query. |
| ExternalIdColumn | String |
Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called. |
| FilterScope | String |
Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team. |