"ContactSelectionCombined"

• 94 minutes to read

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

Implementation of the provider for the combined selection

Supported Entities

Name	Description
"staticContact"	Static company
"staticPerson"	Static contact

Supported Columns

Name	Restriction	Description	OrderBy
selectionId	int	Selection ID: The database ID of the selection
rowKind	None	Icon indicating whether the row comes from a static or a dynamic selection
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
selectionMemberId	None	Selection member ID: The database ID of the selection member record
contactId	int	Company ID: Database ID of company	x
name	stringorPK	Company name	x
department	string	Department	x
nameDepartment	None	Company: Displays the company an activity is linked to	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
associateId	associate	Our contact: Displays our contact	x
category	listAny	Category	x
business	listAny	Business	x
country	listAny	Country: This criterion corresponds to the Country field on the Company card.	x
countryId	int	Country ID: Country ID	x
number	string	Number	x
code	string	Code	x
orgnr	string	VAT No.	x
stop	bool	Stop	x
contactNoMail	bool	No mailings (company	x
updatedBy	associate	Updated by: The user who last updated the data	x
updatedByFullName	associate	Updated by - Full name: The user who last updated the data	x
updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
registeredBy	associate	Registered by: The user who registered the data	x
registeredByFullName	associate	Registered by - Full name: The user who registered the data	x
registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
contactSource	listAny	Source: Source (Company)	x
contactDeleted	bool	Deleted: Deleted	x
phone/formattedNumber	string	Phone : Displays phone number
activeErpLinks	bool	ERP connected: Is there an active ERP Sync?	x
deletedDate	datetime	Deleted date: Deleted date
mainContact	None	Main contact: Main contact for this company	x
who	None	Company: Displays the name of a selection member's company	x
contactPhone/formattedNumber	string	Telephone - Phone: Displays phone number
contactPhone/description	string	Telephone - Description: Phone number description	x
contactFax/formattedNumber	None	Fax - Phone: Displays phone number
contactFax/description	None	Fax - Description: Phone number description
searchPhone/formattedNumber	None	Searchphone - Phone: Displays phone number
searchPhone/description	None	Searchphone - Description: Phone number description
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
postAddress/addressId	int	Postal address - Address ID: Database ID for the address record	x
postAddress/line1	string	Postal address - Address 1: First line of the address	x
postAddress/line2	string	Postal address - Address 2: Second line of the address	x
postAddress/line3	string	Postal address - Address 3: Third line of the address	x
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
postAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.	x
postAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
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
postAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude	x
postAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude	x
postAddress/formattedAddress	None	Postal address - {formattedAddress}: {formattedAddress}
postAddress/formattedMultiLineAddress	None	Postal address - {formattedAddress}: {formattedAddress}
streetAddress/addressId	int	Street address - Address ID: Database ID for the address record	x
streetAddress/line1	string	Street address - Address 1: First line of the address	x
streetAddress/line2	string	Street address - Address 2: Second line of the address	x
streetAddress/line3	string	Street address - Address 3: Third line of the address	x
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
streetAddress/city	string	Street address - City: This criterion corresponds to the City field on the Company card.	x
streetAddress/zip	string	Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
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
streetAddress/wgs84latitude	decimal	Street address - Latitude: Latitude	x
streetAddress/wgs84longitude	decimal	Street address - Longitude: Longitude	x
streetAddress/formattedAddress	None	Street address - {formattedAddress}: {formattedAddress}
streetAddress/formattedMultiLineAddress	None	Street 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}
url/URLAddress	string	URL	x
url/URLDescription	string	Description	x
contactAssociate/firstName	string	First name: Displays the contact's first name	x
contactAssociate/lastName	string	Last name: Displays the contact's last name	x
contactAssociate/middleName	string	Middle Name : Displays the contact's middle name.	x
contactAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
contactAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
contactAssociate/personId	int	Contact ID: Database ID of the contact row
contactAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
contactAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
contactAssociate/associateDbId	associate	ID	x
contactAssociate/contactName	string	Owning company: Name of the company the user belongs to	x
contactAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
contactAssociate/usergroup	userGroup	Primary group: The user's primary user group	x
contactAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
contactAssociate/contactCategory	listAny	Category: Category	x
contactAssociate/role	listAny	Role : Role	x
contactAssociate/assocName	associate	User ID : User ID	x
contactAssociate/assocTooltip	string	Description : Description
contactAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
contactAssociate/ejUserId	int	Service user ID: The database ID of a Service user
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
contactAssociate/ejDisplayName	string	Nick name: User's nick name in Service	x
contactAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
contactAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
contactAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
contactAssociate/isActive	bool	Active: Is this user active, and should be able to log in?	x
contactAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
contactAssociate/portraitThumbnail	None	Person image: Person image
contactAssociate/otherGroups	userGroup	Other groups: Other groups
contactAssociate/userName	string	User name: User name	x
contactAssociate/personEmail	string	E-mail	x
contactAssociate/locationAddress	string	Location: Location	x
contactAssociate/isLocation	bool	Is a location: Is a location	x
contactInterestIds	listInterest	Company Interest: This criterion corresponds to the Interests tab on the Company card.
contactUdef/SuperOffice:1	string	companyshorttext: tooltipshorttext	x
contactUdef/SuperOffice:2	string	companylongtext: tooltiplongtext	x
contactUdef/SuperOffice:3	int	companynumber	x
contactUdef/SuperOffice:4	date	companydate	x
contactUdef/SuperOffice:5	unlimitedDate	companyunlimiteddate: tooltipunlimiteddate	x
contactUdef/SuperOffice:6	bool	companycheckbox	x
contactUdef/SuperOffice:7	listAny	companydropdownlistbox	x
contactUdef/SuperOffice:8	decimal	companydecimal	x
contactUdef/SuperOffice:9	string	page1saleonly	x
contactUdef/SuperOffice:10	string	page1marketingonly	x
contactUdef/SuperOffice:11	string	page1adminonly	x
contactUdef/SuperOffice:12	listAny	Udlist one: Static tooltip for udlist one	x
contactUdef/SuperOffice:13	listAny	Udlist two: Static tooltip for udlist two	x
contactExtra/x_contact_integer	int	Extra Integer: Custom integer field	x
contactExtra/x_contact_default_integer	int	Extra Default Integer: Custom integer field with default value 123.	x
contactExtra/x_contact_float	decimal	Extra Float: Custom float field with 3 decimals	x
contactExtra/x_contact_longtext	string	Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor	x
contactExtra/x_contact_dropdown	listAny	Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.	x
contactExtra/x_contact_date	date	Extra date: Custom date field. User current as default.	x
contactExtra/x_contact_datetime	datetime	Extra DateTime: Custom Date Time field. No default value. External	x
contactExtra/x_contact_time	None	Extra time: Custom time field.	x
contactExtra/x_contact_boolean	bool	Extra boolean: Custom boolean field.	x
contactExtra/x_contact_timespan	timeSpan	Extra timespan: Custom timespan field. Hours and minutes in 10 units	x
contactExtra/x_contact_shorttext	string	Extra short text: Custom short text field. Keep HTML tags.	x
contactExtra/x_contact_short_dropdown	listAny	Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.	x
contactExtra/x_contact_contact_relation	stringorPK	Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons	x
contactExtra/x_contact_request_relation	stringorPK	Extra Request relation: Request relation on company	x
contactExtra/x_contact_contact	stringorPK	Extra contact relation: Contact relation on company	x
contactExtra/y_organization/x_name	string	Organization - Name	x
NumberOfActivities	None	Number of activities
NumberOfActivitiesInPeriod	None	Number of activities in last 90 days
NumberOfNotCompletedActivities	None	Number of non-completed activities
NumberOfNotCompletedActivitiesInPeriod	None	Number of non-completed activities in last 90 days
LastActivity	None	Date of last activity
LastCompletedActivity	None	Date of last completed activity
LastDoByActivity	None	Date of last non-completed activity
NumberOfSales	None	Number of sales
NumberOfSalesInPeriod	None	Number of sales in last 90 days
NumberOfNotCompletedSales	None	Number of non-completed sales
NumberOfNotCompletedSalesInPeriod	None	Number of non-completed sales in last 90 days
LastSale	None	Date of last sale
LastCompletedSale	None	Date of last completed sale
LastDoBySale	None	Date of last non-completed sale
NumberOfTickets	None	Number of requests
NumberOfTicketsInPeriod	None	Number of requests in last 90 days
NumberOfNotCompletedTickets	None	Number of non-completed requests
NumberOfNotCompletedTicketsInPeriod	None	Number of non-completed requests in last 90 days
LastTicket	None	Date of last request
LastCompletedTicket	None	Date of last completed request
LastDoByTicket	None	Date of last non-completed request
SaintStatus1	None	Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden.
SaintStatus2	None	C-company: Kundens navn starter med bokstaven C
saintSaleStatus	None	With status
saintAmountClass	None	Amount class
saintActivityType	None	SAINT type
saintDirection	None	Direction
saintIntention	None	Intention
saintTicketStatus	None	Status
saintTicketCategory	None	Category
sourceRelation/contactId	None	Source - Company ID: Database ID of company
sourceRelation/name	None	Source - Company name
sourceRelation/department	None	Source - Department
sourceRelation/nameDepartment	None	Source - Company: Displays the company an activity is linked to
sourceRelation/hasInfoText	None	Source - Has note: Displays an icon indicating if there is additional information available about the contact
sourceRelation/hasInterests	None	Source - Has interests: Displays an Icon indicating if the contact has active interests
sourceRelation/associateId	None	Source - Our contact: Displays our contact
sourceRelation/category	None	Source - Category
sourceRelation/business	None	Source - Business
sourceRelation/country	None	Source - Country: This criterion corresponds to the Country field on the Company card.
sourceRelation/countryId	None	Source - Country ID: Country ID
sourceRelation/number	None	Source - Number
sourceRelation/code	None	Source - Code
sourceRelation/orgnr	None	Source - VAT No.
sourceRelation/stop	None	Source - Stop
sourceRelation/contactNoMail	None	Source - No mailings (company)
sourceRelation/updatedBy	None	Source - Updated by: The user who last updated the data
sourceRelation/updatedByFullName	None	Source - Updated by - Full name: The user who last updated the data
sourceRelation/updatedDate	None	Source - Updated: The date/time the data was last updated in UTC.
sourceRelation/registeredBy	None	Source - Registered by: The user who registered the data
sourceRelation/registeredByFullName	None	Source - Registered by - Full name: The user who registered the data

