SSIS Components for Oracle Sales

Build 24.0.9062

OpportunityDeals

A deal associated with the opportunity.

Columns

Name Type References Description
OptyDealId [KEY] Long This is the primary key of the opportunity deals table.
OptyNumber [KEY] String

Opportunities.OptyNumber

CreatedBy String The user who created the opportunity deal record.
CreationDate Datetime The date and time when the opportunity deal record was created.
DealId Long The unique identifier of the deal.
LastUpdateDate Datetime The date and time when the opportunity deal record was last updated.
LastUpdatedBy String The user who last updated the opportunity deal record.
LastUpdateLogin String The session login associated to the user who last updated the opportunity deal record.
OptyId Long The unique identifier of the opportunity.
PartyName String The name of the partner.
OpportunityLastUpdateDate Datetime The date and time when the opportunity was last updated.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

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