Opportunity Contact
The contact associated with the opportunity who is involved in the purchase.
QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}OpportunityContact
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 |
---|---|---|
AffinityLvlCd |
string |
The affinity level for an opportunity contact. Valid values from the HZ_SLS_CNTCT_AFFINITY_CODE lookup type. |
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. |
ContactPartyNumber |
string |
The party number of the opportunity contact. |
ContactPointId |
long |
The unique primary key identifier for the contact point. |
ContactPointId1 |
long |
The unique identifier for a contact point. |
ContactPointType |
string |
The type of the contact point. |
ContactPointType1 |
string |
The type of the contact point. For example, phone, e-mail, and so on. |
ContactedFlg |
string |
Indicates if there was a previous communication with the contact regarding this opportunity. |
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. |
DoNotContactFlag |
boolean |
Indicates whether the contact can be contacted through phone, e-mail, and mail. |
EmailAddress |
string |
The email address associated with the record. |
EmailPreferenceExistsFlag |
boolean |
Indicates if the contact has specified an email preference. |
FormattedAddress |
string |
The formatted address of the opportunity contact. |
FormattedMultilineAddress |
string |
The formatted multi-line address for the opportunity contact. |
FormattedPhoneNumber |
string |
The formatted phone number. |
InfluenceLvlCd |
string |
The influence level of the opportunity contact. Valid values from the HZ_SLS_CNTCT_INFLUENCE_LVL_CD lookup type. |
JobTitle |
string |
The job title of the opportunity contact. |
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. |
LocationId |
long |
The identifier of the location. It is the foreign key to the HZ_LOCATIONS table. |
ObjectId |
long |
The identifier of the object in the contact's relationship record. |
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. |
OptyConId |
long |
The identifier of the opportunity contact.
|
OptyId |
long |
The unique identifier of the opportunity. |
OrgContactId |
long |
The identifier of the organization contact. |
OrganizationPartyId |
long |
The party identifier of the contact's organization. |
OrganizationPartyName |
string |
The name of the contact's organization. |
PERPartyId |
long |
The party identifier of the opportunity contact. |
PartyId |
long |
The unique identifier of the contact party. |
PartyName |
string |
The name of the party. |
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. |
PersonCentricJobTitle |
string |
The job title of the contact person. |
PhonePreferenceExistsFlag |
boolean |
Indicates if the contact has specified a phone preference. |
PreferredContactMethod |
string |
The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD. |
PrimaryFlg |
string |
Indicates whether the contact is the primary contact for the opportunity. |
RawPhoneNumber |
string |
Unformatted telephone number. |
RelationshipCode |
string |
Forward or a backward relationship code that describes the contact's relationship record. |
RelationshipId |
long |
The relationship identifier for the record. |
RelationshipRecId |
long |
The identifier of the contact's relationship record. |
RoleCd |
string |
Role played by contact on the opportunity. Valid values from the HZ_SLS_CNTCT_BUY_ROLE_CODE lookup type. |
SalesAffinityCode |
string |
Contact's affinity towards the deploying organization. |
SalesBuyingRoleCode |
string |
Contact's role in the buying process. |
SalesInfluenceLevelCode |
string |
Contact's level of influence in the buying process. |
SubjectId |
long |
The identifier of the subject in the contact's relationship record. |
TargetPartyId |
long |
The Party identifier 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. |