Supported Columns (cont.)

Name	Restriction	Description
sourceRelation/registeredDate	None	Source - Registered date: The date/time the data was registered in UTC.
sourceRelation/contactSource	None	Source - Source: Source (Company)
sourceRelation/contactDeleted	None	Source - Deleted: Deleted
sourceRelation/activeErpLinks	None	Source - ERP connected: Is there an active ERP Sync?
sourceRelation/deletedDate	None	Source - Deleted date: Deleted date
sourceRelation/mainContact	None	Source - Main contact: Main contact for this company
sourceRelation/restrictionContactId	None	Source - Company ID: Database ID of company to fetch relations for
sourceRelation/who	None	Source - Full name: Full name of company/contact
sourceRelation/csRelation	None	Source - Company-to-company relation: Name of relation, not taking into account the relation direction
targetRelation/contactId	None	Target - Company ID: Database ID of company
targetRelation/name	None	Target - Company name
targetRelation/department	None	Target - Department
targetRelation/nameDepartment	None	Target - Company: Displays the company an activity is linked to
targetRelation/hasInfoText	None	Target - Has note: Displays an icon indicating if there is additional information available about the contact
targetRelation/hasInterests	None	Target - Has interests: Displays an Icon indicating if the contact has active interests
targetRelation/associateId	None	Target - Our contact: Displays our contact
targetRelation/category	None	Target - Category
targetRelation/business	None	Target - Business
targetRelation/country	None	Target - Country: This criterion corresponds to the Country field on the Company card.
targetRelation/countryId	None	Target - Country ID: Country ID
targetRelation/number	None	Target - Number
targetRelation/code	None	Target - Code
targetRelation/orgnr	None	Target - VAT No.
targetRelation/stop	None	Target - Stop
targetRelation/contactNoMail	None	Target - No mailings (company)
targetRelation/updatedBy	None	Target - Updated by: The user who last updated the data
targetRelation/updatedByFullName	None	Target - Updated by - Full name: The user who last updated the data
targetRelation/updatedDate	None	Target - Updated: The date/time the data was last updated in UTC.
targetRelation/registeredBy	None	Target - Registered by: The user who registered the data
targetRelation/registeredByFullName	None	Target - Registered by - Full name: The user who registered the data
targetRelation/registeredDate	None	Target - Registered date: The date/time the data was registered in UTC.
targetRelation/contactSource	None	Target - Source: Source (Company)
targetRelation/contactDeleted	None	Target - Deleted: Deleted
targetRelation/activeErpLinks	None	Target - ERP connected: Is there an active ERP Sync?
targetRelation/deletedDate	None	Target - Deleted date: Deleted date
targetRelation/mainContact	None	Target - Main contact: Main contact for this company
targetRelation/restrictionContactId	None	Target - Company ID: Database ID of company to fetch relations for
targetRelation/who	None	Target - Full name: Full name of company/contact
targetRelation/csRelation	None	Target - Company-to-company relation: Name of relation, not taking into account the relation direction
sourceRelation/contactPersonRelation	None	Source - Company-to-contact relation: Name of relation, not taking into account the relation direction
targetRelation/personContactRelation	None	Target - Contact-to-company relation: Name of relation, not taking into account the relation direction
sale/completed	None	Completed: Displays a checkbox showing if an appointment is completed
sale/icon	None	Category: Displays the icon for an activity type
sale/date	None	Date: Displays start date of a follow-up / sale date of a sale
sale/time	None	Time: Time
sale/type	None	Type: Displays the type of an activity
sale/recordType	None	Record type : Shows the record type
sale/text	None	Text: Displays a descriptive text for the item
sale/associateId	None	ID: Displays the login ID of the associate who owns the activity.
sale/contactId	None	Company ID: Database ID of company
sale/personId	None	Contact ID: Database ID of the contact row
sale/projectId	None	Project ID: Database ID of project record
sale/saleId	None	Sale ID: The database ID of the sale record
sale/userGroup	None	User group : The user group that owns the record
sale/who	None	Who: Contact and/or company
sale/updatedBy	None	Updated by: The user who last updated the data
sale/updatedByFullName	None	Updated by - Full name: The user who last updated the data
sale/updatedDate	None	Updated: The date/time the data was last updated in UTC.
sale/registeredBy	None	Registered by: The user who registered the data
sale/registeredByFullName	None	Registered by - Full name: The user who registered the data
sale/registeredDate	None	Registered date: The date/time the data was registered in UTC.
sale/currencyId	None	Currency ID: The currency list item ID
sale/currency	None	Currency: The currency of the sale
sale/credited	None	Credited: The user to be credited with the sale
sale/lossReason	None	Reason (lost: The reason for losing the sale
sale/source	None	Source: The source (lead) of the sale
sale/competitor	None	Competitor: The competitor who won the sale
sale/heading	None	Sale: The name of the sale
sale/amount	None	Amount: The gross sales total
sale/amountWeighted	None	Weighted amount: Virtual field calculated from amount * probability percent.
sale/earning	None	Profit: Gross profit (gross sales total - cost) for the sale
sale/earningPercent	None	Profit as % : The profit as a percentage of the gross sales total
sale/probPercent	None	Probability as %: Probability as %
sale/originalStage	None	Stage: Displays the stage of the sale
sale/stage	None	Stage: Displays the stage of the sale
sale/stageName	None	Stage name: Displays the stage of the sale
sale/saleStatus	None	Status: The status of the sale - open, lost or sold
sale/stageRank	None	Stage rank: Rank of the sale stage in the stage list
sale/saleType	None	Sale type: Sale type, from list
sale/saleTypeId	None	Sale type ID: Sale type, from list
sale/stageId	None	Sale stage ID: Displays the stage of the sale
sale/nextDueDate	None	Next activity: Date for next activity for a sale, updated live from the sale's activities
sale/reopenDate	None	Reopen date: Displays the reopen date for the sale
sale/stalledComment	None	Reason (stalled: The reason the sale has been stalled
sale/saleTypeCategory	None	Sale type category: Sale type category
sale/soldReason	None	Reason (sold: Reason (sold)
sale/saleNumber	None	Number: Number
sale/hasStakeholders	None	Has stakeholders: Does this sale have stakeholders enabled
sale/hasQuote	None	Has quote?: Does the sale have a quote attached?
sale/hasGuide	None	Guided: Does this sale have a Sales Guide
sale/description	None	Description: The long description field on Sale
sale/activeErpLinks	None	ERP connected: Is there an active ERP Sync?
sale/createdByWorkflow	None	Created by flow: Created by flow
sale/amountInBaseCurrency	None	Amount (BaseCurrency): The gross sales total
sale/amountWeightedInBaseCurrency	None	Weighted amount (BaseCurrency): Virtual field calculated from amount * probability percent.
sale/visibleFor	None	Visible for
sale/sale/textId	None	Text ID
sale/sale/description	None	Text: Displays the text entered in the description field
sale/salePublish/isPublished	None	Published: Displays an icon indicating if the project or sale has been published
sale/salePublish/publishedFrom	None	From date: Start date for publishing. The record will not be visible prior to this date

Supported Columns (cont.)

Name	Restriction	Description
sale/salePublish/publishedTo	None	To date: End date for publishing. The record will not be visible after this date
sale/salePublish/publishedBy	None	Published by: Published by
sale/associate/firstName	None	First name: Displays the contact's first name
sale/associate/lastName	None	Last name: Displays the contact's last name
sale/associate/middleName	None	Middle Name : Displays the contact's middle name.
sale/associate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
sale/associate/contactId	None	Company ID: Database ID of the company the user belongs to
sale/associate/personId	None	Contact ID: Database ID of the contact row
sale/associate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
sale/associate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
sale/associate/associateDbId	None	ID
sale/associate/contactName	None	Owning company: Name of the company the user belongs to
sale/associate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
sale/associate/usergroup	None	Primary group: The user's primary user group
sale/associate/contactFullName	None	Owner: Name and department of the company the user belongs to
sale/associate/contactCategory	None	Category: Category
sale/associate/role	None	Role : Role
sale/associate/assocName	None	User ID : User ID
sale/associate/assocTooltip	None	Description : Description
sale/associate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
sale/associate/ejUserId	None	Service user ID: The database ID of a Service user
sale/associate/simultaneousEjUser	None	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
sale/associate/ejDisplayName	None	Nick name: User's nick name in Service
sale/associate/ejStatus	None	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
sale/associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
sale/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
sale/associate/isActive	None	Active: Is this user active, and should be able to log in?
sale/associate/isActiveText	None	Active status: Is this user active, and should be able to log in?
sale/associate/portraitThumbnail	None	Person image: Person image
sale/associate/otherGroups	None	Other groups: Other groups
sale/associate/userName	None	User name: User name
sale/associate/personEmail	None	E-mail
sale/associate/locationAddress	None	Location: Location
sale/associate/isLocation	None	Is a location: Is a location
sale/saleUdef/SuperOffice:1	None	saleshorttext
sale/saleUdef/SuperOffice:2	None	salelongtext
sale/saleUdef/SuperOffice:3	None	salenumber
sale/saleUdef/SuperOffice:4	None	saledate
sale/saleUdef/SuperOffice:5	None	saleunlimiteddate
sale/saleUdef/SuperOffice:6	None	salecheckbox
sale/saleUdef/SuperOffice:7	None	saledropdownlistbox
sale/saleUdef/SuperOffice:8	None	saledecimal
appointment/completed	None	Completed: Displays a checkbox showing if an appointment is completed
appointment/icon	None	Category: Displays the icon for an activity type
appointment/date	None	Date: Displays start date of a follow-up / sale date of a sale
appointment/time	None	Time: Time
appointment/type	None	Type: Displays the type of an activity
appointment/recordType	None	Record type : Shows the record type
appointment/text	None	Text: Displays a descriptive text for the item
appointment/associateId	None	ID: Displays the login ID of the associate who owns the activity.
appointment/contactId	None	Company ID: Database ID of company
appointment/personId	None	Contact ID: Database ID of the contact row
appointment/projectId	None	Project ID: Database ID of project record
appointment/saleId	None	Sale ID: The database ID of the sale record
appointment/userGroup	None	User group : The user group that owns the record
appointment/who	None	Who: Contact and/or company
appointment/updatedBy	None	Updated by: The user who last updated the data
appointment/updatedByFullName	None	Updated by - Full name: The user who last updated the data
appointment/updatedDate	None	Updated: The date/time the data was last updated in UTC.
appointment/registeredBy	None	Registered by: The user who registered the data
appointment/registeredByFullName	None	Registered by - Full name: The user who registered the data
appointment/registeredDate	None	Registered date: The date/time the data was registered in UTC.
appointment/appointmentId	None	DB ID: Displays the database ID of a row
appointment/endDate	None	End date: Displays the deadline for a follow-up/sale
appointment/priority	None	Priority: Displays the priority of the activity
appointment/alarm	None	Has alarm: Displays the alarm state of a follow-up
appointment/isFree	None	Is free: Displays whether the appointment should be considered free or busy
appointment/recurring	None	Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up
appointment/booking	None	Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip.
appointment/intention	None	Intention: Displays the intention of the follow-up type
appointment/location	None	Location: Display the location where the follow-up will take place.
appointment/recurrenceRuleId	None	RR-ID: Repetition rule ID of follow-up
appointment/rawType	None	Type: Type field for appointment, not decoded or formatted
appointment/rawStatus	None	Status: Status field for the follow-up, not decoded or formatted
appointment/cautionWarning	None	Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems.
appointment/visibleInDiary	None	ExcludeBook: Is the activity visible in the diary?
appointment/endTime	None	End time: End time of an activity
appointment/suggestedAppointmentId	None	Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion
appointment/completedDate	None	Completed date: Displays the actual date a follow-up/sale was marked as completed
appointment/isMilestone	None	Milestone: Shows whether or not the follow-ups in this row are milestones
appointment/invitedPersonId	None	ID of invited person: appointment.invitedpersonid record - utility for rd
appointment/recordTypeText	None	Activity type: The type of the activity (appointment, phone call, etc)
appointment/joinVideomeetUrl	None	Video meeting URL: URL for joining the video meeting
appointment/duration	None	Duration: The duration of the chat session
appointment/createdByWorkflow	None	Created by flow: Created by flow
appointment/visibleFor	None	Visible for
appointment/appointmentPublish/isPublished	None	Published: Displays an icon indicating if the project or sale has been published
appointment/appointmentPublish/publishedFrom	None	From date: Start date for publishing. The record will not be visible prior to this date
appointment/appointmentPublish/publishedTo	None	To date: End date for publishing. The record will not be visible after this date
appointment/appointmentPublish/publishedBy	None	Published by: Published by
appointment/appointmentUdef/SuperOffice:1	None	followupshorttext
appointment/appointmentUdef/SuperOffice:2	None	followuplongtext
appointment/appointmentUdef/SuperOffice:3	None	followupnumber
appointment/appointmentUdef/SuperOffice:4	None	followupdate
appointment/appointmentUdef/SuperOffice:5	None	followupunlimiteddate
appointment/appointmentUdef/SuperOffice:6	None	followupcheckbox
appointment/appointmentUdef/SuperOffice:7	None	followupdropdownlistbox
appointment/appointmentUdef/SuperOffice:8	None	followupdecimal
appointment/associate/firstName	None	First name: Displays the contact's first name
appointment/associate/lastName	None	Last name: Displays the contact's last name

Supported Columns (cont.)

Name	Restriction	Description
appointment/associate/middleName	None	Middle Name : Displays the contact's middle name.
appointment/associate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
appointment/associate/contactId	None	Company ID: Database ID of the company the user belongs to
appointment/associate/personId	None	Contact ID: Database ID of the contact row
appointment/associate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
appointment/associate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
appointment/associate/associateDbId	None	ID
appointment/associate/contactName	None	Owning company: Name of the company the user belongs to
appointment/associate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
appointment/associate/usergroup	None	Primary group: The user's primary user group
appointment/associate/contactFullName	None	Owner: Name and department of the company the user belongs to
appointment/associate/contactCategory	None	Category: Category
appointment/associate/role	None	Role : Role
appointment/associate/assocName	None	User ID : User ID
appointment/associate/assocTooltip	None	Description : Description
appointment/associate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
appointment/associate/ejUserId	None	Service user ID: The database ID of a Service user
appointment/associate/simultaneousEjUser	None	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
appointment/associate/ejDisplayName	None	Nick name: User's nick name in Service
appointment/associate/ejStatus	None	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
appointment/associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
appointment/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
appointment/associate/isActive	None	Active: Is this user active, and should be able to log in?
appointment/associate/isActiveText	None	Active status: Is this user active, and should be able to log in?
appointment/associate/portraitThumbnail	None	Person image: Person image
appointment/associate/otherGroups	None	Other groups: Other groups
appointment/associate/userName	None	User name: User name
appointment/associate/personEmail	None	E-mail
appointment/associate/locationAddress	None	Location: Location
appointment/associate/isLocation	None	Is a location: Is a location
appointment/appointment/description	None	Text: Displays the text entered in the description field
appointment/appointment/title	None	Title
appointment/appointment/titleHtml	None	!!Title Html
appointment/appointment/agenda	None	Agenda
appointment/appointment/agendaHtml	None	!!Agenda Html
appointment/appointment/isConverted	None	!!Is Converted
appointment/appointment/textId	None	Text ID
appointment/appointment/internalNotes	None	Internal notes: Displays the text entered in the description field
appointment/appointment/internalNotesHtml	None	!!Internal Notes Html
document/completed	None	Completed: Displays a checkbox showing if an appointment is completed
document/icon	None	Category: Displays the icon for an activity type
document/date	None	Date: Displays start date of a follow-up / sale date of a sale
document/time	None	Time: Time
document/type	None	Type: Displays the type of an activity
document/recordType	None	Record type : Shows the record type
document/text	None	Text: Displays a descriptive text for the item
document/associateId	None	ID: Displays the login ID of the associate who owns the activity.
document/contactId	None	Company ID: Database ID of company
document/personId	None	Contact ID: Database ID of the contact row
document/projectId	None	Project ID: Database ID of project record
document/saleId	None	Sale ID: The database ID of the sale record
document/userGroup	None	User group : The user group that owns the record
document/who	None	Who: Contact and/or company
document/updatedBy	None	Updated by: The user who last updated the data
document/updatedByFullName	None	Updated by - Full name: The user who last updated the data
document/updatedDate	None	Updated: The date/time the data was last updated in UTC.
document/registeredBy	None	Registered by: The user who registered the data
document/registeredByFullName	None	Registered by - Full name: The user who registered the data
document/registeredDate	None	Registered date: The date/time the data was registered in UTC.
document/documentId	None	Document ID: Database ID of document record
document/keywords	None	Keywords
document/ourref	None	Our ref.
document/yourref	None	Your ref.
document/attention	None	Salutation
document/subject	None	Subject
document/name	None	File name
document/mailMergeDraft	None	Mail merge draft : Indicates whether the document is a mail merge template
document/snum	None	Document number: Serial number of document. It can be generated by the number allocation system for a dedicated document template.
document/isReport	None	Report: Is this document a saved report run?
document/suggestedDocumentId	None	Document ID (suggestion: The database ID of a document that originates in a suggestion
document/isMail	None	E-mail
document/recordTypeText	None	Activity type: The type of the activity (appointment, phone call, etc)
document/visibleFor	None	Visible for
document/documentPublish/isPublished	None	Published: Displays an icon indicating if the project or sale has been published
document/documentPublish/publishedFrom	None	From date: Start date for publishing. The record will not be visible prior to this date
document/documentPublish/publishedTo	None	To date: End date for publishing. The record will not be visible after this date
document/documentPublish/publishedBy	None	Published by: Published by
document/associate/firstName	None	First name: Displays the contact's first name
document/associate/lastName	None	Last name: Displays the contact's last name
document/associate/middleName	None	Middle Name : Displays the contact's middle name.
document/associate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
document/associate/contactId	None	Company ID: Database ID of the company the user belongs to
document/associate/personId	None	Contact ID: Database ID of the contact row
document/associate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
document/associate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
document/associate/associateDbId	None	ID
document/associate/contactName	None	Owning company: Name of the company the user belongs to
document/associate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
document/associate/usergroup	None	Primary group: The user's primary user group
document/associate/contactFullName	None	Owner: Name and department of the company the user belongs to
document/associate/contactCategory	None	Category: Category
document/associate/role	None	Role : Role
document/associate/assocName	None	User ID : User ID
document/associate/assocTooltip	None	Description : Description
document/associate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
document/associate/ejUserId	None	Service user ID: The database ID of a Service user
document/associate/simultaneousEjUser	None	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
document/associate/ejDisplayName	None	Nick name: User's nick name in Service
document/associate/ejStatus	None	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
document/associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
document/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
document/associate/isActive	None	Active: Is this user active, and should be able to log in?
document/associate/isActiveText	None	Active status: Is this user active, and should be able to log in?
document/associate/portraitThumbnail	None	Person image: Person image
document/associate/otherGroups	None	Other groups: Other groups
document/associate/userName	None	User name: User name
document/associate/personEmail	None	E-mail
document/associate/locationAddress	None	Location: Location
document/associate/isLocation	None	Is a location: Is a location
document/documentUdef/SuperOffice:1	None	documentshorttext
document/documentUdef/SuperOffice:2	None	documentlongtext
document/documentUdef/SuperOffice:3	None	documentnumber
document/documentUdef/SuperOffice:4	None	documentdate
document/documentUdef/SuperOffice:5	None	documentunlimiteddate
document/documentUdef/SuperOffice:6	None	documentcheckbox
document/documentUdef/SuperOffice:7	None	documentdropdownlistbox
document/documentUdef/SuperOffice:8	None	documentdecimal
document/document/textId	None	Text ID
document/document/description	None	Text: Displays the text entered in the description field
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
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
personCountryId	int	Country ID: Country ID	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
personUpdatedByFullName	associate	Updated by - Full name: 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
personRegisteredByFullName	associate	Registered by - Full name: 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
supportAssociateFullName	associate	Our service contact - Full name: Default service contact for this contact	x
personAssociateId	associate	Our contact: Displays our contact	x
personAssociateFullName	associate	Our contact - Full name: 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
updatedByWorkflow	listAny	Updated by flow: Updated by flow	x
whenUpdatedByWorkflow	datetime	When updated by flow: When updated by flow	x
createdByForm	listAny	Created by form: Created by form	x
personInfo/textId	int	Text ID	x
personInfo/infoText	positiveString	Information: Displays the text entered in the description field	x
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
personExtra/x_person_integer	int	Extra Integer: Custom person integer	x
personExtra/x_person_float	decimal	Extra float: Custom float field	x
personExtra/x_person_longtext	string	Extra Long Text: Custom long text field on person, keep HTML tags. Simple input, not text area. Default value = 'Hello there'	x
personExtra/x_person_date	date	Extra date: Custom date field on person. Default value = 28.03.2019	x
personExtra/x_person_datetime	datetime	Extra DateTime: Custom person date and time field. No default	x
personExtra/x_person_time	None	Extra time: Custom time field on person. Current time as default	x
personExtra/x_person_boolean	bool	Extra Boolean: Custom boolean field on person. Default checked	x
personExtra/x_person_timespan	timeSpan	Extra timespan: Custom timespan on person. Minutes only in 15 units	x
personExtra/x_person_shorttext	string	Extra short text: Custom short text on person. With index. Do not keep HTML tags	x
personExtra/x_person_shorttext_list	listAny	Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent	x
personExtra/x_person_user_relation	associate	Extra user relation: Custom person-user relation field	x
personExtra/x_person_category_relation	listAny	Extra category relation: Custom person-category relation	x
personExtra/x_person_priority_relation	listAny	Extra priority relation: Custom person-priority relation	x
personExtra/x_person_request_relation	stringorPK	Extra request relation: Request relation on contact	x
personExtra/x_person_appointment_relation	stringorPK	Extra appointment relation: Appointment relation on person	x
personExtra/x_person_contact_relation	stringorPK	Extra company relation: Company relation on contact	x
personExtra/y_rental/id	int	Rental - id: Displays the row's primary key (y_rental)	x
personExtra/y_rental/x_start	date	Rental - Start rental	x
personExtra/y_rental/x_end	date	Rental - End	x
personExtra/y_rental/x_amount	int	Rental - Amount: Number to rent. Default = 1	x
personExtra/y_rental/x_contact	stringorPK	Rental - Renter: Company that rents equipment	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
personExtra/y_rental/y_equipment/x_name	string	Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table	x
personExtra/y_car/id	int	Car - id: Displays the row's primary key (y_car)	x
isMailingRecipient	bool	Is mailing recipient: 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
fullNameWithContact	None	Contact and company: The fully formatted contact name, and full company name
personDirectPhone/formattedNumber	None	Direct - Phone: Displays phone number
personDirectPhone/description	None	Direct - Description: Phone number description
personMobilePhone/formattedNumber	None	Mobile - Phone: Displays phone number
personMobilePhone/description	None	Mobile - Description: Phone number description
personPrivate/formattedNumber	None	Private - Phone: Displays phone number
personPrivate/description	None	Private - Description: Phone number description
personPager/formattedNumber	None	Other - Phone: Displays phone number
personPager/description	None	Other - Description: Phone number description
personDirectFax/formattedNumber	None	Fax - Phone: Displays phone number
personDirectFax/description	None	Fax - Description: Phone number description
personEmail/emailProtocol	None	Protocol: E-mail protocol, such as SMTP
personEmail/emailAddress	None	E-mail
personEmail/emailDescription	None	Description
personEmail/emailId	None	ID
personEmail/emailLastSent	None	Last sent: The date and time an e-mail was last sent to this address
personEmail/emailBounceCount	None	Bounce count: Bounce count for this e-mail address
personEmail/emailLastBounce	None	Last bounce: Date and time for last bounce to this e-mail address
personEmail/emailHasBounced	None	Has bounced: This checkbox is active if delivery to this e-mail address has failed.
personUrl/URLAddress	None	URL
personUrl/URLDescription	None	Description
personAddress/addressId	None	Contact address - Address ID: Database ID for the address record
personAddress/line1	None	Contact address - Address 1: First line of the address
personAddress/line2	None	Contact address - Address 2: Second line of the address
personAddress/line3	None	Contact address - Address 3: Third line of the address
personAddress/county	None	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.
personAddress/city	None	Contact address - City: This criterion corresponds to the City field on the Company card.
personAddress/zip	None	Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
personAddress/state	None	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.
personAddress/wgs84latitude	None	Contact address - Latitude: Latitude
personAddress/wgs84longitude	None	Contact address - Longitude: Longitude
personAddress/formattedAddress	None	Contact address - {formattedAddress}: {formattedAddress}
personAddress/formattedMultiLineAddress	None	Contact address - {formattedAddress}: {formattedAddress}
personInterestIds	None	Contact interest: This criterion corresponds to a contact's interests. It is available via the Contact dialog's Interests tab.
personSourceRelation/personId	None	Source - DB ID: Displays the database ID of a contact
personSourceRelation/firstName	None	Source - First name: Displays the contact's first name
personSourceRelation/lastName	None	Source - Last name: Displays the contact's last name
personSourceRelation/middleName	None	Source - Middle name: Displays the contact's middle name.
personSourceRelation/fullName	None	Source - Contact: Displays the contact to which an item is linked
personSourceRelation/contactId	None	Source - Company ID: Database ID of company
personSourceRelation/hasInfoText	None	Source - Has note: Displays an icon indicating if there is additional information available about the contact
personSourceRelation/hasInterests	None	Source - Has interests: Displays an Icon indicating if the contact has active interests
personSourceRelation/personHasInterests	None	Source - Has interests: Displays an Icon indicating if the contact has active interests
personSourceRelation/mrMrs	None	Source - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
personSourceRelation/position	None	Source - Position
personSourceRelation/personNumber	None	Source - Number: Displays the contact's number
personSourceRelation/title	None	Source - Title: Displays the contact's job title
personSourceRelation/personCountry	None	Source - Country: Country
personSourceRelation/personCountryId	None	Source - Country ID: Country ID
personSourceRelation/personNoMail	None	Source - No Mailings: Displays the contact's No Mailings checkbox
personSourceRelation/rank	None	Source - Rank: Displays a contact's current rank
personSourceRelation/birthdate	None	Source - Birthdate: Displays the contact's date of birth
personSourceRelation/associateType	None	Source - 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.
personSourceRelation/useAsMailingAddress	None	Source - Use as postal address: Use as postal address
personSourceRelation/personSource	None	Source - Source: Source (Contact)
personSourceRelation/retired	None	Source - Former employee: Indicates whether the contact has retired/left the company
personSourceRelation/birthYear	None	Source - Birth year: Displays contact's birth year
personSourceRelation/birthMonth	None	Source - Birth month: Displays contact's birth month
personSourceRelation/birthDay	None	Source - Birth day: Displays contact's birth day (day of month)
personSourceRelation/kanaFirstName	None	Source - First name, kana: Contact's first name, in kana alphabet
personSourceRelation/kanaLastName	None	Source - Last name, kana: Contact's last name, in kana alphabet
personSourceRelation/personUpdatedBy	None	Source - Updated by: The user who last updated the data
personSourceRelation/personUpdatedByFullName	None	Source - Updated by - Full name: The user who last updated the data
personSourceRelation/personUpdatedDate	None	Source - Updated: The date/time the data was last updated in UTC.
personSourceRelation/personRegisteredBy	None	Source - Registered by: The user who registered the data
personSourceRelation/personRegisteredByFullName	None	Source - Registered by - Full name: The user who registered the data
personSourceRelation/personRegisteredDate	None	Source - Registered date: The date/time the data was registered in UTC.
personSourceRelation/portraitThumbnail	None	Source - Person image: Person image
personSourceRelation/personActiveErpLinks	None	Source - ERP connected: Is there an active ERP Sync?
personSourceRelation/ticketPriority	None	Source - Service priority: Default service priority for this contact
personSourceRelation/supportLanguage	None	Source - Preferred language: Preferred language used for reply templates and more
personSourceRelation/supportAssociate	None	Source - Our service contact: Default service contact for this contact
personSourceRelation/supportAssociateFullName	None	Source - Our service contact - Full name: Default service contact for this contact
personSourceRelation/personAssociateId	None	Source - Our contact: Displays our contact
personSourceRelation/personAssociateFullName	None	Source - Our contact - Full name: Displays our contact
personSourceRelation/personCategory	None	Source - Category
personSourceRelation/personBusiness	None	Source - Business
personSourceRelation/personDeletedDate	None	Source - Deleted date: Deleted date
personSourceRelation/hasCompany	None	Source - Has company: The contact is associated with a company
personSourceRelation/isProjectMember	None	Source - Is project member: This person is a project member
personSourceRelation/isStakeholder	None	Source - Is stakeholder: This person is a sale stakeholder
personSourceRelation/updatedByWorkflow	None	Source - Updated by flow: Updated by flow
personSourceRelation/whenUpdatedByWorkflow	None	Source - When updated by flow: When updated by flow
personSourceRelation/createdByForm	None	Source - Created by form: Created by form
personSourceRelation/restrictionContactId	None	Source - Company ID: Database ID of company to fetch relations for
personSourceRelation/restrictionPersonId	None	Source - Company ID: Database ID of company to fetch relations for
personSourceRelation/who	None	Source - Full name: Full name of company/contact
personSourceRelation/personPersonRelation	None	Source - Contact-to-contact relation: Name of relation, not taking into account the relation direction

Supported Columns (cont.)

Name	Restriction	Description
personTargetRelation/personId	None	Target - DB ID: Displays the database ID of a contact
personTargetRelation/firstName	None	Target - First name: Displays the contact's first name
personTargetRelation/lastName	None	Target - Last name: Displays the contact's last name
personTargetRelation/middleName	None	Target - Middle name: Displays the contact's middle name.
personTargetRelation/fullName	None	Target - Contact: Displays the contact to which an item is linked
personTargetRelation/contactId	None	Target - Company ID: Database ID of company
personTargetRelation/hasInfoText	None	Target - Has note: Displays an icon indicating if there is additional information available about the contact
personTargetRelation/hasInterests	None	Target - Has interests: Displays an Icon indicating if the contact has active interests
personTargetRelation/personHasInterests	None	Target - Has interests: Displays an Icon indicating if the contact has active interests
personTargetRelation/mrMrs	None	Target - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
personTargetRelation/position	None	Target - Position
personTargetRelation/personNumber	None	Target - Number: Displays the contact's number
personTargetRelation/title	None	Target - Title: Displays the contact's job title
personTargetRelation/personCountry	None	Target - Country: Country
personTargetRelation/personCountryId	None	Target - Country ID: Country ID
personTargetRelation/personNoMail	None	Target - No Mailings: Displays the contact's No Mailings checkbox
personTargetRelation/rank	None	Target - Rank: Displays a contact's current rank
personTargetRelation/birthdate	None	Target - Birthdate: Displays the contact's date of birth
personTargetRelation/associateType	None	Target - 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.
personTargetRelation/useAsMailingAddress	None	Target - Use as postal address: Use as postal address
personTargetRelation/personSource	None	Target - Source: Source (Contact)
personTargetRelation/retired	None	Target - Former employee: Indicates whether the contact has retired/left the company
personTargetRelation/birthYear	None	Target - Birth year: Displays contact's birth year
personTargetRelation/birthMonth	None	Target - Birth month: Displays contact's birth month
personTargetRelation/birthDay	None	Target - Birth day: Displays contact's birth day (day of month)
personTargetRelation/kanaFirstName	None	Target - First name, kana: Contact's first name, in kana alphabet
personTargetRelation/kanaLastName	None	Target - Last name, kana: Contact's last name, in kana alphabet
personTargetRelation/personUpdatedBy	None	Target - Updated by: The user who last updated the data
personTargetRelation/personUpdatedByFullName	None	Target - Updated by - Full name: The user who last updated the data
personTargetRelation/personUpdatedDate	None	Target - Updated: The date/time the data was last updated in UTC.
personTargetRelation/personRegisteredBy	None	Target - Registered by: The user who registered the data
personTargetRelation/personRegisteredByFullName	None	Target - Registered by - Full name: The user who registered the data
personTargetRelation/personRegisteredDate	None	Target - Registered date: The date/time the data was registered in UTC.
personTargetRelation/portraitThumbnail	None	Target - Person image: Person image
personTargetRelation/personActiveErpLinks	None	Target - ERP connected: Is there an active ERP Sync?
personTargetRelation/ticketPriority	None	Target - Service priority: Default service priority for this contact
personTargetRelation/supportLanguage	None	Target - Preferred language: Preferred language used for reply templates and more
personTargetRelation/supportAssociate	None	Target - Our service contact: Default service contact for this contact
personTargetRelation/supportAssociateFullName	None	Target - Our service contact - Full name: Default service contact for this contact
personTargetRelation/personAssociateId	None	Target - Our contact: Displays our contact
personTargetRelation/personAssociateFullName	None	Target - Our contact - Full name: Displays our contact
personTargetRelation/personCategory	None	Target - Category
personTargetRelation/personBusiness	None	Target - Business
personTargetRelation/personDeletedDate	None	Target - Deleted date: Deleted date
personTargetRelation/hasCompany	None	Target - Has company: The contact is associated with a company
personTargetRelation/isProjectMember	None	Target - Is project member: This person is a project member
personTargetRelation/isStakeholder	None	Target - Is stakeholder: This person is a sale stakeholder
personTargetRelation/updatedByWorkflow	None	Target - Updated by flow: Updated by flow
personTargetRelation/whenUpdatedByWorkflow	None	Target - When updated by flow: When updated by flow
personTargetRelation/createdByForm	None	Target - Created by form: Created by form
personTargetRelation/restrictionContactId	None	Target - Company ID: Database ID of company to fetch relations for
personTargetRelation/restrictionPersonId	None	Target - Company ID: Database ID of company to fetch relations for
personTargetRelation/who	None	Target - Full name: Full name of company/contact
personTargetRelation/personPersonRelation	None	Target - Contact-to-contact relation: Name of relation, not taking into account the relation direction
personSourceRelation/personContactRelation	None	Source - Contact-to-company relation: Name of relation, not taking into account the relation direction
personTargetRelation/contactPersonRelation	None	Target - Company-to-contact relation: Name of relation, not taking into account the relation direction
personAssociate/firstName	None	First name: Displays the contact's first name
personAssociate/lastName	None	Last name: Displays the contact's last name
personAssociate/middleName	None	Middle Name : Displays the contact's middle name.
personAssociate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
personAssociate/contactId	None	Company ID: Database ID of the company the user belongs to
personAssociate/personId	None	Contact ID: Database ID of the contact row
personAssociate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
personAssociate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
personAssociate/associateDbId	None	ID
personAssociate/contactName	None	Owning company: Name of the company the user belongs to
personAssociate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
personAssociate/usergroup	None	Primary group: The user's primary user group
personAssociate/contactFullName	None	Owner: Name and department of the company the user belongs to
personAssociate/contactCategory	None	Category: Category
personAssociate/role	None	Role : Role
personAssociate/assocName	None	User ID : User ID
personAssociate/assocTooltip	None	Description : Description
personAssociate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
personAssociate/ejUserId	None	Service user ID: The database ID of a Service user
personAssociate/simultaneousEjUser	None	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	None	Nick name: User's nick name in Service
personAssociate/ejStatus	None	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
personAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
personAssociate/isActive	None	Active: Is this user active, and should be able to log in?
personAssociate/isActiveText	None	Active status: Is this user active, and should be able to log in?
personAssociate/portraitThumbnail	None	Person image: Person image
personAssociate/otherGroups	None	Other groups: Other groups
personAssociate/userName	None	User name: User name
personAssociate/personEmail	None	E-mail
personAssociate/locationAddress	None	Location: Location
personAssociate/isLocation	None	Is a location: Is a location
correspondingAssociate/firstName	None	First name: Displays the contact's first name
correspondingAssociate/lastName	None	Last name: Displays the contact's last name
correspondingAssociate/middleName	None	Middle Name : Displays the contact's middle name.
correspondingAssociate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
correspondingAssociate/contactId	None	Company ID: Database ID of the company the user belongs to
correspondingAssociate/personId	None	Contact ID: Database ID of the contact row
correspondingAssociate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
correspondingAssociate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
correspondingAssociate/associateDbId	None	ID
correspondingAssociate/contactName	None	Owning company: Name of the company the user belongs to
correspondingAssociate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
correspondingAssociate/usergroup	None	Primary group: The user's primary user group

Supported Columns (cont.)

Name	Restriction	Description
correspondingAssociate/contactFullName	None	Owner: Name and department of the company the user belongs to
correspondingAssociate/contactCategory	None	Category: Category
correspondingAssociate/role	None	Role : Role
correspondingAssociate/assocName	None	User ID : User ID
correspondingAssociate/assocTooltip	None	Description : Description
correspondingAssociate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
correspondingAssociate/ejUserId	None	Service user ID: The database ID of a Service user
correspondingAssociate/simultaneousEjUser	None	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
correspondingAssociate/ejDisplayName	None	Nick name: User's nick name in Service
correspondingAssociate/ejStatus	None	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
correspondingAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
correspondingAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
correspondingAssociate/isActive	None	Active: Is this user active, and should be able to log in?
correspondingAssociate/isActiveText	None	Active status: Is this user active, and should be able to log in?
correspondingAssociate/portraitThumbnail	None	Person image: Person image
correspondingAssociate/otherGroups	None	Other groups: Other groups
correspondingAssociate/userName	None	User name: User name
correspondingAssociate/personEmail	None	E-mail
correspondingAssociate/locationAddress	None	Location: Location
correspondingAssociate/isLocation	None	Is a location: Is a location
request/contactId	None	Company ID: Database ID of company
request/personId	None	Contact ID: Database ID of the contact row
request/saleId	None	Sale ID: The database ID of the sale record
request/projectId	None	Project ID: Database ID of project record
request/ticketStatusId	None	Status ID: Status
request/priorityId	None	Priority ID: ID of priority in database
request/categoryId	None	Category ID: ID of ticket category in database
request/ticketTypeName	None	Request type: Request type
request/ticketStatusName	None	Status: Request status
request/categoryFullName	None	Category: Request category
request/priorityName	None	Priority: Service priority
request/ownedBy	None	Owner: The owner of the request
request/ticketId	None	ID: Displays request ID
request/title	None	Title: Displays the request title
request/createdAt	None	Created: Displays when the request was created
request/lastChanged	None	Last changed: Displays when the request was last changed
request/author	None	Author: Displays the author of the request
request/readByOwner	None	Read by owner: Displays when the request was read by the owner
request/firstReadByOwner	None	First read by owner: Displays when the request was read by owner for the first time
request/firstReadByUser	None	First read by user: Displays when the request was read by user for the first time
request/readByCustomer	None	Read by contact: Displays when the request was read by the contact
request/status	None	Internal status: Shows only system defined statuses for a request
request/origin	None	Origin: Origin
request/slevel	None	Access level: Access level
request/numberOfMessages	None	Number of messages: Number of messages
request/numberOfReplies	None	Number of replies: Number of replies
request/connectId	None	Merged with request: Merged with request
request/readStatus	None	Read: Read
request/realTimeSpentQueue	None	Real time in queue: Real time in queue
request/realTimeSpentExternally	None	Real time externally: Real time externally
request/realTimeSpentInternally	None	Real time internally: Real time internally
request/timeSpentQueue	None	Time spent in queue: Time spent in queue
request/timeSpentExternally	None	Time spent externally: Time spent externally
request/timeSpentInternally	None	Time spent internally: Time spent internally
request/timeSpent	None	Time spent: Time spent
request/timeToReply	None	Time to reply: Time to reply
request/timeToClose	None	Time to close: Time to close
request/realTimeToReply	None	Real time to reply: Real time to reply
request/realTimeToClose	None	Real time to close: Real time to close
request/repliedAt	None	Replied at: Replied at
request/closedAt	None	Closed at: Closed at
request/activated	None	Postponed to: Postponed to
request/deadline	None	Deadline: Deadline
request/has_attachment	None	Has attachment: Indicates whether the e-mail has one or more attachments
request/tags	None	Tags: Tags connected to a request
request/createdBy	None	Created by: Created by
request/content	None	Content: Search for content in messages related to requests
request/messageLanguage	None	Language: Recognized language in messages
request/sentimentScore	None	Sentiment: Sentiment score, -100 to +100
request/suggestedCategory	None	Suggested category: Suggested service category
request/createdByWorkflow	None	Created by flow: Created by flow
request/createdBy/firstName	None	Created by - First name: Displays the contact's first name
request/createdBy/lastName	None	Created by - Last name: Displays the contact's last name
request/createdBy/middleName	None	Created by - Middle Name: Displays the contact's middle name.
request/createdBy/fullName	None	Created by - Full name: Displays full name of user (first, middle, last - according to settings)
request/createdBy/contactId	None	Created by - Company ID: Database ID of the company the user belongs to
request/createdBy/personId	None	Created by - Contact ID: Database ID of the contact row
request/createdBy/mrMrs	None	Created by - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
request/createdBy/title	None	Created by - Title: Displays whether the contact is addressed as Mr or Ms
request/createdBy/associateDbId	None	Created by - ID
request/createdBy/contactName	None	Created by - Owning company: Name of the company the user belongs to
request/createdBy/contactDepartment	None	Created by - Owning department: Name of the department at the company the user belongs to
request/createdBy/usergroup	None	Created by - Primary group: The user's primary user group
request/createdBy/contactFullName	None	Created by - Owner: Name and department of the company the user belongs to
request/createdBy/contactCategory	None	Created by - Category: Category
request/createdBy/role	None	Created by - Role: Role
request/createdBy/assocName	None	Created by - User ID: User ID
request/createdBy/assocTooltip	None	Created by - Description: Description
request/createdBy/assocType	None	Created by - Type: Type of user: associate, external user, system user, anonymous account
request/createdBy/ejUserId	None	Created by - Service user ID: The database ID of a Service user
request/createdBy/simultaneousEjUser	None	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	None	Created by - Nick name: User's nick name in Service
request/createdBy/ejStatus	None	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
request/createdBy/credentialDisplayValue	None	Created by - Auth. value: Credential value (public, visible part) to be used when this user logs in
request/createdBy/isActive	None	Created by - Active: Is this user active, and should be able to log in?
request/createdBy/isActiveText	None	Created by - Active status: Is this user active, and should be able to log in?
request/createdBy/portraitThumbnail	None	Created by - Person image: Person image
request/createdBy/otherGroups	None	Created by - Other groups: Other groups
request/createdBy/userName	None	Created by - User name: User name

Supported Columns (cont.)

Name	Restriction	Description
request/createdBy/personEmail	None	Created by - E-mail
request/createdBy/locationAddress	None	Created by - Location: Location
request/createdBy/isLocation	None	Created by - Is a location: Is a location
request/ownedBy/firstName	None	Owner - First name: Displays the contact's first name
request/ownedBy/lastName	None	Owner - Last name: Displays the contact's last name
request/ownedBy/middleName	None	Owner - Middle Name: Displays the contact's middle name.
request/ownedBy/fullName	None	Owner - Full name: Displays full name of user (first, middle, last - according to settings)
request/ownedBy/contactId	None	Owner - Company ID: Database ID of the company the user belongs to
request/ownedBy/personId	None	Owner - Contact ID: Database ID of the contact row
request/ownedBy/mrMrs	None	Owner - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
request/ownedBy/title	None	Owner - Title: Displays whether the contact is addressed as Mr or Ms
request/ownedBy/associateDbId	None	Owner - ID
request/ownedBy/contactName	None	Owner - Owning company: Name of the company the user belongs to
request/ownedBy/contactDepartment	None	Owner - Owning department: Name of the department at the company the user belongs to
request/ownedBy/usergroup	None	Owner - Primary group: The user's primary user group
request/ownedBy/contactFullName	None	Owner - Owner: Name and department of the company the user belongs to
request/ownedBy/contactCategory	None	Owner - Category: Category
request/ownedBy/role	None	Owner - Role: Role
request/ownedBy/assocName	None	Owner - User ID: User ID
request/ownedBy/assocTooltip	None	Owner - Description: Description
request/ownedBy/assocType	None	Owner - Type: Type of user: associate, external user, system user, anonymous account
request/ownedBy/ejUserId	None	Owner - Service user ID: The database ID of a Service user
request/ownedBy/simultaneousEjUser	None	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	None	Owner - Nick name: User's nick name in Service
request/ownedBy/ejStatus	None	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
request/ownedBy/credentialDisplayValue	None	Owner - Auth. value: Credential value (public, visible part) to be used when this user logs in
request/ownedBy/isActive	None	Owner - Active: Is this user active, and should be able to log in?
request/ownedBy/isActiveText	None	Owner - Active status: Is this user active, and should be able to log in?
request/ownedBy/portraitThumbnail	None	Owner - Person image: Person image
request/ownedBy/otherGroups	None	Owner - Other groups: Other groups
request/ownedBy/userName	None	Owner - User name: User name
request/ownedBy/personEmail	None	Owner - E-mail
request/ownedBy/locationAddress	None	Owner - Location: Location
request/ownedBy/isLocation	None	Owner - Is a location: Is a location
request/extra/x_ticket_integer	None	Extra integer: Custom ticket integer. Default 123. External. Show in properties
request/extra/x_ticket_float	None	Extra float: Custom float on Request. 2 decimal places
request/extra/x_ticket_longtext	None	Extra long text: Custom long text on Request. Keep HTML tags. 9 line text area. Show in props
request/extra/x_ticket_date	None	Extra date: Custom date field on Request. No default value
request/extra/x_ticket_datetime	None	Extra DateTime: Custom date+time on ticket. Default = 28.03.2019 2:24 pm. External. Show in properties. Display for new request
request/extra/x_ticket_time	None	Extra time: Custom time field on Request. Default = 13min Display for new.
request/extra/x_ticket_boolean	None	Extra boolean: Custom boolean on Ticket.
request/extra/x_ticket_timespan	None	Extra timespan: Custom timespan field on Request. Default = 1 hr 25 minutes. Show in props
request/extra/x_ticket_short_text	None	Extra short text: Custom short text field on Request. Do not keep HTML tags. Display on new request
request/extra/x_ticket_shorttext_list	None	Extra Dropdown: Custom short text with list for Request Pink, Orange, Yellow, Polkadot
request/extra/x_ticket_project_relation	None	Extra project: Custom project relation on Request
request/extra/x_ticket_faq	None	Extra FAQ Relation
request/extra/x_ticket_category_relation	None	Extra category relation: Category relation on request
request/extra/y_equipment/x_name	None	Equipment - Name: Equpment name custom field. Cannot be null., show in table
request/extra/y_car/id	None	Car - id: Displays the row's primary key (y_car)
projectMembers/completed	None	Completed: Displays a check mark indicating if the project has been completed.
projectMembers/projectId	None	DB ID: Displays the database ID for a project row
projectMembers/name	None	Project name: Displays the Project's name
projectMembers/number	None	Number: Displays the project's number
projectMembers/type	None	Project type: Displays the project's type
projectMembers/status	None	Status: Displays the project's status
projectMembers/statusRank	None	Status rank: Rank of the project status in the status list
projectMembers/associateId	None	ID: Displays login ID of the associate who owns the project
projectMembers/hasInfoText	None	Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip.
projectMembers/icon	None	Category: Displays the icon for an activity type
projectMembers/text	None	Text: Displays a descriptive text for the item
projectMembers/description	None	Description : Description
projectMembers/updatedBy	None	Updated by: The user who last updated the data
projectMembers/updatedByFullName	None	Updated by - Full name: The user who last updated the data
projectMembers/updatedDate	None	Updated: The date/time the data was last updated in UTC.
projectMembers/registeredBy	None	Registered by: The user who registered the data
projectMembers/registeredByFullName	None	Registered by - Full name: The user who registered the data
projectMembers/registeredDate	None	Registered date: The date/time the data was registered in UTC.
projectMembers/hasGuide	None	Guided: Does this sale have a Sales Guide
projectMembers/nextMilestone	None	Next milestone: Date of next non-completed activity that is marked as a milestone
projectMembers/endDate	None	End date: End date of project
projectMembers/imageThumbnail	None	Thumbnail: Scaled-down image of project image
projectMembers/activeErpLinks	None	ERP connected: Is there an active ERP Sync?
projectMembers/function	None	Function: Displays the project member's function in the project
projectMembers/projectPublish/isPublished	None	Published: Displays an icon indicating if the project or sale has been published
projectMembers/projectPublish/publishedFrom	None	From date: Start date for publishing. The record will not be visible prior to this date
projectMembers/projectPublish/publishedTo	None	To date: End date for publishing. The record will not be visible after this date
projectMembers/projectPublish/publishedBy	None	Published by: Published by
projectMembers/projectEvent/isExternalEvent	None	Event: Is this an external event
projectMembers/projectEvent/eventDate	None	Event date: Event date
projectMembers/projectEvent/hasSignOn	None	Sign On: Does this event have the Sign On function enabled
projectMembers/projectEvent/hasSignOff	None	Sign Off: Does this event have the Sign Off function enabled
projectMembers/projectUrl/URLAddress	None	URL
projectMembers/projectUrl/URLDescription	None	Description
projectMembers/projectAssociate/firstName	None	First name: Displays the contact's first name
projectMembers/projectAssociate/lastName	None	Last name: Displays the contact's last name
projectMembers/projectAssociate/middleName	None	Middle Name : Displays the contact's middle name.
projectMembers/projectAssociate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
projectMembers/projectAssociate/contactId	None	Company ID: Database ID of the company the user belongs to
projectMembers/projectAssociate/personId	None	Contact ID: Database ID of the contact row
projectMembers/projectAssociate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
projectMembers/projectAssociate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
projectMembers/projectAssociate/associateDbId	None	ID
projectMembers/projectAssociate/contactName	None	Owning company: Name of the company the user belongs to
projectMembers/projectAssociate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
projectMembers/projectAssociate/usergroup	None	Primary group: The user's primary user group
projectMembers/projectAssociate/contactFullName	None	Owner: Name and department of the company the user belongs to
projectMembers/projectAssociate/contactCategory	None	Category: Category
projectMembers/projectAssociate/role	None	Role : Role
projectMembers/projectAssociate/assocName	None	User ID : User ID

Supported Columns (cont.)

Name	Restriction	Description
projectMembers/projectAssociate/assocTooltip	None	Description : Description
projectMembers/projectAssociate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
projectMembers/projectAssociate/ejUserId	None	Service user ID: The database ID of a Service user
projectMembers/projectAssociate/simultaneousEjUser	None	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	None	Nick name: User's nick name in Service
projectMembers/projectAssociate/ejStatus	None	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
projectMembers/projectAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
projectMembers/projectAssociate/isActive	None	Active: Is this user active, and should be able to log in?
projectMembers/projectAssociate/isActiveText	None	Active status: Is this user active, and should be able to log in?
projectMembers/projectAssociate/portraitThumbnail	None	Person image: Person image
projectMembers/projectAssociate/otherGroups	None	Other groups: Other groups
projectMembers/projectAssociate/userName	None	User name: User name
projectMembers/projectAssociate/personEmail	None	E-mail
projectMembers/projectAssociate/locationAddress	None	Location: Location
projectMembers/projectAssociate/isLocation	None	Is a location: Is a location
projectMembers/projectUdef/SuperOffice:1	None	projectshorttext
projectMembers/projectUdef/SuperOffice:2	None	projectlongtext
projectMembers/projectUdef/SuperOffice:3	None	projectnumber
projectMembers/projectUdef/SuperOffice:4	None	projectdate
projectMembers/projectUdef/SuperOffice:5	None	projectunlimiteddate
projectMembers/projectUdef/SuperOffice:6	None	projectcheckbox
projectMembers/projectUdef/SuperOffice:7	None	projectdropdownlistbox
projectMembers/projectUdef/SuperOffice:8	None	projectdecimal
projectMembers/projectUdef/SuperOffice:9	None	page1saleandmarketing
projectMembers/projectUdef/SuperOffice:10	None	page1saleandadmin
projectMembers/NumberOfActivities	None	Number of activities
projectMembers/NumberOfActivitiesInPeriod	None	Number of activities in last 90 days
projectMembers/NumberOfNotCompletedActivities	None	Number of non-completed activities
projectMembers/NumberOfNotCompletedActivitiesInPeriod	None	Number of non-completed activities in last 90 days
projectMembers/LastActivity	None	Date of last activity
projectMembers/LastCompletedActivity	None	Date of last completed activity
projectMembers/LastDoByActivity	None	Date of last non-completed activity
projectMembers/NumberOfSales	None	Number of sales
projectMembers/NumberOfSalesInPeriod	None	Number of sales in last 90 days
projectMembers/NumberOfNotCompletedSales	None	Number of non-completed sales
projectMembers/NumberOfNotCompletedSalesInPeriod	None	Number of non-completed sales in last 90 days
projectMembers/LastSale	None	Date of last sale
projectMembers/LastCompletedSale	None	Date of last completed sale
projectMembers/LastDoBySale	None	Date of last non-completed sale
projectMembers/SaintStatus3	None	Not completed activites with intention sale: Number of not completed activities for intention sale > 0.
projectMembers/saintSaleStatus	None	With status
projectMembers/saintAmountClass	None	Amount class
projectMembers/saintActivityType	None	SAINT type
projectMembers/saintDirection	None	Direction
projectMembers/saintIntention	None	Intention
projectMembers/saintTicketStatus	None	Status
projectMembers/saintTicketCategory	None	Category
projectMembers/project/textId	None	Text ID
projectMembers/project/infoText	None	Information: Displays the text entered in the description field
personAppointment/completed	None	Completed: Displays a checkbox showing if an appointment is completed
personAppointment/icon	None	Category: Displays the icon for an activity type
personAppointment/date	None	Date: Displays start date of a follow-up / sale date of a sale
personAppointment/time	None	Time: Time
personAppointment/type	None	Type: Displays the type of an activity
personAppointment/recordType	None	Record type : Shows the record type
personAppointment/text	None	Text: Displays a descriptive text for the item
personAppointment/associateId	None	ID: Displays the login ID of the associate who owns the activity.
personAppointment/contactId	None	Company ID: Database ID of company
personAppointment/personId	None	Contact ID: Database ID of the contact row
personAppointment/projectId	None	Project ID: Database ID of project record
personAppointment/saleId	None	Sale ID: The database ID of the sale record
personAppointment/userGroup	None	User group : The user group that owns the record
personAppointment/who	None	Who: Contact and/or company
personAppointment/updatedBy	None	Updated by: The user who last updated the data
personAppointment/updatedByFullName	None	Updated by - Full name: The user who last updated the data
personAppointment/updatedDate	None	Updated: The date/time the data was last updated in UTC.
personAppointment/registeredBy	None	Registered by: The user who registered the data
personAppointment/registeredByFullName	None	Registered by - Full name: The user who registered the data
personAppointment/registeredDate	None	Registered date: The date/time the data was registered in UTC.
personAppointment/appointmentId	None	DB ID: Displays the database ID of a row
personAppointment/endDate	None	End date: Displays the deadline for a follow-up/sale
personAppointment/priority	None	Priority: Displays the priority of the activity
personAppointment/alarm	None	Has alarm: Displays the alarm state of a follow-up
personAppointment/isFree	None	Is free: Displays whether the appointment should be considered free or busy
personAppointment/recurring	None	Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up
personAppointment/booking	None	Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip.
personAppointment/intention	None	Intention: Displays the intention of the follow-up type
personAppointment/location	None	Location: Display the location where the follow-up will take place.
personAppointment/recurrenceRuleId	None	RR-ID: Repetition rule ID of follow-up
personAppointment/rawType	None	Type: Type field for appointment, not decoded or formatted
personAppointment/rawStatus	None	Status: Status field for the follow-up, not decoded or formatted
personAppointment/cautionWarning	None	Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems.
personAppointment/visibleInDiary	None	ExcludeBook: Is the activity visible in the diary?
personAppointment/endTime	None	End time: End time of an activity
personAppointment/suggestedAppointmentId	None	Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion
personAppointment/completedDate	None	Completed date: Displays the actual date a follow-up/sale was marked as completed
personAppointment/isMilestone	None	Milestone: Shows whether or not the follow-ups in this row are milestones
personAppointment/invitedPersonId	None	ID of invited person: appointment.invitedpersonid record - utility for rd
personAppointment/recordTypeText	None	Activity type: The type of the activity (appointment, phone call, etc)
personAppointment/joinVideomeetUrl	None	Video meeting URL: URL for joining the video meeting
personAppointment/duration	None	Duration: The duration of the chat session
personAppointment/createdByWorkflow	None	Created by flow: Created by flow
personAppointment/visibleFor	None	Visible for
personAppointment/appointmentPublish/isPublished	None	Published: Displays an icon indicating if the project or sale has been published
personAppointment/appointmentPublish/publishedFrom	None	From date: Start date for publishing. The record will not be visible prior to this date
personAppointment/appointmentPublish/publishedTo	None	To date: End date for publishing. The record will not be visible after this date
personAppointment/appointmentPublish/publishedBy	None	Published by: Published by
personAppointment/appointmentUdef/SuperOffice:1	None	followupshorttext
personAppointment/appointmentUdef/SuperOffice:2	None	followuplongtext

Supported Columns (cont.)

Name	Restriction	Description
personAppointment/appointmentUdef/SuperOffice:3	None	followupnumber
personAppointment/appointmentUdef/SuperOffice:4	None	followupdate
personAppointment/appointmentUdef/SuperOffice:5	None	followupunlimiteddate
personAppointment/appointmentUdef/SuperOffice:6	None	followupcheckbox
personAppointment/appointmentUdef/SuperOffice:7	None	followupdropdownlistbox
personAppointment/appointmentUdef/SuperOffice:8	None	followupdecimal
personAppointment/associate/firstName	None	First name: Displays the contact's first name
personAppointment/associate/lastName	None	Last name: Displays the contact's last name
personAppointment/associate/middleName	None	Middle Name : Displays the contact's middle name.
personAppointment/associate/fullName	None	Full name: Displays full name of user (first, middle, last - according to settings)
personAppointment/associate/contactId	None	Company ID: Database ID of the company the user belongs to
personAppointment/associate/personId	None	Contact ID: Database ID of the contact row
personAppointment/associate/mrMrs	None	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
personAppointment/associate/title	None	Title: Displays whether the contact is addressed as Mr or Ms
personAppointment/associate/associateDbId	None	ID
personAppointment/associate/contactName	None	Owning company: Name of the company the user belongs to
personAppointment/associate/contactDepartment	None	Owning department: Name of the department at the company the user belongs to
personAppointment/associate/usergroup	None	Primary group: The user's primary user group
personAppointment/associate/contactFullName	None	Owner: Name and department of the company the user belongs to
personAppointment/associate/contactCategory	None	Category: Category
personAppointment/associate/role	None	Role : Role
personAppointment/associate/assocName	None	User ID : User ID
personAppointment/associate/assocTooltip	None	Description : Description
personAppointment/associate/assocType	None	Type: Type of user: associate, external user, system user, anonymous account
personAppointment/associate/ejUserId	None	Service user ID: The database ID of a Service user
personAppointment/associate/simultaneousEjUser	None	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	None	Nick name: User's nick name in Service
personAppointment/associate/ejStatus	None	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
personAppointment/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
personAppointment/associate/isActive	None	Active: Is this user active, and should be able to log in?
personAppointment/associate/isActiveText	None	Active status: Is this user active, and should be able to log in?
personAppointment/associate/portraitThumbnail	None	Person image: Person image
personAppointment/associate/otherGroups	None	Other groups: Other groups
personAppointment/associate/userName	None	User name: User name
personAppointment/associate/personEmail	None	E-mail
personAppointment/associate/locationAddress	None	Location: Location
personAppointment/associate/isLocation	None	Is a location: Is a location
personAppointment/appointment/description	None	Text: Displays the text entered in the description field
personAppointment/appointment/title	None	Title
personAppointment/appointment/titleHtml	None	!!Title Html
personAppointment/appointment/agenda	None	Agenda
personAppointment/appointment/agendaHtml	None	!!Agenda Html
personAppointment/appointment/isConverted	None	!!Is Converted
personAppointment/appointment/textId	None	Text ID
personAppointment/appointment/internalNotes	None	Internal notes: Displays the text entered in the description field
personAppointment/appointment/internalNotesHtml	None	!!Internal Notes Html

Sample

GET /api/v1/archive/ContactSelectionCombined?$select=countryId,searchPhone/formattedNumber,restrictionAddress/state,contactAssociate/personId,saintIntention
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv