ODBC Driver for Oracle Sales

Build 21.0.7930


The opportunity source resource is used to view, create, and update the source of an opportunity.The opportunity source is used to capture the marketing or sales campaign that resulted in this opportunity.


Name Type ReadOnly References Description
OptySrcId [KEY] Long False

This is the primary key of the opportunity sources table.

OptyNumber String False

CreatedBy String False

The user who created the record.

CreationDate Datetime False

The date and time when the record was created.

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.

SrcNumber String False

A unique number indicating the source of the marketing event for the opportunity, such as campaign, new product line, a marketing seminar, and so on.

UserLastUpdateDate Datetime False

The date and time when the opportunity was last updated from mobile.


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) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930