ODBC Driver for SugarCRM

Build 24.0.9062

ExternalUsers

The ExternalUsers table.

Columns

Name Type ReadOnly Description
Salutation String False

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

First_Name String False

First name of the contact

Last_Name String False

Last name of the contact

Name String False

Full_Name String True

Title String False

The title of the contact

Facebook String False

The facebook name of the user

Twitter String False

The twitter name of the user

Googleplus String False

The google plus id of the user

Department String False

The department of the contact

Do_Not_Call Bool False

An indicator of whether contact can be called

Phone_Home String False

Home phone number of the contact

Phone_Mobile String False

Mobile phone number of the contact

Phone_Work String False

Work phone number of the contact

Phone_Other String False

Other phone number for the contact

Phone_Fax String False

Contact fax number

Primary_Address_Street String False

The street address used for primary address

Primary_Address_Street_2 String False

Primary_Address_Street_3 String False

Primary_Address_City String False

City for primary address

Primary_Address_State String False

State for primary address

Primary_Address_Postalcode String False

Postal code for primary address

Primary_Address_Country String False

Country for primary address

Alt_Address_Street String False

Street address for alternate address

Alt_Address_Street_2 String False

Alt_Address_Street_3 String False

Alt_Address_City String False

City for alternate address

Alt_Address_State String False

State for alternate address

Alt_Address_Postalcode String False

Postal code for alternate address

Alt_Address_Country String False

Country for alternate address

Assistant String False

Name of the assistant of the contact

Assistant_Phone String False

Phone number of the assistant of the contact

Picture String False

Avatar

Id [KEY] String False

Unique identifier

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Modified_User_Id String True

User who last modified record

Modified_By_Name String True

Created_By String True

User who created record

Created_By_Name String True

Description String False

Full text of the note

Deleted Bool False

Record deletion indicator

User_Name String False

Username of the external user

Status String False

Status of the external user

External_App String False

External application which creates the external user

External_Id String False

External id of the external user

Contact_Name String True

Contact_Id String False

Contact ID the external user is associated with

Email String False

Email1 String False

Email2 String False

Invalid_Email Bool False

Email_Opt_Out Bool False

Email_Addresses_Non_Primary String False

Tag String False

Source_Id String False

Source_Type String False

Source_Meta String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Commentlog String True

Locked_Fields String True

Sync_Key String True

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