"ContactPersonStaticSelectionV2"

Some tooltip text!

• 93 minutes to read

 • 93 minutes to read

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

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	OrderBy
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/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/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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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/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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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.

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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/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/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/ownedBy	None	Owner: The owner of the 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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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?

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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/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
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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

Sample

GET /api/v1/archive/ContactPersonStaticSelectionV2?$select=sale/updatedDate,sale/associate/simultaneousEjUser,document/associate/contactName,personUpdatedBy,supportAssociateFullName
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.