Opportunity Reference
The past customer who is being used as a reference on the opportunity.
QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}OpportunityReference
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 |
|---|---|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
Comments |
string |
The comments for the record. |
|
Comments1 |
string |
The comments for the opportunity reference. |
|
ConflictId |
long |
The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases. |
|
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. |
|
CustomerContactRelationId |
long |
The customer contact relationship identifier. |
|
DUNSNumberC |
string |
The nine-digit identification number that is assigned to business entities by Dun and Bradstreet. |
|
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. |
|
IntContactPartyId |
long |
The Party identifier of the internal contact for the opportunity reference. |
|
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. |
|
Name |
string |
The sales stage of the opportunity. |
|
Name1 |
string |
The name of 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. |
|
OptyId |
long |
The unique identifier of the opportunity. |
|
OptyReferenceId |
long |
The identifier of the opportunity's references.
|
|
PartyName |
string |
The name of the party. |
|
PartyName1 |
string |
The name of the party. |
|
PartyName2 |
string |
The name of the party. |
|
PartyNumber |
string |
The unique identification number for the party. |
|
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 |
This is the derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, this is concatenation of person_name and suffix. |
|
ReferencePartyId |
long |
The Party identifier with the reference party usage. |
|
ReferenceRankNumber |
string |
The ranking for this reference. |
|
RevnAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The revenue amount. |
|
RevnAmountCurcyCode |
string |
The currency on which the revenue line is based. |
|
SalesAccountId |
long |
The identifier of the opportunity sales account. |
|
SalesAccountUniqueName |
string |
The name of the sales account. |
|
StatusCode |
string |
The pre-defined code used to indicate the status. |
|
StgId |
long |
The sales stage of the opportunity. |
|
TargetPartyId |
long |
The Party identifier of the opportunity sales account. |
|
TargetPartyName |
string |
The name of the opportunity sales account. |
|
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 percent. |