Opportunity
The object used by a sales organization to track information about a potential sale such as the sales account, key contacts, product interests, and potential revenues.
QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}Opportunity
Logical Business Objects
-
CRM : Opportunity Management : Opportunity
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccountNumber |
string |
The account number of the opportunity sales account. |
Appointment |
The appointments associated with the opportunity. |
|
AssetId |
long |
Identifier of the asset of the opportunity. |
AssetNumber |
string |
Asset number of the asset of the opportunity. |
AssetProduct |
string |
The associated Asset's Product name |
AssetSerialNumber |
string |
The associated Asset's Serial number |
AverageDaysAtStage |
long |
The average days an opportunity remains in the current sales stage. |
BdgtAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The budget amount from the sales account. |
BudgetAvailableDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the budget will be available. |
BudgetedFlag |
boolean |
The attribute that indicates if the opportunity sales account has its budget approved for the potential purchase. |
CategorySummaryRevenue |
The category summary revenue for revenue line set enabled opportunity. |
|
ChampionFlag |
boolean |
The attribute that indicates if this opportunity has a key internal sponsor. |
ChildRevenue |
The revenue items on the opportunity. |
|
City |
string |
The name of the city. |
Comments |
string |
The comments for the record. |
ConflictId |
long |
The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases. |
ConsumerFirstName |
string |
The First Name of the Target Party for the opportunity. |
ConsumerLastName |
string |
The Last Name of the Target Party for the opportunity. |
Country |
string |
The name of the country. |
CreatedBy |
string |
The user who created the record. |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
CrmConversionRate |
decimal |
The rate is used for the conversion of the revenue amount to the CRM common currency to facilitate the computation of the revenue forecast metrics. This is the amount that one currency can be exchanged for, at a specific point of time. |
CrmRevenue |
decimal |
The opportunity revenue amount converted to the corporate currency. |
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
CurrentFyPotentialRevenue |
decimal |
Do not use this attribute. |
CustomerAccountId |
long |
The customer account associated with the opportunity. |
DUNSNumber |
string |
The D-U-N-S number of the sales account. |
DealHorizonCode |
string |
The attribute that indicates how long it may take to close the deal. This field refers to the lookup type MOO_SETID_DEAL_HORIZION. |
DealHorizonCodeSetId |
long |
The set identifier for the Deal Horizon of this opportunity. |
DecisionLevelCode |
string |
The attribute that indicates the decision level at the opportunity sales account to commit. This field refers to the lookup type MOO_SETID_DECISION_LEVEL. |
DecisionLevelCodeSetId |
long |
The set identifier for the Decision Level of this opportunity. |
DeleteFlag |
boolean |
Indicates whether the record can be deleted or not. |
Description |
string |
The free text description of the record. |
DescriptionText |
string |
The attribute for sales objective of the opportunity. |
DownsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The worst case amount. |
EffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The estimated close date for the opportunity. |
EmailAddress |
string |
The email address associated with the record. |
EmployeesTotal |
decimal |
The total number of employees. |
ExpectAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The expected revenue amount. |
FormattedAddress |
string |
Do not use this attribute. |
IBAssetId |
long |
Identifier of the installed base asset of the opportunity. |
IBAssetNumber |
string |
Asset number of the installed base asset of the opportunity. |
IBAssetSerialNumber |
string |
The associated installed base Asset's Serial number |
KeyContactId |
long |
The identifier of the primary contact. |
LastAssignedDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the opportunity is last assigned. |
LastAssignedTimestamp |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The timestamp when the opportunity is last assigned. |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
LastUpdateLogin |
string |
The login of the user who last updated the record. |
LastUpdatedBy |
string |
The user who last updated the record. |
LineOfBusinessCode |
string |
The line of business that is responsible for the opportunity. |
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table. |
LookupCategory |
string |
The status category of the opportunity. |
LookupValuesId |
long |
The attribute for lookup value identifier for the opportunity status. |
MaximumDaysInStage |
long |
The attribute for maximum days the opportunity can be in the sales stage prior to considering it stalled. |
Name |
string |
The name of the opportunity. |
Note |
The notes associated with the opportunity. |
|
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
ObjectVersionNumber1 |
int |
The attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was last queried. |
OpportunityCompetitor2 |
The attribute containing all competitors associated with the opportunity, including both primary and non-primary competitors. |
|
OpportunityCompetitor3 |
The non-primary competitors associated with the opportunity. |
|
OpportunityContact |
The contacts associated with the opportunity. |
|
OpportunityDeal |
The deal registrations associated to the opportunity. |
|
OpportunityLead |
The attribute for leads associated to the opportunity. |
|
OpportunityReference |
The references associated with the opportunity. |
|
OpportunityResource |
The resources on the opportunity team. |
|
OpportunityResponse |
The attribute for marketing responses associated with the opportunity. |
|
OpportunitySource1 |
The attribute for marketing sources associated to the opportunity. |
|
OpportunitySubscription |
Opportunity Subscription aggregates all revenue subscriptions to opportunity level. |
|
OpportunityTypeCode |
string |
Display the different types of opportunity such as new, renewal and expansion. |
OptyCreatedBy |
string |
The attribute that replicates WHO column CREATED_BY for functional use. |
OptyCreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The attribute that replicates WHO column creation_date for functional use. |
OptyId |
long |
The unique identifier of the opportunity.
|
OptyLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The attribute that replicates WHO column last_update_date for functional use. |
OptyLastUpdatedBy |
string |
The attribute that replicates WHO column last_updated_by for functional use. |
OptyNumber |
string |
The number of the opportunity. |
OwnerResourcePartyId |
long |
The identifier of the opportunity owner. |
PartyName |
string |
The name of the party. |
PartyName1 |
string |
The name of the opportunity owner. |
PartyType |
string |
The party type of the contact. The party type can only be Person, Organization, or Group. |
PartyUniqueName |
string |
This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix. |
PartyUniqueName1 |
string |
The unique name of the primary opportunity competitor. |
PhaseCd |
string |
The phase of the opportunity sales stage. |
PhonePreferenceExistsFlag |
boolean |
The attribute that indicates if the contact has specified a phone preference. |
PostalCode |
string |
The postal code element of the address. |
PrConRelationshipId |
long |
The relationship identifier of the primary contact on the opportunity. |
PrSrcNumber |
string |
The primary marketing source or campaign that generated this opportunity. |
PreferredFunctionalCurrency |
string |
The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES. |
PrimaryCompetitorId |
long |
The identifier of the primary competitor of this opportunity. |
PrimaryContactEmailAddress |
string |
The e-mail address of the primary contact. |
PrimaryContactFirstName |
string |
The first name of the primary contact for the opportunity. |
PrimaryContactFormattedPhoneNumber |
string |
The formatted phone number for the primary contact on the opportunity. |
PrimaryContactLastName |
string |
The last name of the primary contact for the opportunity. |
PrimaryContactPartyId |
long |
The party identifier of the primary contact. |
PrimaryContactPartyName |
string |
The name of the primary contact. |
PrimaryOrganizationId |
long |
The identifier of the business unit to which this opportunity belongs. |
PrimaryOrganizationName |
string |
The name of the business unit to which this opportunity belongs. |
PrimaryPartnerId |
long |
The party identifier of primary partner. |
PrimaryPartnerOrgPartyName |
string |
The attribute for name of primary partner assigned to the opportunity. |
PrimaryRevenueId |
long |
The identifier for the summary revenue line for the opportunity. The summary revenue line stores the total revenue amount of an opportunity. |
PrimarySubscriptionId |
long |
The unique identifier for the primary subscription of an opportunity. |
PrimarySubscriptionNumber |
string |
The alternate identifier for primary subscription of the opportunity. |
QuotaFactor |
decimal |
The quote factor of the opportunity sales stage. |
QuotedFlag |
boolean |
Indicates that a quote has been created for this Opportunity. |
RcmndWinProb |
decimal |
The recommended win probability for an opportunity in the sales stage. |
ReasonWonLostCode |
string |
The win or loss reason for the opportunity. Valid values from the MOO_SETID_WIN_LOSS_REASON lookup type. |
ReasonWonLostCodeSetId |
long |
The set identifier for the win or loss reason for the opportunity. |
RecurringRevenue |
The revenues that span over a period of time and are sourced from the same product on the opportunity. |
|
Registered |
string |
The attribute that indicates the deal registration status. |
RegistrationStatus |
string |
The registration type used for the partner-created opportunity or deal. |
RegistrationType |
string |
The registration type used for the partner-created opportunity or deal. |
RenewalProcess |
string |
The renewal process can be manual, do not renew or automatic renewal. |
Revenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The attribute for revenue amount. |
RevenueLineSet |
The revenue line set associated with the opportunity. |
|
RevenuePartnerPrimary |
The partners associated to the opportunity. |
|
RevenueTerritory |
The territories assigned to the opportunity. |
|
RevenueType |
string |
Do not use this attribute. |
RevnId |
long |
The attribute for revenue identifier. |
RevnLineSetEnabledFlag |
boolean |
The attribute that indicates whether the sales method on the opportunity is revenue line set enabled. |
RiskLevelCode |
string |
The attribute that indicates the risk level for the opportunity. This field refers to the lookup type MOO_SETID_RISK_LEVEL. |
RiskLevelCodeSetId |
long |
The set identifier for risk-level of an opportunity. |
SalesAccountId |
long |
The identifier of the opportunity sales account. |
SalesAccountUniqueName |
string |
The name of the sales account. |
SalesChannelCd |
string |
The attribute that indicates the sales channel for the opportunity. |
SalesMethod |
string |
The attribute for sales method of the opportunity. |
SalesMethodEOObjVerNumber |
int |
The object version number of the sales method associated to the opportunity. |
SalesMethodId |
long |
The sales method identifier for this opportunity. This indicates the sales process used. |
SalesStage |
string |
The sales stage of the opportunity. |
SalesStageEOObjVerNumber |
int |
The object version number of the sales stage associated to the opportunity. |
SalesStageId |
long |
The identifier of the sales stage of the opportunity. |
SplitRevenue |
The revenue or nonrevenue credit allocated to resources who have contributed to the selling effort for the opportunity. |
|
StageStatusCd |
string |
The default status for the opportunity sales stage. |
State |
string |
The name of the state. |
StatusCode |
string |
The pre-defined code used to indicate the status. |
StatusCodeSetId |
long |
The set identifier for the Status of this opportunity. |
StgOrder |
decimal |
The order of the opportunity's sales stage within the sales method. |
StrategicLevelCode |
string |
The attribute that indicates the level of the strategic value to work with the opportunity sales account. This field refers to the lookup type MOO_SETID_STRATEGIC_VALUE. |
StrategicLevelCodeSetId |
long |
The set identifier for strategic value of an opportunity. |
TargetPartyId |
long |
The party identifier of the opportunity sales account. |
TargetPartyName |
string |
The name of the sales account. |
TargetPartyPrimaryAddressCountry |
string |
Country of the primary account's primary address. |
UpdateFlag |
boolean |
This flag controls if the user has access to update the record. |
UpsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The best case amount. |
UserLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the row was last updated. |
WinProb |
decimal |
The win-probability percentage. |