Power BI Connector for SugarCRM

Build 25.0.9454

Contacts

Stores contact records representing individual people who are associated with accounts, opportunities, or leads. This table supports relationship management, communication workflows, and customer engagement activities.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

The contact's acceptance status for call invitations. This field reflects whether the contact has accepted, declined, or not responded to the call request.

Accept_Status_Id String False

The internal reference value that represents the contact's current acceptance status across supported activity types.

Accept_Status_Meetings String False

The contact's acceptance status for meeting invitations. This field indicates whether the contact has accepted, declined, or not responded to meeting requests.

Accept_Status_Messages String False

The contact's acceptance status for message-based interactions or communications that are associated with the CRM record.

Accept_Status_Name String False

The descriptive label that corresponds to the contact's acceptance status. This value is typically displayed in the user interface.

Account_Id String False

The identifier (Id) of the account that is associated with the contact. This field establishes the primary organizational relationship for account-based workflows.

Account_Name String True

The display name of the account that is associated with the contact. This field provides readable context for the account_id relationship.

Accounting_Bulletins_C Bool False

A Boolean field that returns a value of 'true' when the contact is subscribed to receive accounting bulletins or financial communications. It returns a value of 'false' when the contact is not subscribed.

Acl_Team_Names String True

A system-managed list of team names that grant the current user access to this contact record. This field supports access control and data visibility enforcement.

Acl_Team_Set_Id String False

The Id that references the team set that is associated with this contact record. Team sets allow multiple teams to share access to a record.

Alt_Address_City String False

The city of the contact's alternate address location. This address can be used for secondary mailing or communication purposes.

Alt_Address_Country String False

The country of the contact's alternate address location.

Alt_Address_Postalcode String False

The postal code of the contact's alternate address location.

Alt_Address_State String False

The state or region of the contact's alternate address location.

Alt_Address_Street String False

The street address of the contact's alternate address location.

Alt_Address_Street_2 String False

The second address line of the contact's alternate address location. This field is used for suite numbers, unit identifiers, or extended address details.

Alt_Address_Street_3 String False

The third address line of the contact's alternate address location. This field supports additional addressing needs.

Assigned_User_Id String False

The Id of the user who is assigned ownership of the contact record. This field supports workload distribution and accountability.

Assigned_User_Name String True

The display name of the user who is assigned ownership of the contact record.

Assistant String False

The name of the assistant who supports the contact in business-related activities.

Assistant_Phone String False

The assistant's phone number, used for scheduling and direct communication on behalf of the contact.

Birthdate Date False

The contact's date of birth. This information can support age-based personalization, demographic analysis, or compliance-driven documentation.

Business_Center_Id String False

The Id of the business center that is associated with the contact. Business centers are used to determine hours of service and region-specific handling.

Business_Center_Name String True

The display name of the business center that is associated with the contact. This value corresponds to the business_center_id field.

C_Accept_Status_Fields String True

A stored representation of acceptance status values across multiple communication channels for the contact. This field supports user interface rendering and workflow logic.

Campaign_Id String False

The Id of the marketing campaign that originally generated or influenced the contact. This field supports campaign attribution and performance analysis.

Campaign_Name String True

The display name of the marketing campaign that is associated with the contact. This value provides readable context for the campaign_id field.

Commentlog String True

A free-form text field for storing internal comments that are related to the contact record. This field supports collaborative communication among CRM users.

Contact_Type_C String False

The classification of the contact based on organizational category, relationship role, or segmentation criteria.

Contactid_C String False

An internal or external reference Id for the contact that is used in integrated business systems.

Cookie_Consent Bool False

A Boolean field that returns a value of 'true' when the contact provides consent for cookie usage within portal or digital service interfaces. It returns a value of 'false' when consent is not provided.

Cookie_Consent_Received_On Datetime False

The date and time when cookie consent was received from the contact. This field supports privacy compliance auditing.

Created_By String True

The Id of the user who created the contact record. This field supports record lineage and audit history.

Created_By_Name String True

The display name of the user who created the contact record.

Date_Entered Datetime True

