ODBC Driver for SugarCRM

Build 23.0.8839

Opportunities

The Opportunities table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String False

Name of the opportunity

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

Opportunity_Type String False

Type of opportunity (ex: Existing, New)

Account_Name String False

Account_Id String False

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

Lead_Source String False

Source of the opportunity

Amount Decimal True

Unconverted amount of the opportunity

Amount_Usdollar Decimal True

Formatted amount of the opportunity

Date_Closed Date False

Expected or actual date the oppportunity will close

Date_Closed_Timestamp String True

Next_Step String False

The next step in the sales process

Sales_Stage String False

Indication of progression towards closure

Sales_Status String True

Probability Int True

The probability of closure

Best_Case Decimal True

Worst_Case Decimal True

Commit_Stage String False

Forecast commit ranges: Include, Likely, Omit etc.

Forecasted_Likely Decimal True

Rollup of included RLIs on the Opportunity

Lost Decimal True

Rollup of lost RLIs on the Opportunity

Commit_Stage_Cascade String False

Closed_Won_Revenue_Line_Items Int True

Service_Start_Date Date False

Service start date field.

Service_Open_Revenue_Line_Items Int True

Service_Start_Date_Cascade Date False

Total_Revenue_Line_Items Int True

Closed_Revenue_Line_Items Int True

Included_Revenue_Line_Items Int True

Renewal_Parent_Id String False

Renewal_Parent_Name String True

Widget_Sales_Stage String True

Widget_Date_Closed String True

Widget_Amount String True

Sales_Stage_Cascade String False

Date_Closed_Cascade Date False

Contact_Role String False

Ai_Opp_Conv_Score_Absolute Decimal True

Ai_Opp_Conv_Bin_Accuracy Decimal True

Ai_Opp_Conv_Multiplier Decimal True

Service_Duration_Value Int True

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

Service_Duration_Unit String False

Service duration unit: day, month, or year

Service_Duration_Value_Cascade Int True

Service_Duration_Unit_Cascade String False

Service_Open_Flex_Duration_Rlis Int True

Geocode_Status String True

Mkto_Sync Bool False

Should the Lead be synced to Marketo

Mkto_Id Int True

Associated Marketo Lead ID

Ai_Opp_Close_Week_Scores String True

Renewal Bool False

Indicates whether the opportunity is a renewal

Ai_Opp_Conv_Score_Enum String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Tag String False

Commentlog String True

Locked_Fields String True

Sync_Key String True

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Currency_Id String False

Base_Rate String True

Currency_Name String True

Currency_Symbol String True

Is_Escalated Bool True

Is this escalated?

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Perform_Sugar_Action Bool False

Denorm_Account_Name String False

Name of the Company

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