Contacts

Create, update, delete, and query the contacts in SuiteCRM

Table Specific Information

Select

You can query the Contacts table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Contacts WHERE Title LIKE 'PhD'

Insert

Create a Contact by specifying any writable column.

INSERT INTO Contacts ([First name], [Last name]) VALUES ('Heisen', 'Schulz')

Update

You can update any Contact column that is writable, by specifying the Id.

UPDATE Contacts SET Home = '004284294' WHERE Id = 'Test123'

Delete

Delete a Contact by specifying the Id.

DELETE FROM Contacts WHERE Id = 10003

Columns


Name	Type	ReadOnly	Description
ID [KEY]	String	False	The unique identifier for the record.
AcceptStatus	String	True	Id of the event status
AcceptStatusC	String	True	The call accept status fields.
AcceptStatusId	String	True	The Id of the accept status.
AcceptStatusM	String	True	The meeting accept status fields.
AcceptStatusName	String	True	The name of the accept status.
AccountDisabled	Bool	False	Whether the portal account has been disabled for the contact.
AccountID	String	True	The Id of the account associated with the contact.
AccountName	String	True	The name of the account associated with the contact.
Address	String	True	Address from Google Maps of the contact.
AlternateAddressCity	String	False	The city for the alternate address.
AlternateAddressCountry	String	False	The country for the alternate address.
AlternateAddressPostal_Code	String	False	The postal code for the alternate address.
AlternateAddressState	String	False	The state for the alternate address.
AlternateAddressStreet	String	False	The street address for the alternate address.
AlternateAddressStreet2	String	True	The second line of the alternate address.
AlternateAddressStreet3	String	True	The third line of the alternate address.
AnyEmail	String	True	The email for the contact.
Assignedto	String	True	The name of the user assigned to the record.
AssignedUser	String	False	The user Id assigned to the record.
Assistant	String	False	The name of the assistant of the contact.
AssistantPhone	String	False	The phone number of the assistant of the contact.
Birthdate	Date	False	The birthdate of the contact.
Campaign	String	False	The first campaign name for Contact.
CampaignID	String	False	The campaign that generated the lead.
CreatedById	String	False	The Id of the user who created the record.
CreatedByName	String	False	The name of the user who created the record.
DateCreated	Datetime	False	The date the record was created.
DateModified	Datetime	False	The date the record was last modified.
Deleted	Bool	False	Record deletion indicator.
Department	String	False	The department of the contact.
Description	String	False	The full text of the note.
DoNotCall	Bool	False	An indicator of whether the contact can be called.
Email	String	True	The email and name of the contact.
EmailAddress	String	False	The alternate email for the contact.
EmailOptOut	Bool	True	Whether the contact has opted out of emails.
Fax	String	False	The contact fax number.
FirstName	String	False	The first name of the contact.
Fullname	String	True	The full name of hte contact.
GeocodeStatus	String	True	Geocode from Google Maps of the contact.
Home	String	False	Home phone number of the contact.
InvalidEmail	Bool	True	Whether the contact email has been marked as invalid.
JoomlaAccountID	String	False	Id of the contact's Joomla account.
LastName	String	False	The last name of the contact.
Latitude	Double	True	Latitude from Google Maps of the contact.
LBL_CONT_ACCEPT_STATUS	String	True	The event accept status fields.
LBL_CONT_INVITE_STATUS	String	True	The event invite status fields.
LBL_JOOMLA_ACCOUNT_ACCESS	String	True	Access point for the contact's Joomla account.
LBL_LIST_ACCEPT_STATUS_EVENT	String	True	Accept status for the event
LBL_LIST_INVITE_STATUS	String	True	Id for the event invite
LBL_LIST_INVITE_STATUS_EVENT	String	True	Invite status of the event
LeadSource	String	False	The lead source for the contact.
Longitude	Double	True	Longitude from Google Maps of the contact.
Mobile	String	False	Mobile phone number of the contact.
ModifiedById	String	False	The Id of the user who last modified the record.
ModifiedByName	String	True	The user name of the user who last modified the record.
Name	String	True	The name of the contact.
NonPrimaryEmails	String	True	The nonprimary email addresses for the contact.
OfficePhone	String	False	Work phone number of the contact.
OpportunityRole	String	True	The opportunity role.
OpportunityRoleFields	String	True	The opportunity role fields.
OpportunityRoleID	String	True	The Id of the opportunity role.
OtherEmail	String	True	The alternate email for the contact.
OtherPhone	String	False	Other phone number for the contact.
Photo	String	False	The avatar for the contact.
PortalUserType	String	False	Type of the contact's portal account.
PrimaryAddressCity	String	False	The city for the primary address.
PrimaryAddressCountry	String	False	The country for primary address.
PrimaryAddressPostalCode	String	False	The postal code for the primary address.
PrimaryAddressState	String	False	The state for the primary address.
PrimaryAddressStreet	String	False	The street address for the alternate address.
PrimaryAddressStreet2	String	True	The second line of the alternate address.
PrimaryAddressStreet3	String	True	The third line of the alternate address.
ReportsTo	String	True	The name of the contact this contact reports to.
ReportstoID	String	False	The Id of the contact this contact reports to.
Salutation	String	False	The contact salutation (e.g., Mr. or Ms.).
SynctoOutlook_reg_	Bool	True	Whether the lead is synced to Outlook.
Title	String	False	The title of the contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Rows@Next	String	Identifier for the next page of results. Do not set this value manually.

ODBC Driver for SuiteCRM