"Links"

Some tooltip text!

• 117 minutes to read

 • 117 minutes to read

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

Supported Entities

Name	Description
"appointment"	Follow-ups
"sale"	Sales
"project"	Project
"document"	Documents
"url"	[url]
"person"	Contact
"Contact"	Company
"Selection"	Selection

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool	GetAll: Get all rows of archive - use with care, you may be fetching the whole database
getNoRows	bool	GetNone: Do not get any rows from the archive
sourceAppointmentRestrictionId	int	Source follow-up ID: Unique ID of follow-up to fetch link data for
sourceSaleRestrictionId	int	Source sale ID: Unique ID of sale to fetch link data for
sourceDocumentRestrictionId	int	Source document ID: Unique ID of document to fetch link data for
sourceProjectRestrictionId	int	Source project ID: Unique ID of project there is a link from
sourcePersonRestrictionId	int	Contact ID: Database ID of the contact row
sourceContactRestrictionId	int	Company ID: Database ID of company
sourceSelectionRestrictionId	int	Selection ID: The database ID of the selection
linkId	int	Link ID: Unique ID of relation between linked entities
linkDescription	string	Link description: A description of the relation between linked entities
completed	bool	Completed: Displays a checkbox showing if an appointment is completed
icon	listAny	Category: Displays the icon for an activity type	x
date	date	Date: Displays start date of a follow-up / sale date of a sale
time	None	Time: Time
type	listAny	Type: Displays the type of an activity
recordType	string	Record type : Shows the record type
text	positiveString	Text: Displays a descriptive text for the item	x
associateId	associate	ID: Displays the login ID of the associate who owns the activity.
contactId	listAny	Company ID: Database ID of company
personId	listAny	Contact ID: Database ID of the contact row
projectId	listAny	Project ID: Database ID of project record
saleId	int	Sale ID: The database ID of the sale record
userGroup	userGroup	User group : The user group that owns the record
who	None	Who: Contact and/or company
updatedBy	associate	Updated by: The user who last updated the data
updatedByFullName	associate	Updated by - Full name: The user who last updated the data
updatedDate	date	Updated: The date/time the data was last updated in UTC.
registeredBy	associate	Registered by: The user who registered the data
registeredByFullName	associate	Registered by - Full name: The user who registered the data
registeredDate	date	Registered date: The date/time the data was registered in UTC.
appointmentId	int	DB ID: Displays the database ID of a row
endDate	date	End date: Displays the deadline for a follow-up/sale
priority	listAny	Priority: Displays the priority of the activity
alarm	bool	Has alarm: Displays the alarm state of a follow-up
isFree	bool	Is free: Displays whether the appointment should be considered free or busy
recurring	bool	Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up
booking	bool	Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip.
intention	listAny	Intention: Displays the intention of the follow-up type
location	string	Location: Display the location where the follow-up will take place.
recurrenceRuleId	int	RR-ID: Repetition rule ID of follow-up
rawType	int	Type: Type field for appointment, not decoded or formatted
rawStatus	int	Status: Status field for the follow-up, not decoded or formatted
cautionWarning	listAny	Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems.
visibleInDiary	bool	ExcludeBook: Is the activity visible in the diary?
endTime	None	End time: End time of an activity
suggestedAppointmentId	int	Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion
completedDate	date	Completed date: Displays the actual date a follow-up/sale was marked as completed
isMilestone	bool	Milestone: Shows whether or not the follow-ups in this row are milestones
invitedPersonId	int	ID of invited person: appointment.invitedpersonid record - utility for rd
recordTypeText	listAny	Activity type: The type of the activity (appointment, phone call, etc)
joinVideomeetUrl	None	Video meeting URL: URL for joining the video meeting
duration	timeSpan	Duration: The duration of the chat session
createdByWorkflow	listAny	Created by flow: Created by flow
visibleFor	listAny	Visible for
appointmentPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
appointmentPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
appointmentPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date
appointmentPublish/publishedBy	None	Published by: Published by
contact/contactId	int	Company ID: Database ID of company
contact/name	stringorPK	Company name
contact/department	string	Department
contact/nameDepartment	None	Company: Displays the company an activity is linked to
contact/hasInfoText	bool	Has note: Displays an icon indicating if there is additional information available about the contact
contact/hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests
contact/associateId	associate	Our contact: Displays our contact
contact/category	listAny	Category
contact/business	listAny	Business
contact/country	listAny	Country: This criterion corresponds to the Country field on the Company card.
contact/countryId	int	Country ID: Country ID
contact/number	string	Number
contact/code	string	Code
contact/orgnr	string	VAT No.
contact/stop	bool	Stop
contact/contactNoMail	bool	No mailings (company
contact/updatedBy	associate	Updated by: The user who last updated the data
contact/updatedByFullName	associate	Updated by - Full name: The user who last updated the data
contact/updatedDate	date	Updated: The date/time the data was last updated in UTC.
contact/registeredBy	associate	Registered by: The user who registered the data
contact/registeredByFullName	associate	Registered by - Full name: The user who registered the data
contact/registeredDate	date	Registered date: The date/time the data was registered in UTC.
contact/contactSource	listAny	Source: Source (Company)
contact/contactDeleted	bool	Deleted: Deleted
contact/phone/formattedNumber	string	Phone : Displays phone number
contact/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?
contact/deletedDate	datetime	Deleted date: Deleted date
contact/mainContact	None	Main contact: Main contact for this company
contact/contactPhone/formattedNumber	string	Telephone - Phone: Displays phone number
contact/contactPhone/description	string	Telephone - Description: Phone number description
contact/contactFax/formattedNumber	string	Fax - Phone: Displays phone number
contact/contactFax/description	string	Fax - Description: Phone number description
contact/searchPhone/formattedNumber	string	Searchphone - Phone: Displays phone number
contact/searchPhone/description	string	Searchphone - Description: Phone number description
contact/email/emailProtocol	string	Protocol: E-mail protocol, such as SMTP
contact/email/emailAddress	string	E-mail
contact/email/emailDescription	string	Description
contact/email/emailId	int	ID
contact/email/emailLastSent	datetime	Last sent: The date and time an e-mail was last sent to this address
contact/email/emailBounceCount	int	Bounce count: Bounce count for this e-mail address

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
contact/email/emailLastBounce	datetime	Last bounce: Date and time for last bounce to this e-mail address
contact/email/emailHasBounced	bool	Has bounced: This checkbox is active if delivery to this e-mail address has failed.
contact/postAddress/addressId	int	Postal address - Address ID: Database ID for the address record
contact/postAddress/line1	string	Postal address - Address 1: First line of the address
contact/postAddress/line2	string	Postal address - Address 2: Second line of the address
contact/postAddress/line3	string	Postal address - Address 3: Third line of the address
contact/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.
contact/postAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.
contact/postAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
contact/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.
contact/postAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude
contact/postAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude
contact/postAddress/formattedAddress	None	Postal address - {formattedAddress}: {formattedAddress}
contact/postAddress/formattedMultiLineAddress	None	Postal address - {formattedAddress}: {formattedAddress}
contact/streetAddress/addressId	int	Street address - Address ID: Database ID for the address record
contact/streetAddress/line1	string	Street address - Address 1: First line of the address
contact/streetAddress/line2	string	Street address - Address 2: Second line of the address
contact/streetAddress/line3	string	Street address - Address 3: Third line of the address
contact/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.
contact/streetAddress/city	string	Street address - City: This criterion corresponds to the City field on the Company card.
contact/streetAddress/zip	string	Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
contact/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.
contact/streetAddress/wgs84latitude	decimal	Street address - Latitude: Latitude
contact/streetAddress/wgs84longitude	decimal	Street address - Longitude: Longitude
contact/streetAddress/formattedAddress	None	Street address - {formattedAddress}: {formattedAddress}
contact/streetAddress/formattedMultiLineAddress	None	Street address - {formattedAddress}: {formattedAddress}
contact/restrictionAddress/addressId	int	Search address - Address ID: Database ID for the address record
contact/restrictionAddress/line1	string	Search address - Address 1: First line of the address
contact/restrictionAddress/line2	string	Search address - Address 2: Second line of the address
contact/restrictionAddress/line3	string	Search address - Address 3: Third line of the address
contact/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.
contact/restrictionAddress/city	string	Search address - City: This criterion corresponds to the City field on the Company card.
contact/restrictionAddress/zip	string	Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
contact/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.
contact/restrictionAddress/wgs84latitude	decimal	Search address - Latitude: Latitude
contact/restrictionAddress/wgs84longitude	decimal	Search address - Longitude: Longitude
contact/restrictionAddress/formattedAddress	None	Search address - {formattedAddress}: {formattedAddress}
contact/restrictionAddress/formattedMultiLineAddress	None	Search address - {formattedAddress}: {formattedAddress}
contact/url/URLAddress	string	URL
contact/url/URLDescription	string	Description
contact/contactAssociate/firstName	string	First name: Displays the contact's first name
contact/contactAssociate/lastName	string	Last name: Displays the contact's last name
contact/contactAssociate/middleName	string	Middle Name : Displays the contact's middle name.
contact/contactAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
contact/contactAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
contact/contactAssociate/personId	int	Contact ID: Database ID of the contact row
contact/contactAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
contact/contactAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
contact/contactAssociate/associateDbId	associate	ID
contact/contactAssociate/contactName	string	Owning company: Name of the company the user belongs to
contact/contactAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
contact/contactAssociate/usergroup	userGroup	Primary group: The user's primary user group
contact/contactAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to
contact/contactAssociate/contactCategory	listAny	Category: Category
contact/contactAssociate/role	listAny	Role : Role
contact/contactAssociate/assocName	associate	User ID : User ID
contact/contactAssociate/assocTooltip	string	Description : Description
contact/contactAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
contact/contactAssociate/ejUserId	int	Service user ID: The database ID of a Service user
contact/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
contact/contactAssociate/ejDisplayName	string	Nick name: User's nick name in Service
contact/contactAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
contact/contactAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
contact/contactAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
contact/contactAssociate/isActive	bool	Active: Is this user active, and should be able to log in?
contact/contactAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
contact/contactAssociate/portraitThumbnail	None	Person image: Person image
contact/contactAssociate/otherGroups	userGroup	Other groups: Other groups
contact/contactAssociate/userName	string	User name: User name
contact/contactAssociate/personEmail	string	E-mail
contact/contactAssociate/locationAddress	string	Location: Location
contact/contactAssociate/isLocation	bool	Is a location: Is a location
contact/contactInterestIds	listInterest	Company Interest: This criterion corresponds to the Interests tab on the Company card.
contact/contactUdef/SuperOffice:1	string	companyshorttext: tooltipshorttext
contact/contactUdef/SuperOffice:2	string	companylongtext: tooltiplongtext
contact/contactUdef/SuperOffice:3	int	companynumber
contact/contactUdef/SuperOffice:4	date	companydate
contact/contactUdef/SuperOffice:5	unlimitedDate	companyunlimiteddate: tooltipunlimiteddate
contact/contactUdef/SuperOffice:6	bool	companycheckbox
contact/contactUdef/SuperOffice:7	listAny	companydropdownlistbox
contact/contactUdef/SuperOffice:8	decimal	companydecimal
contact/contactUdef/SuperOffice:9	string	page1saleonly
contact/contactUdef/SuperOffice:10	string	page1marketingonly
contact/contactUdef/SuperOffice:11	string	page1adminonly
contact/contactUdef/SuperOffice:12	listAny	Udlist one: Static tooltip for udlist one
contact/contactUdef/SuperOffice:13	listAny	Udlist two: Static tooltip for udlist two
contact/contactExtra/x_contact_integer	int	Extra Integer: Custom integer field
contact/contactExtra/x_contact_default_integer	int	Extra Default Integer: Custom integer field with default value 123.
contact/contactExtra/x_contact_float	decimal	Extra Float: Custom float field with 3 decimals
contact/contactExtra/x_contact_longtext	string	Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor
contact/contactExtra/x_contact_dropdown	listAny	Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.
contact/contactExtra/x_contact_date	date	Extra date: Custom date field. User current as default.
contact/contactExtra/x_contact_datetime	datetime	Extra DateTime: Custom Date Time field. No default value. External
contact/contactExtra/x_contact_time	None	Extra time: Custom time field.
contact/contactExtra/x_contact_boolean	bool	Extra boolean: Custom boolean field.
contact/contactExtra/x_contact_timespan	timeSpan	Extra timespan: Custom timespan field. Hours and minutes in 10 units
contact/contactExtra/x_contact_shorttext	string	Extra short text: Custom short text field. Keep HTML tags.
contact/contactExtra/x_contact_short_dropdown	listAny	Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.
contact/contactExtra/x_contact_contact_relation	stringorPK	Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons
contact/contactExtra/x_contact_request_relation	stringorPK	Extra Request relation: Request relation on company

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
contact/contactExtra/x_contact_contact	stringorPK	Extra contact relation: Contact relation on company
contact/contactExtra/y_organization/x_name	string	Organization - Name
contact/NumberOfActivities	int	Number of activities
contact/NumberOfActivitiesInPeriod	int	Number of activities in last 90 days
contact/NumberOfNotCompletedActivities	int	Number of non-completed activities
contact/NumberOfNotCompletedActivitiesInPeriod	int	Number of non-completed activities in last 90 days
contact/LastActivity	date	Date of last activity
contact/LastCompletedActivity	date	Date of last completed activity
contact/LastDoByActivity	date	Date of last non-completed activity
contact/NumberOfSales	int	Number of sales
contact/NumberOfSalesInPeriod	int	Number of sales in last 90 days
contact/NumberOfNotCompletedSales	int	Number of non-completed sales
contact/NumberOfNotCompletedSalesInPeriod	int	Number of non-completed sales in last 90 days
contact/LastSale	date	Date of last sale
contact/LastCompletedSale	date	Date of last completed sale
contact/LastDoBySale	date	Date of last non-completed sale
contact/NumberOfTickets	int	Number of requests
contact/NumberOfTicketsInPeriod	int	Number of requests in last 90 days
contact/NumberOfNotCompletedTickets	int	Number of non-completed requests
contact/NumberOfNotCompletedTicketsInPeriod	int	Number of non-completed requests in last 90 days
contact/LastTicket	date	Date of last request
contact/LastCompletedTicket	date	Date of last completed request
contact/LastDoByTicket	date	Date of last non-completed request
contact/SaintStatus1	saintStatus	Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden.
contact/SaintStatus2	saintStatus	C-company: Kundens navn starter med bokstaven C
contact/saintSaleStatus	listAny	With status
contact/saintAmountClass	listAny	Amount class
contact/saintActivityType	listAny	SAINT type
contact/saintDirection	listAny	Direction
contact/saintIntention	listAny	Intention
contact/saintTicketStatus	listAny	Status
contact/saintTicketCategory	listAny	Category
person/personId	int	DB ID: Displays the database ID of a contact
person/firstName	string	First name: Displays the contact's first name
person/lastName	string	Last name: Displays the contact's last name
person/middleName	string	Middle name: Displays the contact's middle name.
person/fullName	stringorPK	Contact: Displays the contact to which an item is linked
person/contactId	int	Company ID: Database ID of company
person/hasInfoText	bool	Has note: Displays an icon indicating if there is additional information available about the contact
person/hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests
person/personHasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests
person/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
person/position	listAny	Position
person/personNumber	string	Number: Displays the contact's number
person/title	string	Title: Displays the contact's job title
person/personCountry	listAny	Country: Country
person/personCountryId	int	Country ID: Country ID
person/personNoMail	bool	No Mailings: Displays the contact's No Mailings checkbox
person/rank	int	Rank: Displays a contact's current rank
person/birthdate	None	Birthdate: Displays the contact's date of birth
person/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.
person/useAsMailingAddress	bool	Use as postal address: Use as postal address
person/personSource	listAny	Source: Source (Contact)
person/retired	bool	Former employee: Indicates whether the contact has retired/left the company
person/birthYear	int	Birth year: Displays contact's birth year
person/birthMonth	int	Birth month: Displays contact's birth month
person/birthDay	int	Birth day: Displays contact's birth day (day of month)
person/kanaFirstName	string	First name, kana: Contact's first name, in kana alphabet
person/kanaLastName	string	Last name, kana: Contact's last name, in kana alphabet
person/personUpdatedBy	associate	Updated by: The user who last updated the data
person/personUpdatedByFullName	associate	Updated by - Full name: The user who last updated the data
person/personUpdatedDate	date	Updated: The date/time the data was last updated in UTC.
person/personRegisteredBy	associate	Registered by: The user who registered the data
person/personRegisteredByFullName	associate	Registered by - Full name: The user who registered the data
person/personRegisteredDate	date	Registered date: The date/time the data was registered in UTC.
person/portraitThumbnail	None	Person image: Person image
person/personActiveErpLinks	bool	ERP connected: Is there an active ERP Sync?
person/ticketPriority	listAny	Service priority: Default service priority for this contact
person/supportLanguage	listAny	Preferred language: Preferred language used for reply templates and more
person/supportAssociate	associate	Our service contact: Default service contact for this contact
person/supportAssociateFullName	associate	Our service contact - Full name: Default service contact for this contact
person/personAssociateId	associate	Our contact: Displays our contact
person/personAssociateFullName	associate	Our contact - Full name: Displays our contact
person/personCategory	listAny	Category
person/personBusiness	listAny	Business
person/personDeletedDate	datetime	Deleted date: Deleted date
person/hasCompany	bool	Has company: The contact is associated with a company
person/isProjectMember	bool	Is project member: This person is a project member
person/isStakeholder	bool	Is stakeholder: This person is a sale stakeholder
person/updatedByWorkflow	listAny	Updated by flow: Updated by flow
person/whenUpdatedByWorkflow	datetime	When updated by flow: When updated by flow
person/createdByForm	listAny	Created by form: Created by form
person/phone/formattedNumber	string	Phone : Displays phone number
person/personDirectPhone/formattedNumber	string	Direct - Phone: Displays phone number
person/personDirectPhone/description	string	Direct - Description: Phone number description
person/personMobilePhone/formattedNumber	string	Mobile - Phone: Displays phone number
person/personMobilePhone/description	string	Mobile - Description: Phone number description
person/personPrivate/formattedNumber	string	Private - Phone: Displays phone number
person/personPrivate/description	string	Private - Description: Phone number description
person/personPager/formattedNumber	string	Other - Phone: Displays phone number
person/personPager/description	string	Other - Description: Phone number description
person/personDirectFax/formattedNumber	string	Fax - Phone: Displays phone number
person/personDirectFax/description	string	Fax - Description: Phone number description
person/searchPhone/formattedNumber	string	Phone : Displays phone number
person/searchPhone/description	string	Description: Phone number description
person/personInfo/textId	int	Text ID
person/personInfo/infoText	positiveString	Information: Displays the text entered in the description field
person/email/emailProtocol	string	Protocol: E-mail protocol, such as SMTP
person/email/emailAddress	string	E-mail
person/email/emailDescription	string	Description

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
person/email/emailId	int	ID
person/email/emailLastSent	datetime	Last sent: The date and time an e-mail was last sent to this address
person/email/emailBounceCount	int	Bounce count: Bounce count for this e-mail address
person/email/emailLastBounce	datetime	Last bounce: Date and time for last bounce to this e-mail address
person/email/emailHasBounced	bool	Has bounced: This checkbox is active if delivery to this e-mail address has failed.
person/personUrl/URLAddress	string	URL
person/personUrl/URLDescription	string	Description
person/personAddress/addressId	int	Contact address - Address ID: Database ID for the address record
person/personAddress/line1	string	Contact address - Address 1: First line of the address
person/personAddress/line2	string	Contact address - Address 2: Second line of the address
person/personAddress/line3	string	Contact address - Address 3: Third line of the address
person/personAddress/county	string	Contact address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format.
person/personAddress/city	string	Contact address - City: This criterion corresponds to the City field on the Company card.
person/personAddress/zip	string	Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
person/personAddress/state	string	Contact address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format.
person/personAddress/wgs84latitude	decimal	Contact address - Latitude: Latitude
person/personAddress/wgs84longitude	decimal	Contact address - Longitude: Longitude
person/personAddress/formattedAddress	None	Contact address - {formattedAddress}: {formattedAddress}
person/personAddress/formattedMultiLineAddress	None	Contact address - {formattedAddress}: {formattedAddress}
person/restrictionAddress/addressId	int	Search address - Address ID: Database ID for the address record
person/restrictionAddress/line1	string	Search address - Address 1: First line of the address
person/restrictionAddress/line2	string	Search address - Address 2: Second line of the address
person/restrictionAddress/line3	string	Search address - Address 3: Third line of the address
person/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.
person/restrictionAddress/city	string	Search address - City: This criterion corresponds to the City field on the Company card.
person/restrictionAddress/zip	string	Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
person/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.
person/restrictionAddress/wgs84latitude	decimal	Search address - Latitude: Latitude
person/restrictionAddress/wgs84longitude	decimal	Search address - Longitude: Longitude
person/restrictionAddress/formattedAddress	None	Search address - {formattedAddress}: {formattedAddress}
person/restrictionAddress/formattedMultiLineAddress	None	Search address - {formattedAddress}: {formattedAddress}
person/personInterestIds	listInterest	Contact interest: This criterion corresponds to a contact's interests. It is available via the Contact dialog's Interests tab.
person/personUdef/SuperOffice:1	string	contactshorttext: tooltipshorttext
person/personUdef/SuperOffice:2	string	contactlongtext: tooltiplongtext
person/personUdef/SuperOffice:3	int	contactnumber
person/personUdef/SuperOffice:4	date	contactdate
person/personUdef/SuperOffice:5	unlimitedDate	contactunlimiteddate: tooltipunlimiteddate
person/personUdef/SuperOffice:6	bool	contactcheckbox
person/personUdef/SuperOffice:7	listAny	contactdropdownlistbox
person/personUdef/SuperOffice:8	decimal	contactdecimal
person/personUdef/SuperOffice:9	string	page1saleonly
person/personUdef/SuperOffice:10	string	page1marketingonly
person/personUdef/SuperOffice:11	string	page1adminonly
person/personExtra/x_person_integer	int	Extra Integer: Custom person integer
person/personExtra/x_person_float	decimal	Extra float: Custom float field
person/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'
person/personExtra/x_person_date	date	Extra date: Custom date field on person. Default value = 28.03.2019
person/personExtra/x_person_datetime	datetime	Extra DateTime: Custom person date and time field. No default
person/personExtra/x_person_time	None	Extra time: Custom time field on person. Current time as default
person/personExtra/x_person_boolean	bool	Extra Boolean: Custom boolean field on person. Default checked
person/personExtra/x_person_timespan	timeSpan	Extra timespan: Custom timespan on person. Minutes only in 15 units
person/personExtra/x_person_shorttext	string	Extra short text: Custom short text on person. With index. Do not keep HTML tags
person/personExtra/x_person_shorttext_list	listAny	Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent
person/personExtra/x_person_user_relation	associate	Extra user relation: Custom person-user relation field
person/personExtra/x_person_category_relation	listAny	Extra category relation: Custom person-category relation
person/personExtra/x_person_priority_relation	listAny	Extra priority relation: Custom person-priority relation
person/personExtra/x_person_request_relation	stringorPK	Extra request relation: Request relation on contact
person/personExtra/x_person_appointment_relation	stringorPK	Extra appointment relation: Appointment relation on person
person/personExtra/x_person_contact_relation	stringorPK	Extra company relation: Company relation on contact
person/personExtra/y_rental/id	int	Rental - id: Displays the row's primary key (y_rental)
person/personExtra/y_rental/x_start	date	Rental - Start rental
person/personExtra/y_rental/x_end	date	Rental - End
person/personExtra/y_rental/x_amount	int	Rental - Amount: Number to rent. Default = 1
person/personExtra/y_rental/x_contact	stringorPK	Rental - Renter: Company that rents equipment
person/personExtra/y_rental/y_equipment/x_name	string	Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table
person/personExtra/y_car/id	int	Car - id: Displays the row's primary key (y_car)
person/personAssociate/firstName	string	First name: Displays the contact's first name
person/personAssociate/lastName	string	Last name: Displays the contact's last name
person/personAssociate/middleName	string	Middle Name : Displays the contact's middle name.
person/personAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
person/personAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
person/personAssociate/personId	int	Contact ID: Database ID of the contact row
person/personAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
person/personAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
person/personAssociate/associateDbId	associate	ID
person/personAssociate/contactName	string	Owning company: Name of the company the user belongs to
person/personAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
person/personAssociate/usergroup	userGroup	Primary group: The user's primary user group
person/personAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to
person/personAssociate/contactCategory	listAny	Category: Category
person/personAssociate/role	listAny	Role : Role
person/personAssociate/assocName	associate	User ID : User ID
person/personAssociate/assocTooltip	string	Description : Description
person/personAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
person/personAssociate/ejUserId	int	Service user ID: The database ID of a Service user
person/personAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
person/personAssociate/ejDisplayName	string	Nick name: User's nick name in Service
person/personAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
person/personAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
person/personAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
person/personAssociate/isActive	bool	Active: Is this user active, and should be able to log in?
person/personAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
person/personAssociate/portraitThumbnail	None	Person image: Person image
person/personAssociate/otherGroups	userGroup	Other groups: Other groups
person/personAssociate/userName	string	User name: User name
person/personAssociate/personEmail	string	E-mail
person/personAssociate/locationAddress	string	Location: Location
person/personAssociate/isLocation	bool	Is a location: Is a location
person/correspondingAssociate/firstName	string	First name: Displays the contact's first name
person/correspondingAssociate/lastName	string	Last name: Displays the contact's last name

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
person/correspondingAssociate/middleName	string	Middle Name : Displays the contact's middle name.
person/correspondingAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
person/correspondingAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
person/correspondingAssociate/personId	int	Contact ID: Database ID of the contact row
person/correspondingAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
person/correspondingAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
person/correspondingAssociate/associateDbId	associate	ID
person/correspondingAssociate/contactName	string	Owning company: Name of the company the user belongs to
person/correspondingAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
person/correspondingAssociate/usergroup	userGroup	Primary group: The user's primary user group
person/correspondingAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to
person/correspondingAssociate/contactCategory	listAny	Category: Category
person/correspondingAssociate/role	listAny	Role : Role
person/correspondingAssociate/assocName	associate	User ID : User ID
person/correspondingAssociate/assocTooltip	string	Description : Description
person/correspondingAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
person/correspondingAssociate/ejUserId	int	Service user ID: The database ID of a Service user
person/correspondingAssociate/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
person/correspondingAssociate/ejDisplayName	string	Nick name: User's nick name in Service
person/correspondingAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
person/correspondingAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
person/correspondingAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
person/correspondingAssociate/isActive	bool	Active: Is this user active, and should be able to log in?
person/correspondingAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
person/correspondingAssociate/portraitThumbnail	None	Person image: Person image
person/correspondingAssociate/otherGroups	userGroup	Other groups: Other groups
person/correspondingAssociate/userName	string	User name: User name
person/correspondingAssociate/personEmail	string	E-mail
person/correspondingAssociate/locationAddress	string	Location: Location
person/correspondingAssociate/isLocation	bool	Is a location: Is a location
person/isMailingRecipient	bool	Is mailing recipient: isMailingRecipient
person/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.
person/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.
person/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.
person/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.
person/subscription	listAny	Subscription: Subscription for marketing
person/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.
person/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.
person/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.
person/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.
appointmentUdef/SuperOffice:1	string	followupshorttext
appointmentUdef/SuperOffice:2	string	followuplongtext
appointmentUdef/SuperOffice:3	int	followupnumber
appointmentUdef/SuperOffice:4	date	followupdate
appointmentUdef/SuperOffice:5	unlimitedDate	followupunlimiteddate
appointmentUdef/SuperOffice:6	bool	followupcheckbox
appointmentUdef/SuperOffice:7	listAny	followupdropdownlistbox
appointmentUdef/SuperOffice:8	decimal	followupdecimal
project/completed	bool	Completed: Displays a check mark indicating if the project has been completed.
project/projectId	int	DB ID: Displays the database ID for a project row
project/name	stringorPK	Project name: Displays the Project's name
project/number	string	Number: Displays the project's number
project/type	listAny	Project type: Displays the project's type
project/status	listAny	Status: Displays the project's status
project/statusRank	None	Status rank: Rank of the project status in the status list
project/associateId	associate	ID: Displays login ID of the associate who owns the project
project/hasInfoText	bool	Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip.
project/icon	None	Category: Displays the icon for an activity type
project/text	string	Text: Displays a descriptive text for the item
project/description	string	Description : Description
project/updatedBy	associate	Updated by: The user who last updated the data
project/updatedByFullName	associate	Updated by - Full name: The user who last updated the data
project/updatedDate	date	Updated: The date/time the data was last updated in UTC.
project/registeredBy	associate	Registered by: The user who registered the data
project/registeredByFullName	associate	Registered by - Full name: The user who registered the data
project/registeredDate	date	Registered date: The date/time the data was registered in UTC.
project/hasGuide	bool	Guided: Does this sale have a Sales Guide
project/nextMilestone	date	Next milestone: Date of next non-completed activity that is marked as a milestone
project/endDate	date	End date: End date of project
project/imageThumbnail	None	Thumbnail: Scaled-down image of project image
project/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?
project/projectPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
project/projectPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
project/projectPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date
project/projectPublish/publishedBy	None	Published by: Published by
project/projectEvent/isExternalEvent	bool	Event: Is this an external event
project/projectEvent/eventDate	date	Event date: Event date
project/projectEvent/hasSignOn	bool	Sign On: Does this event have the Sign On function enabled
project/projectEvent/hasSignOff	bool	Sign Off: Does this event have the Sign Off function enabled
project/projectUrl/URLAddress	string	URL
project/projectUrl/URLDescription	string	Description
project/projectAssociate/firstName	string	First name: Displays the contact's first name
project/projectAssociate/lastName	string	Last name: Displays the contact's last name
project/projectAssociate/middleName	string	Middle Name : Displays the contact's middle name.
project/projectAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
project/projectAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
project/projectAssociate/personId	int	Contact ID: Database ID of the contact row
project/projectAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
project/projectAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
project/projectAssociate/associateDbId	associate	ID
project/projectAssociate/contactName	string	Owning company: Name of the company the user belongs to
project/projectAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
project/projectAssociate/usergroup	userGroup	Primary group: The user's primary user group
project/projectAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to
project/projectAssociate/contactCategory	listAny	Category: Category
project/projectAssociate/role	listAny	Role : Role
project/projectAssociate/assocName	associate	User ID : User ID
project/projectAssociate/assocTooltip	string	Description : Description
project/projectAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
project/projectAssociate/ejUserId	int	Service user ID: The database ID of a Service user

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
project/projectAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
project/projectAssociate/ejDisplayName	string	Nick name: User's nick name in Service
project/projectAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
project/projectAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
project/projectAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
project/projectAssociate/isActive	bool	Active: Is this user active, and should be able to log in?
project/projectAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
project/projectAssociate/portraitThumbnail	None	Person image: Person image
project/projectAssociate/otherGroups	userGroup	Other groups: Other groups
project/projectAssociate/userName	string	User name: User name
project/projectAssociate/personEmail	string	E-mail
project/projectAssociate/locationAddress	string	Location: Location
project/projectAssociate/isLocation	bool	Is a location: Is a location
project/projectUdef/SuperOffice:1	string	projectshorttext
project/projectUdef/SuperOffice:2	string	projectlongtext
project/projectUdef/SuperOffice:3	int	projectnumber
project/projectUdef/SuperOffice:4	date	projectdate
project/projectUdef/SuperOffice:5	unlimitedDate	projectunlimiteddate
project/projectUdef/SuperOffice:6	bool	projectcheckbox
project/projectUdef/SuperOffice:7	listAny	projectdropdownlistbox
project/projectUdef/SuperOffice:8	decimal	projectdecimal
project/projectUdef/SuperOffice:9	int	page1saleandmarketing
project/projectUdef/SuperOffice:10	int	page1saleandadmin
project/NumberOfActivities	int	Number of activities
project/NumberOfActivitiesInPeriod	int	Number of activities in last 90 days
project/NumberOfNotCompletedActivities	int	Number of non-completed activities
project/NumberOfNotCompletedActivitiesInPeriod	int	Number of non-completed activities in last 90 days
project/LastActivity	date	Date of last activity
project/LastCompletedActivity	date	Date of last completed activity
project/LastDoByActivity	date	Date of last non-completed activity
project/NumberOfSales	int	Number of sales
project/NumberOfSalesInPeriod	int	Number of sales in last 90 days
project/NumberOfNotCompletedSales	int	Number of non-completed sales
project/NumberOfNotCompletedSalesInPeriod	int	Number of non-completed sales in last 90 days
project/LastSale	date	Date of last sale
project/LastCompletedSale	date	Date of last completed sale
project/LastDoBySale	date	Date of last non-completed sale
project/SaintStatus3	saintStatus	Not completed activites with intention sale: Number of not completed activities for intention sale > 0.
project/saintSaleStatus	listAny	With status
project/saintAmountClass	listAny	Amount class
project/saintActivityType	listAny	SAINT type
project/saintDirection	listAny	Direction
project/saintIntention	listAny	Intention
project/saintTicketStatus	listAny	Status
project/saintTicketCategory	listAny	Category
project/project/textId	int	Text ID
project/project/infoText	positiveString	Information: Displays the text entered in the description field
sale/completed	bool	Completed: Displays a checkbox showing if an appointment is completed
sale/icon	listAny	Category: Displays the icon for an activity type
sale/date	date	Date: Displays start date of a follow-up / sale date of a sale
sale/time	None	Time: Time
sale/type	listAny	Type: Displays the type of an activity
sale/recordType	string	Record type : Shows the record type
sale/text	positiveString	Text: Displays a descriptive text for the item
sale/associateId	associate	ID: Displays the login ID of the associate who owns the activity.
sale/contactId	listAny	Company ID: Database ID of company
sale/personId	listAny	Contact ID: Database ID of the contact row
sale/projectId	listAny	Project ID: Database ID of project record
sale/saleId	int	Sale ID: The database ID of the sale record
sale/userGroup	userGroup	User group : The user group that owns the record
sale/who	None	Who: Contact and/or company
sale/updatedBy	associate	Updated by: The user who last updated the data
sale/updatedByFullName	associate	Updated by - Full name: The user who last updated the data
sale/updatedDate	date	Updated: The date/time the data was last updated in UTC.
sale/registeredBy	associate	Registered by: The user who registered the data
sale/registeredByFullName	associate	Registered by - Full name: The user who registered the data
sale/registeredDate	date	Registered date: The date/time the data was registered in UTC.
sale/currencyId	int	Currency ID: The currency list item ID
sale/currency	listAny	Currency: The currency of the sale
sale/credited	listAny	Credited: The user to be credited with the sale
sale/lossReason	listAny	Reason (lost: The reason for losing the sale
sale/source	listAny	Source: The source (lead) of the sale
sale/competitor	listAny	Competitor: The competitor who won the sale
sale/heading	stringorPK	Sale: The name of the sale
sale/amount	decimal	Amount: The gross sales total
sale/amountWeighted	decimal	Weighted amount: Virtual field calculated from amount * probability percent.
sale/earning	decimal	Profit: Gross profit (gross sales total - cost) for the sale
sale/earningPercent	decimal	Profit as % : The profit as a percentage of the gross sales total
sale/probPercent	int	Probability as %: Probability as %
sale/originalStage	listAny	Stage: Displays the stage of the sale
sale/stage	listAny	Stage: Displays the stage of the sale
sale/stageName	None	Stage name: Displays the stage of the sale
sale/saleStatus	listAny	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	listAny	Sale type: Sale type, from list
sale/saleTypeId	None	Sale type ID: Sale type, from list
sale/stageId	None	Sale stage ID: Displays the stage of the sale
sale/nextDueDate	date	Next activity: Date for next activity for a sale, updated live from the sale's activities
sale/reopenDate	date	Reopen date: Displays the reopen date for the sale
sale/stalledComment	listAny	Reason (stalled: The reason the sale has been stalled
sale/saleTypeCategory	listAny	Sale type category: Sale type category
sale/soldReason	listAny	Reason (sold: Reason (sold)
sale/saleNumber	string	Number: Number
sale/hasStakeholders	bool	Has stakeholders: Does this sale have stakeholders enabled
sale/hasQuote	bool	Has quote?: Does the sale have a quote attached?
sale/hasGuide	bool	Guided: Does this sale have a Sales Guide
sale/description	string	Description: The long description field on Sale
sale/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?
sale/createdByWorkflow	listAny	Created by flow: Created by flow
sale/amountInBaseCurrency	None	Amount (BaseCurrency): The gross sales total

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
sale/amountWeightedInBaseCurrency	None	Weighted amount (BaseCurrency): Virtual field calculated from amount * probability percent.
sale/visibleFor	listAny	Visible for
sale/sale/textId	int	Text ID
sale/sale/description	positiveString	Text: Displays the text entered in the description field
sale/salePublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
sale/salePublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
sale/salePublish/publishedTo	date	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	string	First name: Displays the contact's first name
sale/associate/lastName	string	Last name: Displays the contact's last name
sale/associate/middleName	string	Middle Name : Displays the contact's middle name.
sale/associate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
sale/associate/contactId	int	Company ID: Database ID of the company the user belongs to
sale/associate/personId	int	Contact ID: Database ID of the contact row
sale/associate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
sale/associate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
sale/associate/associateDbId	associate	ID
sale/associate/contactName	string	Owning company: Name of the company the user belongs to
sale/associate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
sale/associate/usergroup	userGroup	Primary group: The user's primary user group
sale/associate/contactFullName	string	Owner: Name and department of the company the user belongs to
sale/associate/contactCategory	listAny	Category: Category
sale/associate/role	listAny	Role : Role
sale/associate/assocName	associate	User ID : User ID
sale/associate/assocTooltip	string	Description : Description
sale/associate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
sale/associate/ejUserId	int	Service user ID: The database ID of a Service user
sale/associate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
sale/associate/ejDisplayName	string	Nick name: User's nick name in Service
sale/associate/ejStatus	int	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	bool	Active: Is this user active, and should be able to log in?
sale/associate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
sale/associate/portraitThumbnail	None	Person image: Person image
sale/associate/otherGroups	userGroup	Other groups: Other groups
sale/associate/userName	string	User name: User name
sale/associate/personEmail	string	E-mail
sale/associate/locationAddress	string	Location: Location
sale/associate/isLocation	bool	Is a location: Is a location
sale/saleUdef/SuperOffice:1	string	saleshorttext
sale/saleUdef/SuperOffice:2	string	salelongtext
sale/saleUdef/SuperOffice:3	int	salenumber
sale/saleUdef/SuperOffice:4	date	saledate
sale/saleUdef/SuperOffice:5	unlimitedDate	saleunlimiteddate
sale/saleUdef/SuperOffice:6	bool	salecheckbox
sale/saleUdef/SuperOffice:7	listAny	saledropdownlistbox
sale/saleUdef/SuperOffice:8	decimal	saledecimal
associate/firstName	string	First name: Displays the contact's first name
associate/lastName	string	Last name: Displays the contact's last name
associate/middleName	string	Middle Name : Displays the contact's middle name.
associate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
associate/contactId	int	Company ID: Database ID of the company the user belongs to
associate/personId	int	Contact ID: Database ID of the contact row
associate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
associate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
associate/associateDbId	associate	ID
associate/contactName	string	Owning company: Name of the company the user belongs to
associate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
associate/usergroup	userGroup	Primary group: The user's primary user group
associate/contactFullName	string	Owner: Name and department of the company the user belongs to
associate/contactCategory	listAny	Category: Category
associate/role	listAny	Role : Role
associate/assocName	associate	User ID : User ID
associate/assocTooltip	string	Description : Description
associate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
associate/ejUserId	int	Service user ID: The database ID of a Service user
associate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
associate/ejDisplayName	string	Nick name: User's nick name in Service
associate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
associate/isActive	bool	Active: Is this user active, and should be able to log in?
associate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
associate/portraitThumbnail	None	Person image: Person image
associate/otherGroups	userGroup	Other groups: Other groups
associate/userName	string	User name: User name
associate/personEmail	string	E-mail
associate/locationAddress	string	Location: Location
associate/isLocation	bool	Is a location: Is a location
appointment/description	positiveString	Text: Displays the text entered in the description field
appointment/title	positiveString	Title
appointment/titleHtml	None	!!Title Html
appointment/agenda	positiveString	Agenda
appointment/agendaHtml	None	!!Agenda Html
appointment/isConverted	None	!!Is Converted
appointment/textId	int	Text ID
appointment/internalNotes	positiveString	Internal notes: Displays the text entered in the description field
appointment/internalNotesHtml	positiveString	!!Internal Notes Html
destinationAppointmentRestrictionId	int	Destination follow-up ID: IDs of follow-ups which are linked to
currencyId	int	Currency ID: The currency list item ID
currency	listAny	Currency: The currency of the sale
credited	listAny	Credited: The user to be credited with the sale
lossReason	listAny	Reason (lost: The reason for losing the sale
source	listAny	Source: The source (lead) of the sale
competitor	listAny	Competitor: The competitor who won the sale
heading	stringorPK	Sale: The name of the sale
amount	decimal	Amount: The gross sales total
amountWeighted	decimal	Weighted amount: Virtual field calculated from amount * probability percent.
earning	decimal	Profit: Gross profit (gross sales total - cost) for the sale

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
earningPercent	decimal	Profit as % : The profit as a percentage of the gross sales total
probPercent	int	Probability as %: Probability as %
originalStage	listAny	Stage: Displays the stage of the sale
stage	listAny	Stage: Displays the stage of the sale
stageName	None	Stage name: Displays the stage of the sale
saleStatus	listAny	Status: The status of the sale - open, lost or sold
stageRank	None	Stage rank: Rank of the sale stage in the stage list
saleType	listAny	Sale type: Sale type, from list
saleTypeId	None	Sale type ID: Sale type, from list
stageId	None	Sale stage ID: Displays the stage of the sale
nextDueDate	date	Next activity: Date for next activity for a sale, updated live from the sale's activities
reopenDate	date	Reopen date: Displays the reopen date for the sale
stalledComment	listAny	Reason (stalled: The reason the sale has been stalled
saleTypeCategory	listAny	Sale type category: Sale type category
soldReason	listAny	Reason (sold: Reason (sold)
saleNumber	string	Number: Number
hasStakeholders	bool	Has stakeholders: Does this sale have stakeholders enabled
hasQuote	bool	Has quote?: Does the sale have a quote attached?
hasGuide	bool	Guided: Does this sale have a Sales Guide
description	string	Description: The long description field on Sale
activeErpLinks	bool	ERP connected: Is there an active ERP Sync?
amountInBaseCurrency	None	Amount (BaseCurrency): The gross sales total
amountWeightedInBaseCurrency	None	Weighted amount (BaseCurrency): Virtual field calculated from amount * probability percent.
sale/textId	int	Text ID
salePublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
salePublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
salePublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date
salePublish/publishedBy	None	Published by: Published by
saleUdef/SuperOffice:1	string	saleshorttext
saleUdef/SuperOffice:2	string	salelongtext
saleUdef/SuperOffice:3	int	salenumber
saleUdef/SuperOffice:4	date	saledate
saleUdef/SuperOffice:5	unlimitedDate	saleunlimiteddate
saleUdef/SuperOffice:6	bool	salecheckbox
saleUdef/SuperOffice:7	listAny	saledropdownlistbox
saleUdef/SuperOffice:8	decimal	saledecimal
saleStakeholder/saleStakeholderId	int	Stakeholder - Stakeholder ID: Database ID of the stakeholder row
saleStakeholder/saleId	int	Stakeholder - Sale ID: The database ID of the sale record
saleStakeholder/comment	string	Stakeholder - Sales role comment text: Sales role comment text
saleStakeholder/salesRoleId	listAny	Stakeholder - Sales role: Sales role
saleStakeholder/hasInfoText	bool	Stakeholder - Sales role comment: Sales role comment
saleStakeholder/person/personId	int	Stakeholder - DB ID: Displays the database ID of a contact
saleStakeholder/person/firstName	string	Stakeholder - First name: Displays the contact's first name
saleStakeholder/person/lastName	string	Stakeholder - Last name: Displays the contact's last name
saleStakeholder/person/middleName	string	Stakeholder - Middle name: Displays the contact's middle name.
saleStakeholder/person/fullName	stringorPK	Stakeholder - Contact: Displays the contact to which an item is linked
saleStakeholder/person/contactId	int	Stakeholder - Company ID: Database ID of company
saleStakeholder/person/hasInfoText	bool	Stakeholder - Has note: Displays an icon indicating if there is additional information available about the contact
saleStakeholder/person/hasInterests	bool	Stakeholder - Has interests: Displays an Icon indicating if the contact has active interests
saleStakeholder/person/personHasInterests	bool	Stakeholder - Has interests: Displays an Icon indicating if the contact has active interests
saleStakeholder/person/mrMrs	string	Stakeholder - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/person/position	listAny	Stakeholder - Position
saleStakeholder/person/personNumber	string	Stakeholder - Number: Displays the contact's number
saleStakeholder/person/title	string	Stakeholder - Title: Displays the contact's job title
saleStakeholder/person/personCountry	listAny	Stakeholder - Country: Country
saleStakeholder/person/personCountryId	int	Stakeholder - Country ID: Country ID
saleStakeholder/person/personNoMail	bool	Stakeholder - No Mailings: Displays the contact's No Mailings checkbox
saleStakeholder/person/rank	int	Stakeholder - Rank: Displays a contact's current rank
saleStakeholder/person/birthdate	None	Stakeholder - Birthdate: Displays the contact's date of birth
saleStakeholder/person/associateType	None	Stakeholder - 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.
saleStakeholder/person/useAsMailingAddress	bool	Stakeholder - Use as postal address: Use as postal address
saleStakeholder/person/personSource	listAny	Stakeholder - Source: Source (Contact)
saleStakeholder/person/retired	bool	Stakeholder - Former employee: Indicates whether the contact has retired/left the company
saleStakeholder/person/birthYear	int	Stakeholder - Birth year: Displays contact's birth year
saleStakeholder/person/birthMonth	int	Stakeholder - Birth month: Displays contact's birth month
saleStakeholder/person/birthDay	int	Stakeholder - Birth day: Displays contact's birth day (day of month)
saleStakeholder/person/kanaFirstName	string	Stakeholder - First name, kana: Contact's first name, in kana alphabet
saleStakeholder/person/kanaLastName	string	Stakeholder - Last name, kana: Contact's last name, in kana alphabet
saleStakeholder/person/personUpdatedBy	associate	Stakeholder - Updated by: The user who last updated the data
saleStakeholder/person/personUpdatedByFullName	associate	Stakeholder - Updated by - Full name: The user who last updated the data
saleStakeholder/person/personUpdatedDate	date	Stakeholder - Updated: The date/time the data was last updated in UTC.
saleStakeholder/person/personRegisteredBy	associate	Stakeholder - Registered by: The user who registered the data
saleStakeholder/person/personRegisteredByFullName	associate	Stakeholder - Registered by - Full name: The user who registered the data
saleStakeholder/person/personRegisteredDate	date	Stakeholder - Registered date: The date/time the data was registered in UTC.
saleStakeholder/person/portraitThumbnail	None	Stakeholder - Person image: Person image
saleStakeholder/person/personActiveErpLinks	bool	Stakeholder - ERP connected: Is there an active ERP Sync?
saleStakeholder/person/ticketPriority	listAny	Stakeholder - Service priority: Default service priority for this contact
saleStakeholder/person/supportLanguage	listAny	Stakeholder - Preferred language: Preferred language used for reply templates and more
saleStakeholder/person/supportAssociate	associate	Stakeholder - Our service contact: Default service contact for this contact
saleStakeholder/person/supportAssociateFullName	associate	Stakeholder - Our service contact - Full name: Default service contact for this contact
saleStakeholder/person/personAssociateId	associate	Stakeholder - Our contact: Displays our contact
saleStakeholder/person/personAssociateFullName	associate	Stakeholder - Our contact - Full name: Displays our contact
saleStakeholder/person/personCategory	listAny	Stakeholder - Category
saleStakeholder/person/personBusiness	listAny	Stakeholder - Business
saleStakeholder/person/personDeletedDate	datetime	Stakeholder - Deleted date: Deleted date
saleStakeholder/person/hasCompany	bool	Stakeholder - Has company: The contact is associated with a company
saleStakeholder/person/isProjectMember	bool	Stakeholder - Is project member: This person is a project member
saleStakeholder/person/isStakeholder	bool	Stakeholder - Is stakeholder: This person is a sale stakeholder
saleStakeholder/person/updatedByWorkflow	listAny	Stakeholder - Updated by flow: Updated by flow
saleStakeholder/person/whenUpdatedByWorkflow	datetime	Stakeholder - When updated by flow: When updated by flow
saleStakeholder/person/createdByForm	listAny	Stakeholder - Created by form: Created by form
saleStakeholder/person/phone/formattedNumber	string	Stakeholder - Phone: Displays phone number
saleStakeholder/person/personDirectPhone/formattedNumber	string	Stakeholder - Direct - Phone: Displays phone number
saleStakeholder/person/personDirectPhone/description	string	Stakeholder - Direct - Description: Phone number description
saleStakeholder/person/personMobilePhone/formattedNumber	string	Stakeholder - Mobile - Phone: Displays phone number
saleStakeholder/person/personMobilePhone/description	string	Stakeholder - Mobile - Description: Phone number description
saleStakeholder/person/personPrivate/formattedNumber	string	Stakeholder - Private - Phone: Displays phone number
saleStakeholder/person/personPrivate/description	string	Stakeholder - Private - Description: Phone number description
saleStakeholder/person/personPager/formattedNumber	string	Stakeholder - Other - Phone: Displays phone number
saleStakeholder/person/personPager/description	string	Stakeholder - Other - Description: Phone number description

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
saleStakeholder/person/personDirectFax/formattedNumber	string	Stakeholder - Fax - Phone: Displays phone number
saleStakeholder/person/personDirectFax/description	string	Stakeholder - Fax - Description: Phone number description
saleStakeholder/person/searchPhone/formattedNumber	string	Stakeholder - Phone: Displays phone number
saleStakeholder/person/searchPhone/description	string	Stakeholder - Description: Phone number description
saleStakeholder/person/personInfo/textId	int	Stakeholder - Text ID
saleStakeholder/person/personInfo/infoText	positiveString	Stakeholder - Information: Displays the text entered in the description field
saleStakeholder/person/email/emailProtocol	string	Stakeholder - Protocol: E-mail protocol, such as SMTP
saleStakeholder/person/email/emailAddress	string	Stakeholder - E-mail
saleStakeholder/person/email/emailDescription	string	Stakeholder - Description
saleStakeholder/person/email/emailId	int	Stakeholder - ID
saleStakeholder/person/email/emailLastSent	datetime	Stakeholder - Last sent: The date and time an e-mail was last sent to this address
saleStakeholder/person/email/emailBounceCount	int	Stakeholder - Bounce count: Bounce count for this e-mail address
saleStakeholder/person/email/emailLastBounce	datetime	Stakeholder - Last bounce: Date and time for last bounce to this e-mail address
saleStakeholder/person/email/emailHasBounced	bool	Stakeholder - Has bounced: This checkbox is active if delivery to this e-mail address has failed.
saleStakeholder/person/personUrl/URLAddress	string	Stakeholder - URL
saleStakeholder/person/personUrl/URLDescription	string	Stakeholder - Description
saleStakeholder/person/personAddress/addressId	int	Stakeholder - Contact address - Address ID: Database ID for the address record
saleStakeholder/person/personAddress/line1	string	Stakeholder - Contact address - Address 1: First line of the address
saleStakeholder/person/personAddress/line2	string	Stakeholder - Contact address - Address 2: Second line of the address
saleStakeholder/person/personAddress/line3	string	Stakeholder - Contact address - Address 3: Third line of the address
saleStakeholder/person/personAddress/county	string	Stakeholder - 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.
saleStakeholder/person/personAddress/city	string	Stakeholder - Contact address - City: This criterion corresponds to the City field on the Company card.
saleStakeholder/person/personAddress/zip	string	Stakeholder - Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
saleStakeholder/person/personAddress/state	string	Stakeholder - 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.
saleStakeholder/person/personAddress/wgs84latitude	decimal	Stakeholder - Contact address - Latitude: Latitude
saleStakeholder/person/personAddress/wgs84longitude	decimal	Stakeholder - Contact address - Longitude: Longitude
saleStakeholder/person/personAddress/formattedAddress	None	Stakeholder - Contact address - {formattedAddress}: {formattedAddress}
saleStakeholder/person/personAddress/formattedMultiLineAddress	None	Stakeholder - Contact address - {formattedAddress}: {formattedAddress}
saleStakeholder/person/restrictionAddress/addressId	int	Stakeholder - Search address - Address ID: Database ID for the address record
saleStakeholder/person/restrictionAddress/line1	string	Stakeholder - Search address - Address 1: First line of the address
saleStakeholder/person/restrictionAddress/line2	string	Stakeholder - Search address - Address 2: Second line of the address
saleStakeholder/person/restrictionAddress/line3	string	Stakeholder - Search address - Address 3: Third line of the address
saleStakeholder/person/restrictionAddress/county	string	Stakeholder - 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.
saleStakeholder/person/restrictionAddress/city	string	Stakeholder - Search address - City: This criterion corresponds to the City field on the Company card.
saleStakeholder/person/restrictionAddress/zip	string	Stakeholder - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
saleStakeholder/person/restrictionAddress/state	string	Stakeholder - 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.
saleStakeholder/person/restrictionAddress/wgs84latitude	decimal	Stakeholder - Search address - Latitude: Latitude
saleStakeholder/person/restrictionAddress/wgs84longitude	decimal	Stakeholder - Search address - Longitude: Longitude
saleStakeholder/person/restrictionAddress/formattedAddress	None	Stakeholder - Search address - {formattedAddress}: {formattedAddress}
saleStakeholder/person/restrictionAddress/formattedMultiLineAddress	None	Stakeholder - Search address - {formattedAddress}: {formattedAddress}
saleStakeholder/person/personInterestIds	listInterest	Stakeholder - Contact interest: This criterion corresponds to a contact's interests. It is available via the Contact dialog's Interests tab.
saleStakeholder/person/personUdef/SuperOffice:1	string	Stakeholder - contactshorttext: tooltipshorttext
saleStakeholder/person/personUdef/SuperOffice:2	string	Stakeholder - contactlongtext: tooltiplongtext
saleStakeholder/person/personUdef/SuperOffice:3	int	Stakeholder - contactnumber
saleStakeholder/person/personUdef/SuperOffice:4	date	Stakeholder - contactdate
saleStakeholder/person/personUdef/SuperOffice:5	unlimitedDate	Stakeholder - contactunlimiteddate: tooltipunlimiteddate
saleStakeholder/person/personUdef/SuperOffice:6	bool	Stakeholder - contactcheckbox
saleStakeholder/person/personUdef/SuperOffice:7	listAny	Stakeholder - contactdropdownlistbox
saleStakeholder/person/personUdef/SuperOffice:8	decimal	Stakeholder - contactdecimal
saleStakeholder/person/personUdef/SuperOffice:9	string	Stakeholder - page1saleonly
saleStakeholder/person/personUdef/SuperOffice:10	string	Stakeholder - page1marketingonly
saleStakeholder/person/personUdef/SuperOffice:11	string	Stakeholder - page1adminonly
saleStakeholder/person/personExtra/x_person_integer	int	Stakeholder - Extra Integer: Custom person integer
saleStakeholder/person/personExtra/x_person_float	decimal	Stakeholder - Extra float: Custom float field
saleStakeholder/person/personExtra/x_person_longtext	string	Stakeholder - Extra Long Text: Custom long text field on person, keep HTML tags. Simple input, not text area. Default value = 'Hello there'
saleStakeholder/person/personExtra/x_person_date	date	Stakeholder - Extra date: Custom date field on person. Default value = 28.03.2019
saleStakeholder/person/personExtra/x_person_datetime	datetime	Stakeholder - Extra DateTime: Custom person date and time field. No default
saleStakeholder/person/personExtra/x_person_time	None	Stakeholder - Extra time: Custom time field on person. Current time as default
saleStakeholder/person/personExtra/x_person_boolean	bool	Stakeholder - Extra Boolean: Custom boolean field on person. Default checked
saleStakeholder/person/personExtra/x_person_timespan	timeSpan	Stakeholder - Extra timespan: Custom timespan on person. Minutes only in 15 units
saleStakeholder/person/personExtra/x_person_shorttext	string	Stakeholder - Extra short text: Custom short text on person. With index. Do not keep HTML tags
saleStakeholder/person/personExtra/x_person_shorttext_list	listAny	Stakeholder - Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent
saleStakeholder/person/personExtra/x_person_user_relation	associate	Stakeholder - Extra user relation: Custom person-user relation field
saleStakeholder/person/personExtra/x_person_category_relation	listAny	Stakeholder - Extra category relation: Custom person-category relation
saleStakeholder/person/personExtra/x_person_priority_relation	listAny	Stakeholder - Extra priority relation: Custom person-priority relation
saleStakeholder/person/personExtra/x_person_request_relation	stringorPK	Stakeholder - Extra request relation: Request relation on contact
saleStakeholder/person/personExtra/x_person_appointment_relation	stringorPK	Stakeholder - Extra appointment relation: Appointment relation on person
saleStakeholder/person/personExtra/x_person_contact_relation	stringorPK	Stakeholder - Extra company relation: Company relation on contact
saleStakeholder/person/personExtra/y_rental/id	int	Stakeholder - Rental - id: Displays the row's primary key (y_rental)
saleStakeholder/person/personExtra/y_rental/x_start	date	Stakeholder - Rental - Start rental
saleStakeholder/person/personExtra/y_rental/x_end	date	Stakeholder - Rental - End
saleStakeholder/person/personExtra/y_rental/x_amount	int	Stakeholder - Rental - Amount: Number to rent. Default = 1
saleStakeholder/person/personExtra/y_rental/x_contact	stringorPK	Stakeholder - Rental - Renter: Company that rents equipment
saleStakeholder/person/personExtra/y_rental/y_equipment/x_name	string	Stakeholder - Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table
saleStakeholder/person/personExtra/y_car/id	int	Stakeholder - Car - id: Displays the row's primary key (y_car)
saleStakeholder/person/personAssociate/firstName	string	Stakeholder - First name: Displays the contact's first name
saleStakeholder/person/personAssociate/lastName	string	Stakeholder - Last name: Displays the contact's last name
saleStakeholder/person/personAssociate/middleName	string	Stakeholder - Middle Name: Displays the contact's middle name.
saleStakeholder/person/personAssociate/fullName	string	Stakeholder - Full name: Displays full name of user (first, middle, last - according to settings)
saleStakeholder/person/personAssociate/contactId	int	Stakeholder - Company ID: Database ID of the company the user belongs to
saleStakeholder/person/personAssociate/personId	int	Stakeholder - Contact ID: Database ID of the contact row
saleStakeholder/person/personAssociate/mrMrs	string	Stakeholder - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/person/personAssociate/title	string	Stakeholder - Title: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/person/personAssociate/associateDbId	associate	Stakeholder - ID
saleStakeholder/person/personAssociate/contactName	string	Stakeholder - Owning company: Name of the company the user belongs to
saleStakeholder/person/personAssociate/contactDepartment	string	Stakeholder - Owning department: Name of the department at the company the user belongs to
saleStakeholder/person/personAssociate/usergroup	userGroup	Stakeholder - Primary group: The user's primary user group
saleStakeholder/person/personAssociate/contactFullName	string	Stakeholder - Owner: Name and department of the company the user belongs to
saleStakeholder/person/personAssociate/contactCategory	listAny	Stakeholder - Category: Category
saleStakeholder/person/personAssociate/role	listAny	Stakeholder - Role: Role
saleStakeholder/person/personAssociate/assocName	associate	Stakeholder - User ID: User ID
saleStakeholder/person/personAssociate/assocTooltip	string	Stakeholder - Description: Description
saleStakeholder/person/personAssociate/assocType	listAny	Stakeholder - Type: Type of user: associate, external user, system user, anonymous account
saleStakeholder/person/personAssociate/ejUserId	int	Stakeholder - Service user ID: The database ID of a Service user
saleStakeholder/person/personAssociate/simultaneousEjUser	bool	Stakeholder - 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
saleStakeholder/person/personAssociate/ejDisplayName	string	Stakeholder - Nick name: User's nick name in Service
saleStakeholder/person/personAssociate/ejStatus	int	Stakeholder - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
saleStakeholder/person/personAssociate/credentialType	None	Stakeholder - Auth. type: What type of credentials to use when this user logs in
saleStakeholder/person/personAssociate/credentialDisplayValue	None	Stakeholder - Auth. value: Credential value (public, visible part) to be used when this user logs in
saleStakeholder/person/personAssociate/isActive	bool	Stakeholder - Active: Is this user active, and should be able to log in?

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
saleStakeholder/person/personAssociate/isActiveText	bool	Stakeholder - Active status: Is this user active, and should be able to log in?
saleStakeholder/person/personAssociate/portraitThumbnail	None	Stakeholder - Person image: Person image
saleStakeholder/person/personAssociate/otherGroups	userGroup	Stakeholder - Other groups: Other groups
saleStakeholder/person/personAssociate/userName	string	Stakeholder - User name: User name
saleStakeholder/person/personAssociate/personEmail	string	Stakeholder - E-mail
saleStakeholder/person/personAssociate/locationAddress	string	Stakeholder - Location: Location
saleStakeholder/person/personAssociate/isLocation	bool	Stakeholder - Is a location: Is a location
saleStakeholder/person/correspondingAssociate/firstName	string	Stakeholder - First name: Displays the contact's first name
saleStakeholder/person/correspondingAssociate/lastName	string	Stakeholder - Last name: Displays the contact's last name
saleStakeholder/person/correspondingAssociate/middleName	string	Stakeholder - Middle Name: Displays the contact's middle name.
saleStakeholder/person/correspondingAssociate/fullName	string	Stakeholder - Full name: Displays full name of user (first, middle, last - according to settings)
saleStakeholder/person/correspondingAssociate/contactId	int	Stakeholder - Company ID: Database ID of the company the user belongs to
saleStakeholder/person/correspondingAssociate/personId	int	Stakeholder - Contact ID: Database ID of the contact row
saleStakeholder/person/correspondingAssociate/mrMrs	string	Stakeholder - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/person/correspondingAssociate/title	string	Stakeholder - Title: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/person/correspondingAssociate/associateDbId	associate	Stakeholder - ID
saleStakeholder/person/correspondingAssociate/contactName	string	Stakeholder - Owning company: Name of the company the user belongs to
saleStakeholder/person/correspondingAssociate/contactDepartment	string	Stakeholder - Owning department: Name of the department at the company the user belongs to
saleStakeholder/person/correspondingAssociate/usergroup	userGroup	Stakeholder - Primary group: The user's primary user group
saleStakeholder/person/correspondingAssociate/contactFullName	string	Stakeholder - Owner: Name and department of the company the user belongs to
saleStakeholder/person/correspondingAssociate/contactCategory	listAny	Stakeholder - Category: Category
saleStakeholder/person/correspondingAssociate/role	listAny	Stakeholder - Role: Role
saleStakeholder/person/correspondingAssociate/assocName	associate	Stakeholder - User ID: User ID
saleStakeholder/person/correspondingAssociate/assocTooltip	string	Stakeholder - Description: Description
saleStakeholder/person/correspondingAssociate/assocType	listAny	Stakeholder - Type: Type of user: associate, external user, system user, anonymous account
saleStakeholder/person/correspondingAssociate/ejUserId	int	Stakeholder - Service user ID: The database ID of a Service user
saleStakeholder/person/correspondingAssociate/simultaneousEjUser	bool	Stakeholder - 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
saleStakeholder/person/correspondingAssociate/ejDisplayName	string	Stakeholder - Nick name: User's nick name in Service
saleStakeholder/person/correspondingAssociate/ejStatus	int	Stakeholder - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
saleStakeholder/person/correspondingAssociate/credentialType	None	Stakeholder - Auth. type: What type of credentials to use when this user logs in
saleStakeholder/person/correspondingAssociate/credentialDisplayValue	None	Stakeholder - Auth. value: Credential value (public, visible part) to be used when this user logs in
saleStakeholder/person/correspondingAssociate/isActive	bool	Stakeholder - Active: Is this user active, and should be able to log in?
saleStakeholder/person/correspondingAssociate/isActiveText	bool	Stakeholder - Active status: Is this user active, and should be able to log in?
saleStakeholder/person/correspondingAssociate/portraitThumbnail	None	Stakeholder - Person image: Person image
saleStakeholder/person/correspondingAssociate/otherGroups	userGroup	Stakeholder - Other groups: Other groups
saleStakeholder/person/correspondingAssociate/userName	string	Stakeholder - User name: User name
saleStakeholder/person/correspondingAssociate/personEmail	string	Stakeholder - E-mail
saleStakeholder/person/correspondingAssociate/locationAddress	string	Stakeholder - Location: Location
saleStakeholder/person/correspondingAssociate/isLocation	bool	Stakeholder - Is a location: Is a location
saleStakeholder/person/isMailingRecipient	bool	Stakeholder - Is mailing recipient: isMailingRecipient
saleStakeholder/person/hasStoreConsent	bool	Stakeholder - 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.
saleStakeholder/person/withdrawnStoreConsent	bool	Stakeholder - 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.
saleStakeholder/person/hasEmarketingConsent	bool	Stakeholder - 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.
saleStakeholder/person/withdrawnEmarketingConsent	bool	Stakeholder - 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.
saleStakeholder/person/subscription	listAny	Stakeholder - Subscription: Subscription for marketing
saleStakeholder/person/legalBaseStore	listAny	Stakeholder - 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.
saleStakeholder/person/legalBaseEmarketing	listAny	Stakeholder - 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.
saleStakeholder/person/consentSourceStore	listAny	Stakeholder - 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.
saleStakeholder/person/consentSourceEmarketing	listAny	Stakeholder - 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.
saleStakeholder/contact/contactId	int	Stakeholder - Company ID: Database ID of company
saleStakeholder/contact/name	stringorPK	Stakeholder - Company name
saleStakeholder/contact/department	string	Stakeholder - Department
saleStakeholder/contact/nameDepartment	None	Stakeholder - Company: Displays the company an activity is linked to
saleStakeholder/contact/hasInfoText	bool	Stakeholder - Has note: Displays an icon indicating if there is additional information available about the contact
saleStakeholder/contact/hasInterests	bool	Stakeholder - Has interests: Displays an Icon indicating if the contact has active interests
saleStakeholder/contact/associateId	associate	Stakeholder - Our contact: Displays our contact
saleStakeholder/contact/category	listAny	Stakeholder - Category
saleStakeholder/contact/business	listAny	Stakeholder - Business
saleStakeholder/contact/country	listAny	Stakeholder - Country: This criterion corresponds to the Country field on the Company card.
saleStakeholder/contact/countryId	int	Stakeholder - Country ID: Country ID
saleStakeholder/contact/number	string	Stakeholder - Number
saleStakeholder/contact/code	string	Stakeholder - Code
saleStakeholder/contact/orgnr	string	Stakeholder - VAT No.
saleStakeholder/contact/stop	bool	Stakeholder - Stop
saleStakeholder/contact/contactNoMail	bool	Stakeholder - No mailings (company)
saleStakeholder/contact/updatedBy	associate	Stakeholder - Updated by: The user who last updated the data
saleStakeholder/contact/updatedByFullName	associate	Stakeholder - Updated by - Full name: The user who last updated the data
saleStakeholder/contact/updatedDate	date	Stakeholder - Updated: The date/time the data was last updated in UTC.
saleStakeholder/contact/registeredBy	associate	Stakeholder - Registered by: The user who registered the data
saleStakeholder/contact/registeredByFullName	associate	Stakeholder - Registered by - Full name: The user who registered the data
saleStakeholder/contact/registeredDate	date	Stakeholder - Registered date: The date/time the data was registered in UTC.
saleStakeholder/contact/contactSource	listAny	Stakeholder - Source: Source (Company)
saleStakeholder/contact/contactDeleted	bool	Stakeholder - Deleted: Deleted
saleStakeholder/contact/phone/formattedNumber	string	Stakeholder - Phone: Displays phone number
saleStakeholder/contact/activeErpLinks	bool	Stakeholder - ERP connected: Is there an active ERP Sync?
saleStakeholder/contact/deletedDate	datetime	Stakeholder - Deleted date: Deleted date
saleStakeholder/contact/mainContact	None	Stakeholder - Main contact: Main contact for this company
saleStakeholder/contact/contactPhone/formattedNumber	string	Stakeholder - Telephone - Phone: Displays phone number
saleStakeholder/contact/contactPhone/description	string	Stakeholder - Telephone - Description: Phone number description
saleStakeholder/contact/contactFax/formattedNumber	string	Stakeholder - Fax - Phone: Displays phone number
saleStakeholder/contact/contactFax/description	string	Stakeholder - Fax - Description: Phone number description
saleStakeholder/contact/searchPhone/formattedNumber	string	Stakeholder - Searchphone - Phone: Displays phone number
saleStakeholder/contact/searchPhone/description	string	Stakeholder - Searchphone - Description: Phone number description
saleStakeholder/contact/email/emailProtocol	string	Stakeholder - Protocol: E-mail protocol, such as SMTP
saleStakeholder/contact/email/emailAddress	string	Stakeholder - E-mail
saleStakeholder/contact/email/emailDescription	string	Stakeholder - Description
saleStakeholder/contact/email/emailId	int	Stakeholder - ID
saleStakeholder/contact/email/emailLastSent	datetime	Stakeholder - Last sent: The date and time an e-mail was last sent to this address
saleStakeholder/contact/email/emailBounceCount	int	Stakeholder - Bounce count: Bounce count for this e-mail address
saleStakeholder/contact/email/emailLastBounce	datetime	Stakeholder - Last bounce: Date and time for last bounce to this e-mail address
saleStakeholder/contact/email/emailHasBounced	bool	Stakeholder - Has bounced: This checkbox is active if delivery to this e-mail address has failed.
saleStakeholder/contact/postAddress/addressId	int	Stakeholder - Postal address - Address ID: Database ID for the address record
saleStakeholder/contact/postAddress/line1	string	Stakeholder - Postal address - Address 1: First line of the address
saleStakeholder/contact/postAddress/line2	string	Stakeholder - Postal address - Address 2: Second line of the address
saleStakeholder/contact/postAddress/line3	string	Stakeholder - Postal address - Address 3: Third line of the address
saleStakeholder/contact/postAddress/county	string	Stakeholder - 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.
saleStakeholder/contact/postAddress/city	string	Stakeholder - Postal address - City: This criterion corresponds to the City field on the Company card.
saleStakeholder/contact/postAddress/zip	string	Stakeholder - Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
saleStakeholder/contact/postAddress/state	string	Stakeholder - 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.
saleStakeholder/contact/postAddress/wgs84latitude	decimal	Stakeholder - Postal address - Latitude: Latitude

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
saleStakeholder/contact/postAddress/wgs84longitude	decimal	Stakeholder - Postal address - Longitude: Longitude
saleStakeholder/contact/postAddress/formattedAddress	None	Stakeholder - Postal address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/postAddress/formattedMultiLineAddress	None	Stakeholder - Postal address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/streetAddress/addressId	int	Stakeholder - Street address - Address ID: Database ID for the address record
saleStakeholder/contact/streetAddress/line1	string	Stakeholder - Street address - Address 1: First line of the address
saleStakeholder/contact/streetAddress/line2	string	Stakeholder - Street address - Address 2: Second line of the address
saleStakeholder/contact/streetAddress/line3	string	Stakeholder - Street address - Address 3: Third line of the address
saleStakeholder/contact/streetAddress/county	string	Stakeholder - 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.
saleStakeholder/contact/streetAddress/city	string	Stakeholder - Street address - City: This criterion corresponds to the City field on the Company card.
saleStakeholder/contact/streetAddress/zip	string	Stakeholder - Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
saleStakeholder/contact/streetAddress/state	string	Stakeholder - 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.
saleStakeholder/contact/streetAddress/wgs84latitude	decimal	Stakeholder - Street address - Latitude: Latitude
saleStakeholder/contact/streetAddress/wgs84longitude	decimal	Stakeholder - Street address - Longitude: Longitude
saleStakeholder/contact/streetAddress/formattedAddress	None	Stakeholder - Street address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/streetAddress/formattedMultiLineAddress	None	Stakeholder - Street address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/restrictionAddress/addressId	int	Stakeholder - Search address - Address ID: Database ID for the address record
saleStakeholder/contact/restrictionAddress/line1	string	Stakeholder - Search address - Address 1: First line of the address
saleStakeholder/contact/restrictionAddress/line2	string	Stakeholder - Search address - Address 2: Second line of the address
saleStakeholder/contact/restrictionAddress/line3	string	Stakeholder - Search address - Address 3: Third line of the address
saleStakeholder/contact/restrictionAddress/county	string	Stakeholder - 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.
saleStakeholder/contact/restrictionAddress/city	string	Stakeholder - Search address - City: This criterion corresponds to the City field on the Company card.
saleStakeholder/contact/restrictionAddress/zip	string	Stakeholder - Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.
saleStakeholder/contact/restrictionAddress/state	string	Stakeholder - 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.
saleStakeholder/contact/restrictionAddress/wgs84latitude	decimal	Stakeholder - Search address - Latitude: Latitude
saleStakeholder/contact/restrictionAddress/wgs84longitude	decimal	Stakeholder - Search address - Longitude: Longitude
saleStakeholder/contact/restrictionAddress/formattedAddress	None	Stakeholder - Search address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/restrictionAddress/formattedMultiLineAddress	None	Stakeholder - Search address - {formattedAddress}: {formattedAddress}
saleStakeholder/contact/url/URLAddress	string	Stakeholder - URL
saleStakeholder/contact/url/URLDescription	string	Stakeholder - Description
saleStakeholder/contact/contactAssociate/firstName	string	Stakeholder - First name: Displays the contact's first name
saleStakeholder/contact/contactAssociate/lastName	string	Stakeholder - Last name: Displays the contact's last name
saleStakeholder/contact/contactAssociate/middleName	string	Stakeholder - Middle Name: Displays the contact's middle name.
saleStakeholder/contact/contactAssociate/fullName	string	Stakeholder - Full name: Displays full name of user (first, middle, last - according to settings)
saleStakeholder/contact/contactAssociate/contactId	int	Stakeholder - Company ID: Database ID of the company the user belongs to
saleStakeholder/contact/contactAssociate/personId	int	Stakeholder - Contact ID: Database ID of the contact row
saleStakeholder/contact/contactAssociate/mrMrs	string	Stakeholder - Mr/Ms: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/contact/contactAssociate/title	string	Stakeholder - Title: Displays whether the contact is addressed as Mr or Ms
saleStakeholder/contact/contactAssociate/associateDbId	associate	Stakeholder - ID
saleStakeholder/contact/contactAssociate/contactName	string	Stakeholder - Owning company: Name of the company the user belongs to
saleStakeholder/contact/contactAssociate/contactDepartment	string	Stakeholder - Owning department: Name of the department at the company the user belongs to
saleStakeholder/contact/contactAssociate/usergroup	userGroup	Stakeholder - Primary group: The user's primary user group
saleStakeholder/contact/contactAssociate/contactFullName	string	Stakeholder - Owner: Name and department of the company the user belongs to
saleStakeholder/contact/contactAssociate/contactCategory	listAny	Stakeholder - Category: Category
saleStakeholder/contact/contactAssociate/role	listAny	Stakeholder - Role: Role
saleStakeholder/contact/contactAssociate/assocName	associate	Stakeholder - User ID: User ID
saleStakeholder/contact/contactAssociate/assocTooltip	string	Stakeholder - Description: Description
saleStakeholder/contact/contactAssociate/assocType	listAny	Stakeholder - Type: Type of user: associate, external user, system user, anonymous account
saleStakeholder/contact/contactAssociate/ejUserId	int	Stakeholder - Service user ID: The database ID of a Service user
saleStakeholder/contact/contactAssociate/simultaneousEjUser	bool	Stakeholder - 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
saleStakeholder/contact/contactAssociate/ejDisplayName	string	Stakeholder - Nick name: User's nick name in Service
saleStakeholder/contact/contactAssociate/ejStatus	int	Stakeholder - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
saleStakeholder/contact/contactAssociate/credentialType	None	Stakeholder - Auth. type: What type of credentials to use when this user logs in
saleStakeholder/contact/contactAssociate/credentialDisplayValue	None	Stakeholder - Auth. value: Credential value (public, visible part) to be used when this user logs in
saleStakeholder/contact/contactAssociate/isActive	bool	Stakeholder - Active: Is this user active, and should be able to log in?
saleStakeholder/contact/contactAssociate/isActiveText	bool	Stakeholder - Active status: Is this user active, and should be able to log in?
saleStakeholder/contact/contactAssociate/portraitThumbnail	None	Stakeholder - Person image: Person image
saleStakeholder/contact/contactAssociate/otherGroups	userGroup	Stakeholder - Other groups: Other groups
saleStakeholder/contact/contactAssociate/userName	string	Stakeholder - User name: User name
saleStakeholder/contact/contactAssociate/personEmail	string	Stakeholder - E-mail
saleStakeholder/contact/contactAssociate/locationAddress	string	Stakeholder - Location: Location
saleStakeholder/contact/contactAssociate/isLocation	bool	Stakeholder - Is a location: Is a location
saleStakeholder/contact/contactInterestIds	listInterest	Stakeholder - Company Interest: This criterion corresponds to the Interests tab on the Company card.
saleStakeholder/contact/contactUdef/SuperOffice:1	string	Stakeholder - companyshorttext: tooltipshorttext
saleStakeholder/contact/contactUdef/SuperOffice:2	string	Stakeholder - companylongtext: tooltiplongtext
saleStakeholder/contact/contactUdef/SuperOffice:3	int	Stakeholder - companynumber
saleStakeholder/contact/contactUdef/SuperOffice:4	date	Stakeholder - companydate
saleStakeholder/contact/contactUdef/SuperOffice:5	unlimitedDate	Stakeholder - companyunlimiteddate: tooltipunlimiteddate
saleStakeholder/contact/contactUdef/SuperOffice:6	bool	Stakeholder - companycheckbox
saleStakeholder/contact/contactUdef/SuperOffice:7	listAny	Stakeholder - companydropdownlistbox
saleStakeholder/contact/contactUdef/SuperOffice:8	decimal	Stakeholder - companydecimal
saleStakeholder/contact/contactUdef/SuperOffice:9	string	Stakeholder - page1saleonly
saleStakeholder/contact/contactUdef/SuperOffice:10	string	Stakeholder - page1marketingonly
saleStakeholder/contact/contactUdef/SuperOffice:11	string	Stakeholder - page1adminonly
saleStakeholder/contact/contactUdef/SuperOffice:12	listAny	Stakeholder - Udlist one: Static tooltip for udlist one
saleStakeholder/contact/contactUdef/SuperOffice:13	listAny	Stakeholder - Udlist two: Static tooltip for udlist two
saleStakeholder/contact/contactExtra/x_contact_integer	int	Stakeholder - Extra Integer: Custom integer field
saleStakeholder/contact/contactExtra/x_contact_default_integer	int	Stakeholder - Extra Default Integer: Custom integer field with default value 123.
saleStakeholder/contact/contactExtra/x_contact_float	decimal	Stakeholder - Extra Float: Custom float field with 3 decimals
saleStakeholder/contact/contactExtra/x_contact_longtext	string	Stakeholder - Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor
saleStakeholder/contact/contactExtra/x_contact_dropdown	listAny	Stakeholder - Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.
saleStakeholder/contact/contactExtra/x_contact_date	date	Stakeholder - Extra date: Custom date field. User current as default.
saleStakeholder/contact/contactExtra/x_contact_datetime	datetime	Stakeholder - Extra DateTime: Custom Date Time field. No default value. External
saleStakeholder/contact/contactExtra/x_contact_time	None	Stakeholder - Extra time: Custom time field.
saleStakeholder/contact/contactExtra/x_contact_boolean	bool	Stakeholder - Extra boolean: Custom boolean field.
saleStakeholder/contact/contactExtra/x_contact_timespan	timeSpan	Stakeholder - Extra timespan: Custom timespan field. Hours and minutes in 10 units
saleStakeholder/contact/contactExtra/x_contact_shorttext	string	Stakeholder - Extra short text: Custom short text field. Keep HTML tags.
saleStakeholder/contact/contactExtra/x_contact_short_dropdown	listAny	Stakeholder - Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.
saleStakeholder/contact/contactExtra/x_contact_contact_relation	stringorPK	Stakeholder - Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons
saleStakeholder/contact/contactExtra/x_contact_request_relation	stringorPK	Stakeholder - Extra Request relation: Request relation on company
saleStakeholder/contact/contactExtra/x_contact_contact	stringorPK	Stakeholder - Extra contact relation: Contact relation on company
saleStakeholder/contact/contactExtra/y_organization/x_name	string	Stakeholder - Organization - Name
saleStakeholder/contact/NumberOfActivities	int	Stakeholder - Number of activities
saleStakeholder/contact/NumberOfActivitiesInPeriod	int	Stakeholder - Number of activities in last 90 days
saleStakeholder/contact/NumberOfNotCompletedActivities	int	Stakeholder - Number of non-completed activities
saleStakeholder/contact/NumberOfNotCompletedActivitiesInPeriod	int	Stakeholder - Number of non-completed activities in last 90 days
saleStakeholder/contact/LastActivity	date	Stakeholder - Date of last activity
saleStakeholder/contact/LastCompletedActivity	date	Stakeholder - Date of last completed activity
saleStakeholder/contact/LastDoByActivity	date	Stakeholder - Date of last non-completed activity
saleStakeholder/contact/NumberOfSales	int	Stakeholder - Number of sales
saleStakeholder/contact/NumberOfSalesInPeriod	int	Stakeholder - Number of sales in last 90 days

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
saleStakeholder/contact/NumberOfNotCompletedSales	int	Stakeholder - Number of non-completed sales
saleStakeholder/contact/NumberOfNotCompletedSalesInPeriod	int	Stakeholder - Number of non-completed sales in last 90 days
saleStakeholder/contact/LastSale	date	Stakeholder - Date of last sale
saleStakeholder/contact/LastCompletedSale	date	Stakeholder - Date of last completed sale
saleStakeholder/contact/LastDoBySale	date	Stakeholder - Date of last non-completed sale
saleStakeholder/contact/NumberOfTickets	int	Stakeholder - Number of requests
saleStakeholder/contact/NumberOfTicketsInPeriod	int	Stakeholder - Number of requests in last 90 days
saleStakeholder/contact/NumberOfNotCompletedTickets	int	Stakeholder - Number of non-completed requests
saleStakeholder/contact/NumberOfNotCompletedTicketsInPeriod	int	Stakeholder - Number of non-completed requests in last 90 days
saleStakeholder/contact/LastTicket	date	Stakeholder - Date of last request
saleStakeholder/contact/LastCompletedTicket	date	Stakeholder - Date of last completed request
saleStakeholder/contact/LastDoByTicket	date	Stakeholder - Date of last non-completed request
saleStakeholder/contact/SaintStatus1	saintStatus	Stakeholder - Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden.
saleStakeholder/contact/SaintStatus2	saintStatus	Stakeholder - C-company: Kundens navn starter med bokstaven C
saleStakeholder/contact/saintSaleStatus	listAny	Stakeholder - With status
saleStakeholder/contact/saintAmountClass	listAny	Stakeholder - Amount class
saleStakeholder/contact/saintActivityType	listAny	Stakeholder - SAINT type
saleStakeholder/contact/saintDirection	listAny	Stakeholder - Direction
saleStakeholder/contact/saintIntention	listAny	Stakeholder - Intention
saleStakeholder/contact/saintTicketStatus	listAny	Stakeholder - Status
saleStakeholder/contact/saintTicketCategory	listAny	Stakeholder - Category
quote/quoteId	int	Quote ID: SuperOffice database ID of quote record
quote/poNumber	string	P.O. Number: Customer's purchase order number
quote/orderComment	string	Comment: Customer's comment
quote/connectionId	int	DB-ID: Database ID
quote/registeredDate	date	Registered at: Displays the date when the quote was registered.
quote/version/quoteVersionId	int	ID: Database ID of QuoteVersion record
quote/version/description	string	Description: Description of the quote version
quote/version/number	string	Number: Reference number for the quote version
quote/version/sent	date	Sent: The date the quote (version) was sent to the customer
quote/version/expiration	date	Expiry date: The last date that the quote is valid
quote/version/state	listAny	State: The current state the quote is in
quote/version/status	listAny	Quote status: Status field showing the status of each line.
quote/version/reason	string	Quote reason: The reason or explanation for any status other than 'OK'.
quote/version/paymentTerms	listExternal	Payment terms: Payment terms
quote/version/paymentType	listExternal	Payment type: Payment type
quote/version/deliveryTerms	listExternal	Delivery terms: Delivery terms
quote/version/deliveryType	listExternal	Delivery type: Delivery type
quote/version/approvedBy	associate	Approved by: Associate who approved a quote that broke one or more of the workflow rules that trigger an approval process
quote/version/approvalRegisteredBy	associate	Approval reg by: Associate who entered the approval of a quote that broke one or more of the workflow rules that trigger an approval process. Not necessarily the person who approved the quote.
quote/version/approvedText	string	Approval comment: Comment added to the approval of a quote that broke one or more of the workflow rules that trigger an approval process
quote/version/approvedDate	date	Approved date: Date of approval of a quote that broke one or more of the workflow rules that trigger an approval process
quote/version/extraField1	string	Extra field 1: One of the extra fields on the product; meaning is installation dependent
quote/version/extraField2	string	Extra field 2: One of the extra fields on the product; meaning is installation dependent
quote/version/extraField3	string	Extra field 3: One of the extra fields on the product; meaning is installation dependent
quote/version/extraField4	string	Extra field 4: One of the extra fields on the product; meaning is installation dependent
quote/version/extraField5	string	Extra field 5: One of the extra fields on the product; meaning is installation dependent
quote/version/alternative/quoteAlternativeId	int	QuoteAlternative ID: SuperOffice database ID of the quote alternative record
quote/version/alternative/quoteVersionId	int	ID: Database ID of QuoteVersion record
quote/version/alternative/name	string	Name: Name of the quote alternative
quote/version/alternative/description	string	Description: Description of the quote alternative
quote/version/alternative/status	listAny	Quote status: Status field showing the status of each line.
quote/version/alternative/reason	string	Quote reason: The reason or explanation for any status other than 'OK'.
quote/version/alternative/erpDiscountPercent	decimal	ERP Discount %: Discount percentage suggested by ERP system
quote/version/alternative/erpDiscountAmount	decimal	ERP Discount: Discount amount suggested by ERP system
quote/version/alternative/discountPercent	decimal	Discount %: Enter discount in percent for entire alternative
quote/version/alternative/discountAmount	decimal	Discount: Enter total discount for entire alternative
quote/version/alternative/vatInfo	string	VAT Info: Information about value-added and other taxes
quote/version/alternative/vat	decimal	VAT: Value-added and other taxes, total amount
quote/version/alternative/earningPercent	decimal	Earnings %: Total Earnings as a percentage of the total price, of all lines in the quote alternative, including all discounts
quote/version/alternative/earningAmount	decimal	Earnings: Total Earnings for all lines in the quote alternative, including all discounts
quote/version/alternative/totalPrice	decimal	Total: Total price of all items in the quote alternative, including all discounts
quote/version/alternative/extraField1	string	Extra 1: Extra field 1 on the quote alternative
quote/version/alternative/extraField2	string	Extra 2: Extra field 2 on the quote alternative
quote/version/alternative/extraField3	string	Extra 3: Extra field 3on the quote alternative
quote/version/alternative/extraField4	string	Extra 4: Extra field 4 on the quote alternative
quote/version/alternative/extraField5	string	Extra 5: Extra field 5 on the quote alternative
quote/version/alternative/alternativeOrdering	int	QuoteAlternative ID: SuperOffice database ID of the quote alternative record
quote/version/alternative/subTotal	decimal	Total before discount: Total of all lines, before applying the Alternative discount
quote/version/alternative/totalPriceIncVAT	decimal	Total incl. VAT: Total of all lines, including VAT
quote/version/alternative/vatAmount	decimal	VAT: VAT (amount) for the alternative
quote/version/alternative/quoteline/quoteLineId	int	Quote line ID: Database identity of the quote line
quote/version/alternative/quoteline/quoteAlternativeId	int	Alternative ID: The database identity of the quote alternative
quote/version/alternative/quoteline/erpProductKey	string	Product key: The foreign key of the product the quote line is based on.
quote/version/alternative/quoteline/rank	int	Rank: Shows the rank of a product
quote/version/alternative/quoteline/quantity	decimal	Quantity: The quantity that is offered
quote/version/alternative/quoteline/name	string	Name: The name of the product that is being offered. This name can be changed to accommodate the customer's needs.
quote/version/alternative/quoteline/description	string	Description: Description of the product that is offered
quote/version/alternative/quoteline/code	string	Code: The product or article code. This code is created to help you quickly find products you offer regularly.
quote/version/alternative/quoteline/quantityUnit	string	Unit: The unit of the product that is offered.
quote/version/alternative/quoteline/priceUnit	string	Price unit: What is the price unit defined in
quote/version/alternative/quoteline/url	string	Web address: The web address of the product info.
quote/version/alternative/quoteline/subscriptionUnit	string	Subscription unit: Unit the subscription is sold/renewed in, such as year/quarter/month
quote/version/alternative/quoteline/subscriptionQuantity	decimal	Subscription quantity: Number of subscription units offered
quote/version/alternative/quoteline/UnitListPriceSubscriptionQuantity	None	Subscription list price: Unit price * subscription quantity
quote/version/alternative/quoteline/PriceUnitSubscriptionUnit	None	P/S Unit: Price unit/subscription unit
quote/version/alternative/quoteline/PriceUnitSubscriptionQuantityUnit	None	Expanded unit: Price unit @ subscription quantity + unit
quote/version/alternative/quoteline/vatInfo	string	VAT info:
quote/version/alternative/quoteline/vat	decimal	VAT: May be filled out by the ERP system
quote/version/alternative/quoteline/unitCost	decimal	Cost: Cost per item.
quote/version/alternative/quoteline/unitMinimumPrice	decimal	Unit minimum price: Minimum price per item. Users are not allowed to send quotes with prices lower than the minimum price.
quote/version/alternative/quoteline/unitListPrice	decimal	List price: List price of a unit
quote/version/alternative/quoteline/totalPrice	decimal	Total: List price * Quantity - Discount Amount
quote/version/alternative/quoteline/totalCost	decimal	Total cost
quote/version/alternative/quoteline/quoteLineThumbnail	None	Thumbnail: A miniature version of the product picture
quote/version/alternative/quoteline/quoteLineThumbnailLarge	None	Thumbnail: A miniature version of the product picture
quote/version/alternative/quoteline/discountAmount	decimal	Discount: Discount amount given by salesperson
quote/version/alternative/quoteline/discountPercent	decimal	Discount (%: Discount percent given by salesperson
quote/version/alternative/quoteline/earningAmount	decimal	Earnings: Amount of Earnings (Total - Cost) on the line, after discount
quote/version/alternative/quoteline/earningPercent	decimal	Earnings (%: Percentage Earnings on the line (Total - Cost / Total), after discount

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
quote/version/alternative/quoteline/updatedBy	associate	Updated by: The user who last updated the data
quote/version/alternative/quoteline/updatedByFullName	associate	Updated by - Full name: The user who last updated the data
quote/version/alternative/quoteline/updatedDate	date	Updated: The date/time the data was last updated in UTC.
quote/version/alternative/quoteline/registeredBy	associate	Registered by: The user who registered the data
quote/version/alternative/quoteline/registeredByFullName	associate	Registered by - Full name: The user who registered the data
quote/version/alternative/quoteline/registeredDate	date	Registered date: The date/time the data was registered in UTC.
quote/version/alternative/quoteline/productCategoryKey	listExternal	Product category: The category the product is defined in
quote/version/alternative/quoteline/productFamilyKey	listExternal	Product family: The family the product is defined in
quote/version/alternative/quoteline/productTypeKey	listExternal	Product type: The type of product
quote/version/alternative/quoteline/status	listAny	Quote status: Status field showing the status of each line.
quote/version/alternative/quoteline/subTotal	decimal	Sum: Sum of Quantity * Unit list price
quote/version/alternative/quoteline/vatAmount	decimal	VAT (amount: The calculated VAT amount
quote/version/alternative/quoteline/totalPriceIncVAT	decimal	Total incl. VAT: Total including VAT
quote/version/alternative/quoteline/totalPriceWithAlternativeDiscount	decimal	Total incl. alt. disc: Total, including any discount percentage set on the alternative
destinationSaleRestrictionId	int	Destination sale ID: IDs of sales which are linked to
name	stringorPK	Project name: Displays the Project's name
number	string	Number: Displays the project's number
status	listAny	Status: Displays the project's status
statusRank	None	Status rank: Rank of the project status in the status list
hasInfoText	bool	Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip.
nextMilestone	date	Next milestone: Date of next non-completed activity that is marked as a milestone
imageThumbnail	None	Thumbnail: Scaled-down image of project image
projectPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
projectPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
projectPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date
projectPublish/publishedBy	None	Published by: Published by
projectEvent/isExternalEvent	bool	Event: Is this an external event
projectEvent/eventDate	date	Event date: Event date
projectEvent/hasSignOn	bool	Sign On: Does this event have the Sign On function enabled
projectEvent/hasSignOff	bool	Sign Off: Does this event have the Sign Off function enabled
projectUrl/URLAddress	string	URL
projectUrl/URLDescription	string	Description
projectAssociate/firstName	string	First name: Displays the contact's first name
projectAssociate/lastName	string	Last name: Displays the contact's last name
projectAssociate/middleName	string	Middle Name : Displays the contact's middle name.
projectAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)
projectAssociate/contactId	int	Company ID: Database ID of the company the user belongs to
projectAssociate/personId	int	Contact ID: Database ID of the contact row
projectAssociate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
projectAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms
projectAssociate/associateDbId	associate	ID
projectAssociate/contactName	string	Owning company: Name of the company the user belongs to
projectAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to
projectAssociate/usergroup	userGroup	Primary group: The user's primary user group
projectAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to
projectAssociate/contactCategory	listAny	Category: Category
projectAssociate/role	listAny	Role : Role
projectAssociate/assocName	associate	User ID : User ID
projectAssociate/assocTooltip	string	Description : Description
projectAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account
projectAssociate/ejUserId	int	Service user ID: The database ID of a Service user
projectAssociate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
projectAssociate/ejDisplayName	string	Nick name: User's nick name in Service
projectAssociate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
projectAssociate/credentialType	None	Auth. type: What type of credentials to use when this user logs in
projectAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in
projectAssociate/isActive	bool	Active: Is this user active, and should be able to log in?
projectAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?
projectAssociate/portraitThumbnail	None	Person image: Person image
projectAssociate/otherGroups	userGroup	Other groups: Other groups
projectAssociate/userName	string	User name: User name
projectAssociate/personEmail	string	E-mail
projectAssociate/locationAddress	string	Location: Location
projectAssociate/isLocation	bool	Is a location: Is a location
projectUdef/SuperOffice:1	string	projectshorttext
projectUdef/SuperOffice:2	string	projectlongtext
projectUdef/SuperOffice:3	int	projectnumber
projectUdef/SuperOffice:4	date	projectdate
projectUdef/SuperOffice:5	unlimitedDate	projectunlimiteddate
projectUdef/SuperOffice:6	bool	projectcheckbox
projectUdef/SuperOffice:7	listAny	projectdropdownlistbox
projectUdef/SuperOffice:8	decimal	projectdecimal
projectUdef/SuperOffice:9	int	page1saleandmarketing
projectUdef/SuperOffice:10	int	page1saleandadmin
NumberOfActivities	int	Number of activities
NumberOfActivitiesInPeriod	int	Number of activities in last 90 days
NumberOfNotCompletedActivities	int	Number of non-completed activities
NumberOfNotCompletedActivitiesInPeriod	int	Number of non-completed activities in last 90 days
LastActivity	date	Date of last activity
LastCompletedActivity	date	Date of last completed activity
LastDoByActivity	date	Date of last non-completed activity
NumberOfSales	int	Number of sales
NumberOfSalesInPeriod	int	Number of sales in last 90 days
NumberOfNotCompletedSales	int	Number of non-completed sales
NumberOfNotCompletedSalesInPeriod	int	Number of non-completed sales in last 90 days
LastSale	date	Date of last sale
LastCompletedSale	date	Date of last completed sale
LastDoBySale	date	Date of last non-completed sale
SaintStatus3	saintStatus	Not completed activites with intention sale: Number of not completed activities for intention sale > 0.
saintSaleStatus	listAny	With status
saintAmountClass	listAny	Amount class
saintActivityType	listAny	SAINT type
saintDirection	listAny	Direction
saintIntention	listAny	Intention
saintTicketStatus	listAny	Status
saintTicketCategory	listAny	Category
project/textId	int	Text ID
project/infoText	positiveString	Information: Displays the text entered in the description field
destinationProjectRestrictionId	int	ADD LINK PROJECT DESTINATION RESOURCE: ADD LINK PROJECT DESTINATION TOOLTIP RESOURCE
documentId	int	Document ID: Database ID of document record

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
keywords	string	Keywords
ourref	string	Our ref.
yourref	string	Your ref.
attention	string	Salutation
subject	string	Subject
mailMergeDraft	bool	Mail merge draft : Indicates whether the document is a mail merge template
snum	int	Document number: Serial number of document. It can be generated by the number allocation system for a dedicated document template.
isReport	bool	Report: Is this document a saved report run?
suggestedDocumentId	int	Document ID (suggestion: The database ID of a document that originates in a suggestion
isMail	bool	E-mail
documentPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published
documentPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date
documentPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date
documentPublish/publishedBy	None	Published by: Published by
documentUdef/SuperOffice:1	string	documentshorttext
documentUdef/SuperOffice:2	string	documentlongtext
documentUdef/SuperOffice:3	int	documentnumber
documentUdef/SuperOffice:4	date	documentdate
documentUdef/SuperOffice:5	unlimitedDate	documentunlimiteddate
documentUdef/SuperOffice:6	bool	documentcheckbox
documentUdef/SuperOffice:7	listAny	documentdropdownlistbox
documentUdef/SuperOffice:8	decimal	documentdecimal
destinationDocumentRestrictionId	int	Destination document ID: IDs of documents which are linked to
document/textId	int	Text ID
document/description	positiveString	Text: Displays the text entered in the description field
URLAddress	string	URL
URLDescription	string	Description
destinationURLRestrictionId	int	ADD LINK URL DESTINATION RESOURCE: ADD LINK URL DESTINATION TOOLTIP RESOURCE
firstName	string	First name: Displays the contact's first name
lastName	string	Last name: Displays the contact's last name
middleName	string	Middle name: Displays the contact's middle name.
fullName	stringorPK	Contact: Displays the contact to which an item is linked
hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests
personHasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests
mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms
position	listAny	Position
personNumber	string	Number: Displays the contact's number
title	string	Title: Displays the contact's job title
personCountry	listAny	Country: Country
personCountryId	int	Country ID: Country ID
personNoMail	bool	No Mailings: Displays the contact's No Mailings checkbox
rank	int	Rank: Displays a contact's current rank
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
personSource	listAny	Source: Source (Contact)
retired	bool	Former employee: Indicates whether the contact has retired/left the company
birthYear	int	Birth year: Displays contact's birth year
birthMonth	int	Birth month: Displays contact's birth month
birthDay	int	Birth day: Displays contact's birth day (day of month)
kanaFirstName	string	First name, kana: Contact's first name, in kana alphabet
kanaLastName	string	Last name, kana: Contact's last name, in kana alphabet
personUpdatedBy	associate	Updated by: The user who last updated the data
personUpdatedByFullName	associate	Updated by - Full name: The user who last updated the data
personUpdatedDate	date	Updated: The date/time the data was last updated in UTC.
personRegisteredBy	associate	Registered by: The user who registered the data
personRegisteredByFullName	associate	Registered by - Full name: The user who registered the data
personRegisteredDate	date	Registered date: The date/time the data was registered in UTC.
portraitThumbnail	None	Person image: Person image
personActiveErpLinks	bool	ERP connected: Is there an active ERP Sync?
ticketPriority	listAny	Service priority: Default service priority for this contact
supportLanguage	listAny	Preferred language: Preferred language used for reply templates and more
supportAssociate	associate	Our service contact: Default service contact for this contact
supportAssociateFullName	associate	Our service contact - Full name: Default service contact for this contact
personAssociateId	associate	Our contact: Displays our contact
personAssociateFullName	associate	Our contact - Full name: Displays our contact
personCategory	listAny	Category
personBusiness	listAny	Business
personDeletedDate	datetime	Deleted date: Deleted date
hasCompany	bool	Has company: The contact is associated with a company
isProjectMember	bool	Is project member: This person is a project member
isStakeholder	bool	Is stakeholder: This person is a sale stakeholder
updatedByWorkflow	listAny	Updated by flow: Updated by flow
whenUpdatedByWorkflow	datetime	When updated by flow: When updated by flow
createdByForm	listAny	Created by form: Created by form
destinationPersonRestrictionId	int	ADD LINK Person DESTINATION RESOURCE: ADD LINK Person DESTINATION TOOLTIP RESOURCE
department	string	Department
nameDepartment	None	Company: Displays the company an activity is linked to
category	listAny	Category
business	listAny	Business
country	listAny	Country: This criterion corresponds to the Country field on the Company card.
countryId	int	Country ID: Country ID
code	string	Code
orgnr	string	VAT No.
stop	bool	Stop
contactNoMail	bool	No mailings (company
contactSource	listAny	Source: Source (Company)
contactDeleted	bool	Deleted: Deleted
deletedDate	datetime	Deleted date: Deleted date
mainContact	None	Main contact: Main contact for this company
destinationContactRestrictionId	int	ADD LINK Contact DESTINATION RESOURCE: ADD LINK Contact DESTINATION TOOLTIP RESOURCE
selectionId	int	Selection ID: The database ID of the selection
kind	listAny	Selection is : The kind of selection (static, dynamic or combined)
targetTableNumber	listAny	Selection of: Displays what the selection consists of
combinationType	listAny	Combination type: Displays the combination type for a selection
done	bool	Completed: Shows whether the selection has been completed
lastLoaded	date	Last used: When was the result list for the selection last shown
lastLoadedBy	associate	Last used by: Who was the last person to show the result list for the selection
lastLoadedByFullName	associate	Last used by - Full name: Who was the last person to show the result list for the selection
lastMembershipChange	date	Members changed: When was the result list for the selection last changed, for instance due to a change in the criteria

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
lastMembershipChangeBy	associate	Members changed by: Who was the last person to change the result list for the selection, for instance by changing the criteria
lastMembershipChangeByFullName	associate	Members changed by - Full name: Who was the last person to change the result list for the selection, for instance by changing the criteria
memberCount	int	Members: How many members were in the selection, the last time all were fetched. May be imprecise/outdated.
destinationSelectionRestrictionId	int	ADD LINK Selection DESTINATION RESOURCE: ADD LINK Selection DESTINATION TOOLTIP RESOURCE

Sample

GET /api/v1/archive/Links?$select=contact/registeredBy,contact/streetAddress/line3,contact/contactExtra/x_contact_boolean,contact/NumberOfNotCompletedTicketsInPeriod,person/personUdef/SuperOffice:1
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.