SSIS Components for SugarCRM

Build 24.0.9062

Contacts

The Contacts table.

Columns

Name Type ReadOnly Description
Accept_Status_Calls String False

Accept_Status_Id String False

Accept_Status_Meetings String False

Accept_Status_Messages String False

Accept_Status_Name String False

Account_Id String False

Account_Name String True

Accounting_Bulletins_C Bool False

Acl_Team_Names String True

Acl_Team_Set_Id String False

Alt_Address_City String False

City for alternate address

Alt_Address_Country String False

Country for alternate address

Alt_Address_Postalcode String False

Postal code for alternate address

Alt_Address_State String False

State for alternate address

Alt_Address_Street String False

Street address for alternate address

Alt_Address_Street_2 String False

Alt_Address_Street_3 String False

Assigned_User_Id String False

User ID assigned to record

Assigned_User_Name String True

Assistant String False

Name of the assistant of the contact

Assistant_Phone String False

Phone number of the assistant of the contact

Birthdate Date False

The birthdate of the contact

Business_Center_Id String False

The business center to which the case is associated

Business_Center_Name String True

The name of the business center represented by the business_center_id field

C_Accept_Status_Fields String True

Campaign_Id String False

Campaign that generated lead

Campaign_Name String True

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

Commentlog String True

Contact_Type_C String False

Contactid_C String False

Cookie_Consent Bool False

Indicator whether this portal user accepts cookies

Cookie_Consent_Received_On Datetime False

Date cookie consent received on

Created_By String True

User who created record

Created_By_Name String True

Date_Entered Datetime True

Date record created

Date_Modified Datetime True

Date record last modified

Day_Of_Birth_Yr_Optional_C String False

Deleted Bool False

Record deletion indicator

Department String False

The department of the contact

Description String False

Full text of the note

Dnb_Principal_Id String False

Unique Id For DB Contact

Do_Not_Call Bool False

An indicator of whether contact can be called

Dp_Business_Purpose String True

Business purposes consented for

Dp_Consent_Last_Updated Date False

Date consent last updated

Dri_Workflow_Template_Id String False

Dri_Workflow_Template_Name String True

Email String False

Email_Addresses_Non_Primary String False

Email_And_Name1 String False

Email_Opt_Out Bool False

Email1 String False

Email2 String False

Entry_Source String True

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

Escrow_Bulletins_C Bool False

Facebook String False

The facebook name of the user

First_Name String False

First name of the contact

Fnf_Agencies_Contacts_1_Name String True

Fnf_Agencies_Contacts_1fnf_Agencies_Ida String False

Following Bool False

Is user following this record

Full_Name String True

General_Bulletins_C Bool False

Googleplus String False

The google plus id of the user

Hint_Account_Annual_Revenue String False

Annual Rev

Hint_Account_Description String False

Company Description

Hint_Account_Facebook_Handle String False

company facebook

Hint_Account_Fiscal_Year_End String False

FY End

Hint_Account_Founded_Year String False

company founded year

Hint_Account_Industry String False

Company Industry

Hint_Account_Location String False

Company Location

Hint_Account_Logo String False

company logo

Hint_Account_Naics_Code_Lbl String False

NAICS Code

Hint_Account_Sic_Code_Label String False

SIC Code

Hint_Account_Size String False

Company Size

Hint_Account_Twitter_Handle String False

company twitter

Hint_Account_Website String False

company website

Hint_Contact_Pic String False

Hint Contact logo

Hint_Education String False

Education

Hint_Education_2 String False

Education 2

Hint_Facebook String False

Hint_Industry_Tags String False

industry tags

Hint_Job_2 String False

Job 2

Hint_Phone_1 String False

extra phone field

Hint_Phone_2 String False

extra phone field

Hint_Photo String False

person photo

Hint_Twitter String False

Id [KEY] String True

Unique identifier

Invalid_Email Bool False

Last_Name String False

Last name of the contact

Lead_Registered_User_C Bool False

Lead_Source String False

How did the contact come about

Locked_Fields String True

M_Accept_Status_Fields String True

Market_Interest_Prediction_Score String True

Market_Score Int True

Mkto_Id Int True

Associated Marketo Lead ID

Mkto_Lead_Score Int True

Mkto_Sync Bool False

Should the Lead be synced to Marketo

Modified_By_Name String True

Modified_User_Id String True

User who last modified record

My_Favorite Bool False

Favorite for the user

Name String True

No_Longer_At_Account_C Bool False

Opportunity_Role String False

Opportunity_Role_Fields String True

Opportunity_Role_Id String False

Owner_Only_Bulletins_C Bool False

Perform_Sugar_Action Bool False

Phone_Fax String False

Contact fax number

Phone_Home String False

Home phone number of the contact

Phone_Mobile String False

Mobile phone number of the contact

Phone_Other String False

Other phone number for the contact

Phone_Work String False

Work phone number of the contact

Picture String False

Avatar

Portal_Active Bool False

Indicator whether this contact is a portal user

Portal_App String False

Reference to the portal

Portal_Name String True

Name as it appears in the portal

Portal_Password String True

Portal_Password1 String True

Portal_User_Company_Name String False

User company name in the portal

Preferred_Language String False

Primary_Address_City String False

City for primary address

Primary_Address_Country String False

Country for primary address

Primary_Address_Postalcode String False

Postal code for primary address

Primary_Address_State String False

State for primary address

Primary_Address_Street String False

The street address used for primary address

Primary_Address_Street_2 String False

Primary_Address_Street_3 String False

Report_To_Name String True

Reports_To_Id String False

The contact this contact reports to

Salutation String False

Contact salutation (e.g., Mr, Ms)

Site_User_Id String True

Source_Id String False

Source_Meta String False

Source_Type String False

Sync_Contact Bool False

Synch to outlook? (Meta-Data only)

Sync_Key String True

Tag String False

Team_Count String False

Team_Id String False

Team ID for the account

Team_Name String False

Team_Set_Id String False

Title String False

The title of the contact

Title_Wave_User_C Bool False

Twitter String False

The twitter name of the user

Underwriting_Bulletins_C Bool False

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