Power BI Connector for SugarCRM

Build 25.0.9454

ExternalUsers

Stores external portal user identities. This table supports partner, customer, or outside-user access to portal-based functionality.

Columns

Name Type ReadOnly Description
Salutation String False

The salutation used for this external user (for example, 'Mr', 'Ms', 'Dr', or another formal greeting). This value is commonly displayed in communication and name formatting contexts.

First_Name String False

The first name of the external user. This value is used in display formatting and communication.

Last_Name String False

The last name of the external user. This value is used in searching, sorting, and formal reference.

Name String False

The formatted full name of the external user. This value is typically presented as First Name Last Name and is used in list displays and record headers.

Full_Name String True

The combined full legal name of the external user. This value is used for reporting, identity verification, and UI presentation.

Title String False

The job title or professional designation of the external user. This value helps identify role or responsibility when interacting across systems.

Facebook String False

The external user's associated Facebook handle or profile reference. This value supports social media linkage where applicable.

Twitter String False

The external user's associated Twitter handle. This value supports social media engagement or identity matching.

Googleplus String False

The external user's associated Google Plus identifier (Id). This value can be present in legacy integrations.

Department String False

The department or organizational division that is associated with the external user. This value is used for grouping and reporting.

Do_Not_Call Bool False

A Boolean field that returns a value of 'true' when the external user has requested not to be contacted by phone. It returns a value of 'false' when phone contact is permitted.

Phone_Home String False

The home phone number of the external user, if it is provided.

Phone_Mobile String False

The mobile phone number of the external user. This value is often used for direct outreach or SMS-based communication.

Phone_Work String False

The work phone number of the external user, typically associated with their business or professional role.

Phone_Other String False

An additional alternative phone number for the external user that does not fall under standard categories.

Phone_Fax String False

The fax number associated with the external user, where fax communication is still in use.

Primary_Address_Street String False

The street line of the external user's primary mailing address.

Primary_Address_Street_2 String False

The second street line of the external user's primary mailing address, if it is required.

Primary_Address_Street_3 String False

The third street line of the external user's primary mailing address, if it is required.

Primary_Address_City String False

The city associated with the external user's primary address.

Primary_Address_State String False

The state or province that is associated with the external user's primary address.

Primary_Address_Postalcode String False

The postal code that is associated with the external user's primary address.

Primary_Address_Country String False

The country that is associated with the external user's primary address.

Alt_Address_Street String False

The street line of the external user's alternate mailing address.

Alt_Address_Street_2 String False

The second street line for the external user's alternate address, if it is applicable.

Alt_Address_Street_3 String False

The third street line for the external user's alternate address, if it is applicable.

Alt_Address_City String False

The city that is associated with the external user's alternate address.

Alt_Address_State String False

The state or province that is associated with the external user's alternate address.

Alt_Address_Postalcode String False

The postal code that is associated with the external user's alternate address.

Alt_Address_Country String False

The country that is associated with the external user's alternate address.

Assistant String False

The name of the external user's assistant, if it is applicable. This value can be used for communication or scheduling coordination.

Assistant_Phone String False

The phone number for the external user's assistant, when provided.

Picture String False

The reference to the external user's profile image or avatar. This value generally points to a stored file resource.

Id [KEY] String False

The unique Id of this external user record. The system uses this Id to reference and manage the record internally.

Date_Entered Datetime True

The date and time when the external user record was created. This timestamp supports auditing and chronological analysis.

Date_Modified Datetime True

The date and time when the external user record was last updated. This value supports change tracking.

Modified_User_Id String True

The unique Id of the user who last modified this external user record. This value supports audit and ownership review.

Modified_By_Name String True

The display name of the user who last modified this external user record. This value is shown in UI displays for context.

Created_By String True

The unique Id of the user who created this external user record. This value documents record origin.

Created_By_Name String True

The display name of the user who created this external user record. This value appears in administrative views.

Description String False

A detailed narrative note or context statement about the external user. This field is often used for relationship or account history notes.

Deleted Bool False

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

User_Name String False

The username that is associated with this external user. This value is used for authentication into linked portal or external systems.

Status String False

The current status of the external user within the system (for example, 'Active' or 'Inactive'). This status influences authentication and visibility.

External_App String False

The external application that created or manages this external user record. This value is used in integration mapping.

External_Id String False

The Id that is assigned to the external user by the external application. This Id is used to match records across systems.

Contact_Name String True

The display name of the related contact that is associated with this external user. This value is used for UI visibility and relationship context.

Contact_Id String False

The unique Id of the contact that is associated with this external user. This relationship links the external user back to CRM contact records.

Email String False

The email address that is associated with this external user. This value is used for communication and messaging workflows.

Email1 String False

An additional email address that is associated with this external user. This field allows multiple communication channels to be stored.

Email2 String False

A second supplemental email address that is associated with this external user, when needed for alternate correspondence.

Invalid_Email Bool False

A Boolean field that returns a value of 'true' when the email address for the external user is flagged as invalid. It returns a value of 'false' when the email address is recognized as deliverable.

Email_Opt_Out Bool False

A Boolean field that returns a value of 'true' when the external user has opted out of email communications. It returns a value of 'false' when email messaging is allowed.

Email_Addresses_Non_Primary String False

Additional non-primary email addresses that are associated with the external user. This field stores secondary communication channels.

Tag String False

The tags that are associated with this external user for search, classification, and filtering.

Source_Id String False

The Id that indicates where the external user originated. This value supports data source tracking in multi-system environments.

Source_Type String False

The type of external data source from which the external user record originated (for example, 'import', 'API', or 'portal registration').

Source_Meta String False

Metadata or supplemental information about the external data source. This value helps interpret how the record was created.

Assigned_User_Id String False

The Id of the user who is responsible for managing or maintaining this external user record.

Assigned_User_Name String True

The display name of the user who is assigned responsibility for this external user record.

Team_Id String False

The Id of the primary team that is associated with this external user record. The primary team defines default access controls.

Team_Set_Id String False

The Id of the team set that is assigned to this external user record. The team set defines the full list of teams with access to view or modify the record.

Acl_Team_Set_Id String False

The Id of the Access Control List (ACL) team set that determines which role-based permissions apply to this external user record.

Team_Count String False

The number of teams that are associated with this external user record. This value helps evaluate collaboration scope.

Team_Name String False

The display name of the primary team that is associated with this external user record. This value appears in assignment and filtering user interfaces.

Acl_Team_Names String True

The list of team names that are associated with this record for access control and collaboration visibility.

Following Bool False

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

My_Favorite Bool False

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

Commentlog String True

The log of comments and discussion history that is associated with this external user record. This field is commonly used to support collaboration and decision documentation.

Locked_Fields String True

The list of fields on this external user record that are restricted from being edited. Locked fields are used to preserve data accuracy or compliance.

Sync_Key String True

The synchronization key that is used to align this external user record with external systems or integration pipelines. This key supports cross-system record matching.

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