ODBC Driver for SugarCRM

Build 23.0.8839

Contacts

The Contacts table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier

Name String True

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

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

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

Email_And_Name1 String False

Lead_Source String False

How did the contact come about

Account_Name String True

Account_Id String False

Dnb_Principal_Id String False

Unique Id For DB Contact

Opportunity_Role_Fields String True

Opportunity_Role_Id String False

Opportunity_Role String False

Reports_To_Id String False

The contact this contact reports to

Report_To_Name String True

Birthdate Date False

The birthdate of the contact

Portal_Name String True

Name as it appears in the portal

Portal_Active Bool False

Indicator whether this contact is a portal user

Portal_Password String True

Portal_Password1 String True

Portal_App String False

Reference to the portal

Portal_User_Company_Name String False

User company name in the portal

Preferred_Language String False

Cookie_Consent Bool False

Indicator whether this portal user accepts cookies

Cookie_Consent_Received_On Datetime False

Date cookie consent received on

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

Dp_Business_Purpose String True

Business purposes consented for

Dp_Consent_Last_Updated Date False

Date consent last updated

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

The first campaign name for Contact (Meta-data only)

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

Hint_Account_Size String False

Company Size

Hint_Account_Industry String False

Company Industry

Hint_Account_Location String False

Company Location

Hint_Account_Description String False

Company Description

Hint_Job_2 String False

Job 2

Hint_Education String False

Education

Hint_Education_2 String False

Education 2

Hint_Facebook String False

Hint_Twitter String False

Hint_Industry_Tags String False

industry tags

Hint_Account_Founded_Year String False

company founded year

Hint_Account_Facebook_Handle String False

company facebook

Hint_Account_Twitter_Handle String False

company twitter

Hint_Account_Logo String False

company logo

Hint_Contact_Pic String False

Hint Contact logo

Hint_Photo String False

person photo

Hint_Phone_1 String False

extra phone field

Hint_Phone_2 String False

extra phone field

Hint_Account_Website String False

company website

Hint_Account_Naics_Code_Lbl String False

NAICS Code

Hint_Account_Sic_Code_Label String False

SIC Code

Hint_Account_Fiscal_Year_End String False

FY End

Hint_Account_Annual_Revenue String False

Annual Rev

Geocode_Status String True

Sync_Contact Bool False

Synch to outlook? (Meta-Data only)

Market_Interest_Prediction_Score String True

Market_Score Int True

Mkto_Sync Bool False

Should the Lead be synced to Marketo

Mkto_Id Int True

Associated Marketo Lead ID

Mkto_Lead_Score Int True

Entry_Source String True

Determines if a record was created internal to the system or external to the system

Site_User_Id String True

Following Bool False

Is user following this record

My_Favorite Bool False

Favorite for the user

Tag String False

Commentlog String True

Locked_Fields String True

Sync_Key String True

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

Email String False

Email1 String False

Email2 String False

Invalid_Email Bool False

Email_Opt_Out Bool False

Email_Addresses_Non_Primary String False

Source_Id String False

Source_Type String False

Source_Meta String False

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Perform_Sugar_Action Bool False

Hint_Education_C String False

Hint_Facebook_C String False

Hint_Education_2_C String False

Hint_Twitter_C String False

Hint_Job_2_C String False

Hint_Phone_2_C String False

Hint_Phone_1_C String False

Denorm_Account_Name String False

Name of the Company

Purchases_Contacts_1_Name String True

Purchases_Contacts_1purchases_Ida String False

Hint_Account_Annual_Revenue_C String False

Hint_Account_Description_C String False

Hint_Account_Facebook_Handle_C String False

Hint_Account_Fiscal_Year_End_C String False

Hint_Account_Founded_Year_C String False

Hint_Account_Industry_C String False

Hint_Account_Location_C String False

Hint_Account_Logo_C String False

Hint_Account_Naics_Code_Lbl_C String False

Hint_Account_Sic_Code_Label_C String False

Hint_Account_Size_C String False

Hint_Account_Twitter_Handle_C String False

Hint_Account_Website_C String False

Hint_Contact_Pic_C String False

Hint_Industry_Tags_C String False

Hint_Photo_C String False

Latitude_C String False

Longitude_C String False

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