Cmdlets for Oracle Sales

Build 24.0.9060

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.

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.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060