Power BI Connector for SugarCRM

Build 25.0.9454

Leads

Stores prospective customer records representing individuals or organizations that might convert into opportunities. This table supports lead qualification, nurturing workflows, and conversion tracking into contacts, accounts, and opportunities.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

The user's availability status for accepting calls that are related to this lead (for example, 'Accept', 'Decline', or 'Tentative'.

Accept_Status_Id String False

The unique identifier (Id) for the acceptance status record that is associated with this lead. This Id is used to determine the user's communication availability state.

Accept_Status_Meetings String False

The user's availability status for accepting meeting invitations that are related to this lead.

Accept_Status_Messages String False

The user's availability status for accepting message-based communications that are related to this lead.

Accept_Status_Name String False

The display name of the acceptance status configuration that is applied to this lead's communication preferences.

Account_Description String False

A descriptive summary of the account that is associated with the lead or that can result from lead conversion. This value can provide context for qualification decisions.

Account_Id String False

The Id of the account that is created or linked when this lead is converted. This value is blank until conversion occurs.

Account_Name String False

The display name of the account that is associated with the lead, either through conversion or manual association.

Account_To_Lead String True

A field used internally to support lead-to-account association workflows, including matching and duplicate checking during conversion.

Acl_Team_Names String True

The list of team names that are associated with this lead. These names determine which teams can view or collaborate on the lead record.

Acl_Team_Set_Id String False

The Id of the team set that is associated with this lead. The team set defines the complete group of teams that are granted access.

Ai_Conv_Bin_Accuracy Decimal True

The accuracy value of the AI lead conversion binary prediction model. Higher values indicate stronger prediction reliability for conversion likelihood.

Ai_Conv_Multiplier Decimal True

The weighting factor that is applied to the AI conversion score to influence prioritization or routing decisions.

Ai_Conv_Score_Absolute Decimal True

The absolute AI-generated score that estimates how likely the lead is to convert into an account, contact, or opportunity.

Ai_Conv_Score_Classification String True

The classification label that is assigned to the AI conversion score (for example, 'High', 'Medium', or 'Low' likelihood).

Ai_Icp_Fit_Bin_Accuracy Decimal True

The accuracy value of the Ideal Customer Profile (ICP) fit model, indicating how well the lead aligns with known successful customer attributes.

Ai_Icp_Fit_Multiplier Decimal True

The weighting factor that is applied to the ICP fit score when calculating prioritization rankings.

Ai_Icp_Fit_Score_Absolute Decimal True

The absolute score that indicates how closely this lead matches the organization's ICP.

Ai_Icp_Fit_Score_Classification String True

The classification label that describes the ICP fit score quality (for example, 'Excellent', 'Average', or 'Poor').

Alt_Address_City String False

The city of the lead's alternate address.

Alt_Address_Country String False

The country of the lead's alternate address.

Alt_Address_Postalcode String False

The postal code or ZIP code of the lead's alternate address.

Alt_Address_State String False

The state or province of the lead's alternate address.

Alt_Address_Street String False

The street address of the lead's alternate address.

Alt_Address_Street_2 String False

An additional street address line for the lead's alternate address, if it is required for mailing or location detail.

Alt_Address_Street_3 String False

A third street address line for the lead's alternate address, used when extended address formatting is needed.

Assigned_User_Id String False

The Id of the user who is assigned ownership of this lead. This user is responsible for qualification and follow-up.

Assigned_User_Name String True

The display name of the user who is assigned ownership of this lead. This value appears in record headers and assignment views.

Assistant String False

The name of the assistant who supports the lead, when relevant to outreach or scheduling.

Assistant_Phone String False

The phone number of the lead's assistant, when direct scheduling or contact coordination is needed.

Base_Rate Decimal False

The currency conversion rate that is applied when revenue or valuation metrics are calculated for this lead.

Birthdate Date False

The date of birth of the lead contact. This value can support demographic or segmentation analysis.

Brand_C String False

