Opportunity
The opportunity object allows employees to identify and record a potential revenue-generating event that has arisen with an account or contact. Opportunities can be generated from marketing campaigns when leads indicate that they are interested in a product or service that has been offered.
Parent Objects
Child Components
Activity, Attachment, Book, Competitor, Contact, Lead, Note, and Opportunity Team.
For information about using attachments with this object, see Using Attachments with Web Services On Demand.
Methods Called
The following table details the methods called by the Opportunity service.
Method | Name as Defined in Service |
---|---|
OpportunityDelete |
|
OpportunityDeleteChild |
|
OpportunityInsert |
|
OpportunityInsertChild |
|
OpportunityInsertOrUpdate |
|
OpportunityQueryPage |
|
OpportunityUpdate |
|
OpportunityUpdateChild |
Fields
The following table details the required and read-only fields for the opportunity object.
Child Component | Field Name | Type |
---|---|---|
Opportunity (parent) |
AccountId |
Required |
CloseDate |
Required |
|
OpportunityName |
Required |
|
SalesStage |
Required |
|
Read-only |
||
LastUpdated |
Read-only |
|
OpportunityConcatField |
Read-only |
|
Activity |
AccountLocation |
Read-only |
CreatedDetail |
Read-only |
|
MEEventName |
Read-only |
|
Opportunity |
Read-only |
|
OpportunityIntegrationId |
Read-only |
|
OpportunityExternalId |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
DescriptionShadow |
Read-only |
|
Duration |
Read-only |
|
Read-only |
||
Attachment |
DisplayFileName |
Required |
FileNameOrURL |
Required |
|
FileDate |
Read-only |
|
FileSize |
Read-only |
|
OpportunityId |
Read-only |
|
Id |
Read-only |
|
ModId |
Read-only |
|
Read-only |
||
Book |
BookName |
Required |
BookId |
Read-only |
|
SystemAssociateFlag |
Read-only |
|
ModId |
Read-only |
|
Read-only |
||
Competitor |
CompetitorId |
Required |
CompetitorExternalSystemId |
Required |
|
ReverseRelationshipRole |
Required |
|
RelationshipRole |
Required |
|
StartDate |
Required |
|
OpportunityCompetitorId |
Read-only |
|
Contact |
Age |
Read-only |
OwnerFullName |
Read-only |
|
CreatedbyEmailAddress |
Read-only |
|
ModifiedbyEmailAddress |
Read-only |
|
LastActivityDate |
Read-only |
|
FirstNameShadow |
Read-only |
|
LastNameShadow |
Read-only |
|
OpportunityTeam |
OpportunityAccess |
Required |
UserId |
Required |
|
Partner |
OpportunityPartnerId |
Read-only |
PartnerExternalSystemId |
Required |
|
ReverseRelationshipRole |
Required |
|
RelationshipRole |
Required |
|
StartDate |
Required |
|
Product |
ProductRevenueId |
Read-only |
ProductCategoryId |
Read-only |
|
ProductCategory |
Read-only |
|
ProductPartNumber |
Read-only |
|
ProductStatus |
Read-only |
|
ProductType |
Read-only |
|
OpportunityId |
Read-only |
|
OpportunityName |
Read-only |
|
OpportunityIntegrationID |
Read-only |
|
OpportunityExternalSystemId |
Read-only |
|
OpportunitySalesStage |
Read-only |
|
OpportunityAccountId |
Read-only |
|
OpportunityAccountName |
Read-only |
|
OpportunityAccountLocation |
Read-only |
|
OpportunityAccountExternalSystemId |
Read-only |
|
OpportunityAccountIntegrationId |
Read-only |
|
ContactFirstName |
Read-only |
|
ContactLastName |
Read-only |
The following table details the status key for the opportunity object.
Child Component | Field Name |
---|---|
Opportunity (parent) |
|
AccountId |
|
ExternalSystemId |
|
Id |
|
IntegrationId |
|
Activity |
|
ExternalSystemId |
|
Id |
|
IntegrationId |
|
OpportunityId |
|
Attachment |
|
Id |
|
OpportunityId |
|
Book |
|
BookId |
|
ModId |
|
Competitor |
|
OpportunityCompetitorId |
|
CompetitorId |
|
CompetitorExternalSystemId |
|
Contact |
|
AccountId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
OpportunityId |
|
Lead |
|
AccountId |
|
ContactId |
|
ExternalSystemId |
|
IntegrationId |
|
LastUpdated |
|
LeadId |
|
OpportunityId |
|
OpportunityNote |
|
ExternalSystemId |
|
Id |
|
IntegrationId |
|
OpportunityId |
|
Partner |
|
OpportunityPartnerId |
|
PartnerId |
|
PartnerExternalSystemId |
|
Product |
|
ExternalId |
|
ProductRevenueId |
|
IntegrationID |
The following table details the pick map fields for the opportunity object.
Child Component | Pick Map Field | Maps To |
---|---|---|
Opportunity (parent) |
Owner |
OwnerId |
AccountExternalSystemId |
AccountId |
|
Territory |
TerritoryId |
|
KeyContactIntegrationId |
KeyContactId |
|
KeyContactExternalSystemId |
KeyContactId |
|
Activity |
AccountIntegrationId |
AccountId |
AccountExternalId |
AccountId |
|
Address |
AddressId |
|
AssignedTo |
AssignedToId |
|
CampaignExternalId |
CampaignId |
|
CampaignIntegrationId |
CampaignId |
|
Dealer |
DealerId |
|
DelegatedBy |
DelegatedById |
|
FundRequest |
FundRequestId |
|
OpportunityIntegrationId |
OpportunityId |
|
OpportunityExternalId |
OpportunityId |
|
PrimaryContactIntegrationId |
PrimaryContactId |
|
PrimaryContactExternalId |
PrimaryContactId |
|
LeadIntegrationId |
LeadId |
|
LeadExternalId |
LeadId |
|
OwnerExternalId |
OwnerId |
|
OwnerIntegrationId |
OwnerId |
|
SRIntegrationId |
SRId |
|
SRExternalId |
SRId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
|
Book |
BookName |
BookId |
Contact |
AccountExternalSystemlId |
AccountId |
AccountIntegrationId |
AccountId |
|
ManagerExternalSystemId |
ManagerId |
|
ManagerIntegrationId |
ManagerId |
|
OwnerEmailAddress |
OwnerId |
|
OwnerExternalId |
OwnerId |
|
OwnerIntegrationId |
OwnerId |
|
SourceCampaignName |
SourceCampaignId |
|
SourceCampaignExternalId |
SourceCampaignId |
|
TimeZoneName |
TimeZoneId |
|
CustomObject1Name |
CustomObject1Id |
|
CustomObject2Name |
CustomObject2Id |
|
CustomObject3Name |
CustomObject3Id |
|
Competitor |
PrimaryContactName |
ContactId |
PartnerExternalSystemId |
PartnerId |
|
PartnerName |
PartnerId |
|
Partner |
PrimaryContactName |
ContactId |
CompetitorExternalSystemId |
CompetitorId |
|
CompetitorName |
CompetitorId |
|
Product |
ProductName |
ProductId |
ProductExternalSystemId |
ProductId |
|
ProductIntegrationId |
ProductId |
|
ContactExternalSystemId |
ContactId |
|
ContactIntegrationId |
ContactId |
|
Owner |
OwnerId |
|
CustomObject5Name |
CustomObject5Id |
|
CustomObject5ExternalSystemId |
CustomObject5Id |
|
CustomObject6Name |
CustomObject6Id |
|
CustomObject6ExternalSystemId |
CustomObject6Id |
The following table provides a list of the filterable fields for the child components of the opportunity objects, and a list of user key combinations for each child component.
Child Components | Filterable Fields | User Key Field Combinations |
---|---|---|
Opportunity (parent) |
All |
OpportunityId |
IntegrationId |
||
ExternalSystemId |
||
Activity |
Type |
Type and Description |
Owner |
IntegrationId |
|
Subject |
ExternalSystemId |
|
DueDate |
||
Priority |
||
Status |
||
Attachment |
None |
Id |
ExternalSystemId |
||
FileNameOrURL and FileExtension |
||
Book |
None |
BookId |
BookName |
||
Competitor |
OpportunityCompetitorId |
OpportunityCompetitorId |
PrimaryContactId |
CompetitorExternalSystemId |
|
EndDate |
CompetitorId |
|
CompetitorId |
||
CompetitorExternalSystemId |
||
ReverseRelationshipRole |
||
RelationshipRole |
||
StartDate |
||
ModifiedDate |
||
Contact |
ContactType |
AccountName and Private |
ContactFirstName |
ContactFirstName and ContactLastName and Private |
|
JobTitle |
IntegrationId |
|
ContactLastName |
ExternalSystemId |
|
Owner |
||
Id |
||
Lead |
Campaign |
IntegrationId |
EstimatedCloseDate |
ExternalSystemId |
|
Rating |
||
Source |
||
Status |
||
LeadOwner |
||
PotentialRevenue |
||
ProductInterest |
||
SalesPerson |
||
LeadId |
||
Note |
Subject |
Subject and Description |
IntegrationId |
||
ExternalSystemId |
||
OpportunityTeam |
UserFirstName |
OpportunityTeamId |
UserLastName |
UserId |
|
ModifiedDate |
UserExternalSystemId |
|
OpportunityAccess |
UserEmail |
|
OpportunityAccessId |
UserAlias |
|
OpportunityTeamId |
||
TeamRole |
||
UserExternalSystemId |
||
UserId |
||
Partner |
OpportunityPartnerId |
OpportunityPartnerId |
PrimaryContactId |
PartnerExternalSystemId |
|
EndDate |
PartnerId |
|
PartnerId |
||
PartnerExternalSystemId |
||
ReverseRelationshipRole |
||
RelationshipRole |
||
StartDate |
||
ModifiedDate |
||
Product |
OpportunityIntegrationId |
ExternalSystemId |
OpportunityExternalSystemId |
OpportunityIntegrationId |
|
OpportunitySalesStage |
ProductRevenueId |
|
OpportunityAccountId |
IntegrationId |
|
OpportunityAccountName |
||
OpportunityAccountLocation |
||
OpportunityAccountExternalSystemId |
||
OpportunityAccountIntegrationId |
||
ModifiedDate |
||
ContactId |
||
ContactExternalSystemId |
||
ContactIntegrationId |
||
Contract |
||
OwnerId |
||
Owner |
||
SerialNumber |
||
Revenue |
||
ExpectedRevenue |
||
Quantity |
||
PurchasePrice |
||
PurchaseDate |
||
StartCloseDate |
||
NumberOfPeriods |
||
Frequency |
||
Probability |
||
Forecast |
||
AssetValue |
||
Premium |
||
ShipDate |
||
Status |
||
Type |
||
Warranty |
||
ProductRevenueId |
||
ExternalSystemId |
||
IntegrationId |
||
ProductId |
||
ProductName |
||
ProductExternalSystemID |
||
ProductionIntegrationId |
||
ProductCategoryId |
||
ProductCategory |
||
ProductPartNumber |
||
ProductStatus |
||
ProductType |
||
OpportunityId |
||
OpportunityName |
The following table details the picklists available for the opportunity object.
Child Component | Field Name |
---|---|
Opportunity (parent) |
LeadSource |
Priority |
|
Probability |
|
ReasonWonLost |
|
Status |
|
Type |
|
Year |
|
Make |
|
Model |
|
OpportunityTeam |
TeamRole |
Product |
Frequency |
Probability |
|
Status |
|
Type |
|
Warranty |
|
Contract |
For more information on the fields accessible through the Opportunity Web service, go to the Web Services Administration page within the Oracle CRM On Demand application, and generate the WSDL file for the opportunity object.