Opportunities
Create, update, delete, and query the Opportunities module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the record is a favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier of the opportunity. |
| Name | String | False |
Name of the opportunity. |
| Date_Entered | Datetime | True |
Date the record was created. |
| Date_Modified | Datetime | True |
The date the record was last modified. |
| Modified_User_Id | String | True |
User who last modified the record. |
| Modified_By_Name | String | True |
The user name of the user who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The user name of the user who created the record. |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The user favorites for the record. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| Assigned_User_Id | String | False |
The Id of the user assigned to the record. |
| Assigned_User_Name | String | False |
The user name of the user assigned to the record. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Opportunity_Type | String | False |
Type of opportunity (e.g., Existing or New). |
| Account_Name | String | False |
The name of the associated account. |
| Account_Id | String | False |
The Id of the associated account. |
| Campaign_Id | String | False |
The Id of the campaign that generated the lead. |
| Campaign_Name | String | False |
The name of the campaign that generated the lead. |
| Lead_Source | String | False |
Source of the opportunity. |
| Amount | Double | True |
Unconverted amount of the opportunity. |
| Base_Rate | Decimal | False |
The base rate of the opportunity. |
| Amount_Usdollar | Double | True |
Formatted amount of the opportunity. |
| Currency_Id | String | False |
The Id of the currency used for display purposes. |
| Currency_Name | String | False |
The name of the currency used for display purposes. |
| Currency_Symbol | String | False |
The symbol of the currency used for display purposes. |
| Date_Closed | Datetime | True |
The expected or actual date the oppportunity will close. |
| Date_Closed_Timestamp | Int | False |
The timestamp of the close date. |
| Next_Step | String | False |
The next step in the sales process. |
| Sales_Stage | String | False |
Indication of progression towards closure. |
| Sales_Status | String | True |
The status of the sale. |
| Probability | Int | False |
The probability of closure. |
| Best_Case | Double | True |
The most optimistic scenario. |
| Worst_Case | Double | True |
The least optimistic scenario. |
| Commit_Stage | String | False |
Forecast commit ranges: Include, Likely, Omit etc. |
| Total_Revenue_Line_Items | Int | False |
The count of all revenue line items. |
| Closed_Revenue_Line_Items | Int | False |
The count of the closed revenue line items. |
| Contact_Role | String | False |
The role of the contact for the opprtunity. |
| Mkto_Sync | Bool | False |
Whether the Opportunity is to be synced to Marketo. |
| Mkto_Id | Int | False |
The associated Marketo lead Id. |