Opportunities
Create, update, delete, and query opportunities saved in SuiteCRM
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
The unique identifier of the opportunity. |
| Name | String | False |
|
| DateEntered | Datetime | False |
The date the record was created. |
| DateModified | Datetime | False |
The date the record was last modified. |
| ModifiedUserId | String | False |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| CreatedBy | String | False |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| Description | String | False |
Full text of the note. |
| Deleted | Bool | False |
The record deletion indicator. |
| CreatedByLink | String | True |
Link to the record who created it |
| ModifiedUserLink | String | True |
Link to the record who modified it. |
| AssignedUserId | String | False |
|
| AssignedUserName | String | True |
|
| AssignedUserLink | String | True |
Link to the user which the record has been assigned to |
| SecurityGroups | String | True |
The security group associated with the record. |
| OpportunityType | String | False |
|
| AccountName | String | False |
The name of the associated account. |
| AccountId | String | False |
The Id of the associated account. |
| CampaignId | String | False |
The Id of the campaign associated with the record. |
| CampaignName | String | True |
The name of the campaign associated with the record. |
| CampaignOpportunities | String | True |
|
| LeadSource | String | False |
Source of the opportunity. |
| Amount | String | False |
Formatted amount of the opportunity. |
| AmountUsdollar | String | False |
|
| CurrencyId | String | False |
|
| CurrencyName | String | True |
The name of the currency used for display purposes. |
| CurrencySymbol | String | True |
The symbol of the currency used for display purposes. |
| DateClosed | String | False |
|
| NextStep | String | False |
The next step in the sales process. |
| SalesStage | String | False |
Indication of progression towards closure. |
| Probability | String | False |
|
| Accounts | String | True |
The accounts associated with the record |
| Contacts | String | True |
The contacts associated with the record |
| Tasks | String | True |
The tasks associated with the record. |
| Notes | String | True |
The notes associated with the record. |
| Meetings | String | True |
The meetings associated with the record. |
| Calls | String | True |
The calls associated with the record |
| Emails | String | True |
The emails associated with the record |
| Documents | String | True |
The documents associated with the record. |
| Project | String | True |
The project associated with the record. |
| Leads | String | True |
The leads associated with the record. |
| Campaigns | String | True |
The campaigns associated with the account. |
| CampaignLink | String | True |
|
| Currencies | String | True |
|
| AosQuotes | String | True |
|
| AosContracts | String | True |
|
| JjwgMapsLatC | Double | False |
|
| JjwgMapsLngC | Double | False |
|
| JjwgMapsGeocodeStatusC | String | False |
|
| JjwgMapsAddressC | String | False |
|