SSIS Components for Oracle Sales

Build 25.0.9434

OpportunityCampaigns

The opportunity campaigns resource is used to view, create, update, and delete campaigns associated with an opportunity.

Columns

Name Type ReadOnly References Description
OptyCampaignId [KEY] Long False

OptyCampaignId

OptyNumber [KEY] String False

Opportunities.OptyNumber

OptyNumber

CampaignEndDate Datetime True

CampaignEndDate

CampaignId Long False

CampaignId

CampaignName String True

CampaignName

CampaignNumber String False

CampaignNumber

CampaignStartDate Datetime True

CampaignStartDate

CampaignStatus String True

CampaignStatus

CampaignType String True

CampaignType

CreatedBy String True

CreatedBy

CreationDate Datetime True

CreationDate

LastUpdateDate Datetime True

LastUpdateDate

LastUpdatedBy String True

LastUpdatedBy

OptyCampaignNumber String False

OptyCampaignNumber

OptyId Long False

OptyId

PrimaryFlag Bool False

PrimaryFlag

RevenuePercentage Double False

RevenuePercentage

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.

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434