Power BI Connector for SugarCRM

Build 20.0.7587

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587