TargetValueSub - SuperOffice

“TargetValueSub”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.TargetValueSubProvider inside NetServer’s SODatabase assembly. Archive of TargetValue - used by .

Supported Entities

Name	Description
”targetValue”	targetValue

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
targetValue	int	!!Target value: !!Target value
targetPeriodNumber	int	!!TargetPeriodNumber: !!TargetPeriodNumber
targetAssociate	associate	!!TargetAssociate: !!TargetAssociate
targetContactId	int	!!TargetContact: !!TargetContact
targetUserGroup	userGroup	Primary group: The user’s primary user group
targetYear	int	!!TargetYear: !!TargetYear
targetCurrency	listAny	Currency: The currency of the sale
targetPeriod	date	Date: Displays start date of a follow-up / sale date of a sale
targetPeriodType	int	targetPeriodType: targetPeriodType
targetAssignmentId	int	targetAssignmentId: targetAssignmentId
targetDimensionEntityType	listAny	!!targetDimensionEntityType: !!targetDimensionEntityType
targetDimensionMeasurementUnit	listAny	!!targetDimensionMeasurementUnit: !!targetDimensionMeasurementUnit
targetDimensionListField	string	!!targetDimensionListField: !!targetDimensionListField
targetAssignmentDimensionItemId	intArray	!!targetAssignmentDimensionItemId: !!targetAssignmentDimensionItemId
targetDimensionTargetTypeName	listAny	!!targetDimensionTargetTypeName: !!targetDimensionTargetTypeName
associate/firstName	string	First name: Displays the contact’s first name	x
associate/lastName	string	Last name: Displays the contact’s last name	x
associate/middleName	string	Middle Name : Displays the contact’s middle name.	x
associate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
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	x
associate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
associate/associateDbId	associate	ID	x
associate/contactName	string	Owning company: Name of the company the user belongs to	x
associate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
associate/usergroup	userGroup	Primary group: The user’s primary user group	x
associate/usergroupId	int	Group ID: The user’s primary user group	x
associate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
associate/contactCategory	listAny	Category: Category	x
associate/role	listAny	Role : Role	x
associate/assocName	associate	User ID : User ID	x
associate/assocTooltip	string	Description : Description
associate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
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	Nickname: User’s nickname in Service	x
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	x
associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
associate/isActive	bool	Active: Is this user active, and should be able to log in?	x
associate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
associate/portraitThumbnail	None	Person image: Person image
associate/otherGroups	userGroup	Other groups: Other groups
associate/userName	string	User name: User name	x
associate/personEmail	string	E-mail	x
associate/locationAddress	string	Location: Location	x
associate/isLocation	bool	Is a location: Is a location	x
contact/contactId	int	Company ID: Database ID of company	x
contact/name	stringorPK	Company name	x
contact/department	string	Department	x
contact/nameDepartment	string	Company: Displays the company an activity is linked to	x
contact/hasInfoText	bool	Has note: Displays an icon indicating if there is additional information available about the contact	x
contact/hasInterests	bool	Has interests: Displays an Icon indicating if the contact has active interests	x
contact/associateId	associate	Our contact: Displays our contact	x
contact/category	listAny	Category	x
contact/categoryGroup	listAny	Category group	x
contact/companyCategoryRank	int	Category rank	x
contact/business	listAny	Business	x
contact/country	listAny	Country: This criterion corresponds to the Country field on the Company card.	x
contact/countryId	int	Country ID: Country ID	x
contact/number	string	Number	x
contact/code	string	Code	x
contact/orgnr	string	VAT No.	x
contact/stop	bool	Stop	x
contact/contactNoMail	bool	No mailings (company)	x
contact/updatedBy	associate	Updated by: The user who last updated the data	x
contact/updatedByFullName	associate	Updated by - Full name: The user who last updated the data	x
contact/updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
contact/registeredBy	associate	Registered by: The user who registered the data	x
contact/registeredByFullName	associate	Registered by - Full name: The user who registered the data	x
contact/registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
contact/contactSource	listAny	Source: Source (Company)	x
contact/contactDeleted	bool	Deleted: Deleted	x
contact/phone/formattedNumber	string	Phone : Displays phone number
contact/activeErpLinks	bool	ERP connected: Is there an active ERP Sync?	x
contact/deletedDate	datetime	Deleted date: Deleted date
contact/mainContact	None	Main contact: Main contact for this company	x
contact/forceCompany	bool	Dummy: Dummy
contact/contactPhone/formattedNumber	string	Telephone - Phone: Displays phone number
contact/contactPhone/description	string	Telephone - Description: Phone number description	x
contact/contactFax/formattedNumber	string	Fax - Phone: Displays phone number
contact/contactFax/description	string	Fax - Description: Phone number description	x
contact/searchPhone/formattedNumber	string	Searchphone - Phone: Displays phone number
contact/searchPhone/description	string	Searchphone - Description: Phone number description	x
contact/email/emailProtocol	string	Protocol: E-mail protocol, such as SMTP	x
contact/email/emailAddress	string	E-mail	x
contact/email/emailDescription	string	Description	x
contact/email/emailId	int	ID	x
contact/email/emailLastSent	datetime	Last sent: The date and time an e-mail was last sent to this address	x
contact/email/emailBounceCount	int	Bounce count: Bounce count for this e-mail address	x
contact/email/emailLastBounce	datetime	Last bounce: Date and time for last bounce to this e-mail address	x
contact/email/emailHasBounced	bool	Has bounced: This checkbox is active if delivery to this e-mail address has failed.	x
contact/postAddress/addressId	int	Postal address - Address ID: Database ID for the address record	x
contact/postAddress/line1	string	Postal address - Address 1: First line of the address	x
contact/postAddress/line2	string	Postal address - Address 2: Second line of the address	x
contact/postAddress/line3	string	Postal address - Address 3: Third line of the address	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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.	x
contact/postAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.	x
contact/postAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
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.	x
contact/postAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude	x
contact/postAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude	x
contact/postAddress/formattedAddress	None	Postal address - :
contact/postAddress/formattedMultiLineAddress	None	Postal address - :
contact/restrictionPostalAddress/addressId	int	Postal address - Address ID: Database ID for the address record	x
contact/restrictionPostalAddress/line1	string	Postal address - Address 1: First line of the address	x
contact/restrictionPostalAddress/line2	string	Postal address - Address 2: Second line of the address	x
contact/restrictionPostalAddress/line3	string	Postal address - Address 3: Third line of the address	x
contact/restrictionPostalAddress/county	string	Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format.	x
contact/restrictionPostalAddress/city	string	Postal address - City: This criterion corresponds to the City field on the Company card.	x
contact/restrictionPostalAddress/zip	string	Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
contact/restrictionPostalAddress/state	string	Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format.	x
contact/restrictionPostalAddress/wgs84latitude	decimal	Postal address - Latitude: Latitude	x
contact/restrictionPostalAddress/wgs84longitude	decimal	Postal address - Longitude: Longitude	x
contact/restrictionPostalAddress/formattedAddress	None	Postal address - :
contact/restrictionPostalAddress/formattedMultiLineAddress	None	Postal address - :
contact/streetAddress/addressId	int	Street address - Address ID: Database ID for the address record	x
contact/streetAddress/line1	string	Street address - Address 1: First line of the address	x
contact/streetAddress/line2	string	Street address - Address 2: Second line of the address	x
contact/streetAddress/line3	string	Street address - Address 3: Third line of the address	x
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.	x
contact/streetAddress/city	string	Street address - City: This criterion corresponds to the City field on the Company card.	x
contact/streetAddress/zip	string	Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
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.	x
contact/streetAddress/wgs84latitude	decimal	Street address - Latitude: Latitude	x
contact/streetAddress/wgs84longitude	decimal	Street address - Longitude: Longitude	x
contact/streetAddress/formattedAddress	None	Street address - :
contact/streetAddress/formattedMultiLineAddress	None	Street address - :
contact/restrictionAddress/addressId	int	Search address - Address ID: Database ID for the address record	x
contact/restrictionAddress/line1	string	Search address - Address 1: First line of the address	x
contact/restrictionAddress/line2	string	Search address - Address 2: Second line of the address	x
contact/restrictionAddress/line3	string	Search address - Address 3: Third line of the address	x
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.	x
contact/restrictionAddress/city	string	Search address - City: This criterion corresponds to the City field on the Company card.	x
contact/restrictionAddress/zip	string	Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card.	x
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.	x
contact/restrictionAddress/wgs84latitude	decimal	Search address - Latitude: Latitude	x
contact/restrictionAddress/wgs84longitude	decimal	Search address - Longitude: Longitude	x
contact/restrictionAddress/formattedAddress	None	Search address - :
contact/restrictionAddress/formattedMultiLineAddress	None	Search address - :
contact/url/URLAddress	string	URL	x
contact/url/URLDescription	string	Description	x
contact/contactAssociate/firstName	string	First name: Displays the contact’s first name	x
contact/contactAssociate/lastName	string	Last name: Displays the contact’s last name	x
contact/contactAssociate/middleName	string	Middle Name : Displays the contact’s middle name.	x
contact/contactAssociate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
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	x
contact/contactAssociate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
contact/contactAssociate/associateDbId	associate	ID	x
contact/contactAssociate/contactName	string	Owning company: Name of the company the user belongs to	x
contact/contactAssociate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
contact/contactAssociate/usergroup	userGroup	Primary group: The user’s primary user group	x
contact/contactAssociate/usergroupId	int	Group ID: The user’s primary user group	x
contact/contactAssociate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
contact/contactAssociate/contactCategory	listAny	Category: Category	x
contact/contactAssociate/role	listAny	Role : Role	x
contact/contactAssociate/assocName	associate	User ID : User ID	x
contact/contactAssociate/assocTooltip	string	Description : Description
contact/contactAssociate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
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	Nickname: User’s nickname in Service	x
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	x
contact/contactAssociate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
contact/contactAssociate/isActive	bool	Active: Is this user active, and should be able to log in?	x
contact/contactAssociate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
contact/contactAssociate/portraitThumbnail	None	Person image: Person image
contact/contactAssociate/otherGroups	userGroup	Other groups: Other groups
contact/contactAssociate/userName	string	User name: User name	x
contact/contactAssociate/personEmail	string	E-mail	x
contact/contactAssociate/locationAddress	string	Location: Location	x
contact/contactAssociate/isLocation	bool	Is a location: Is a location	x
contact/contactSupportAssociate/firstName	string	Our service contact - First name: Displays the contact’s first name	x
contact/contactSupportAssociate/lastName	string	Our service contact - Last name: Displays the contact’s last name	x
contact/contactSupportAssociate/middleName	string	Our service contact - Middle Name: Displays the contact’s middle name.	x
contact/contactSupportAssociate/fullName	string	Our service contact - Full name: Displays full name of user (first, middle, last - according to settings)	x
contact/contactSupportAssociate/contactId	int	Our service contact - Company ID: Database ID of the company the user belongs to
contact/contactSupportAssociate/personId	int	Our service contact - Contact ID: Database ID of the contact row
contact/contactSupportAssociate/mrMrs	string	Our service contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
contact/contactSupportAssociate/title	string	Our service contact - Title: Displays whether the contact is addressed as Mr or Ms	x
contact/contactSupportAssociate/associateDbId	associate	Our service contact - ID	x
contact/contactSupportAssociate/contactName	string	Our service contact - Owning company: Name of the company the user belongs to	x
contact/contactSupportAssociate/contactDepartment	string	Our service contact - Owning department: Name of the department at the company the user belongs to	x
contact/contactSupportAssociate/usergroup	userGroup	Our service contact - Primary group: The user’s primary user group	x
contact/contactSupportAssociate/usergroupId	int	Our service contact - Group ID: The user’s primary user group	x
contact/contactSupportAssociate/contactFullName	string	Our service contact - Owner: Name and department of the company the user belongs to	x
contact/contactSupportAssociate/contactCategory	listAny	Our service contact - Category: Category	x
contact/contactSupportAssociate/role	listAny	Our service contact - Role: Role	x
contact/contactSupportAssociate/assocName	associate	Our service contact - User ID: User ID	x
contact/contactSupportAssociate/assocTooltip	string	Our service contact - Description: Description
contact/contactSupportAssociate/assocType	listAny	Our service contact - Type: Type of user: associate, external user, system user, anonymous account	x
contact/contactSupportAssociate/ejUserId	int	Our service contact - Service user ID: The database ID of a Service user
contact/contactSupportAssociate/simultaneousEjUser	bool	Our service contact - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
contact/contactSupportAssociate/ejDisplayName	string	Our service contact - Nickname: User’s nickname in Service	x
contact/contactSupportAssociate/ejStatus	int	Our service contact - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
contact/contactSupportAssociate/credentialType	None	Our service contact - Auth. type: What type of credentials to use when this user logs in	x
contact/contactSupportAssociate/credentialDisplayValue	None	Our service contact - Auth. value: Credential value (public, visible part) to be used when this user logs in	x
contact/contactSupportAssociate/isActive	bool	Our service contact - Active: Is this user active, and should be able to log in?	x
contact/contactSupportAssociate/isActiveText	bool	Our service contact - Active status: Is this user active, and should be able to log in?	x
contact/contactSupportAssociate/portraitThumbnail	None	Our service contact - Person image: Person image
contact/contactSupportAssociate/otherGroups	userGroup	Our service contact - Other groups: Other groups
contact/contactSupportAssociate/userName	string	Our service contact - User name: User name	x
contact/contactSupportAssociate/personEmail	string	Our service contact - E-mail	x
contact/contactSupportAssociate/locationAddress	string	Our service contact - Location: Location	x
contact/contactSupportAssociate/isLocation	bool	Our service contact - Is a location: Is a location	x
contact/contactSupportPerson/personId	int	User support contact - DB ID: Displays the database ID of a contact	x
contact/contactSupportPerson/firstName	string	User support contact - First name: Displays the contact’s first name	x
contact/contactSupportPerson/lastName	string	User support contact - Last name: Displays the contact’s last name	x
contact/contactSupportPerson/middleName	string	User support contact - Middle name: Displays the contact’s middle name.	x
contact/contactSupportPerson/fullName	string	User support contact - Contact: Displays the contact to which an item is linked	x
contact/contactSupportPerson/contactId	int	User support contact - Company ID: Database ID of company	x
contact/contactSupportPerson/hasInfoText	bool	User support contact - Has note: Displays an icon indicating if there is additional information available about the contact	x
contact/contactSupportPerson/hasInterests	bool	User support contact - Has interests: Displays an Icon indicating if the contact has active interests	x
contact/contactSupportPerson/personHasInterests	bool	User support contact - Has interests: Displays an Icon indicating if the contact has active interests	x
contact/contactSupportPerson/mrMrs	string	User support contact - Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
contact/contactSupportPerson/position	listAny	User support contact - Position	x
contact/contactSupportPerson/personNumber	string	User support contact - Number: Displays the contact’s number	x
contact/contactSupportPerson/title	string	User support contact - Title: Displays the contact’s job title	x
contact/contactSupportPerson/personCountry	listAny	User support contact - Country: Country	x
contact/contactSupportPerson/personCountryId	int	User support contact - Country ID: Country ID	x
contact/contactSupportPerson/personNoMail	bool	User support contact - No Mailings: Displays the contact’s No Mailings checkbox	x
contact/contactSupportPerson/rank	int	User support contact - Rank: Displays a contact’s current rank	x
contact/contactSupportPerson/birthdate	None	User support contact - Birthdate: Displays the contact’s date of birth
contact/contactSupportPerson/associateType	None	User support contact - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading.
contact/contactSupportPerson/useAsMailingAddress	bool	User support contact - Use as postal address: Use as postal address	x
contact/contactSupportPerson/personSource	listAny	User support contact - Source: Source (Contact)	x
contact/contactSupportPerson/retired	bool	User support contact - Former employee: Indicates whether the contact has retired/left the company	x
contact/contactSupportPerson/birthYear	int	User support contact - Birth year: Displays contact’s birth year	x
contact/contactSupportPerson/birthMonth	int	User support contact - Birth month: Displays contact’s birth month	x
contact/contactSupportPerson/birthDay	int	User support contact - Birth day: Displays contact’s birth day (day of month)	x
contact/contactSupportPerson/kanaFirstName	string	User support contact - First name, kana: Contact’s first name, in kana alphabet	x
contact/contactSupportPerson/kanaLastName	string	User support contact - Last name, kana: Contact’s last name, in kana alphabet	x
contact/contactSupportPerson/personUpdatedBy	associate	User support contact - Updated by: The user who last updated the data	x
contact/contactSupportPerson/personUpdatedByFullName	associate	User support contact - Updated by - Full name: The user who last updated the data	x
contact/contactSupportPerson/personUpdatedDate	date	User support contact - Updated: The date/time the data was last updated in UTC.	x
contact/contactSupportPerson/personRegisteredBy	associate	User support contact - Registered by: The user who registered the data	x
contact/contactSupportPerson/personRegisteredByFullName	associate	User support contact - Registered by - Full name: The user who registered the data	x
contact/contactSupportPerson/personRegisteredDate	date	User support contact - Registered date: The date/time the data was registered in UTC.	x
contact/contactSupportPerson/portraitThumbnail	None	User support contact - Person image: Person image
contact/contactSupportPerson/personActiveErpLinks	bool	User support contact - ERP connected: Is there an active ERP Sync?	x
contact/contactSupportPerson/ticketPriority	listAny	User support contact - Service priority: Default service priority for this contact	x
contact/contactSupportPerson/supportLanguage	listAny	User support contact - Preferred language: Preferred language used for reply templates and more	x
contact/contactSupportPerson/supportAssociate	associate	User support contact - Our service contact: Default service contact for this contact	x
contact/contactSupportPerson/supportAssociateFullName	associate	User support contact - Our service contact - Full name: Default service contact for this contact	x
contact/contactSupportPerson/personAssociateId	associate	User support contact - Our contact: Displays our contact	x
contact/contactSupportPerson/personAssociateFullName	associate	User support contact - Our contact - Full name: Displays our contact	x
contact/contactSupportPerson/personCategory	listAny	User support contact - Category	x
contact/contactSupportPerson/personCategoryGroup	listAny	User support contact - Category group	x
contact/contactSupportPerson/personCategoryRank	int	User support contact - !!Category rank	x
contact/contactSupportPerson/personBusiness	listAny	User support contact - Business	x
contact/contactSupportPerson/leadStatus	listAny	User support contact - Lead status	x
contact/contactSupportPerson/leadstatusRank	int	User support contact - !!Lead status RANK	x
contact/contactSupportPerson/personDeletedDate	datetime	User support contact - Deleted date: Deleted date
contact/contactSupportPerson/hasCompany	bool	User support contact - Has company: The contact is associated with a company	x
contact/contactSupportPerson/isProjectMember	bool	User support contact - Is project member: This person is a project member	x
contact/contactSupportPerson/isStakeholder	bool	User support contact - Is stakeholder: This person is a sale stakeholder	x
contact/contactSupportPerson/updatedByWorkflow	listAny	User support contact - Updated by flow: Updated by flow	x
contact/contactSupportPerson/whenUpdatedByWorkflow	datetime	User support contact - When updated by flow: When updated by flow	x
contact/contactSupportPerson/createdByForm	listAny	User support contact - Created by form: Created by form	x
contact/contactSupportPerson/who	None	User support contact - Full name: Displays the contact’s full name.	x
contact/contactSupportPerson/personInfo/textId	int	User support contact - Text ID	x
contact/contactSupportPerson/personInfo/infoText	positiveString	User support contact - Information: Displays the text entered in the description field	x
contact/contactSupportPerson/personUdef/SuperOffice:1	string	User support contact - contactshorttext: tooltipshorttext	x
contact/contactSupportPerson/personUdef/SuperOffice:2	string	User support contact - contactlongtext: tooltiplongtext	x
contact/contactSupportPerson/personUdef/SuperOffice:3	int	User support contact - contactnumber	x
contact/contactSupportPerson/personUdef/SuperOffice:4	date	User support contact - contactdate	x
contact/contactSupportPerson/personUdef/SuperOffice:5	unlimitedDate	User support contact - contactunlimiteddate: tooltipunlimiteddate	x
contact/contactSupportPerson/personUdef/SuperOffice:6	bool	User support contact - contactcheckbox	x
contact/contactSupportPerson/personUdef/SuperOffice:7	listAny	User support contact - contactdropdownlistbox	x
contact/contactSupportPerson/personUdef/SuperOffice:8	decimal	User support contact - contactdecimal	x
contact/contactSupportPerson/personUdef/SuperOffice:9	string	User support contact - page1saleonly	x
contact/contactSupportPerson/personUdef/SuperOffice:10	string	User support contact - page1marketingonly	x
contact/contactSupportPerson/personUdef/SuperOffice:11	string	User support contact - page1adminonly	x
contact/contactSupportPerson/personExtra/x_person_integer	int	User support contact - Extra Integer: Custom person integer	x
contact/contactSupportPerson/personExtra/x_person_hidden_integer	int	User support contact - Extra hidden integer: Custom integer field that is hidden	x
contact/contactSupportPerson/personExtra/x_person_float	decimal	User support contact - Extra float: Custom float field	x
contact/contactSupportPerson/personExtra/x_person_longtext	string	User support contact - Extra Long Text: Custom long text field on person, keep HTML tags. Simple input, not text area. Default value = ‘Hello there’	x
contact/contactSupportPerson/personExtra/x_person_date	date	User support contact - Extra date: Custom date field on person. Default value = 28.03.2019	x
contact/contactSupportPerson/personExtra/x_person_datetime	datetime	User support contact - Extra DateTime: Custom person date and time field. No default	x
contact/contactSupportPerson/personExtra/x_person_time	None	User support contact - Extra time: Custom time field on person. Current time as default	x
contact/contactSupportPerson/personExtra/x_person_boolean	bool	User support contact - Extra Boolean: Custom boolean field on person. Default checked	x
contact/contactSupportPerson/personExtra/x_person_timespan	timeSpan	User support contact - Extra timespan: Custom timespan on person. Minutes only in 15 units	x
contact/contactSupportPerson/personExtra/x_person_shorttext	string	User support contact - Extra short text: Custom short text on person. With index. Do not keep HTML tags	x
contact/contactSupportPerson/personExtra/x_person_shorttext_list	listAny	User support contact - Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent	x
contact/contactSupportPerson/personExtra/x_person_user_relation	associate	User support contact - Extra user relation: Custom person-user relation field	x
contact/contactSupportPerson/personExtra/x_person_category_relation	listAny	User support contact - Extra category relation: Custom person-category relation	x
contact/contactSupportPerson/personExtra/x_person_priority_relation	listAny	User support contact - Extra priority relation: Custom person-priority relation	x
contact/contactSupportPerson/personExtra/x_person_request_relation	stringorPK	User support contact - Extra request relation: Request relation on contact	x
contact/contactSupportPerson/personExtra/x_person_appointment_relation	stringorPK	User support contact - Extra appointment relation: Appointment relation on person	x
contact/contactSupportPerson/personExtra/x_person_contact_relation	stringorPK	User support contact - Extra company relation: Company relation on contact	x
contact/contactSupportPerson/personExtra/y_rental/id	int	User support contact - Rental - id: Displays the row’s primary key (y_rental)	x
contact/contactSupportPerson/personExtra/y_rental/x_start	date	User support contact - Rental - Start rental: Start rental	x
contact/contactSupportPerson/personExtra/y_rental/x_end	date	User support contact - Rental - End: End	x

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
contact/contactSupportPerson/personExtra/y_rental/x_amount	int	User support contact - Rental - Amount: Number to rent. Default = 1	x
contact/contactSupportPerson/personExtra/y_rental/x_contact	stringorPK	User support contact - Rental - Renter: Company that rents equipment	x
contact/contactSupportPerson/personExtra/y_rental/y_equipment/x_name	string	User support contact - Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table	x
contact/contactSupportPerson/personExtra/y_car/id	int	User support contact - Car - id: Displays the row’s primary key (y_car)	x
contact/contactSupportPerson/isMailingRecipient	bool	User support contact - Is mailing recipient: isMailingRecipient	x
contact/contactSupportPerson/hasStoreConsent	bool	User support contact - Consent - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
contact/contactSupportPerson/withdrawnStoreConsent	bool	User support contact - Consent is withdrawn - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.
contact/contactSupportPerson/hasEmarketingConsent	bool	User support contact - Consent - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
contact/contactSupportPerson/withdrawnEmarketingConsent	bool	User support contact - Consent is withdrawn - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.
contact/contactSupportPerson/subscription	listAny	User support contact - Subscription: Subscription for marketing	x
contact/contactSupportPerson/legalBaseStore	listAny	User support contact - Legal basis - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
contact/contactSupportPerson/legalBaseEmarketing	listAny	User support contact - Legal basis - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
contact/contactSupportPerson/consentSourceStore	listAny	User support contact - Source - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers.	x
contact/contactSupportPerson/consentSourceEmarketing	listAny	User support contact - Source - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes.	x
contact/contactInterestIds	listInterest	Company Interest: This criterion corresponds to the Interests tab on the Company card.
contact/contactUdef/SuperOffice:1	string	companyshorttext: tooltipshorttext	x
contact/contactUdef/SuperOffice:2	string	companylongtext: tooltiplongtext	x
contact/contactUdef/SuperOffice:3	int	companynumber	x
contact/contactUdef/SuperOffice:4	date	companydate	x
contact/contactUdef/SuperOffice:5	unlimitedDate	companyunlimiteddate: tooltipunlimiteddate	x
contact/contactUdef/SuperOffice:6	bool	companycheckbox	x
contact/contactUdef/SuperOffice:7	listAny	companydropdownlistbox	x
contact/contactUdef/SuperOffice:8	decimal	companydecimal	x
contact/contactUdef/SuperOffice:9	string	page1saleonly	x
contact/contactUdef/SuperOffice:10	string	page1marketingonly	x
contact/contactUdef/SuperOffice:11	string	page1adminonly	x
contact/contactUdef/SuperOffice:12	listAny	Udlist one: Static tooltip for udlist one	x
contact/contactUdef/SuperOffice:13	listAny	Udlist two: Static tooltip for udlist two	x
contact/contactExtra/x_contact_integer	int	Extra Integer: Custom integer field	x
contact/contactExtra/x_contact_hidden_integer	int	Extra hidden integer: Custom integer field - hidden	x
contact/contactExtra/x_contact_default_integer	int	Extra Default Integer: Custom integer field with default value 123.	x
contact/contactExtra/x_contact_float	decimal	Extra Float: Custom float field with 3 decimals	x
contact/contactExtra/x_contact_longtext	string	Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor	x
contact/contactExtra/x_contact_dropdown	listAny	Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc.	x
contact/contactExtra/x_contact_date	date	Extra date: Custom date field. User current as default.	x
contact/contactExtra/x_contact_datetime	datetime	Extra DateTime: Custom Date Time field. No default value. External	x
contact/contactExtra/x_contact_time	None	Extra time: Custom time field.	x
contact/contactExtra/x_contact_boolean	bool	Extra boolean: Custom boolean field.	x
contact/contactExtra/x_contact_timespan	timeSpan	Extra timespan: Custom timespan field. Hours and minutes in 10 units	x
contact/contactExtra/x_contact_shorttext	string	Extra short text: Custom short text field. Keep HTML tags.	x
contact/contactExtra/x_contact_short_dropdown	listAny	Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External.	x
contact/contactExtra/x_contact_contact_relation	stringorPK	Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons	x
contact/contactExtra/x_contact_request_relation	stringorPK	Extra Request relation: Request relation on company	x
contact/contactExtra/x_contact_contact	stringorPK	Extra contact relation: Contact relation on company	x
contact/contactExtra/y_organization/x_name	string	Organization - Name: Name	x
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
contact/selectionMemberId	int	Selection member ID: The database ID of the selection member record
contact/selectionIdRequest	int	Selection ID: Database ID of selection which members are to be fetched from

Sample

GET /api/v1/archive/TargetValueSub?$select=contact/url/URLDescription,contact/contactExtra/x_contact_shorttext,contact/streetAddress/zip
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.

Related topics

Set up a sale target type with sub-types SubContactPersonDynamicSelectionSingleCriteriaGroup SubPersonContactDynamicSelectionSingleCriteriaGroup TargetValue Set up sales targets Manage email subscriptions

⌘I