The date and time when the contact record was created.

Date_Modified Datetime True

The date and time when the contact record was last modified.

Day_Of_Birth_Yr_Optional_C String False

An optional user-provided date-of-birth field that can store only month and day information when the year is not required or is unavailable.

Deleted Bool False

A Boolean field that returns a value of 'true' when the contact record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and data recovery.

Department String False

The department or organizational division that is associated with the contact, typically used for business demographic segmentation or reporting.

Description String False

A free-form descriptive text field that is used to store additional narrative or contextual information about the contact.

Dnb_Principal_Id String False

The external reference Id that is used to identify the contact within Dun & Bradstreet (DNB) business intelligence systems.

Do_Not_Call Bool False

A Boolean field that returns a value of 'true' when the contact requests not to be contacted by phone. It returns a value of 'false' when phone communication is permitted. This field supports compliance with consent and privacy requirements.

Dp_Business_Purpose String True

A list or descriptor of the business purposes for which the contact has granted consent. This field supports regulatory documentation such as privacy and consent audits.

Dp_Consent_Last_Updated Date False

The date when the contact's consent preferences were most recently reviewed or updated for compliance tracking.

Dri_Workflow_Template_Id String False

The Id of the Customer Journey workflow template that is associated with this contact. This field links the contact to guided process flows.

Dri_Workflow_Template_Name String True

The display name of the Customer Journey workflow template that is associated with this contact.

Email String False

The primary email address for the contact, used for direct communication, campaign outreach, or portal account identity.

Email_Addresses_Non_Primary String False

A collection of additional email addresses that are associated with the contact but are not designated as the primary email address.

Email_And_Name1 String False

A formatted reference that combines the contact's name and primary email address for display in messaging or selection fields.

Email_Opt_Out Bool False

A Boolean field that returns a value of 'true' when the contact has opted out of email communications. It returns a value of 'false' when email communication is permitted. This field supports compliance with digital communication regulations.

Email1 String False

The primary email address value that is stored for the contact. This field is typically used internally in messaging workflows.

Email2 String False

A secondary email address for the contact. This field supports alternative communication or account recovery.

Entry_Source String True

The origin of the contact record, indicating whether it was created directly within the SugarCRM application or imported from an external system.

Escrow_Bulletins_C Bool False

A Boolean field that returns a value of 'true' when the contact is subscribed to receive escrow-related bulletins or notifications. It returns a value of 'false' when the contact is not subscribed.

Facebook String False

The contact's Facebook profile name or handle, which can be used for social engagement or identity reference.

First_Name String False

The contact's first name.

Fnf_Agencies_Contacts_1_Name String True

The display name of the associated agency record when the contact is linked through Fidelity National Financial (FNF) organizational relationships.

Fnf_Agencies_Contacts_1fnf_Agencies_Ida String False

The Id of the agency record that is associated with the contact in FNF organizational relationships.

Following Bool False

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

Full_Name String True

The fully formatted name of the contact, typically composed from first name, last name, and any applicable prefixes or suffixes.

General_Bulletins_C Bool False

A Boolean field that returns a value of 'true' when the contact is subscribed to receive general informational bulletins. It returns a value of 'false' when the contact is not subscribed.

Googleplus String False

The contact's Google+ profile Id. This field remains for legacy reference and archival historical data.

Hint_Account_Annual_Revenue String False

The estimated or reported annual revenue for the associated organization, as supplied by Sugar Hint enrichment data.

Hint_Account_Description String False

A descriptive profile summary of the associated organization, as enriched by Sugar Hint.

Hint_Account_Facebook_Handle String False

The Facebook profile handle of the associated account, as provided by Sugar Hint.

Hint_Account_Fiscal_Year_End String False

The fiscal year-end month for the associated organization, as provided by Sugar Hint enrichment data.

Hint_Account_Founded_Year String False

The year in which the associated organization was founded, as supplied by Sugar Hint data enrichment.

Hint_Account_Industry String False

The industry classification of the associated organization, as determined through Sugar Hint data enrichment.

