contact
The contact table.
Columns
Name | Type | References | Description |
id [KEY] | Integer | Internal ID | |
altemail | String | Alt. Email | |
assistant | String | Assistant | |
category | String | Category | |
comments | String | Comments | |
company | String | Company | |
contactcampaignevent | String | Campaign Event | |
contactsource | String | Lead Source | |
contactsourcecampaigncategory | String | Campaign Category | |
datecreated | Date | Date Created | |
defaultbillingaddress | String | Default Billing Address | |
defaultshippingaddress | String | Default Shipping Address | |
duplicate | Boolean | Duplicate | |
String | |||
entityid | String | Entity ID | |
entitytitle | String | Name/ID | |
externalid | String | External ID | |
firstname | String | First Name | |
globalsubscriptionstatus | String | Global Subscription Status | |
isinactive | Boolean | Contact is Inactive | |
isprivate | Boolean | Private | |
lastmodifieddate | Date | Last Modified Date | |
lastname | String | Last Name | |
middlename | String | Middle Name | |
phoneticname | String | Furigana | |
salutation | String | Mr./Ms... | |
title | String | Job Title |