ODBC Driver for Oracle Sales

Build 24.0.9062

Leads

Usage information for the operation Leads.rsd.

Columns

Name Type ReadOnly References Description
LeadId [KEY] Long False

Partner Type. Indicates the type of partner stamped on the lead.

AcceptedDate Date False

The date on which lead was accepted by a resource assigned to it.

AcceptedDateTime Datetime False

Date and time when the sales lead is accepted by a resource assigned to it.

AccountPartyNumber String False

AddrElementAttribute1 String False

Additional address element to support flexible address format.

AddrElementAttribute2 String False

Additional address element to support flexible address format.

AddrElementAttribute3 String False

Additional address element to support flexible address format.

AddrElementAttribute4 String False

Additional address element to support flexible address format.

AddrElementAttribute5 String False

Additional address element to support flexible address format.

AddressLinesPhonetic String False

Phonetic or Kana representation of the Kanji address lines (used in Japan).

ApprovalDate Date False

The date on which a partner registered lead is approved by internal channel manager.

ApprovalDateTime Datetime False

Date and time when the sales lead is approved. This is only applicable to deal registrations.

AssetId Long False

Unique identifier for the Asset associated with the Sales Lead.

AssetNumber String False

Unique Number for the Asset associated with the Sales Lead.

AssetSerialNumber String False

Serial Number for the Asset associated with the Sales Lead.

AssignmentStatusCode String False

Includes the current assignment related status for the lead, for example whether the lead is assigned or unassigned.

BudgetAmount Decimal False

Budget amount associated with this sales lead.

BudgetCurrencyCode String False

Currency code associated with the Budget Amount associated with this sales lead.

BudgetStatus String False

Budget status associated with the Budget Amount associated with this sales lead.

Building String False

Specific building name or number at a given address.

BusinessUnitId Long False

Business Unit Identifier associated with the business unit of the sales lead creator.

CampaignName String False

Name of the campaign associated with the sales lead.

ChannelType String False

Indicates the channel through which this lead contacted the company.

ClassCode1 String False

The auxilliary dimension for the Account.

ClassCode2 String False

The auxilliary dimension for the Account.

ClassCode3 String False

The auxilliary dimension for the Account.

ClassCode4 String False

The auxilliary dimension for the Account.

ContactFormattedAddress String False

ContactPartyNumber String False

ContactTimezoneCd String False

Preferred time zone of the contact pursued on the lead.

ConvertedDateTime Datetime False

Date and time when the sales lead is converted to an opportunity.

CreatedBy String False

Indicates the user who created this record.

CreationDate Datetime False

Indicates the date and time when this record is created.

CurrencyCode String False

Currency code for the lead.

CustomerId Long False

Customer Id. It is a reference to the customer record in the TCA schema.

CustomerNeed String False

Indicates what need the lead product serves for the lead customer.

CustomerPartyName String False

Name of the customer.

DealAmount Decimal False

The total amount attributed to a lead.

DecisionMakerIdentifiedFlag Bool False

Indicates if the decision maker at customer site has been identified.

DeleteFlag Bool False

This flag controls if the user has access to delete the record

Description String False

Description associated with this sales lead.

Distance Double False

Distance from the input location.

EstimatedCloseDate Date False

Estimated close date for a deal once registered

ExpirationDate Date False

Expiration date associated with this sales lead.

FloorNumber String False

Specific floor number at a given address or in a particular building when building number is provided.

FormattedPhoneNumber1 String False

InventoryItemDescription String False

The description of the product added to a lead.

JobTitle String False

Job title of the primary contact on the sales lead.

LastAssignmentDate Datetime False

The date on which the lead was last reassigned.

LastUpdateDate Datetime False

Who column: indicates the date and time of the last update of the row.

LastUpdateLogin String False

Who column: indicates the login of the user who last updated the row.

LastUpdatedBy String False

Who column: indicates the user who last updated the row.

Latitude Double False

Latitude information for the location.

LeadAcceptedFlag Bool False

Indicates if the lead has been accepted.

LeadAging Long False

The number of days elapsed since the lead was created.

LeadCreatedBy String False

Functional WHO: Indicates the user who created this record.

LeadCreationDate Datetime False

Functional WHO: Indicates the date and time when this record is created.

LeadLastUpdateDate Datetime False

Functional WHO: Indicates the date and time of the last update of the row.

LeadLastUpdatedBy String False

Functional WHO: Indicates the user who last updated the row.

LeadNumber String False

User friendly unique identifier for a lead.

Longitude Double False

Longitude information for the location.

Name String False

Lead Name used for identifying the lead.

OrganizationSize String False

Organization Size

OrganizationType String False

Organization Type

OwnerId Long False

Party identifier associated with the owner of this sales lead.

OwnerPartyName String False

Name associated with the owner of this sales lead.

OwnerPartyNumber String False

PartnerCompanyNumber String False

PartnerId Long False

Unique identifier for the primary partner associated with the lead.

PartnerPartyName String False

Name associated with the primary partner of this sales lead. This is a deal specific attribute.

PartnerProgramId Long False

