Entity

Internal ID: entity

Search Joins

Join ID	Join Description	Actual Join Name
campaignresponse	Campaign Response	Campaign
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message
user	User	Employee

Search Filters

Internal ID	Type	Label
address	textarea	Address
addressee	text	Addressee
addresslabel	text	Address Label
addressphone	phone	Address Phone
attention	text	Attention
city	text	City
comments	textarea	Comments
country	select	Country
county	text	County/State
datecreated	datetime	Date Created
email	text	Email
entityid	text	Name/ID
externalid	select	External ID
externalidstring	text	External ID (Text)
fax	phone	Fax
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
image	image	Image
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
language	select	Language
lastmodifieddate	datetime	Last Modified
level	select	Level
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
representingsubsidiary	select	Represents Subsidiary
state	select	State/Province
subsidiary	select	Subsidiary
type	select	Entity Type
zipcode	text	Zip

Search Columns

Internal ID	Type	Label
address	text	Address
address1	text	Address 1
address2	text	Address 2
address3	text	Address 3
addressee	text	Addressee
addressinternalid	text	Address Internal ID
addresslabel	text	Address Label
addressphone	text	Address Phone
altemail	email	Alt. Email
altname	text	Name
altphone	phone	Office Phone
attention	text	Attention
billaddress1	text	Billing Address 1
billaddress2	text	Billing Address 2
billaddress3	text	Billing Address 3
billaddressee	text	Billing Addressee
billattention	text	Billing Attention
billcity	text	Billing City
billcountry	select	Billing Country
billcountrycode	text	Billing Country Code
billphone	text	Billing Phone
billstate	select	Billing State/Province
billzipcode	text	Billing Zip
city	text	City
comments	text	Comments
country	select	Country
countrycode	text	Country Code
datecreated	datetime	Date Created
email	email	Email
entityid	text	Name
entitynumber	integer	Number
externalid	select	External ID
fax	text	Fax
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
globalsubscriptionstatus	select	Global Subscription Status
image	select	Image
internalid	select	Internal ID
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isinactive	checkbox	Inactive
language	select	Language
lastmodifieddate	datetime	Last Modified
lastviewed	datetime	Last Viewed
level	select	Level
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
representingsubsidiary	select	Represents Subsidiary
shipaddress1	text	Shipping Address 1
shipaddress2	text	Shipping Address 2
shipaddress3	text	Shipping Address 3
shipaddressee	text	Shipping Addressee
shipattention	text	Shipping Attention
shipcity	text	Shipping City
shipcountry	select	Shipping Country
shipcountrycode	text	Shipping Country Code
shipphone	text	Shipping Phone
shipstate	text	Shipping State/Province
shipzip	text	Shipping Zip
state	select	State/Province
statedisplayname	select	State/Province Display Name
subscription	select	Subscription
subscriptiondate	datetime	Subscription Date
subscriptionstatus	checkbox	Subscription Status
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
type	select	Type
zipcode	text	Zip Code