Power BI Connector for Oracle Sales Cloud

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654