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. |