"SimplePerson"

• 63 minutes to read

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.SimplePersonsProvider inside NetServer's SODatabase assembly.

Supported Entities

Name	Description
"person"	Contact

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool	GetAll: Get all rows of archive - use with care, you may be fetching the whole database
getNoRows	bool	GetNone: Do not get any rows from the archive
personId	int	DB ID: Displays the database ID of a contact	x
firstName	string	First name: Displays the contact's first name	x
lastName	string	Last name: Displays the contact's last name	x
middleName	string	Middle name: Displays the contact's middle name.	x
fullName	stringorPK	Contact: Displays the contact to which an item is linked	x
fullNameWithContact	None	Contact and company: The fully formatted contact name, and full company name	x
contactId	int	Company ID: Database ID of company	x
hasInfoText	bool	Has note: Displays an icon indicating if there is additional information available about the contact	x
hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests	x
personHasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests	x
mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
position	listAny	Position	x
personNumber	string	Number: Displays the contact's number	x
title	string	Title: Displays the contact's job title	x
personCountry	listAny	Country: Country	x
personNoMail	bool	No Mailings: Displays the contact's No Mailings checkbox	x
rank	int	Rank: Displays a contact's current rank	x
birthdate	None	Birthdate: Displays the contact's date of birth
associateType	None	User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading.
useAsMailingAddress	bool	Use as postal address: Use as postal address	x
personSource	listAny	Source: Source (Contact)	x
retired	bool	Former employee: Indicates whether the contact has retired/left the company	x
birthYear	int	Birth year: Displays contact's birth year	x
birthMonth	int	Birth month: Displays contact's birth month	x
birthDay	int	Birth day: Displays contact's birth day (day of month)	x
kanaFirstName	string	First name, kana: Contact's first name, in kana alphabet	x
kanaLastName	string	Last name, kana: Contact's last name, in kana alphabet	x
personUpdatedBy	associate	Updated by: The user who last updated the data	x
personUpdatedDate	date	Updated: The date/time the data was last updated in UTC.	x
personRegisteredBy	associate	Registered by: The user who registered the data	x
personRegisteredDate	date	Registered date: The date/time the data was registered in UTC.	x
portraitThumbnail	None	Person image: Person image
personActiveErpLinks	bool	ERP connected: Is there an active ERP Sync?	x
ticketPriority	listAny	Service priority: Default service priority for this contact	x
supportLanguage	listAny	Preferred language: Preferred language used for reply templates and more	x
supportAssociate	associate	Our service contact: Default service contact for this contact	x
personAssociateId	associate	Our contact: Displays our contact	x
personCategory	listAny	Category	x
personBusiness	listAny	Business	x
personDeletedDate	datetime	Deleted date: Deleted date
hasCompany	bool	Has company: The contact is associated with a company	x
isProjectMember	bool	Is project member: This person is a project member	x
isStakeholder	bool	Is stakeholder: This person is a sale stakeholder	x
phone/formattedNumber	string	Phone : Displays phone number
personDirectPhone/formattedNumber	string	Direct - Phone: Displays phone number
personDirectPhone/description	string	Direct - Description: Phone number description	x
personMobilePhone/formattedNumber	string	Mobile - Phone: Displays phone number
personMobilePhone/description	string	Mobile - Description: Phone number description	x
personPrivate/formattedNumber	string	Private - Phone: Displays phone number
personPrivate/description	string	Private - Description: Phone number description	x
personPager/formattedNumber	string	Other - Phone: Displays phone number
personPager/description	string	Other - Description: Phone number description	x
personDirectFax/formattedNumber	string	Fax - Phone: Displays phone number
personDirectFax/description	string	Fax - Description: Phone number description	x
searchPhone/formattedNumber	string	Phone : Displays phone number
searchPhone/description	string	Description: Phone number description	x
personInfo/textId	int	Text ID	x
personInfo/infoText	positiveString	Information: Displays the text entered in the description field	x
email/emailProtocol	string	Protocol: E-mail protocol, such as SMTP	x
email/emailAddress	string	E-mail	x
email/emailDescription	string	Description	x
email/emailId	int	ID	x
email/emailLastSent	datetime	Last sent: The date and time an e-mail was last sent to this address	x
email/emailBounceCount	int	Bounce count: Bounce count for this e-mail address	x
email/emailLastBounce	datetime	Last bounce: Date and time for last bounce to this e-mail address	x
email/emailHasBounced	bool	Has bounced: This checkbox is active if delivery to this e-mail address has failed.	x
personUrl/URLAddress	string	URL	x
personUrl/URLDescription	string	Description	x
personAddress/addressId	int	Contact address - Address ID: Database ID for the address record	x
personAddress/line1	string	Contact address - Address 1: First line of the address	x
personAddress/line2	string	Contact address - Address 2: Second line of the address	x
personAddress/line3	string	Contact address - Address 3: Third line of the address	x
personAddress/county	string	Contact address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
personAddress/city	string	Contact address - City: This criterion corresponds to the City field on the Company card.	x
personAddress/zip	string	Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
personAddress/state	string	Contact address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
personAddress/wgs84latitude	decimal	Contact address - Latitude: Latitude	x
personAddress/wgs84longitude	decimal	Contact address - Longitude: Longitude	x
personAddress/formattedAddress	None	Contact address - {formattedAddress}: {formattedAddress}
personAddress/formattedMultiLineAddress	None	Contact address - {formattedAddress}: {formattedAddress}
restrictionAddress/addressId	int	Search address - Address ID: Database ID for the address record	x
restrictionAddress/line1	string	Search address - Address 1: First line of the address	x
restrictionAddress/line2	string	Search address - Address 2: Second line of the address	x
restrictionAddress/line3	string	Search address - Address 3: Third line of the address	x
restrictionAddress/county	string	Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
restrictionAddress/city	string	Search address - City: This criterion corresponds to the City field on the Company card.	x
restrictionAddress/zip	string	Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
restrictionAddress/state	string	Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
restrictionAddress/wgs84latitude	decimal	Search address - Latitude: Latitude	x
restrictionAddress/wgs84longitude	decimal	Search address - Longitude: Longitude	x
restrictionAddress/formattedAddress	None	Search address - {formattedAddress}: {formattedAddress}
restrictionAddress/formattedMultiLineAddress	None	Search address - {formattedAddress}: {formattedAddress}
personInterestIds	listInterest	Contact interest: This criterion corresponds to a contact's interests. It is available via the Contact dialog's Interests tab.
personUdef/SuperOffice:1	string	contactshorttext: tooltipshorttext	x
personUdef/SuperOffice:2	string	contactlongtext: tooltiplongtext	x
personUdef/SuperOffice:3	int	contactnumber	x
personUdef/SuperOffice:4	date	contactdate	x
personUdef/SuperOffice:5	unlimitedDate	contactunlimiteddate: tooltipunlimiteddate	x
personUdef/SuperOffice:6	bool	contactcheckbox	x
personUdef/SuperOffice:7	listAny	contactdropdownlistbox	x
personUdef/SuperOffice:8	decimal	contactdecimal	x
personUdef/SuperOffice:9	string	page1saleonly	x
personUdef/SuperOffice:10	string	page1marketingonly	x
personUdef/SuperOffice:11	string	page1adminonly	x
personAssociate/firstName	string	First name: Displays the contact's first name	x
personAssociate/lastName	string	Last name: Displays the contact's last name	x
personAssociate/middleName	string	Middle Name : Displays the contact's middle name.	x
personAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
personAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
personAssociate/personId	int	Contact ID: Database ID of the contact row
personAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
personAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
personAssociate/associateDbId	associate	ID	x
personAssociate/contactName	string	Owning company: Name of the company the user belongs to	x
personAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
personAssociate/usergroup	userGroup	Primary group: The user's primary user group	x
personAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
personAssociate/contactCategory	listAny	Category: Category	x
personAssociate/role	listAny	Role : Role	x
personAssociate/assocName	associate	User ID : User ID	x
personAssociate/assocTooltip	string	Description : Description
personAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
personAssociate/ejUserId	int	Service user ID: The database ID of a Service user
personAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
personAssociate/ejDisplayName	string	Nick name: User's nick name in Service	x
personAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
personAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
personAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
personAssociate/isActive	bool	Active: Is this user active, and should be able to log in?	x
personAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
personAssociate/portraitThumbnail	None	Person image: Person image
personAssociate/otherGroups	userGroup	Other groups: Other groups
personAssociate/userName	string	User name: User name	x
personAssociate/personEmail	string	E-mail	x
personContact/contactId	int	Company ID: Database ID of company	x
personContact/name	stringorPK	Company name	x
personContact/department	string	Department	x
personContact/nameDepartment	None	Company: Displays the company an activity is linked to	x
personContact/hasInfoText	bool	Has note: Displays an icon indicating if there is additional information available about the contact	x
personContact/hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests	x
personContact/associateId	associate	Our contact: Displays our contact	x
personContact/category	listAny	Category	x
personContact/business	listAny	Business	x
personContact/country	listAny	Country: This criterion corresponds to the Country field on the Company card.	x
personContact/number	string	Number	x
personContact/code	string	Code	x
personContact/orgnr	string	VAT No.	x
personContact/stop	bool	Stop	x
personContact/contactNoMail	bool	No mailings (company	x
personContact/updatedBy	associate	Updated by: The user who last updated the data	x
personContact/updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
personContact/registeredBy	associate	Registered by: The user who registered the data	x
personContact/registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
personContact/contactSource	listAny	Source: Source (Company)	x
personContact/contactDeleted	bool	Deleted: Deleted	x
personContact/phone/formattedNumber	string	Phone : Displays phone number
personContact/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?	x
personContact/deletedDate	datetime	Deleted date: Deleted date
personContact/mainContact	None	Main contact: Main contact for this company	x
personContact/contactPhone/formattedNumber	string	Telephone - Phone: Displays phone number
personContact/contactPhone/description	string	Telephone - Description: Phone number description	x
personContact/contactFax/formattedNumber	string	Fax - Phone: Displays phone number
personContact/contactFax/description	string	Fax - Description: Phone number description	x
personContact/searchPhone/formattedNumber	string	Searchphone - Phone: Displays phone number
personContact/searchPhone/description	string	Searchphone - Description: Phone number description	x
personContact/email/emailProtocol	string	Protocol: E-mail protocol, such as SMTP	x
personContact/email/emailAddress	string	E-mail	x
personContact/email/emailDescription	string	Description	x
personContact/email/emailId	int	ID	x
personContact/email/emailLastSent	datetime	Last sent: The date and time an e-mail was last sent to this address	x
personContact/email/emailBounceCount	int	Bounce count: Bounce count for this e-mail address	x
personContact/email/emailLastBounce	datetime	Last bounce: Date and time for last bounce to this e-mail address	x
personContact/email/emailHasBounced	bool	Has bounced: This checkbox is active if delivery to this e-mail address has failed.	x
personContact/postAddress/addressId	int	Postal address - Address ID: Database ID for the address record	x
personContact/postAddress/line1	string	Postal address - Address 1: First line of the address	x
personContact/postAddress/line2	string	Postal address - Address 2: Second line of the address	x
personContact/postAddress/line3	string	Postal address - Address 3: Third line of the address	x
personContact/postAddress/county	string	Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
personContact/postAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.	x
personContact/postAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
personContact/postAddress/state	string	Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
personContact/postAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude	x
personContact/postAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude	x
personContact/postAddress/formattedAddress	None	Postal address - {formattedAddress}: {formattedAddress}
personContact/postAddress/formattedMultiLineAddress	None	Postal address - {formattedAddress}: {formattedAddress}
personContact/restrictionPostalAddress/addressId	int	Postal address - Address ID: Database ID for the address record	x
personContact/restrictionPostalAddress/line1	string	Postal address - Address 1: First line of the address	x
personContact/restrictionPostalAddress/line2	string	Postal address - Address 2: Second line of the address	x
personContact/restrictionPostalAddress/line3	string	Postal address - Address 3: Third line of the address	x
personContact/restrictionPostalAddress/county	string	Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
personContact/restrictionPostalAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.	x
personContact/restrictionPostalAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
personContact/restrictionPostalAddress/state	string	Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
personContact/restrictionPostalAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude	x
personContact/restrictionPostalAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude	x
personContact/restrictionPostalAddress/formattedAddress	None	Postal address - {formattedAddress}: {formattedAddress}
personContact/restrictionPostalAddress/formattedMultiLineAddress	None	Postal address - {formattedAddress}: {formattedAddress}
personContact/streetAddress/addressId	int	Street address - Address ID: Database ID for the address record	x
personContact/streetAddress/line1	string	Street address - Address 1: First line of the address	x
personContact/streetAddress/line2	string	Street address - Address 2: Second line of the address	x
personContact/streetAddress/line3	string	Street address - Address 3: Third line of the address	x
personContact/streetAddress/county	string	Street address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
personContact/streetAddress/city	string	Street address - City: This criterion corresponds to the City field on the Company card.	x
personContact/streetAddress/zip	string	Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
personContact/streetAddress/state	string	Street address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
personContact/streetAddress/wgs84latitude	decimal	Street address - Latitude: Latitude	x
personContact/streetAddress/wgs84longitude	decimal	Street address - Longitude: Longitude	x
personContact/streetAddress/formattedAddress	None	Street address - {formattedAddress}: {formattedAddress}
personContact/streetAddress/formattedMultiLineAddress	None	Street address - {formattedAddress}: {formattedAddress}
personContact/restrictionAddress/addressId	int	Search address - Address ID: Database ID for the address record	x
personContact/restrictionAddress/line1	string	Search address - Address 1: First line of the address	x
personContact/restrictionAddress/line2	string	Search address - Address 2: Second line of the address	x
personContact/restrictionAddress/line3	string	Search address - Address 3: Third line of the address	x
personContact/restrictionAddress/county	string	Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.	x
personContact/restrictionAddress/city	string	Search address - City: This criterion corresponds to the City field on the Company card.	x
personContact/restrictionAddress/zip	string	Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
personContact/restrictionAddress/state	string	Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.	x
personContact/restrictionAddress/wgs84latitude	decimal	Search address - Latitude: Latitude	x
personContact/restrictionAddress/wgs84longitude	decimal	Search address - Longitude: Longitude	x
personContact/restrictionAddress/formattedAddress	None	Search address - {formattedAddress}: {formattedAddress}
personContact/restrictionAddress/formattedMultiLineAddress	None	Search address - {formattedAddress}: {formattedAddress}
personContact/url/URLAddress	string	URL	x
personContact/url/URLDescription	string	Description	x
personContact/contactAssociate/firstName	string	First name: Displays the contact's first name	x
personContact/contactAssociate/lastName	string	Last name: Displays the contact's last name	x
personContact/contactAssociate/middleName	string	Middle Name : Displays the contact's middle name.	x
personContact/contactAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
personContact/contactAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
personContact/contactAssociate/personId	int	Contact ID: Database ID of the contact row
personContact/contactAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
personContact/contactAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
personContact/contactAssociate/associateDbId	associate	ID	x
personContact/contactAssociate/contactName	string	Owning company: Name of the company the user belongs to	x
personContact/contactAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
personContact/contactAssociate/usergroup	userGroup	Primary group: The user's primary user group	x
personContact/contactAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
personContact/contactAssociate/contactCategory	listAny	Category: Category	x
personContact/contactAssociate/role	listAny	Role : Role	x
personContact/contactAssociate/assocName	associate	User ID : User ID	x
personContact/contactAssociate/assocTooltip	string	Description : Description
personContact/contactAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
personContact/contactAssociate/ejUserId	int	Service user ID: The database ID of a Service user
personContact/contactAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
personContact/contactAssociate/ejDisplayName	string	Nick name: User's nick name in Service	x
personContact/contactAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
personContact/contactAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
personContact/contactAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
personContact/contactAssociate/isActive	bool	Active: Is this user active, and should be able to log in?	x
personContact/contactAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
personContact/contactAssociate/portraitThumbnail	None	Person image: Person image
personContact/contactAssociate/otherGroups	userGroup	Other groups: Other groups
personContact/contactAssociate/userName	string	User name: User name	x
personContact/contactAssociate/personEmail	string	E-mail	x
personContact/contactSupportAssociate/firstName	string	Our service contact - First name: Displays the contact's first name	x
personContact/contactSupportAssociate/lastName	string	Our service contact - Last name: Displays the contact's last name	x
personContact/contactSupportAssociate/middleName	string	Our service contact - Middle Name: Displays the contact's middle name.	x
personContact/contactSupportAssociate/fullName	string	Our service contact - Full name: Displays full name of user (first, middle, last - according to settings)	x
personContact/contactSupportAssociate/contactId	int	Our service contact - Company ID: Database ID of the company the user belongs to
personContact/contactSupportAssociate/personId	int	Our service contact - Contact ID: Database ID of the contact row
personContact/contactSupportAssociate/mrMrs	string	Our service contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
personContact/contactSupportAssociate/title	string	Our service contact - Title: Displays whether the contact is addressed as Mr or Ms	x
personContact/contactSupportAssociate/associateDbId	associate	Our service contact - ID	x
personContact/contactSupportAssociate/contactName	string	Our service contact - Owning company: Name of the company the user belongs to	x
personContact/contactSupportAssociate/contactDepartment	string	Our service contact - Owning department: Name of the department at the company the user belongs to	x
personContact/contactSupportAssociate/usergroup	userGroup	Our service contact - Primary group: The user's primary user group	x
personContact/contactSupportAssociate/contactFullName	string	Our service contact - Owner: Name and department of the company the user belongs to	x
personContact/contactSupportAssociate/contactCategory	listAny	Our service contact - Category: Category	x
personContact/contactSupportAssociate/role	listAny	Our service contact - Role: Role	x
personContact/contactSupportAssociate/assocName	associate	Our service contact - User ID: User ID	x
personContact/contactSupportAssociate/assocTooltip	string	Our service contact - Description: Description
personContact/contactSupportAssociate/assocType	listAny	Our service contact - Type: Type of user: associate, external user, system user, anonymous account	x
personContact/contactSupportAssociate/ejUserId	int	Our service contact - Service user ID: The database ID of a Service user
personContact/contactSupportAssociate/simultaneousEjUser	bool	Our service contact - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
personContact/contactSupportAssociate/ejDisplayName	string	Our service contact - Nick name: User's nick name in Service	x
personContact/contactSupportAssociate/ejStatus	int	Our service contact - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
personContact/contactSupportAssociate/credentialType	None	Our service contact - Auth. type: What type of credentials to use when this user logs in	x
personContact/contactSupportAssociate/credentialDisplayValue	None	Our service contact - Auth. value: Credential value (public, visible part) to be used when this user logs in	x
personContact/contactSupportAssociate/isActive	bool	Our service contact - Active: Is this user active, and should be able to log in?	x
personContact/contactSupportAssociate/isActiveText	bool	Our service contact - Active status: Is this user active, and should be able to log in?	x
personContact/contactSupportAssociate/portraitThumbnail	None	Our service contact - Person image: Person image
personContact/contactSupportAssociate/otherGroups	userGroup	Our service contact - Other groups: Other groups
personContact/contactSupportAssociate/userName	string	Our service contact - User name: User name	x
personContact/contactSupportAssociate/personEmail	string	Our service contact - E-mail	x
personContact/contactSupportPerson/personId	int	User support contact - DB ID: Displays the database ID of a contact	x
personContact/contactSupportPerson/firstName	string	User support contact - First name: Displays the contact's first name	x
personContact/contactSupportPerson/lastName	string	User support contact - Last name: Displays the contact's last name	x
personContact/contactSupportPerson/middleName	string	User support contact - Middle name: Displays the contact's middle name.	x
personContact/contactSupportPerson/fullName	stringorPK	User support contact - Contact: Displays the contact to which an item is linked	x
personContact/contactSupportPerson/contactId	int	User support contact - Company ID: Database ID of company	x
personContact/contactSupportPerson/hasInfoText	bool	User support contact - Has note: Displays an icon indicating if there is additional information available about the contact	x
personContact/contactSupportPerson/hasInterests	bool	User support contact - Has interests: Displays an Icon indicating if the contact has active interests	x
personContact/contactSupportPerson/personHasInterests	bool	User support contact - Has interests: Displays an Icon indicating if the contact has active interests	x
personContact/contactSupportPerson/mrMrs	string	User support contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
personContact/contactSupportPerson/position	listAny	User support contact - Position	x
personContact/contactSupportPerson/personNumber	string	User support contact - Number: Displays the contact's number	x
personContact/contactSupportPerson/title	string	User support contact - Title: Displays the contact's job title	x
personContact/contactSupportPerson/personCountry	listAny	User support contact - Country: Country	x
personContact/contactSupportPerson/personNoMail	bool	User support contact - No Mailings: Displays the contact's No Mailings checkbox	x
personContact/contactSupportPerson/rank	int	User support contact - Rank: Displays a contact's current rank	x
personContact/contactSupportPerson/birthdate	None	User support contact - Birthdate: Displays the contact's date of birth
personContact/contactSupportPerson/associateType	None	User support contact - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading.
personContact/contactSupportPerson/useAsMailingAddress	bool	User support contact - Use as postal address: Use as postal address	x
personContact/contactSupportPerson/personSource	listAny	User support contact - Source: Source (Contact)	x
personContact/contactSupportPerson/retired	bool	User support contact - Former employee: Indicates whether the contact has retired/left the company	x
personContact/contactSupportPerson/birthYear	int	User support contact - Birth year: Displays contact's birth year	x
personContact/contactSupportPerson/birthMonth	int	User support contact - Birth month: Displays contact's birth month	x
personContact/contactSupportPerson/birthDay	int	User support contact - Birth day: Displays contact's birth day (day of month)	x
personContact/contactSupportPerson/kanaFirstName	string	User support contact - First name, kana: Contact's first name, in kana alphabet	x
personContact/contactSupportPerson/kanaLastName	string	User support contact - Last name, kana: Contact's last name, in kana alphabet	x
personContact/contactSupportPerson/personUpdatedBy	associate	User support contact - Updated by: The user who last updated the data	x
personContact/contactSupportPerson/personUpdatedDate	date	User support contact - Updated: The date/time the data was last updated in UTC.	x
personContact/contactSupportPerson/personRegisteredBy	associate	User support contact - Registered by: The user who registered the data	x
personContact/contactSupportPerson/personRegisteredDate	date	User support contact - Registered date: The date/time the data was registered in UTC.	x
personContact/contactSupportPerson/portraitThumbnail	None	User support contact - Person image: Person image
personContact/contactSupportPerson/personActiveErpLinks	bool	User support contact - ERP connected: Is there an active ERP Sync?	x
personContact/contactSupportPerson/ticketPriority	listAny	User support contact - Service priority: Default service priority for this contact	x
personContact/contactSupportPerson/supportLanguage	listAny	User support contact - Preferred language: Preferred language used for reply templates and more	x
personContact/contactSupportPerson/supportAssociate	associate	User support contact - Our service contact: Default service contact for this contact	x
personContact/contactSupportPerson/personAssociateId	associate	User support contact - Our contact: Displays our contact	x
personContact/contactSupportPerson/personCategory	listAny	User support contact - Category	x
personContact/contactSupportPerson/personBusiness	listAny	User support contact - Business	x
personContact/contactSupportPerson/personDeletedDate	datetime	User support contact - Deleted date: Deleted date
personContact/contactSupportPerson/hasCompany	bool	User support contact - Has company: The contact is associated with a company	x
personContact/contactSupportPerson/isProjectMember	bool	User support contact - Is project member: This person is a project member	x
personContact/contactSupportPerson/isStakeholder	bool	User support contact - Is stakeholder: This person is a sale stakeholder	x
personContact/contactSupportPerson/who	None	User support contact - Full name: Displays the contact's full name.	x
personContact/contactSupportPerson/personInfo/textId	int	User support contact - Text ID	x
personContact/contactSupportPerson/personInfo/infoText	positiveString	User support contact - Information: Displays the text entered in the description field	x
personContact/contactSupportPerson/personUdef/SuperOffice:1	string	User support contact - contactshorttext: tooltipshorttext	x
personContact/contactSupportPerson/personUdef/SuperOffice:2	string	User support contact - contactlongtext: tooltiplongtext	x
personContact/contactSupportPerson/personUdef/SuperOffice:3	int	User support contact - contactnumber	x
personContact/contactSupportPerson/personUdef/SuperOffice:4	date	User support contact - contactdate	x
personContact/contactSupportPerson/personUdef/SuperOffice:5	unlimitedDate	User support contact - contactunlimiteddate: tooltipunlimiteddate	x
personContact/contactSupportPerson/personUdef/SuperOffice:6	bool	User support contact - contactcheckbox	x
personContact/contactSupportPerson/personUdef/SuperOffice:7	listAny	User support contact - contactdropdownlistbox	x
personContact/contactSupportPerson/personUdef/SuperOffice:8	decimal	User support contact - contactdecimal	x
personContact/contactSupportPerson/personUdef/SuperOffice:9	string	User support contact - page1saleonly	x
personContact/contactSupportPerson/personUdef/SuperOffice:10	string	User support contact - page1marketingonly	x
personContact/contactSupportPerson/personUdef/SuperOffice:11	string	User support contact - page1adminonly	x
personContact/contactSupportPerson/isMailingRecipient	bool	User support contact - isMailingRecipient: isMailingRecipient	x
personContact/contactSupportPerson/hasStoreConsent	bool	User support contact - Consent - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
personContact/contactSupportPerson/withdrawnStoreConsent	bool	User support contact - Consent is withdrawn - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
personContact/contactSupportPerson/hasEmarketingConsent	bool	User support contact - Consent - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
personContact/contactSupportPerson/withdrawnEmarketingConsent	bool	User support contact - Consent is withdrawn - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
personContact/contactSupportPerson/subscription	listAny	User support contact - Subscription: Subscription for marketing	x
personContact/contactSupportPerson/legalBaseStore	listAny	User support contact - Legal basis - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
personContact/contactSupportPerson/legalBaseEmarketing	listAny	User support contact - Legal basis - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
personContact/contactSupportPerson/consentSourceStore	listAny	User support contact - Source - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
personContact/contactSupportPerson/consentSourceEmarketing	listAny	User support contact - Source - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
personContact/contactInterestIds	listInterest	Company Interest: This criterion corresponds to the Interests tab on the Company card.
personContact/contactUdef/SuperOffice:1	string	companyshorttext: tooltipshorttext	x
personContact/contactUdef/SuperOffice:2	string	companylongtext: tooltiplongtext	x
personContact/contactUdef/SuperOffice:3	int	companynumber	x
personContact/contactUdef/SuperOffice:4	date	companydate	x
personContact/contactUdef/SuperOffice:5	unlimitedDate	companyunlimiteddate: tooltipunlimiteddate	x
personContact/contactUdef/SuperOffice:6	bool	companycheckbox	x
personContact/contactUdef/SuperOffice:7	listAny	companydropdownlistbox	x
personContact/contactUdef/SuperOffice:8	decimal	companydecimal	x
personContact/contactUdef/SuperOffice:9	string	page1saleonly	x
personContact/contactUdef/SuperOffice:10	string	page1marketingonly	x
personContact/contactUdef/SuperOffice:11	string	page1adminonly	x
personContact/contactUdef/SuperOffice:12	listAny	Udlist one: Static tooltip for udlist one	x
personContact/contactUdef/SuperOffice:13	listAny	Udlist two: Static tooltip for udlist two	x
personContact/NumberOfActivities	int	Number of activities
personContact/NumberOfActivitiesInPeriod	int	Number of activities in last 90 days
personContact/NumberOfNotCompletedActivities	int	Number of non-completed activities
personContact/NumberOfNotCompletedActivitiesInPeriod	int	Number of non-completed activities in last 90 days
personContact/LastActivity	date	Date of last activity
personContact/LastCompletedActivity	date	Date of last completed activity
personContact/LastDoByActivity	date	Date of last non-completed activity
personContact/NumberOfSales	int	Number of sales
personContact/NumberOfSalesInPeriod	int	Number of sales in last 90 days
personContact/NumberOfNotCompletedSales	int	Number of non-completed sales
personContact/NumberOfNotCompletedSalesInPeriod	int	Number of non-completed sales in last 90 days
personContact/LastSale	date	Date of last sale
personContact/LastCompletedSale	date	Date of last completed sale
personContact/LastDoBySale	date	Date of last non-completed sale
personContact/NumberOfTickets	int	Number of requests
personContact/NumberOfTicketsInPeriod	int	Number of requests in last 90 days
personContact/NumberOfNotCompletedTickets	int	Number of non-completed requests
personContact/NumberOfNotCompletedTicketsInPeriod	int	Number of non-completed requests in last 90 days
personContact/LastTicket	date	Date of last request
personContact/LastCompletedTicket	date	Date of last completed request
personContact/LastDoByTicket	date	Date of last non-completed request
personContact/SaintStatus1	saintStatus	Neglected customer
personContact/SaintStatus2	saintStatus	C-company
personContact/saintSaleStatus	listAny	With status
personContact/saintAmountClass	listAny	Amount class
personContact/saintActivityType	listAny	SAINT type
personContact/saintDirection	listAny	Direction
personContact/saintIntention	listAny	Intention
personContact/saintTicketStatus	listAny	Status
personContact/saintTicketCategory	listAny	Category
personContact/selectionMemberId	None	Selection member ID: The database ID of the selection member record
personContact/selectionIdRequest	int	Selection ID: Database ID of selection which members are to be fetched from
isMailingRecipient	bool	isMailingRecipient: isMailingRecipient	x
hasStoreConsent	bool	Consent - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
withdrawnStoreConsent	bool	Consent is withdrawn - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
hasEmarketingConsent	bool	Consent - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
withdrawnEmarketingConsent	bool	Consent is withdrawn - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
subscription	listAny	Subscription: Subscription for marketing	x
legalBaseStore	listAny	Legal basis - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
legalBaseEmarketing	listAny	Legal basis - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
consentSourceStore	listAny	Source - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
consentSourceEmarketing	listAny	Source - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
request/contactId	int	Company ID: Database ID of company	x
request/personId	int	Contact ID: Database ID of the contact row	x
request/ticketStatusName	listAny	Status: Request status	x
request/categoryFullName	listAny	Category: Request category	x
request/priorityName	listAny	Priority: Service priority	x
request/ticketId	int	ID: Displays request ID	x
request/title	string	Title: Displays the request title	x
request/createdAt	datetime	Created: Displays when the request was created	x
request/lastChanged	datetime	Last changed: Displays when the request was last changed	x
request/author	string	Author: Displays the author of the request	x
request/readByOwner	datetime	Read by owner: Displays when the request was read by the owner	x
request/firstReadByOwner	datetime	First read by owner: Displays when the request was read by owner for the first time	x
request/firstReadByUser	datetime	First read by user: Displays when the request was read by user for the first time	x
request/readByCustomer	datetime	Read by contact: Displays when the request was read by the contact	x
request/status	listAny	Internal status: Shows only system defined statuses for a request	x
request/origin	listAny	Origin: Origin	x
request/slevel	listAny	Access level: Access level	x
request/numberOfMessages	int	Number of messages: Number of messages	x
request/numberOfReplies	int	Number of replies: Number of replies	x
request/connectId	int	Merged with request: Merged with request	x
request/readStatus	listAny	Read: Read	x
request/realTimeSpentQueue	timeSpan	Real time in queue: Real time in queue	x
request/realTimeSpentExternally	timeSpan	Real time externally: Real time externally	x
request/realTimeSpentInternally	timeSpan	Real time internally: Real time internally	x
request/timeSpentQueue	timeSpan	Time spent in queue: Time spent in queue	x
request/timeSpentExternally	timeSpan	Time spent externally: Time spent externally	x
request/timeSpentInternally	timeSpan	Time spent internally: Time spent internally	x
request/timeToReply	timeSpan	Time to reply: Time to reply	x
request/timeToClose	timeSpan	Time to close: Time to close	x
request/realTimeToReply	timeSpan	Real time to reply: Real time to reply	x
request/realTimeToClose	timeSpan	Real time to close: Real time to close	x
request/repliedAt	datetime	Replied at: Replied at	x
request/closedAt	datetime	Closed at: Closed at	x
request/activated	datetime	Postponed to: Postponed to	x
request/deadline	datetime	Deadline: Deadline	x
request/has_attachment	bool	Has attachment: Indicates whether the e-mail has one or more attachments	x
request/tags	intArray	Tags: Tags connected to a request	x
request/ownedBy	ejUser	Owner: The owner of the request	x
request/content	string	Content: Search for content in messages related to requests	x
request/createdBy/firstName	string	Created by - First name: Displays the contact's first name	x
request/createdBy/lastName	string	Created by - Last name: Displays the contact's last name	x
request/createdBy/middleName	string	Created by - Middle Name: Displays the contact's middle name.	x
request/createdBy/fullName	string	Created by - Full name: Displays full name of user (first, middle, last - according to settings)	x
request/createdBy/contactId	int	Created by - Company ID: Database ID of the company the user belongs to
request/createdBy/personId	int	Created by - Contact ID: Database ID of the contact row
request/createdBy/mrMrs	string	Created by - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
request/createdBy/title	string	Created by - Title: Displays whether the contact is addressed as Mr or Ms	x
request/createdBy/associateDbId	associate	Created by - ID	x
request/createdBy/contactName	string	Created by - Owning company: Name of the company the user belongs to	x
request/createdBy/contactDepartment	string	Created by - Owning department: Name of the department at the company the user belongs to	x
request/createdBy/usergroup	userGroup	Created by - Primary group: The user's primary user group	x
request/createdBy/contactFullName	string	Created by - Owner: Name and department of the company the user belongs to	x
request/createdBy/contactCategory	listAny	Created by - Category: Category	x
request/createdBy/role	listAny	Created by - Role: Role	x
request/createdBy/assocName	associate	Created by - User ID: User ID	x
request/createdBy/assocTooltip	string	Created by - Description: Description
request/createdBy/assocType	listAny	Created by - Type: Type of user: associate, external user, system user, anonymous account	x
request/createdBy/ejUserId	int	Created by - Service user ID: The database ID of a Service user
request/createdBy/simultaneousEjUser	bool	Created by - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
request/createdBy/ejDisplayName	string	Created by - Nick name: User's nick name in Service	x
request/createdBy/ejStatus	int	Created by - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
request/createdBy/credentialType	None	Created by - Auth. type: What type of credentials to use when this user logs in	x
request/createdBy/credentialDisplayValue	None	Created by - Auth. value: Credential value (public, visible part) to be used when this user logs in	x
request/createdBy/isActive	bool	Created by - Active: Is this user active, and should be able to log in?	x
request/createdBy/isActiveText	bool	Created by - Active status: Is this user active, and should be able to log in?	x
request/createdBy/portraitThumbnail	None	Created by - Person image: Person image
request/createdBy/otherGroups	userGroup	Created by - Other groups: Other groups
request/createdBy/userName	string	Created by - User name: User name	x
request/createdBy/personEmail	string	Created by - E-mail	x
request/ownedBy/firstName	string	Owner - First name: Displays the contact's first name	x
request/ownedBy/lastName	string	Owner - Last name: Displays the contact's last name	x
request/ownedBy/middleName	string	Owner - Middle Name: Displays the contact's middle name.	x
request/ownedBy/fullName	string	Owner - Full name: Displays full name of user (first, middle, last - according to settings)	x
request/ownedBy/contactId	int	Owner - Company ID: Database ID of the company the user belongs to
request/ownedBy/personId	int	Owner - Contact ID: Database ID of the contact row
request/ownedBy/mrMrs	string	Owner - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
request/ownedBy/title	string	Owner - Title: Displays whether the contact is addressed as Mr or Ms	x
request/ownedBy/associateDbId	associate	Owner - ID	x
request/ownedBy/contactName	string	Owner - Owning company: Name of the company the user belongs to	x
request/ownedBy/contactDepartment	string	Owner - Owning department: Name of the department at the company the user belongs to	x
request/ownedBy/usergroup	userGroup	Owner - Primary group: The user's primary user group	x
request/ownedBy/contactFullName	string	Owner - Owner: Name and department of the company the user belongs to	x
request/ownedBy/contactCategory	listAny	Owner - Category: Category	x
request/ownedBy/role	listAny	Owner - Role: Role	x
request/ownedBy/assocName	associate	Owner - User ID: User ID	x
request/ownedBy/assocTooltip	string	Owner - Description: Description
request/ownedBy/assocType	listAny	Owner - Type: Type of user: associate, external user, system user, anonymous account	x
request/ownedBy/ejUserId	int	Owner - Service user ID: The database ID of a Service user
request/ownedBy/simultaneousEjUser	bool	Owner - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
request/ownedBy/ejDisplayName	string	Owner - Nick name: User's nick name in Service	x
request/ownedBy/ejStatus	int	Owner - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
request/ownedBy/credentialType	None	Owner - Auth. type: What type of credentials to use when this user logs in	x
request/ownedBy/credentialDisplayValue	None	Owner - Auth. value: Credential value (public, visible part) to be used when this user logs in	x
request/ownedBy/isActive	bool	Owner - Active: Is this user active, and should be able to log in?	x
request/ownedBy/isActiveText	bool	Owner - Active status: Is this user active, and should be able to log in?	x
request/ownedBy/portraitThumbnail	None	Owner - Person image: Person image
request/ownedBy/otherGroups	userGroup	Owner - Other groups: Other groups
request/ownedBy/userName	string	Owner - User name: User name	x
request/ownedBy/personEmail	string	Owner - E-mail	x
projectMembers/completed	bool	Completed: Displays a check mark indicating if the project has been completed.	x
projectMembers/projectId	int	DB ID: Displays the database ID for a project row	x
projectMembers/name	stringorPK	Project name: Displays the Project's name	x
projectMembers/number	string	Number: Displays the project's number	x
projectMembers/type	listAny	Project type: Displays the project's type	x
projectMembers/status	listAny	Status: Displays the project's status	x
projectMembers/associateId	associate	ID: Displays login ID of the associate who owns the project	x
projectMembers/hasInfoText	bool	Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip.	x
projectMembers/icon	None	Category: Displays the icon for an activity type	x
projectMembers/text	string	Text: Displays a descriptive text for the item	x
projectMembers/description	string	Description : Description	x
projectMembers/updatedBy	associate	Updated by: The user who last updated the data	x
projectMembers/updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
projectMembers/registeredBy	associate	Registered by: The user who registered the data	x
projectMembers/registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
projectMembers/hasGuide	bool	Guided: Does this sale have a Sales Guide	x
projectMembers/nextMilestone	date	Next milestone: Date of next non-completed activity that is marked as a milestone	x
projectMembers/endDate	date	End date: End date of project	x
projectMembers/imageThumbnail	None	Thumbnail: Scaled-down image of project image
projectMembers/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?	x
projectMembers/function	listAny	Function: Displays the project member's function in the project	x
projectMembers/projectPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published	x
projectMembers/projectPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date	x
projectMembers/projectPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date	x
projectMembers/projectPublish/publishedBy	None	Published by: Published by
projectMembers/projectEvent/isExternalEvent	bool	Event: Is this an external event	x
projectMembers/projectEvent/eventDate	date	Event date: Event date	x
projectMembers/projectEvent/hasSignOn	bool	Sign On: Does this event have the Sign On function enabled	x
projectMembers/projectEvent/hasSignOff	bool	Sign Off: Does this event have the Sign Off function enabled	x
projectMembers/projectUrl/URLAddress	string	URL	x
projectMembers/projectUrl/URLDescription	string	Description	x
projectMembers/projectAssociate/firstName	string	First name: Displays the contact's first name	x
projectMembers/projectAssociate/lastName	string	Last name: Displays the contact's last name	x
projectMembers/projectAssociate/middleName	string	Middle Name : Displays the contact's middle name.	x
projectMembers/projectAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
projectMembers/projectAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
projectMembers/projectAssociate/personId	int	Contact ID: Database ID of the contact row
projectMembers/projectAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
projectMembers/projectAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
projectMembers/projectAssociate/associateDbId	associate	ID	x
projectMembers/projectAssociate/contactName	string	Owning company: Name of the company the user belongs to	x
projectMembers/projectAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
projectMembers/projectAssociate/usergroup	userGroup	Primary group: The user's primary user group	x
projectMembers/projectAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
projectMembers/projectAssociate/contactCategory	listAny	Category: Category	x
projectMembers/projectAssociate/role	listAny	Role : Role	x
projectMembers/projectAssociate/assocName	associate	User ID : User ID	x
projectMembers/projectAssociate/assocTooltip	string	Description : Description
projectMembers/projectAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
projectMembers/projectAssociate/ejUserId	int	Service user ID: The database ID of a Service user
projectMembers/projectAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
projectMembers/projectAssociate/ejDisplayName	string	Nick name: User's nick name in Service	x
projectMembers/projectAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
projectMembers/projectAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
projectMembers/projectAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
projectMembers/projectAssociate/isActive	bool	Active: Is this user active, and should be able to log in?	x
projectMembers/projectAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
projectMembers/projectAssociate/portraitThumbnail	None	Person image: Person image
projectMembers/projectAssociate/otherGroups	userGroup	Other groups: Other groups
projectMembers/projectAssociate/userName	string	User name: User name	x
projectMembers/projectAssociate/personEmail	string	E-mail	x
projectMembers/projectUdef/SuperOffice:1	string	projectshorttext	x
projectMembers/projectUdef/SuperOffice:2	string	projectlongtext	x
projectMembers/projectUdef/SuperOffice:3	int	projectnumber	x
projectMembers/projectUdef/SuperOffice:4	date	projectdate	x
projectMembers/projectUdef/SuperOffice:5	unlimitedDate	projectunlimiteddate	x
projectMembers/projectUdef/SuperOffice:6	bool	projectcheckbox	x
projectMembers/projectUdef/SuperOffice:7	listAny	projectdropdownlistbox	x
projectMembers/projectUdef/SuperOffice:8	decimal	projectdecimal	x
projectMembers/projectUdef/SuperOffice:9	int	page1saleandmarketing	x
projectMembers/projectUdef/SuperOffice:10	int	page1saleandadmin	x
projectMembers/NumberOfActivities	int	Number of activities
projectMembers/NumberOfActivitiesInPeriod	int	Number of activities in last 90 days
projectMembers/NumberOfNotCompletedActivities	int	Number of non-completed activities
projectMembers/NumberOfNotCompletedActivitiesInPeriod	int	Number of non-completed activities in last 90 days
projectMembers/LastActivity	date	Date of last activity
projectMembers/LastCompletedActivity	date	Date of last completed activity
projectMembers/LastDoByActivity	date	Date of last non-completed activity
projectMembers/NumberOfSales	int	Number of sales
projectMembers/NumberOfSalesInPeriod	int	Number of sales in last 90 days
projectMembers/NumberOfNotCompletedSales	int	Number of non-completed sales
projectMembers/NumberOfNotCompletedSalesInPeriod	int	Number of non-completed sales in last 90 days
projectMembers/LastSale	date	Date of last sale
projectMembers/LastCompletedSale	date	Date of last completed sale
projectMembers/LastDoBySale	date	Date of last non-completed sale
projectMembers/SaintStatus3	saintStatus	Not completed activites with intention sale
projectMembers/saintSaleStatus	listAny	With status
projectMembers/saintAmountClass	listAny	Amount class
projectMembers/saintActivityType	listAny	SAINT type
projectMembers/saintDirection	listAny	Direction
projectMembers/saintIntention	listAny	Intention
projectMembers/saintTicketStatus	listAny	Status
projectMembers/saintTicketCategory	listAny	Category
projectMembers/project/textId	int	Text ID	x
projectMembers/project/infoText	positiveString	Information: Displays the text entered in the description field	x
personAppointment/completed	bool	Completed: Displays a checkbox showing if an appointment is completed	x
personAppointment/icon	None	Category: Displays the icon for an activity type	x
personAppointment/date	date	Date: Displays start date of a follow-up / sale date of a sale	x
personAppointment/time	None	Time: Time
personAppointment/type	listAny	Type: Displays the type of an activity	x
personAppointment/recordType	string	Record type : Shows the record type	x
personAppointment/text	positiveString	Text: Displays a descriptive text for the item	x
personAppointment/associateId	associate	ID: Displays the login ID of the associate who owns the activity.	x
personAppointment/contactId	listAny	Company ID: Database ID of company	x
personAppointment/personId	listAny	Contact ID: Database ID of the contact row	x
personAppointment/projectId	listAny	Project ID: Database ID of project record	x
personAppointment/saleId	int	Sale ID: The database ID of the sale record	x
personAppointment/userGroup	userGroup	User group : The user group that owns the record	x
personAppointment/who	None	Who: Contact and/or company
personAppointment/updatedBy	associate	Updated by: The user who last updated the data	x
personAppointment/updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
personAppointment/registeredBy	associate	Registered by: The user who registered the data	x
personAppointment/registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
personAppointment/appointmentId	int	DB ID: Displays the database ID of a row	x
personAppointment/endDate	date	End date: Displays the deadline for a follow-up/sale	x
personAppointment/priority	listAny	Priority: Displays the priority of the activity	x
personAppointment/alarm	bool	Has alarm: Displays the alarm state of a follow-up	x
personAppointment/recurring	bool	Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up	x
personAppointment/booking	bool	Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip.	x
personAppointment/intention	listAny	Intention: Displays the intention of the follow-up type	x
personAppointment/location	string	Location: Display the location where the follow-up will take place.	x
personAppointment/recurrenceRuleId	int	RR-ID: Repetition rule ID of follow-up	x
personAppointment/rawType	int	Type: Type field for appointment, not decoded or formatted	x
personAppointment/rawStatus	int	Status: Status field for the follow-up, not decoded or formatted	x
personAppointment/cautionWarning	listAny	Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems.	x
personAppointment/visibleInDiary	bool	ExcludeBook: Is the activity visible in the diary?	x
personAppointment/endTime	None	End time: End time of an activity
personAppointment/suggestedAppointmentId	int	Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion	x
personAppointment/completedDate	date	Completed date: Displays the actual date a follow-up/sale was marked as completed	x
personAppointment/isMilestone	bool	Milestone: Shows whether or not the follow-ups in this row are milestones	x
personAppointment/invitedPersonId	int	ID of invited person: appointment.invitedpersonid record - utility for rd	x
personAppointment/recordTypeText	None	Activity type: The type of the activity (appointment, phone call, etc)	x
personAppointment/joinVideomeetUrl	None	Video meeting URL: URL for joining the video meeting	x
personAppointment/visibleFor	listAny	Visible for
personAppointment/appointmentPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published	x
personAppointment/appointmentPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date	x
personAppointment/appointmentPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date	x
personAppointment/appointmentPublish/publishedBy	None	Published by: Published by
personAppointment/appointmentUdef/SuperOffice:1	string	followupshorttext	x
personAppointment/appointmentUdef/SuperOffice:2	string	followuplongtext	x
personAppointment/appointmentUdef/SuperOffice:3	int	followupnumber	x
personAppointment/appointmentUdef/SuperOffice:4	date	followupdate	x
personAppointment/appointmentUdef/SuperOffice:5	unlimitedDate	followupunlimiteddate	x
personAppointment/appointmentUdef/SuperOffice:6	bool	followupcheckbox	x
personAppointment/appointmentUdef/SuperOffice:7	listAny	followupdropdownlistbox	x
personAppointment/appointmentUdef/SuperOffice:8	decimal	followupdecimal	x
personAppointment/associate/firstName	string	First name: Displays the contact's first name	x
personAppointment/associate/lastName	string	Last name: Displays the contact's last name	x
personAppointment/associate/middleName	string	Middle Name : Displays the contact's middle name.	x
personAppointment/associate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
personAppointment/associate/contactId	int	Company ID: Database ID of the company the user belongs to
personAppointment/associate/personId	int	Contact ID: Database ID of the contact row
personAppointment/associate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
personAppointment/associate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
personAppointment/associate/associateDbId	associate	ID	x
personAppointment/associate/contactName	string	Owning company: Name of the company the user belongs to	x
personAppointment/associate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
personAppointment/associate/usergroup	userGroup	Primary group: The user's primary user group	x
personAppointment/associate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
personAppointment/associate/contactCategory	listAny	Category: Category	x
personAppointment/associate/role	listAny	Role : Role	x
personAppointment/associate/assocName	associate	User ID : User ID	x
personAppointment/associate/assocTooltip	string	Description : Description
personAppointment/associate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
personAppointment/associate/ejUserId	int	Service user ID: The database ID of a Service user
personAppointment/associate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
personAppointment/associate/ejDisplayName	string	Nick name: User's nick name in Service	x
personAppointment/associate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
personAppointment/associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
personAppointment/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
personAppointment/associate/isActive	bool	Active: Is this user active, and should be able to log in?	x
personAppointment/associate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
personAppointment/associate/portraitThumbnail	None	Person image: Person image
personAppointment/associate/otherGroups	userGroup	Other groups: Other groups
personAppointment/associate/userName	string	User name: User name	x
personAppointment/associate/personEmail	string	E-mail	x
personAppointment/appointment/textId	int	Text ID	x
personAppointment/appointment/description	positiveString	Text: Displays the text entered in the description field	x

Sample

GET /api/v1/archive/SimplePerson?$select=personContact/contactAssociate/isActive,personContact/NumberOfNotCompletedSales,projectMembers/projectAssociate/fullName,projectMembers/projectAssociate/assocName,personAppointment/userGroup
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv