ODBC Driver for Salesforce

Build 24.0.9029

Opportunity

This is a table representing the Opportunity entities in Salesforce.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the Opportunity.

IsDeleted Boolean True

Label Deleted corresponds to this field.

AccountId String False

Account.Id

Label Account ID corresponds to this field.

IsPrivate Boolean False

Label Private corresponds to this field.

Name String False

Label Name corresponds to this field.

Description String False

Label Description corresponds to this field.

StageName String False

Label Stage corresponds to this field.

Amount Double False

Label Amount corresponds to this field.

Probability Double False

Label Probability (%) corresponds to this field.

ExpectedRevenue Double True

Label Expected Amount corresponds to this field.

TotalOpportunityQuantity Double False

Label Quantity corresponds to this field.

CloseDate Datetime False

Label Close Date corresponds to this field.

Type String False

Label Opportunity Type corresponds to this field.

NextStep String False

Label Next Step corresponds to this field.

LeadSource String False

Label Lead Source corresponds to this field.

IsClosed Boolean True

Label Closed corresponds to this field.

IsWon Boolean True

Label Won corresponds to this field.

ForecastCategory String True

Label Forecast Category corresponds to this field.

ForecastCategoryName String False

Label Forecast Category corresponds to this field.

CampaignId String False

Campaign.Id

Label Campaign ID corresponds to this field.

HasOpportunityLineItem Boolean True

Label Has Line Item corresponds to this field.

Pricebook2Id String False

Pricebook2.Id

Label Price Book ID corresponds to this field.

OwnerId String False

User.Id

Label Owner ID corresponds to this field.

CreatedDate Datetime True

Label Created Date corresponds to this field.

CreatedById String True

User.Id

Label Created By ID corresponds to this field.

LastModifiedDate Datetime True

Label Last Modified Date corresponds to this field.

LastModifiedById String True

User.Id

Label Last Modified By ID corresponds to this field.

SystemModstamp Datetime True

Label System Modstamp corresponds to this field.

LastActivityDate Datetime True

Label Last Activity corresponds to this field.

FiscalQuarter Int True

Label Fiscal Quarter corresponds to this field.

FiscalYear Int True

Label Fiscal Year corresponds to this field.

Fiscal String True

Label Fiscal Period corresponds to this field.

LastViewedDate Datetime True

Label Last Viewed Date corresponds to this field.

LastReferencedDate Datetime True

Label Last Referenced Date corresponds to this field.

SyncedQuoteId String False

Quote.Id

Label Quote ID corresponds to this field.

DeliveryInstallationStatus__c String False

Label Delivery/Installation Status corresponds to this field.

CurrentGenerators__c String False

Label Current Generator(s) corresponds to this field.

TrackingNumber__c String False

Label Tracking Number corresponds to this field.

MainCompetitors__c String False

Label Main Competitor(s) corresponds to this field.

OrderNumber__c String False

Label Order Number corresponds to this field.

SomeNumber__c Double False

Label SomeNumber corresponds to this field.

ZeroDecimal__c Double False

Label ZeroDecimal corresponds to this field.

AutoNumber__c String True

Label AutoNumber corresponds to this field.

FloatTest__c Double False

Label FloatTest corresponds to this field.

Don_t_Test__c String False

Label Don?t_Test corresponds to this field.

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