Hint_Account_Location String False

The primary location of the associated organization, as provided by Sugar Hint data enrichment.

Hint_Account_Logo String False

The logo image reference for the associated account, obtained via Sugar Hint data services.

Hint_Account_Naics_Code_Lbl String False

The NAICS classification code that is associated with the organization, provided by Sugar Hint enrichment data.

Hint_Account_Sic_Code_Label String False

The SIC classification code that is associated with the organization, provided by Sugar Hint enrichment data.

Hint_Account_Size String False

The estimated organization size that is based on employee count or operational scale, provided by Sugar Hint enrichment.

Hint_Account_Twitter_Handle String False

The Twitter handle of the associated organization, as retrieved through Sugar Hint.

Hint_Account_Website String False

The public website of the associated organization, as retrieved through Sugar Hint enrichment.

Hint_Contact_Pic String False

The avatar or profile image reference for the contact, provided through Sugar Hint data services.

Hint_Education String False

The primary educational history or degree information that is associated with the contact, as retrieved via Sugar Hint.

Hint_Education_2 String False

Additional educational background data for the contact, also supplied by Sugar Hint enrichment.

Hint_Facebook String False

The contact's Facebook profile Id, as sourced via Sugar Hint enrichment services.

Hint_Industry_Tags String False

Industry-related tags that are associated with the contact as identified by Sugar Hint enrichment. These tags support segmentation and industry-specific analytics.

Hint_Job_2 String False

Additional job role or title information for the contact, as provided by Sugar Hint enrichment.

Hint_Phone_1 String False

An additional phone number that is associated with the contact, sourced from Sugar Hint data enrichment.

Hint_Phone_2 String False

A second additional phone number that is associated with the contact, sourced from Sugar Hint data enrichment.

Hint_Photo String False

A reference to the contact's profile image that is retrieved through Sugar Hint.

Hint_Twitter String False

The contact's Twitter handle or profile Id, sourced via Sugar Hint enrichment.

Id [KEY] String True

The unique Id of the contact record.

Invalid_Email Bool False

A Boolean field that returns a value of 'true' when the primary email address associated with the contact is flagged as invalid. It returns a value of 'false' when the email address is valid and deliverable.

Last_Name String False

The contact's last name or family name.

Lead_Registered_User_C Bool False

A Boolean field that returns a value of 'true' when the contact is recognized as a registered user for lead-related systems or workflows. It returns a value of 'false' when no registration association exists.

Lead_Source String False

The source from which the contact originated (for example,'referral', 'campaign', 'web form submission', or 'internal creation').

Locked_Fields String True

A system-managed list of fields that are restricted from modification. This field preserves data integrity and enforces configuration protections.

M_Accept_Status_Fields String True

A stored representation of acceptance status values for message-related communication events. This field supports user interface rendering and workflow logic.

Market_Interest_Prediction_Score String True

A predictive scoring value that estimates the contact's level of interest or likelihood to engage with offerings.

Market_Score Int True

A numeric score representing activity or engagement strength in market-facing interactions.

Mkto_Id Int True

The Id that identifies the contact within the Marketo marketing automation platform.

Mkto_Lead_Score Int True

The lead scoring value assigned within Marketo based on engagement and behavioral activity.

Mkto_Sync Bool False

A Boolean field that returns a value of 'true' when the contact is configured to synchronize with Marketo. It returns a value of 'false' when the contact is excluded from synchronization.

Modified_By_Name String True

The display name of the user who last modified the contact record.

Modified_User_Id String True

The Id of the user who last modified the contact record.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the contact record is marked as a favorite by the current user. It returns a value of 'false' when the record is not designated as a favorite.

Name String True

The formatted display name of the contact, typically composed from first name, last name, and any applicable prefixes or suffixes.

No_Longer_At_Account_C Bool False

A Boolean field that returns a value of 'true' when the contact is no longer associated with the previously linked account. It returns a value of 'false' when the association remains current.

Opportunity_Role String False

The contact's role in sales or opportunity engagements, (for example, 'decision maker', 'influencer', or 'evaluator'.

