# Opportunity: Opportunity - Name: `Opportunity` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Opportunity ## Table Columns The columns of the table `Opportunity` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountId` | `string` | Account ID | ☐ | | | `Amount` | `decimal` | Amount | ☐ | | | `CampaignId` | `string` | Campaign ID | ☐ | | | `CloseDate` | `datetime` | Close Date | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `CurrentGenerators__c` | `string` | Current Generators | ☐ | | | `DeliveryInstallationStatus__c` | `string` | Delivery Installation Status | ☐ | | | `Description` | `string` | Description | ☐ | | | `ExpectedRevenue` | `decimal` | Expected Revenue | ☐ | | | `Fiscal` | `string` | Fiscal | ☐ | | | `FiscalQuarter` | `int32` | Fiscal Quarter | ☐ | | | `FiscalYear` | `int32` | Fiscal Year | ☐ | | | `ForecastCategory` | `string` | Forecast Category | ☐ | | | `ForecastCategoryName` | `string` | Forecast Category Name | ☐ | | | `HasOpenActivity` | `boolean` | Has Open Activity | ☐ | | | `HasOpportunityLineItem` | `boolean` | Has Opportunity Line Item | ☐ | | | `HasOverdueTask` | `boolean` | Has Overdue Task | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsClosed` | `boolean` | Is Closed | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsPrivate` | `boolean` | Is Private | ☐ | | | `IsWon` | `boolean` | Is Won | ☐ | | | `LastActivityDate` | `datetime` | Date Last Activity | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `LeadSource` | `string` | Lead Source | ☐ | | | `MainCompetitors__c` | `string` | Main Competitors | ☐ | | | `Name` | `string` | Name | ☐ | | | `NextStep` | `string` | Next Step | ☐ | | | `OrderNumber__c` | `string` | Order Number | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `Pricebook2Id` | `string` | Pricebook ID | ☐ | | | `Probability` | `string` | Probability | ☐ | | | `StageName` | `string` | Stage Name | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TotalOpportunityQuantity` | `double` | Total Opportunity Quantity | ☐ | | | `TrackingNumber__c` | `string` | Tracking Number | ☐ | | | `Type` | `string` | Type | ☐ | |