JDBC Driver for SugarCRM

Build 22.0.8462

Prospects

Create, update, delete, and query the Prospects 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 of the record.

Name String False

The name of the prospect.

Date_Entered Datetime True

Date the record was created.

Date_Modified Datetime True

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 user name of the user who created the record.

Doc_Owner String False

The document owner.

User_Favorites String False

The user favorites for the prospect.

Description String False

Full text of the note.

Deleted Bool False

Record deletion indicator.

Assigned_User_Id String False

User Id assigned to the record.

Assigned_User_Name String False

The user 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 prospect.

Email1 String False

The alternate email for the prospect.

Email2 String False

The alternate email for the prospect.

Invalid_Email Bool False

Whether the prospect email has been marked as invalid.

Email_Opt_Out Bool False

Whether the prospect has opted out of radio.

Email_Addresses_Non_Primary String False

The nonprimary email addresses for the prospect.

Salutation String False

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

First_Name String False

The first name of the prospect.

Last_Name String False

The last name of the prospect.

Full_Name String False

The full name of hte prospect.

Title String False

The title of the prospect.

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 prospect.

Do_Not_Call Bool False

An indicator of whether the prospect can be called.

Phone_Home String False

Home phone number of the prospect.

Phone_Mobile String False

Mobile phone number of the prospect.

Phone_Work String False

Work phone number of the prospect.

Phone_Other String False

Other phone number for the prospect.

Phone_Fax String False

The prospect 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 the 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 prospect.

Assistant_Phone String False

The phone number of the assistant of the prospect.

Picture String False

The picture for the prospect.

Tracker_Key Int True

The key for the associated tracker.

Birthdate Datetime False

The birthdate of the prospect.

Lead_Id String False

The Id of the associated lead.

Account_Name String False

The name of the associated acocunt.

Campaign_Id String False

Campaign that generated the lead.

Dnb_Principal_Id String False

The Id for the D. and B. Contact.

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