JDBC Driver for SuiteCRM

Build 22.0.8462

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462