SSIS Components for Oracle Sales Cloud

Build 20.0.7656

OpportunityPartners

The opportunity partner resource is used to view, create, and update the partners associated with this opportunity.The opportunity partner is used to store information about partners who are contributing to the selling effort of the current opportunity.

Columns

Name Type ReadOnly References Description
RevnPartOrgPartyId [KEY] Long False

This is the primary key of the opportunity partners table.

OptyNumber [KEY] String False

Opportunities.OptyNumber

CreatedBy String False

The user who created the record.

CreationDate Datetime False

The date and time when the contact record was created.

DealEstCloseDate Datetime False

The date when the deal registration is estimated to close.

DealExpirationDate Datetime False

The date when the deal registration will expire.

DealType String False

The type of deal registration.

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.

PartOrgEmailAddress String False

The email address of the primary partner organization for this revenue.

PartOrgFormattedPhoneNumber String False

The phone number of the primary partner organization for this revenue.

PartOrgPartyId Long False

The unique identifier of the partner organization associated with the revenue.

PartProgramId Long False

The unique identifier of the partner program associated with the revenue.

PartTypeCd String False

The type of the party associated with the summary or primary revenue of the opportunity.

PartyId Long False

The unique identifier of the partner party is associated with the opportunity.

PartyName String False

The name of the partner associated with the opportunity.

PartyName1 String False

The name of the primary partner resource associated with the opportunity.

PreferredContactEmail String False

The e-mail address of the partner's primary contact.

PreferredContactName String False

The name of the partner's primary contact.

PreferredContactPhone String False

The phone number of the partner's primary contact.

PrPartResourcePartyId Long False

The unique identifier of the primary partner resource.

RegistrationNumber String False

The registration number of the deal registration.

RegistrationStatus String False

The registration status of the partner who create the opportunity or deal.

RevnId Long False

The unique identifier of the summary or primary revenue for the opportunity.

RevnPartnerNumber String False

The unique number of the associated between the opportunity partner and a revenue line.

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.7656