Opportunity_Role_Fields String True

A stored representation of role attributes that is applied to the contact during opportunity-related activities.

Opportunity_Role_Id String False

The Id that is associated with the opportunity role linking the contact to opportunity records.

Owner_Only_Bulletins_C Bool False

A Boolean field that returns a value of 'true' when only the record owner should receive bulletins or notifications related to this contact. It returns a value of 'false' when bulletins may apply to a broader audience.

Perform_Sugar_Action Bool False

A Boolean field that returns a value of 'true' when automated Sugar actions can be triggered from workflows that reference this contact. It returns a value of 'false' when automated workflow-triggered actions are disabled.

Phone_Fax String False

The contact's fax number used for document transmission or business communication.

Phone_Home String False

The contact's home phone number.

Phone_Mobile String False

The contact's mobile phone number.

Phone_Other String False

An additional phone number that is associated with the contact.

Phone_Work String False

The contact's work phone number.

Picture String False

A reference to the contact's avatar or profile image that is used in the interface.

Portal_Active Bool False

A Boolean field that returns a value of 'true' when the contact has an active portal account. It returns a value of 'false' when no active portal access is configured.

Portal_App String False

The portal application with which the contact is associated.

Portal_Name String True

The name or username that the contact uses when accessing the portal.

Portal_Password String True

The encrypted or stored password value that is used for portal authentication. This field is typically managed by system processes.

Portal_Password1 String True

A secondary field that stores the portal password for compatibility and system migration purposes. This field is used when older authentication data needs to be preserved or transitioned.

Portal_User_Company_Name String False

The company name that is associated with the contact's portal user profile.

Preferred_Language String False

The preferred language for communication with the contact. This field supports localization and personalized messaging.

Primary_Address_City String False

The city of the contact's primary address.

Primary_Address_Country String False

The country of the contact's primary address.

Primary_Address_Postalcode String False

The postal code of the contact's primary address.

Primary_Address_State String False

The state or region of the contact's primary address.

Primary_Address_Street String False

The street address of the contact's primary address.

Primary_Address_Street_2 String False

The second address line for the contact's primary address, typically used for suite or unit identifiers.

Primary_Address_Street_3 String False

The third address line for the contact's primary address, used when additional address detail is required.

Report_To_Name String True

The display name of the contact to whom this contact reports, typically used in organizational hierarchy relationships.

Reports_To_Id String False

The Id of the contact to whom this contact reports.

Salutation String False

The salutation or greeting prefix that is used when addressing the contact (for example, 'Mr' or 'Ms').

Site_User_Id String True

The Id that associates the contact with a linked site user profile, typically used in portal or multi-site access scenarios.

Source_Id String False

The Id that is associated with the source system from which the contact originated.

Source_Meta String False

Additional metadata that describes the source or import characteristics of the contact record.

Source_Type String False

The classification of the system or data source from which the contact record originated.

Sync_Contact Bool False

A Boolean field that returns a value of 'true' when the contact is configured to synchronize with external mail and scheduling systems such as Outlook. It returns a value of 'false' when synchronization is disabled.

Sync_Key String True

An internal synchronization key that is used to reconcile the contact record across systems or integrations.

Tag String False

Tags that are assigned to the contact record. Tags support categorization, filtering, and search.

Team_Count String False

The number of teams that have access to the contact record.

Team_Id String False

The Id of the primary team that is associated with the contact record.

Team_Name String False

The display name of the primary team that is associated with the contact record.

Team_Set_Id String False

The Id of the team set that grants shared access permissions for the contact record.

Title String False

The professional title or role of the contact within their organization.

Title_Wave_User_C Bool False

A Boolean field that returns a value of 'true' when the contact is associated with TitleWave system features or workflows. It returns a value of 'false' when the contact has no TitleWave association.

Twitter String False

The Twitter handle or profile name of the contact.

Underwriting_Bulletins_C Bool False

A Boolean field that returns a value of 'true' when the contact is subscribed to receive underwriting-related bulletins. It returns a value of 'false' when the contact is not subscribed.

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