Contact

contact

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Address Book addressbook sublist Yes Yes Yes
Alt. Email altemail email Yes Yes Yes
Assist. Phone assistantphone phone Yes Yes Yes
Assistant assistant select Yes Yes Yes
Bulk Merge bulkmerge sublist Yes Yes Yes
Campaign Category contactsourcecampaigncategory select Yes Yes Yes
Campaign Event contactcampaignevent select Yes Yes Yes
Campaigns campaigns sublist Yes Yes Yes
Category category multiselect Yes Yes Yes
Comments comments textarea Yes Yes Yes
Company company select Yes Yes Yes
Contact is Inactive isinactive checkbox Yes Yes Yes
Date Created datecreated datetime Yes Yes Yes
Default Billing Address defaultbillingaddress select Yes Yes Yes
Default Shipping Address defaultshippingaddress select Yes Yes Yes
Duplicate duplicate checkbox Yes Yes Yes
Email email email Yes Yes Yes
Entity ID entityid text Yes Yes Yes
External ID externalid text Yes Yes Yes
Fax fax phone Yes Yes Yes
First Name firstname text Yes Yes Yes
Furigana phoneticname text Yes Yes Yes
Global Subscription Status globalsubscriptionstatus select Yes Yes Yes
Home Phone homephone phone Yes Yes Yes
Internal ID id integer Yes Yes Yes
Job Title title text Yes Yes Yes
Last Modified Date lastmodifieddate datetime Yes Yes Yes
Last Name lastname text Yes Yes Yes
Lead Source contactsource select Yes Yes Yes
Main Phone phone phone Yes Yes Yes
Middle Name middlename text Yes Yes Yes
Mobile Phone mobilephone phone Yes Yes Yes
Mr./Ms... salutation text Yes Yes Yes
Name/ID entitytitle text Yes Yes Yes
Office Phone officephone phone Yes Yes Yes
Private isprivate checkbox Yes Yes Yes
Subscription Message History subscriptionmessagehistory sublist Yes Yes Yes
Subscriptions subscriptions sublist Yes Yes Yes
Sup. Phone supervisorphone phone Yes Yes Yes
Supervisor supervisor select Yes Yes Yes
User Notes usernotes sublist Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Address to Address (ContactAddressbookEntityAddress.nkey) address (contactaddressbook, contactaddressbook.addressbookaddress) No Yes Yes
Address to Contact (Contact.id) address (contactaddressbook, contactaddressbook.entity) No Yes Yes
Contact to Contact (Contact.id) contact (contact, contact.assistant) No Yes Yes
Bulk Merge to Contact (Contact.id) bulk merge (contactbulkmerge, contactbulkmerge.entity) No Yes Yes
Campaigns to Contact (Contact.id) campaigns (contactcontactcampaigns, contactcontactcampaigns.entityorcontact) No Yes Yes
Contact to Entity (entity.id) contact (contact, contact.company) No Yes Yes
Contact to Campaign Category (campaignCategory.id) contact (contact, contact.contactsourcecampaigncategory) No Yes Yes
Contact to Address (EntityAddress.nkey) contact (contact, contact.defaultbillingaddress) No Yes Yes
Contact to Address (EntityAddress.nkey) contact (contact, contact.defaultshippingaddress) No Yes Yes
Subscription Message History to Contact (Contact.id) subscription message history (contactsubscriptionmessagehistory, contactsubscriptionmessagehistory.recipient) No Yes Yes
Subscription to Contact (Contact.id) subscription (contactsubscriptions, contactsubscriptions.entity) No Yes Yes
Contact to Contact (Contact.id) contact (contact, contact.supervisor) No Yes Yes