A brand-related classification or segmentation code that is assigned to the lead for marketing or routing purposes.

Business_Center_Id String False

The Id of the business center that is associated with this lead. Business centers can define geographic, organizational, or operational routing zones.

Business_Center_Name String True

The display name of the business center that is associated with this lead. This value appears in user interfaces and routing workflows.

C_Accept_Status_Fields String True

A list of acceptance status fields that are configured for communication tracking with this lead.

Campaign_Id String False

The Id of the campaign that generated or influenced this lead. This value is used for marketing attribution and Return on Investment (ROI) reporting.

Campaign_Name String True

The display name of the campaign that is associated with this lead. This value appears in lead source and campaign performance reporting.

Classification_C String False

An internal classification or segmentation code that is used to categorize the lead for routing, scoring, or reporting.

Commentlog String True

The log of comments and discussion notes that are associated with this lead. This field supports collaboration and activity context.

Contact_Id String False

The Id of the contact that is created when this lead is converted. This value remains blank until conversion occurs.

Contact_Name String True

The display name of the contact that results from lead conversion.

Converted Bool False

A Boolean field that returns a value of 'true' when this lead has been converted into one or more SugarCRM records such as an account, contact, or opportunity. It returns a value of 'false' when the lead remains unconverted.

Converted_Opp_Name String True

The display name of the opportunity that is created during lead conversion, when applicable.

Created_By String True

The Id of the user who created this lead record. This value supports audit tracking and origin identification.

Created_By_Name String True

The display name of the user who created this lead record. This value appears in audit history and detail views.

Currency_Id String False

The Id of the currency that is associated with this lead. This value ensures accurate financial display in multi-currency environments.

Date_Entered Datetime True

The date and time when this lead record was created. This timestamp supports history and audit review.

Date_Modified Datetime True

The date and time when this lead record was last modified. This timestamp supports version tracking and change review.

Dead_End_Other_C String False

A reason value recorded when the lead is marked as dead end for a reason that does not fall under standard categories.

Deleted Bool False

A Boolean field that returns a value of 'true' when this lead record is marked as deleted. It returns a value of 'false' when the record remains active.

Department String False

The department or functional area that the lead belongs to within their organization.

Description String False

A free-form descriptive note that provides context, history, or qualification background for this lead.

Dnb_Principal_Id String False

The Id that is assigned by Dun & Bradstreet for the principal contact associated with this lead, when third-party business data enrichment is enabled.

Do_Not_Call Bool False

A Boolean field that returns a value of 'true' when the lead requests not to be contacted by phone. It returns a value of 'false' when calling is permitted.

Dp_Business_Purpose String True

The list of business purposes for which the lead has consented to data usage, used to support privacy and compliance obligations.

Dp_Consent_Last_Updated Date False

The date when the lead's consent preferences were last updated.

Dri_Workflow_Template_Id String False

The Id of the Customer Journey or engagement workflow template that is associated with this lead, when journey automation is used.

Dri_Workflow_Template_Name String True

The display name of the workflow template that is associated with this lead, used to track guided engagement steps.

Email String False

The primary email address of the lead.

Email_Addresses_Non_Primary String False

A list of additional email addresses that are associated with the lead but are not marked as primary.

Email_Opt_Out Bool False

A Boolean field that returns a value of 'true' when the lead has opted out of email communication. It returns a value of 'false' when email communication is permitted.

Email1 String False

The primary email address of the lead, frequently used in legacy configurations.

Email2 String False

A secondary email address for the lead, used when alternate contact routing is necessary.

Estimate_Remittance_C Decimal False

An estimated financial amount that is associated with remittance or revenue expectation for this lead, when tracked.

Facebook String False

The Facebook profile or handle that is associated with the lead.

First_Name String False

The first name of the lead contact.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this lead. It returns a value of 'false' when the lead is not being followed.

Full_Name String True

The full name of the lead contact, formatted according to system settings.

Googleplus String False

