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.
OpportunityLastUpdateDate	Datetime	False		The date and time when the opportunity was last updated.

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.
PartyId	String	Input specifying the Party Id.
PartyIdAttribute	String	Input specifying the Party Id Attribute.
AttributeName	String	Input specifying the Attribute Name.
RollUpId	String	Input specifying the RollUp Id.
SourceObject	String	Input specifying the Source Object.
SourceObjectId	String	Input specifying the Source Object Id.
ClosePeriod	String	Input specifying the Close Period.
ContactPartyId	String	Input specifying the Contact Party Id.
EffectiveBeginDate	String	Input specifying the Effective BeginDate.
EffectiveEndDate	String	Input specifying the Effective EndDate.
LeadNumber	String	Input specifying the Lead Number.
LookupCategory	String	Input specifying the Lookup Category.
OpportunityContactName	String	Input specifying the Opportunity Contact Name.
OptyStatusCode	String	Input specifying the Opty StatusCode.
Partner	String	Input specifying the Partner.
PartnerPartyId	String	Input specifying the Partner Party Id.
Product	String	Input specifying the Product.
ProductGroup	String	Input specifying the Product Group.
ReferenceName	String	Input specifying the Reference Name.
ResourcePartyId	String	Input specifying the Resource Party Id.
TeamMember	String	Input specifying the Team Member.
Name	String	Input specifying the Name.

SSIS Components for Oracle Sales

OpportunityContacts

Columns

Pseudo-Columns