ODBC Driver for Oracle Sales

Build 21.0.7930

OpportunityLeads

The opportunity lead resource is used to view, create, and update the lead that resulted in an opportunity.

Columns

Name Type ReadOnly References Description
OptyLeadId [KEY] Long False

This is the primary key of the opportunity leads 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 record was created.

DealEstimatedCloseDate Datetime False

The date when the deal registration for the opportunity is estimated to be closed.

DealExpirationDate Datetime False

The date when the lead registration will expire.

DealPartProgramId Long False

The unique identifier of the partner program associated with the lead registration.

DealType String False

The deal or lead registration type for the opportunity.

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.

LeadNumber String False

The unique identification number for the lead.

OptyId Long False

The unique identifier of the opportunity.

PartnerTypeCd String False

The type of the partner for the lead registration.

PrDealPartOrgPartyId Long False

The unique identifier for the partner on the lead registration.

PrDealPartResourcePartyId Long False

The unique identifier for the primary partner resource on the lead registration.

RegistrationNumber String False

The unique registration number of the lead for the opportunity.

UserLastUpdateDate Datetime False

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

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