Power BI Connector for SugarCRM

Build 20.0.7587

Leads

Create, update, delete, and query the Leads 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 record.

Name String False

The name of the lead.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

The Id of the 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.

Email String False

The email address for the Lead.

Email1 String False

The alternate email address for the Lead.

Email2 String False

The alternate email address for the Lead.

Invalid_Email Bool False

Whether email for the Lead has been marked as invalid.

Email_Opt_Out Bool False

Whether the Lead has opted out of email.

Email_Addresses_Non_Primary String False

The nonprimary email addresses of the lead.

Salutation String False

The contact salutation (e.g., Mr., Ms.).

First_Name String False

The first name of the lead.

Last_Name String False

The last name of the lead.

Full_Name String False

The full name of the lead.

Title String False

The title of the lead.

Facebook String False

The Facebook name of the lead.

Twitter String False

The Twitter name of the lead.

Googleplus String False

The Google Plus Id of the lead.

Department String False

The department the lead belongs to.

Do_Not_Call Bool False

An indicator of whether the lead can be called.

Phone_Home String False

The home phone number of the lead.

Phone_Mobile String False

The mobile phone number of the lead.

Phone_Work String False

The work phone number of the lead.

Phone_Other String False

Other phone number for the lead

Phone_Fax String False

The contact fax number.

Primary_Address_Street String False

The street address used for the primary address.

Primary_Address_Street_2 String False

The second line of the primary address.

Primary_Address_Street_3 String False

The third line of the primary address.

Primary_Address_City String False

The city for the primary address.

Primary_Address_State String False

The state for the primary address.

Primary_Address_Postalcode String False

The postal code for the primary address.

Primary_Address_Country String False

The country for the primary address.

Alt_Address_Street String False

The street address for the alternate address.

Alt_Address_Street_2 String False

The second line for the alternate address.

Alt_Address_Street_3 String False

The third line for the alternate address.

Alt_Address_City String False

The city for the alternate address.

Alt_Address_State String False

The state for the alternate address.

Alt_Address_Postalcode String False

The postal code for the alternate address.

Alt_Address_Country String False

The country for the alternate address.

Assistant String False

The name of the assistant of the lead.

Assistant_Phone String False

The phone number of the assistant of the lead.

Picture String False

The picture of the lead.

Converted Bool False

Whether the lead been converted to a contact (and other Sugar objects).

Refered_By String False

Identifies who refered the lead.

Lead_Source String False

Lead source (e.g., Web or print).

Lead_Source_Description String False

The description of the lead source.

Status String False

The status of the lead.

Status_Description String False

Description of the status of the lead.

Reports_To_Id String False

Id of the contact the Lead reports to.

Report_To_Name String False

The name of the contact the Lead reports to.

Dnb_Principal_Id String False

The unique Id For the D. and B. Contact.

Account_Name String False

The account name for lead.

Account_Description String False

The description of lead account.

Contact_Id String False

The Id of the contact resulting from the conversion.

Contact_Name String False

The name of the contact resulting from the conversion.

Account_Id String False

The account Id resulting from the conversion.

Opportunity_Id String False

The opportunity Id resulting from the conversion.

Opportunity_Name String False

The opportunity name resulting from the conversion.

Opportunity_Amount String False

The amount of the opportunity.

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.

C_Accept_Status_Fields String False

The fields in the accept status of the call.

M_Accept_Status_Fields String False

The fields in the accept status of the meeting.

Accept_Status_Id String False

The Id of the accept status.

Accept_Status_Name String False

The name of the accept status.

Accept_Status_Calls String False

The accept status of calls for the lead.

Accept_Status_Meetings String False

The accept status of meetings for the lead.

Webtolead_Email1 String False

The main email address of the lead.

Webtolead_Email2 String False

The secondary email address of the lead.

Webtolead_Email_Opt_Out Bool False

Whether the lead elects to opt out of email campaigns.

Webtolead_Invalid_Email Bool False

Whether the email address for the lead is invalid.

Birthdate Datetime False

The birthdate of the lead.

Portal_Name String False

Portal user name when the lead was created via the lead portal.

Portal_App String False

Portal application when the lead was created via lead portal.

Website String False

The URL of the website for the company.

Preferred_Language String False

The preferred language of the lead.

Mkto_Sync Bool False

Whether the lead is to be synced to Marketo.

Mkto_Id Int False

The associated Marketo lead Id.

Mkto_Lead_Score Int False

The lead score of the associated Marketo lead.

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