The Google Plus profile Id that is associated with the lead. This field is retained for legacy social profile storage.

Hint_Account_Annual_Revenue String False

The annual revenue amount of the associated company, as provided by Hint enrichment data sources.

Hint_Account_Description String False

A company description that is enriched from Hint data sources to support contextual qualification.

Hint_Account_Facebook_Handle String False

The company's Facebook handle as enriched from Hint data sources.

Hint_Account_Fiscal_Year_End String False

The fiscal year-end date for the company, as provided by Hint enrichment.

Hint_Account_Founded_Year String False

The year in which the company was founded, as provided by Hint enrichment.

Hint_Account_Industry String False

The industry classification of the company, enriched to support segmentation and ICP scoring.

Hint_Account_Location String False

The primary geographic location of the company, enriched for routing and regional assignment.

Hint_Account_Logo String False

A URL or encoded image reference for the company's logo, enriched from Hint data sources.

Hint_Account_Naics_Code_Lbl String False

The NAICS industry classification label that is associated with the company.

Hint_Account_Sic_Code_Label String False

The SIC industry classification label that is associated with the company.

Hint_Account_Size String False

The company size classification, enriched for segmentation and ICP fit scoring.

Hint_Account_Twitter_Handle String False

The company's Twitter handle, enriched for engagement or research.

Hint_Account_Website String False

The company's website URL, enriched to support research and qualification.

Hint_Contact_Pic String False

A URL or encoded image reference for the lead's contact photo, enriched from Hint sources.

Hint_Education String False

Education details that are enriched from Hint data sources.

Hint_Education_2 String False

Additional education details that are enriched from Hint data sources.

Hint_Facebook String False

The lead's Facebook profile, enriched when it is available.

Hint_Industry_Tags String False

Industry-related tags or keywords that are enriched for segmentation and targeting.

Hint_Job_2 String False

Additional job or role information for the contact, enriched from third-party sources.

Hint_Phone_1 String False

An additional phone number enriched through Hint sources.

Hint_Phone_2 String False

A second additional phone number enriched through Hint sources.

Hint_Photo String False

A profile image reference that is enriched from external data sources.

Hint_Twitter String False

The lead's Twitter handle, enriched for outreach or research.

Id [KEY] String True

The Id of this lead record. The system uses this Id to reference and manage the lead internally.

Invalid_Email Bool False

A Boolean field that returns a value of 'true' when the primary email on file is known to be invalid. It returns a value of 'false' when the email is deliverable.

Last_Name String False

The last name of the lead contact.

Lead_Source String False

The source through which the lead was acquired (for example, 'Web Form', 'Trade Show', 'Referral', or 'Purchased List').

Lead_Source_Description String False

A descriptive explanation of the lead source, such as event details or acquisition notes.

Locked_Fields String True

The list of fields that are restricted from modification to maintain lead data integrity or compliance requirements.

M_Accept_Status_Fields String True

The set of acceptance status fields that are configured for messaging or communication transactions that are related to this lead.

Market_Interest_Prediction_Score String True

The predictive score that indicates the lead's likelihood of expressing interest or responding to market outreach.

Market_Score Int True

A numerical score that represents the lead's overall market fit, derived from behavioral, demographic, or segmentation data.

Mkto_Id Int True

The Id of the corresponding Marketo lead record when lead synchronization with Marketo is enabled.

Mkto_Lead_Score Int True

The lead score that is assigned by Marketo based on engagement, activity, and behavioral scoring models.

Mkto_Sync Bool False

A Boolean field that returns a value of 'true' when this lead should be synchronized with Marketo. It returns a value of 'false' when synchronization is disabled.

Modified_By_Name String True

The display name of the user who last modified this lead record. This value supports visibility in audit and review contexts.

Modified_User_Id String True

The Id of the user who most recently updated this lead record. This value is used to track responsibility for changes.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the current user has marked this lead as a favorite. It returns a value of 'false' when the lead is not marked as a favorite.

Name String True

