ODBC Driver for SugarCRM

Build 24.0.9062

Opportunities

The Opportunities table.

Columns

Name Type ReadOnly Description
Account_Id String False

Account_Name String False

Acl_Team_Names String True

Acl_Team_Set_Id String False

Ai_Opp_Close_Week_Scores String True

Ai_Opp_Conv_Bin_Accuracy Decimal True

Ai_Opp_Conv_Multiplier Decimal True

Ai_Opp_Conv_Score_Absolute Decimal True

Ai_Opp_Conv_Score_Enum String True

Amount Decimal True

Unconverted amount of the opportunity

Amount_Usdollar Decimal True

Formatted amount of the opportunity

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Base_Rate String True

Best_Case Decimal True

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

Closed_Revenue_Line_Items Int True

Closed_Won_Revenue_Line_Items Int True

Commentlog String True

Commit_Stage String False

Forecast commit ranges: Include, Likely, Omit etc.

Commit_Stage_Cascade String False

Contact_Role String False

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Currency_Name String True

Currency_Symbol String True

Date_Closed Date False

Expected or actual date the oppportunity will close

Date_Closed_Cascade Date False

Date_Closed_Timestamp String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Deleted Bool False

Record deletion indicator

Description String False

Full text of the note

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Following Bool False

Is user following this record

Forecasted_Likely Decimal True

Rollup of included RLIs on the Opportunity

Id [KEY] String True

Unique identifier

Included_Revenue_Line_Items Int True

Is_Escalated Bool True

Is this escalated?

Lead_Source String False

Source of the opportunity

Locked_Fields String True

Lost Decimal True

Rollup of lost RLIs on the Opportunity

Mkto_Id Int True

Associated Marketo Lead ID

Mkto_Sync Bool False

Should the Lead be synced to Marketo

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String False

Name of the opportunity

Next_Step String False

The next step in the sales process

Opportunity_Type String False

Type of opportunity (ex: Existing, New)

Perform_Sugar_Action Bool False

Probability Int True

The probability of closure

Renewal Bool False

Indicates whether the opportunity is a renewal

Renewal_Parent_Id String False

Renewal_Parent_Name String True

Sales_Stage String False

Indication of progression towards closure

Sales_Stage_Cascade String False

Sales_Status String True

Service_Duration_Unit String False

Service duration unit: day, month, or year

Service_Duration_Unit_Cascade String False

Service_Duration_Value Int True

Value of the service duration, if service duration is 4 Months the value is 4

Service_Duration_Value_Cascade Int True

Service_Open_Flex_Duration_Rlis Int True

Service_Open_Revenue_Line_Items Int True

Service_Start_Date Date False

Service start date field.

Service_Start_Date_Cascade Date False

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Total_Revenue_Line_Items Int True

Widget_Amount String True

Widget_Date_Closed String True

Widget_Sales_Stage String True

Worst_Case Decimal True

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062