JDBC Driver for SugarCRM

Build 23.0.8839

Users

The Users table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

User_Name String False

User_Hash String True

System_Generated_Password Bool False

Pwd_Last_Changed Datetime False

Authenticate_Id String False

Sugar_Login Bool False

Picture String False

First_Name String False

Last_Name String False

Full_Name String True

Name String True

Is_Admin Bool False

External_Auth_Only Bool False

Receive_Notifications Bool False

Send_Email_On_Mention Bool False

Description String False

Date_Entered Datetime False

Date_Modified Datetime False

Last_Login Datetime True

Modified_User_Id String True

Modified_By_Name String True

Created_By String True

Created_By_Name String True

Title String False

Department String False

Phone_Home String False

Phone_Mobile String False

Phone_Work String False

Phone_Other String False

Phone_Fax String False

Status String False

Address_Street String False

Address_City String False

Address_State String False

Address_Country String False

Address_Postalcode String False

Usertype String False

License_Type String False

Default_Team String False

Team_Id String False

Team_Set_Id String False

Acl_Team_Set_Id String False

Business_Center_Name String True

The name of the business center represented by the business_center_id field

Business_Center_Id String False

The business center to which the case is associated

Team_Count String False

Team_Name String False

Deleted Bool False

Portal_Only Bool False

Show_On_Employees Bool False

Employee_Status String False

Messenger_Id String False

Messenger_Type String False

Reports_To_Id String False

Reports_To_Name String True

Email1 String False

Email String False

Email_Link_Type String False

Is_Group Bool False

C_Accept_Status_Fields String True

M_Accept_Status_Fields String True

Accept_Status_Id String False

Accept_Status_Name String False

Accept_Status_Calls String False

Accept_Status_Meetings String False

Accept_Status_Messages String False

Preferred_Language String False

Acl_Role_Set_Id String False

Site_User_Id String True

Cookie_Consent Bool False

Indicator whether this user accepts cookies

Cookie_Consent_Received_On Datetime False

Date cookie consent received on

Sync_Key String True

Customer_Journey_Access Bool True

Customer_Journey_Last_Active Datetime True

Previously_Licensed_C Bool False

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