The full display name of the lead, formatted according to system settings and naming conventions.

Opportunity_Amount String False

The expected opportunity value that is associated with this lead when it progresses into an opportunity stage.

Opportunity_Id String False

The Id of the opportunity that results from lead conversion, when applicable.

Opportunity_Name String False

The display name of the opportunity that is associated with this lead through conversion or manual association.

Other_Underwriter_Notes_C String False

Additional underwriting notes that are recorded for review, evaluation, or approval processes.

Perform_Sugar_Action Bool False

A Boolean field that returns a value of 'true' when automated workflow actions should be performed on this lead. It returns a value of 'false' when no automation should be applied.

Phone_Fax String False

The fax number that is associated with the lead's contact information.

Phone_Home String False

The home phone number that is associated with the lead's contact record.

Phone_Mobile String False

The mobile phone number for contacting the lead.

Phone_Other String False

An additional phone number that is associated with the lead, used for alternative or backup contact methods.

Phone_Work String False

The work phone number that is associated with the lead's primary business contact.

Picture String False

The avatar or profile image that is associated with the lead's contact profile.

Portal_App String False

The portal application that is used to create the lead record when the lead originates from a self-service portal.

Portal_Name String False

The username or display name of the portal user who submitted the lead through a portal interface.

Preferred_Language String False

The preferred communication language for the lead, used for outreach and localization.

Primary_Address_City String False

The city of the lead's primary mailing address.

Primary_Address_Country String False

The country of the lead's primary mailing address.

Primary_Address_Postalcode String False

The postal code or ZIP code of the lead's primary mailing address.

Primary_Address_State String False

The state or province of the lead's primary mailing address.

Primary_Address_Street String False

The street address that is associated with the lead's primary mailing address.

Primary_Address_Street_2 String False

An additional street address line for the lead's primary mailing address, when needed for location detail.

Primary_Address_Street_3 String False

A third street address line for the lead's primary mailing address, when extended address formatting is required.

Refered_By String False

The person, entity, or source that referred the lead to the organization.

Report_To_Name String True

The display name of the manager, executive, or primary contact to whom the lead reports within their organization.

Reports_To_Id String False

The Id of the contact record that the lead reports to within organizational hierarchy.

Salutation String False

The contact salutation used when addressing the lead (for example, 'Mr', 'Ms', or 'Dr').

Status String False

The current status of the lead in the qualification lifecycle (for example, 'New', 'Working', 'Nurturing', or 'Converted').

Status_Description String False

A descriptive explanation of the lead's status, such as progress notes or qualification reasoning.

Sync_Key String True

The synchronization key that is used to align this lead with external systems or other data sources.

Tag String False

The tags that are applied to this lead for grouping, filtering, and classification.

Team_Count String False

The number of teams that are associated with this lead. This value supports collaboration and visibility analysis.

Team_Id String False

The Id of the primary team that is associated with this lead. The primary team defines the default access scope.

Team_Name String False

The display name of the primary team that is associated with this lead.

Team_Set_Id String False

The Id of the full team set that is associated with this lead. The team set defines all teams that are permitted to view or modify the record.

Title String False

The job title or professional role of the lead.

Twitter String False

The Twitter handle or username that is associated with the lead.

Underwriters_Non_Fntg_C String False

Underwriting notes that are not related to funding considerations, where applicable.

Website String False

The website URL of the lead's associated company or organization.

Webtolead_Email_Opt_Out Bool False

A Boolean field that returns a value of 'true' when the lead has opted out of email marketing during Web-to-Lead capture. It returns a value of 'false' when email marketing is permitted.

Webtolead_Email1 String False

The primary email address that is captured through web-to-lead submission.

Webtolead_Email2 String False

The secondary email address that is captured through web-to-lead submission.

Webtolead_Invalid_Email Bool False

A Boolean field that returns a value of 'true' when the email address that is captured through Web-to-Lead submission is invalid. It returns a value of 'false' when the email is valid.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454