OpportunityContacts
The opportunity contact resource is used to view, create, and update the contacts of an opportunity.The contact associated with the opportunity. You can specify a contact's role, affinity, and influence level on an opportunity. A single contact can be marked as primary.
Columns
| Name | Type | ReadOnly | References | Description |
| OptyConId [KEY] | Long | False |
This is the primary key of the opportunity contacts table. | |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber | |
| AffinityLvlCd | String | False |
The affinity of the opportunity contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task. | |
| Comments | String | False |
The textual comments about the contact on the current opportunity. | |
| ContactedFlg | String | False |
Indicates if the contact for this opportunity has been contacted. If the value is True, then the contact was contacted. The default value is False. | |
| ContactPointId | Long | False |
The unique identifier of the contact's contact point. | |
| CreatedBy | String | False |
The user who created the opportunity contact record. | |
| CreationDate | Datetime | False |
The date and time when the contact record was created. | |
| DoNotContactFlag | Boolean | False |
Indicates if the user can contact the person or not by phone, e-mail, or mail. If the value is True, then the user must not contact the person. The default is False. | |
| EmailAddress | String | False |
The e-mail address of the contact. | |
| FormattedAddress | String | False |
The formatted address of the contact. | |
| FormattedPhoneNumber | String | False |
The formatted phone number of the contact. | |
| InfluenceLvlCd | String | False |
The influence of the opportunity contact has on the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_INFLUENCE_LVL_CD. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task. | |
| JobTitle | String | False |
The free form text for job title of the opportunity contact. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The session login associated to the user who last updated the record. | |
| OptyId | Long | False |
The unique identifier of the opportunity. | |
| OrganizationPartyId | Long | False |
The unique identifier of the contact's organization. | |
| OrganizationPartyName | String | False |
The name of the contact's organization. | |
| OrgContactId | Long | False |
The unique identifier of the organization contact for the opportunity. | |
| PartyName | String | False |
The name of the contact for the opportunity. | |
| PartyUniqueName | String | False |
The unique contact name displayed on party related screens. The default value for Contacts is the concatenation of attributes ContactName and UniqueNameSuffix. The default value for Organizations is the concatenation of the unique name alias and UniqueNameSuffix. | |
| PERPartyId | Long | False |
The unique identifier of a valid employee resource who owns and manages the opportunity. | |
| PreferredContactMethod | String | False |
The preferred method to contact the person. A list of accepted values is defined in the lookup HZ_PREFERRED_CONTACT_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Point Lookups task. | |
| PrimaryFlg | String | False |
Indicates if the contact is the primary contact for the opportunity. If the value is True, then the contact is the primary contact fo the opportunity. The default value is False. | |
| RelationshipCode | String | False |
The code for a forward or a backward relationship. A list of accepted relationship values is defined in the lookup PARTY_RELATIONS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Relationship Lookups. | |
| RelationshipId | Long | False |
The identifier of the relationship for the opportunity contact. | |
| RoleCd | String | False |
The roles played by a contact in the opportunity. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task. | |
| SalesAffinityCode | String | False |
The affinity of a contact to the deploying organization. A list of accepted values are defined in the lookup HZ_SLS_CNTCT_AFFINITY_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task. | |
| SalesBuyingRoleCode | String | False |
The roles played by a contact in the buying process, for example, decision maker or supporting role. A list of accepted values is defined in the lookup HZ_SLS_CNTCT_BUY_ROLE_CODE. Review and update the values for this attribute using the Setup and Maintenance work area, Manage Contact Lookups task. | |
| SalesInfluenceLevelCode | String | False |
The contact's level of influence in the buying process for the current opportunity. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |