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	Opportunity
Handled by	Opportunity Service

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