JDBC Driver for SugarCRM

Build 22.0.8462

Contacts

Create, update, delete, and query the Contacts module in SugarCRM.

Columns

Name Type ReadOnly Description
My_Favorite Bool False

Whether the record is a favorite for the user.

Following Bool False

Whether the user is following this record.

Id [KEY] String False

The unique identifier for the record.

Name String False

The name of the contact.

Date_Entered Datetime True

The date the record was created.

Date_Modified Datetime True

The date the record was last modified.

Modified_User_Id String True

The Id of the user who last modified the record.

Modified_By_Name String True

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

Created_By String True

The Id of the user who created the record.

Created_By_Name String True

The name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the record.

Description String False

The full text of the note.

Deleted Bool False

Record deletion indicator.

Assigned_User_Id String False

The user Id assigned to the record.

Assigned_User_Name String False

The name of the user assigned to the record.

Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Email String False

The email for the contact.

Email1 String False

The alternate email for the contact.

Email2 String False

The alternate email for the contact.

Invalid_Email Bool False

Whether the contact email has been marked as invalid.

Email_Opt_Out Bool False

Whether the contact has opted out of emails.

Email_Addresses_Non_Primary String False

The nonprimary email addresses for the contact.

Salutation String False

The contact salutation (e.g., Mr. or Ms.).

First_Name String False

The first name of the contact.

Last_Name String False

The last name of the contact.

Full_Name String False

The full name of hte contact.

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 the 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

The contact fax number.

Primary_Address_Street String False

The street address used for the primary address.

Primary_Address_Street_2 String False

The second line of the primary address.

Primary_Address_Street_3 String False

The third line of the primary addrss.

Primary_Address_City String False

The city for the primary address.

Primary_Address_State String False

The state for the primary address.

Primary_Address_Postalcode String False

The postal code for the primary address.

Primary_Address_Country String False

The country for primary address.

Alt_Address_Street String False

The street address for the alternate address.

Alt_Address_Street_2 String False

The second line of the alternate address.

Alt_Address_Street_3 String False

The third line of the alternate address.

Alt_Address_City String False

The city for the alternate address.

Alt_Address_State String False

The state for the alternate address.

Alt_Address_Postalcode String False

The postal code for the alternate address.

Alt_Address_Country String False

The country for the alternate address.

Assistant String False

The name of the assistant of the contact.

Assistant_Phone String False

The phone number of the assistant of the contact.

Picture String False

The avatar for the contact.

Email_And_Name1 String False

The email and name of the contact.

Lead_Source String False

The lead source for the contact.

Account_Name String False

The name of the account associated with the contact.

Account_Id String False

The Id of the account associated with the contact.

Dnb_Principal_Id String False

The unique Id For the D. and B. contact.

Opportunity_Role_Fields String False

The opportunity role fields.

Opportunity_Role_Id String False

The Id of the opportunity role.

Opportunity_Role String False

The opportunity role.

Reports_To_Id String False

The Id of the contact this contact reports to.

Report_To_Name String False

The name of the contact this contact reports to.

Birthdate Datetime False

The birthdate of the contact.

Portal_Name String False

The name as it appears in the portal.

Portal_Active Bool False

Whether this contact is a portal user.

Portal_Password String False

Whether the contact has a portal password.

Portal_Password1 String False

The portal password.

Portal_App String False

The reference to the portal.

Preferred_Language String False

The language for the portal.

Campaign_Id String False

The campaign that generated the lead.

Campaign_Name String False

The first campaign name for Contact.

C_Accept_Status_Fields String False

The call accept status fields.

M_Accept_Status_Fields String False

The meeting accept status fields.

Accept_Status_Id String False

The Id of the accept status.

Accept_Status_Name String False

The name of the accept status.

Accept_Status_Calls String False

The accept status for the call.

Accept_Status_Meetings String False

The accept status for the meeting.

Sync_Contact Bool False

Whether the lead is synced to Outlook.

Mkto_Sync Bool False

Whether the lead is synced to Marketo.

Mkto_Id Int False

The associated Marketo lead Id.

Mkto_Lead_Score Int False

The Marketo lead score.

Deptcat_C String False

The department category.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462