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

ODBC Driver for SugarCRM

ExternalUsers

Columns