A reference to the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.

PartnerProgramNumber String False

PartnerType String False

Indicates the type of the primary partner associated with this sales lead. This is a deal specific attribute.

PostalPlus4Code String False

Four digit extension to the United States Postal ZIP code.

PrimaryContactAddress1 String False

The first line of address associated with the primary contact of the lead.

PrimaryContactAddress2 String False

The second line of address associated with the primary contact of the lead.

PrimaryContactAddress3 String False

The third line of address associated with the primary contact of the lead.

PrimaryContactAddress4 String False

The fourth line of address associated with the primary contact of the lead.

PrimaryContactCity String False

The city where the primary contact of the lead is located.

PrimaryContactCountry String False

The country where the primary contact of the lead is located.

PrimaryContactCountryName String False

Full name associated with primary contact country code

PrimaryContactCounty String False

The county where the primary contact of the lead is located.

PrimaryContactEmailAddress String False

Email address for the primary sales lead contact on the lead

PrimaryContactId Long False

Identifer of the sales lead contact marked as a primary lead contact.

PrimaryContactPartyName String False

Name associated with the primary lead contact.

PrimaryContactPersonFirstName String False

First name of the primary contact for a lead.

PrimaryContactPersonLastName String False

Last name of the primary contact for a lead.

PrimaryContactPersonMiddleName String False

Middle name of the primary contact for a lead.

PrimaryContactPostalCode String False

The zip code where the primary contact of the lead is located.

PrimaryContactProvince String False

The province where the primary contact of the lead is located.

PrimaryContactRelationshipId Long False

Unique identifier of the relationship primary contact has with its parent organization.

PrimaryContactState String False

The state where the primary contact of the lead is located.

PrimaryInventoryItemId Long False

Unique identifier of the primary product associated with a lead.

PrimaryInventoryItemNumber String False

PrimaryInventoryOrgId Long False

Unique identifier of the organization to which the primary product associated with a lead belongs.

PrimaryPhoneAreaCode String False

Primary phone area code for the sales lead contact.

PrimaryPhoneCountryCode String False

Primary phone country code for the sales lead contact.

PrimaryPhoneNumber String False

Primary phone number for the sales lead contact.

PrimaryProductGroupId Long False

Unique identifier of the primary product group associated with a lead.

PrimaryProductGroupReferenceNumber String False

ProductGroupDescription String False

Description of the product or product group associated with a lead.

ProductGroupName String False

Name of the product group associated with a lead.

ProgramName String False

Name of the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute.

Project String False

customer project identified for this sales lead.

QualificationScore Long False

Qualification score for a lead.

QualifiedDate Date False

Indicates the date when this sales lead was qualified.

QualifiedDateTime Datetime False

Date and time when the sales lead is qualified.

Rank String False

Rank associated with this sales lead.

ReassignComment String False

Comment provided by a user while requesting the lead reassignment.

ReassignReasonCode String False

Pre-defined code used to indicate the reason for lead reassignment.

RecordSet String False

RegistrationNumber String False

Registration number of the sales lead. This unique identifier is generated when the sales lead is approved. This is a deal specific attribute.

RegistrationStatus String False

Approval Status of the sales lead. This is a deal specific attribute.

RegistrationType String False

Indicates the registration type of the sales lead. This is a deal specific attribute.

RejectByUserId Long False

Identifier of the sales representative who rejected this sales lead.

RejectComment String False

Comments provided by the sales representative who rejected this sales lead.

RejectReasonCode String False

Pre-defined code used to indicate the reason for rejecting a lead.

RejectedDateTime Datetime False

Date and time when the sales lead is rejected.

RetireComment String False

Comments recorded when the sales lead is moved to a retired status.

RetireReasonCode String False

Pre-defined code used to indicate the reason for retiring a lead.

RetiredDateTime Datetime False

Date and time when the sales lead is moved to a retired status.

SalesChannel String False

Indicates the sales channel responsible for following up on this sales lead.

Score Long False

The score associated with this sales lead. This score is computed based on the scoring rules.

SourceCode String False

Marketing source code associated with this sales lead.

StatusCode String False

Pre-defined code used to indicate the status of a lead.

Timeframe String False

Timeframe associated with this sales lead.

ToReassignFlag Bool False

Identifies leads that are marked for reassignment.

UpdateFlag Bool False

This flag controls if the user has access to update the record

WorkPhoneAreaCode String False

Work phone area code for the sales lead contact.

WorkPhoneCountryCode String False

Work phone country code for the sales lead contact.

WorkPhoneNumber String False

Work phone number for the sales lead contact.

Pseudo-Columns

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

Name Type Description
Finder String

Input specifying the Finder type.

ContactId String

The unique identifier of the Contact.

SysEffectiveDate String

SysEffectiveDate.

ResourcePartyIdRest String

The unique identifier of the Resource.

RestCreationDateLower String

Finds the leads that are created before the date specified.

RestCreationDateUpper String

Finds the leads with the specified creation date.

RestRecordSet String

Finds the leads with the specified record set value.

RestStatusCode String

Finds the leads with the specified status code.

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