Opportunity

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.

Last updated