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. |