ODBC Driver for SugarCRM

Build 24.0.9062

Leads

The Leads table.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

Accept_Status_Id String False

Accept_Status_Meetings String False

Accept_Status_Messages String False

Accept_Status_Name String False

Account_Description String False

Description of lead account

Account_Id String False

If converted, Account ID resulting from the conversion

Account_Name String False

Account name for lead

Account_To_Lead String True

Acl_Team_Names String True

Acl_Team_Set_Id String False

Ai_Conv_Bin_Accuracy Decimal True

Ai_Conv_Multiplier Decimal True

Ai_Conv_Score_Absolute Decimal True

Ai_Conv_Score_Classification String True

Ai_Icp_Fit_Bin_Accuracy Decimal True

Ai_Icp_Fit_Multiplier Decimal True

Ai_Icp_Fit_Score_Absolute Decimal True

Ai_Icp_Fit_Score_Classification String True

Alt_Address_City String False

City for alternate address

Alt_Address_Country String False

Country for alternate address

Alt_Address_Postalcode String False

Postal code for alternate address

Alt_Address_State String False

State for alternate address

Alt_Address_Street String False

Street address for alternate address

Alt_Address_Street_2 String False

Alt_Address_Street_3 String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Assistant String False

Name of the assistant of the contact

Assistant_Phone String False

Phone number of the assistant of the contact

Base_Rate Decimal False

Birthdate Date False

The birthdate of the contact

Brand_C String False

Business_Center_Id String False

The business center to which the case is associated

Business_Center_Name String True

The name of the business center represented by the business_center_id field

C_Accept_Status_Fields String True

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

Classification_C String False

Commentlog String True

Contact_Id String False

If converted, Contact ID resulting from the conversion

Contact_Name String True

Converted Bool False

Has Lead been converted to a Contact (and other Sugar objects)

Converted_Opp_Name String True

Created_By String True

User who created record

Created_By_Name String True

Currency_Id String False

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Dead_End_Other_C String False

Deleted Bool False

Record deletion indicator

Department String False

Department the lead belongs to

Description String False

Full text of the note

Dnb_Principal_Id String False

Unique Id For DB Contact

Do_Not_Call Bool False

An indicator of whether contact can be called

Dp_Business_Purpose String True

Business purposes consented for

Dp_Consent_Last_Updated Date False

Date consent last updated

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Email String False

Email_Addresses_Non_Primary String False

Email_Opt_Out Bool False

Email1 String False

Email2 String False

Estimate_Remittance_C Decimal False

Facebook String False

The facebook name of the user

First_Name String False

First name of the contact

Following Bool False

Is user following this record

Full_Name String True

Googleplus String False

The google plus id of the user

Hint_Account_Annual_Revenue String False

Annual Rev

Hint_Account_Description String False

Company Description

Hint_Account_Facebook_Handle String False

company facebook

Hint_Account_Fiscal_Year_End String False

FY End

Hint_Account_Founded_Year String False

company founded year

Hint_Account_Industry String False

Company Industry

Hint_Account_Location String False

Company Location

Hint_Account_Logo String False

company logo

Hint_Account_Naics_Code_Lbl String False

NAICS Code

Hint_Account_Sic_Code_Label String False

SIC Code

Hint_Account_Size String False

Company Size

Hint_Account_Twitter_Handle String False

company twitter

Hint_Account_Website String False

company website

Hint_Contact_Pic String False

Hint Contact logo

Hint_Education String False

Education

Hint_Education_2 String False

Education 2

Hint_Facebook String False

Hint_Industry_Tags String False

industry tags

Hint_Job_2 String False

Job 2

Hint_Phone_1 String False

extra phone field

Hint_Phone_2 String False

extra phone field

Hint_Photo String False

person photo

Hint_Twitter String False

Id [KEY] String True

Unique identifier

Invalid_Email Bool False

Last_Name String False

Last name of the contact

Lead_Source String False

Lead source (ex: Web, print)

Lead_Source_Description String False

Description of the lead source

Locked_Fields String True

M_Accept_Status_Fields String True

Market_Interest_Prediction_Score String True

Market_Score Int True

Mkto_Id Int True

Associated Marketo Lead ID

Mkto_Lead_Score Int True

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 True

Opportunity_Amount String False

Amount of the opportunity

Opportunity_Id String False

If converted, Opportunity ID resulting from the conversion

Opportunity_Name String False

Opportunity name associated with lead

Other_Underwriter_Notes_C String False

Perform_Sugar_Action Bool False

Phone_Fax String False

Contact fax number

Phone_Home String False

Home phone number of the contact

Phone_Mobile String False

Mobile phone number of the contact

Phone_Other String False

Other phone number for the contact

Phone_Work String False

Work phone number of the contact

Picture String False

Avatar

Portal_App String False

Portal application that resulted in created of lead

Portal_Name String False

Portal user name when lead created via lead portal

Preferred_Language String False

Primary_Address_City String False

City for primary address

Primary_Address_Country String False

Country for primary address

Primary_Address_Postalcode String False

Postal code for primary address

Primary_Address_State String False

State for primary address

Primary_Address_Street String False

The street address used for primary address

Primary_Address_Street_2 String False

Primary_Address_Street_3 String False

Refered_By String False

Identifies who refered the lead

Report_To_Name String True

Reports_To_Id String False

ID of Contact the Lead reports to

Salutation String False

Contact salutation (e.g., Mr, Ms)

Status String False

Status of the lead

Status_Description String False

Description of the status of the lead

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

Title String False

The title of the contact

Twitter String False

The twitter name of the user

Underwriters_Non_Fntg_C String False

Website String False

URL of website for the company

Webtolead_Email_Opt_Out Bool False

Indicator signaling if lead elects to opt out of email campaigns

Webtolead_Email1 String False

Main email address of lead

Webtolead_Email2 String False

Secondary email address of lead

Webtolead_Invalid_Email Bool False

Indicator that email address for lead is invalid

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