"ContactPersonSelectionV2"
Some tooltip text!
• 115 minutes to read
• 115 minutes to read
This provider name is implemented by the class
This is the archive Provider for the Selection contact/person archive.
Supported Entities
Name | Description |
---|---|
"staticContact" | Static company |
"staticPerson" | Static contact |
"contact" | Company |
"person" | Contact |
Supported Columns
Name | Restriction | Description | OrderBy |
---|---|---|---|
selectionId | int | Selection ID: The database ID of the selection | |
rowKind | None | Icon indicating whether the row comes from a static or a dynamic selection | |
getAllRows | bool | GetAll: Get all rows of archive - use with care, you may be fetching the whole database | |
getNoRows | bool | GetNone: Do not get any rows from the archive | |
selectionMemberId | None | Selection member ID: The database ID of the selection member record | |
contactId | int | Company ID: Database ID of company | x |
name | stringorPK | Company name | x |
department | string | Department | x |
nameDepartment | None | Company: Displays the company an activity is linked to | x |
hasInfoText | bool | Has note: Displays an icon indicating if there is additional information available about the contact | x |
hasInterests | bool | Has interests: Displays an Icon indicating if the contact has active interests | x |
associateId | associate | Our contact: Displays our contact | x |
category | listAny | Category | x |
business | listAny | Business | x |
country | listAny | Country: This criterion corresponds to the Country field on the Company card. | x |
countryId | int | Country ID: Country ID | x |
number | string | Number | x |
code | string | Code | x |
orgnr | string | VAT No. | x |
stop | bool | Stop | x |
contactNoMail | bool | No mailings (company | x |
updatedBy | associate | Updated by: The user who last updated the data | x |
updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
registeredBy | associate | Registered by: The user who registered the data | x |
registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
contactSource | listAny | Source: Source (Company) | x |
contactDeleted | bool | Deleted: Deleted | x |
phone/formattedNumber | string | Phone : Displays phone number | |
activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
deletedDate | datetime | Deleted date: Deleted date | |
mainContact | None | Main contact: Main contact for this company | x |
who | None | Company: Displays the name of a selection member's company | x |
contactPhone/formattedNumber | string | Telephone - Phone: Displays phone number | |
contactPhone/description | string | Telephone - Description: Phone number description | x |
contactFax/formattedNumber | None | Fax - Phone: Displays phone number | |
contactFax/description | None | Fax - Description: Phone number description | x |
searchPhone/formattedNumber | None | Searchphone - Phone: Displays phone number | |
searchPhone/description | None | Searchphone - Description: Phone number description | x |
email/emailProtocol | string | Protocol: E-mail protocol, such as SMTP | x |
email/emailAddress | string | x | |
email/emailDescription | string | Description | x |
email/emailId | int | ID | x |
email/emailLastSent | datetime | Last sent: The date and time an e-mail was last sent to this address | x |
email/emailBounceCount | int | Bounce count: Bounce count for this e-mail address | x |
email/emailLastBounce | datetime | Last bounce: Date and time for last bounce to this e-mail address | x |
email/emailHasBounced | bool | Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
postAddress/addressId | int | Postal address - Address ID: Database ID for the address record | x |
postAddress/line1 | string | Postal address - Address 1: First line of the address | x |
postAddress/line2 | string | Postal address - Address 2: Second line of the address | x |
postAddress/line3 | string | Postal address - Address 3: Third line of the address | x |
postAddress/county | string | Postal address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
postAddress/city | string | Postal address - City: This criterion corresponds to the City field on the Company card. | x |
postAddress/zip | string | Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
postAddress/state | string | Postal address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
postAddress/wgs84latitude | decimal | Postal address - Latitude: Latitude | x |
postAddress/wgs84longitude | decimal | Postal address - Longitude: Longitude | x |
postAddress/formattedAddress | None | Postal address - {formattedAddress}: {formattedAddress} | |
postAddress/formattedMultiLineAddress | None | Postal address - {formattedAddress}: {formattedAddress} | |
streetAddress/addressId | int | Street address - Address ID: Database ID for the address record | x |
streetAddress/line1 | string | Street address - Address 1: First line of the address | x |
streetAddress/line2 | string | Street address - Address 2: Second line of the address | x |
streetAddress/line3 | string | Street address - Address 3: Third line of the address | x |
streetAddress/county | string | Street address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
streetAddress/city | string | Street address - City: This criterion corresponds to the City field on the Company card. | x |
streetAddress/zip | string | Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
streetAddress/state | string | Street address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
streetAddress/wgs84latitude | decimal | Street address - Latitude: Latitude | x |
streetAddress/wgs84longitude | decimal | Street address - Longitude: Longitude | x |
streetAddress/formattedAddress | None | Street address - {formattedAddress}: {formattedAddress} | |
streetAddress/formattedMultiLineAddress | None | Street address - {formattedAddress}: {formattedAddress} | |
restrictionAddress/addressId | int | Search address - Address ID: Database ID for the address record | x |
restrictionAddress/line1 | string | Search address - Address 1: First line of the address | x |
restrictionAddress/line2 | string | Search address - Address 2: Second line of the address | x |
restrictionAddress/line3 | string | Search address - Address 3: Third line of the address | x |
restrictionAddress/county | string | Search address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
restrictionAddress/city | string | Search address - City: This criterion corresponds to the City field on the Company card. | x |
restrictionAddress/zip | string | Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
restrictionAddress/state | string | Search address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
restrictionAddress/wgs84latitude | decimal | Search address - Latitude: Latitude | x |
restrictionAddress/wgs84longitude | decimal | Search address - Longitude: Longitude | x |
restrictionAddress/formattedAddress | None | Search address - {formattedAddress}: {formattedAddress} | |
restrictionAddress/formattedMultiLineAddress | None | Search address - {formattedAddress}: {formattedAddress} | |
url/URLAddress | string | URL | x |
url/URLDescription | string | Description | x |
contactAssociate/firstName | string | First name: Displays the contact's first name | x |
contactAssociate/lastName | string | Last name: Displays the contact's last name | x |
contactAssociate/middleName | string | Middle Name : Displays the contact's middle name. | x |
contactAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
contactAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
contactAssociate/personId | int | Contact ID: Database ID of the contact row | |
contactAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
contactAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
contactAssociate/associateDbId | associate | ID | x |
contactAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
contactAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
contactAssociate/usergroup | userGroup | Primary group: The user's primary user group | x |
contactAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
contactAssociate/contactCategory | listAny | Category: Category | x |
contactAssociate/role | listAny | Role : Role | x |
contactAssociate/assocName | associate | User ID : User ID | x |
contactAssociate/assocTooltip | string | Description : Description | |
contactAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
contactAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
contactAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
contactAssociate/ejDisplayName | string | Nick name: User's nick name in Service | x |
contactAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
contactAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
contactAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
contactAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
contactAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
contactAssociate/portraitThumbnail | None | Person image: Person image | |
contactAssociate/otherGroups | userGroup | Other groups: Other groups | |
contactAssociate/userName | string | User name: User name | x |
contactAssociate/personEmail | string | x | |
contactAssociate/locationAddress | string | Location: Location | x |
contactAssociate/isLocation | bool | Is a location: Is a location | x |
contactInterestIds | listInterest | Company Interest: This criterion corresponds to the Interests tab on the Company card. | |
contactUdef/SuperOffice:1 | string | companyshorttext: tooltipshorttext | x |
contactUdef/SuperOffice:2 | string | companylongtext: tooltiplongtext | x |
contactUdef/SuperOffice:3 | int | companynumber | x |
contactUdef/SuperOffice:4 | date | companydate | x |
contactUdef/SuperOffice:5 | unlimitedDate | companyunlimiteddate: tooltipunlimiteddate | x |
contactUdef/SuperOffice:6 | bool | companycheckbox | x |
contactUdef/SuperOffice:7 | listAny | companydropdownlistbox | x |
contactUdef/SuperOffice:8 | decimal | companydecimal | x |
contactUdef/SuperOffice:9 | string | page1saleonly | x |
contactUdef/SuperOffice:10 | string | page1marketingonly | x |
contactUdef/SuperOffice:11 | string | page1adminonly | x |
contactUdef/SuperOffice:12 | listAny | Udlist one: Static tooltip for udlist one | x |
contactUdef/SuperOffice:13 | listAny | Udlist two: Static tooltip for udlist two | x |
contactExtra/x_contact_integer | int | Extra Integer: Custom integer field | x |
contactExtra/x_contact_default_integer | int | Extra Default Integer: Custom integer field with default value 123. | x |
contactExtra/x_contact_float | decimal | Extra Float: Custom float field with 3 decimals | x |
contactExtra/x_contact_longtext | string | Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor | x |
contactExtra/x_contact_dropdown | listAny | Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc. | x |
contactExtra/x_contact_date | date | Extra date: Custom date field. User current as default. | x |
contactExtra/x_contact_datetime | datetime | Extra DateTime: Custom Date Time field. No default value. External | x |
contactExtra/x_contact_time | None | Extra time: Custom time field. | x |
contactExtra/x_contact_boolean | bool | Extra boolean: Custom boolean field. | x |
contactExtra/x_contact_timespan | timeSpan | Extra timespan: Custom timespan field. Hours and minutes in 10 units | x |
contactExtra/x_contact_shorttext | string | Extra short text: Custom short text field. Keep HTML tags. | x |
contactExtra/x_contact_short_dropdown | listAny | Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External. | x |
contactExtra/x_contact_contact_relation | stringorPK | Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons | x |
contactExtra/x_contact_request_relation | stringorPK | Extra Request relation: Request relation on company | x |
contactExtra/x_contact_contact | stringorPK | Extra contact relation: Contact relation on company | x |
contactExtra/y_organization/x_name | string | Organization - Name | x |
NumberOfActivities | None | Number of activities | |
NumberOfActivitiesInPeriod | None | Number of activities in last 90 days | |
NumberOfNotCompletedActivities | None | Number of non-completed activities | |
NumberOfNotCompletedActivitiesInPeriod | None | Number of non-completed activities in last 90 days | |
LastActivity | None | Date of last activity | |
LastCompletedActivity | None | Date of last completed activity | |
LastDoByActivity | None | Date of last non-completed activity | |
NumberOfSales | None | Number of sales | |
NumberOfSalesInPeriod | None | Number of sales in last 90 days | |
NumberOfNotCompletedSales | None | Number of non-completed sales | |
NumberOfNotCompletedSalesInPeriod | None | Number of non-completed sales in last 90 days | |
LastSale | None | Date of last sale | |
LastCompletedSale | None | Date of last completed sale | |
LastDoBySale | None | Date of last non-completed sale | |
NumberOfTickets | None | Number of requests | |
NumberOfTicketsInPeriod | None | Number of requests in last 90 days | |
NumberOfNotCompletedTickets | None | Number of non-completed requests | |
NumberOfNotCompletedTicketsInPeriod | None | Number of non-completed requests in last 90 days | |
LastTicket | None | Date of last request | |
LastCompletedTicket | None | Date of last completed request | |
LastDoByTicket | None | Date of last non-completed request | |
SaintStatus1 | None | Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden. | |
SaintStatus2 | None | C-company: Kundens navn starter med bokstaven C | |
saintSaleStatus | None | With status | |
saintAmountClass | None | Amount class | |
saintActivityType | None | SAINT type | |
saintDirection | None | Direction | |
saintIntention | None | Intention | |
saintTicketStatus | None | Status | |
saintTicketCategory | None | Category | |
sourceRelation/contactId | None | Source - Company ID: Database ID of company | x |
sourceRelation/name | None | Source - Company name | x |
sourceRelation/department | None | Source - Department | x |
sourceRelation/nameDepartment | None | Source - Company: Displays the company an activity is linked to | x |
sourceRelation/hasInfoText | None | Source - Has note: Displays an icon indicating if there is additional information available about the contact | x |
sourceRelation/hasInterests | None | Source - Has interests: Displays an Icon indicating if the contact has active interests | x |
sourceRelation/associateId | None | Source - Our contact: Displays our contact | x |
sourceRelation/category | None | Source - Category | x |
sourceRelation/business | None | Source - Business | x |
sourceRelation/country | None | Source - Country: This criterion corresponds to the Country field on the Company card. | x |
sourceRelation/countryId | None | Source - Country ID: Country ID | x |
sourceRelation/number | None | Source - Number | x |
sourceRelation/code | None | Source - Code | x |
sourceRelation/orgnr | None | Source - VAT No. | x |
sourceRelation/stop | None | Source - Stop | x |
sourceRelation/contactNoMail | None | Source - No mailings (company) | x |
sourceRelation/updatedBy | None | Source - Updated by: The user who last updated the data | x |
sourceRelation/updatedByFullName | None | Source - Updated by - Full name: The user who last updated the data | x |
sourceRelation/updatedDate | None | Source - Updated: The date/time the data was last updated in UTC. | x |
sourceRelation/registeredBy | None | Source - Registered by: The user who registered the data | x |
sourceRelation/registeredByFullName | None | Source - Registered by - Full name: The user who registered the data | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
sourceRelation/registeredDate | None | Source - Registered date: The date/time the data was registered in UTC. | x |
sourceRelation/contactSource | None | Source - Source: Source (Company) | x |
sourceRelation/contactDeleted | None | Source - Deleted: Deleted | x |
sourceRelation/activeErpLinks | None | Source - ERP connected: Is there an active ERP Sync? | x |
sourceRelation/deletedDate | None | Source - Deleted date: Deleted date | |
sourceRelation/mainContact | None | Source - Main contact: Main contact for this company | x |
sourceRelation/restrictionContactId | None | Source - Company ID: Database ID of company to fetch relations for | |
sourceRelation/who | None | Source - Full name: Full name of company/contact | x |
sourceRelation/csRelation | None | Source - Company-to-company relation: Name of relation, not taking into account the relation direction | x |
targetRelation/contactId | None | Target - Company ID: Database ID of company | x |
targetRelation/name | None | Target - Company name | x |
targetRelation/department | None | Target - Department | x |
targetRelation/nameDepartment | None | Target - Company: Displays the company an activity is linked to | x |
targetRelation/hasInfoText | None | Target - Has note: Displays an icon indicating if there is additional information available about the contact | x |
targetRelation/hasInterests | None | Target - Has interests: Displays an Icon indicating if the contact has active interests | x |
targetRelation/associateId | None | Target - Our contact: Displays our contact | x |
targetRelation/category | None | Target - Category | x |
targetRelation/business | None | Target - Business | x |
targetRelation/country | None | Target - Country: This criterion corresponds to the Country field on the Company card. | x |
targetRelation/countryId | None | Target - Country ID: Country ID | x |
targetRelation/number | None | Target - Number | x |
targetRelation/code | None | Target - Code | x |
targetRelation/orgnr | None | Target - VAT No. | x |
targetRelation/stop | None | Target - Stop | x |
targetRelation/contactNoMail | None | Target - No mailings (company) | x |
targetRelation/updatedBy | None | Target - Updated by: The user who last updated the data | x |
targetRelation/updatedByFullName | None | Target - Updated by - Full name: The user who last updated the data | x |
targetRelation/updatedDate | None | Target - Updated: The date/time the data was last updated in UTC. | x |
targetRelation/registeredBy | None | Target - Registered by: The user who registered the data | x |
targetRelation/registeredByFullName | None | Target - Registered by - Full name: The user who registered the data | x |
targetRelation/registeredDate | None | Target - Registered date: The date/time the data was registered in UTC. | x |
targetRelation/contactSource | None | Target - Source: Source (Company) | x |
targetRelation/contactDeleted | None | Target - Deleted: Deleted | x |
targetRelation/activeErpLinks | None | Target - ERP connected: Is there an active ERP Sync? | x |
targetRelation/deletedDate | None | Target - Deleted date: Deleted date | |
targetRelation/mainContact | None | Target - Main contact: Main contact for this company | x |
targetRelation/restrictionContactId | None | Target - Company ID: Database ID of company to fetch relations for | |
targetRelation/who | None | Target - Full name: Full name of company/contact | x |
targetRelation/csRelation | None | Target - Company-to-company relation: Name of relation, not taking into account the relation direction | x |
sourceRelation/contactPersonRelation | None | Source - Company-to-contact relation: Name of relation, not taking into account the relation direction | x |
targetRelation/personContactRelation | None | Target - Contact-to-company relation: Name of relation, not taking into account the relation direction | x |
sale/completed | None | Completed: Displays a checkbox showing if an appointment is completed | x |
sale/icon | None | Category: Displays the icon for an activity type | x |
sale/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
sale/time | None | Time: Time | |
sale/type | None | Type: Displays the type of an activity | x |
sale/recordType | None | Record type : Shows the record type | x |
sale/text | None | Text: Displays a descriptive text for the item | x |
sale/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
sale/contactId | None | Company ID: Database ID of company | x |
sale/personId | None | Contact ID: Database ID of the contact row | x |
sale/projectId | None | Project ID: Database ID of project record | x |
sale/saleId | None | Sale ID: The database ID of the sale record | x |
sale/userGroup | None | User group : The user group that owns the record | x |
sale/who | None | Who: Contact and/or company | |
sale/updatedBy | None | Updated by: The user who last updated the data | x |
sale/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
sale/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
sale/registeredBy | None | Registered by: The user who registered the data | x |
sale/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
sale/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
sale/currencyId | None | Currency ID: The currency list item ID | x |
sale/currency | None | Currency: The currency of the sale | x |
sale/credited | None | Credited: The user to be credited with the sale | x |
sale/lossReason | None | Reason (lost: The reason for losing the sale | x |
sale/source | None | Source: The source (lead) of the sale | x |
sale/competitor | None | Competitor: The competitor who won the sale | x |
sale/heading | None | Sale: The name of the sale | x |
sale/amount | None | Amount: The gross sales total | x |
sale/amountWeighted | None | Weighted amount: Virtual field calculated from amount * probability percent. | x |
sale/earning | None | Profit: Gross profit (gross sales total - cost) for the sale | x |
sale/earningPercent | None | Profit as % : The profit as a percentage of the gross sales total | x |
sale/probPercent | None | Probability as %: Probability as % | x |
sale/originalStage | None | Stage: Displays the stage of the sale | x |
sale/stage | None | Stage: Displays the stage of the sale | x |
sale/saleStatus | None | Status: The status of the sale - open, lost or sold | x |
sale/stageRank | None | Stage rank: Rank of the sale stage in the stage list | x |
sale/saleType | None | Sale type: Sale type, from list | x |
sale/nextDueDate | None | Next activity: Date for next activity for a sale, updated live from the sale's activities | x |
sale/reopenDate | None | Reopen date: Displays the reopen date for the sale | x |
sale/stalledComment | None | Reason (stalled: The reason the sale has been stalled | x |
sale/saleTypeCategory | None | Sale type category: Sale type category | x |
sale/soldReason | None | Reason (sold: Reason (sold) | x |
sale/saleNumber | None | Number: Number | x |
sale/hasStakeholders | None | Has stakeholders: Does this sale have stakeholders enabled | x |
sale/hasQuote | None | Has quote?: Does the sale have a quote attached? | x |
sale/hasGuide | None | Guided: Does this sale have a Sales Guide | x |
sale/description | None | Description: The long description field on Sale | |
sale/activeErpLinks | None | ERP connected: Is there an active ERP Sync? | x |
sale/createdByWorkflow | None | Created by flow: Created by flow | x |
sale/amountInBaseCurrency | None | Amount (BaseCurrency): The gross sales total | x |
sale/amountWeightedInBaseCurrency | None | Weighted amount (BaseCurrency): Virtual field calculated from amount * probability percent. | x |
sale/visibleFor | None | Visible for | |
sale/sale/textId | None | Text ID | x |
sale/sale/description | None | Text: Displays the text entered in the description field | x |
sale/salePublish/isPublished | None | Published: Displays an icon indicating if the project or sale has been published | x |
sale/salePublish/publishedFrom | None | From date: Start date for publishing. The record will not be visible prior to this date | x |
sale/salePublish/publishedTo | None | To date: End date for publishing. The record will not be visible after this date | x |
sale/salePublish/publishedBy | None | Published by: Published by | |
sale/associate/firstName | None | First name: Displays the contact's first name | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
sale/associate/lastName | None | Last name: Displays the contact's last name | x |
sale/associate/middleName | None | Middle Name : Displays the contact's middle name. | x |
sale/associate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
sale/associate/contactId | None | Company ID: Database ID of the company the user belongs to | |
sale/associate/personId | None | Contact ID: Database ID of the contact row | |
sale/associate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
sale/associate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
sale/associate/associateDbId | None | ID | x |
sale/associate/contactName | None | Owning company: Name of the company the user belongs to | x |
sale/associate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
sale/associate/usergroup | None | Primary group: The user's primary user group | x |
sale/associate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
sale/associate/contactCategory | None | Category: Category | x |
sale/associate/role | None | Role : Role | x |
sale/associate/assocName | None | User ID : User ID | x |
sale/associate/assocTooltip | None | Description : Description | |
sale/associate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
sale/associate/ejUserId | None | Service user ID: The database ID of a Service user | |
sale/associate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
sale/associate/ejDisplayName | None | Nick name: User's nick name in Service | x |
sale/associate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
sale/associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
sale/associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
sale/associate/isActive | None | Active: Is this user active, and should be able to log in? | x |
sale/associate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
sale/associate/portraitThumbnail | None | Person image: Person image | |
sale/associate/otherGroups | None | Other groups: Other groups | |
sale/associate/userName | None | User name: User name | x |
sale/associate/personEmail | None | x | |
sale/associate/locationAddress | None | Location: Location | x |
sale/associate/isLocation | None | Is a location: Is a location | x |
sale/saleUdef/SuperOffice:1 | None | saleshorttext | x |
sale/saleUdef/SuperOffice:2 | None | salelongtext | x |
sale/saleUdef/SuperOffice:3 | None | salenumber | x |
sale/saleUdef/SuperOffice:4 | None | saledate | x |
sale/saleUdef/SuperOffice:5 | None | saleunlimiteddate | x |
sale/saleUdef/SuperOffice:6 | None | salecheckbox | x |
sale/saleUdef/SuperOffice:7 | None | saledropdownlistbox | x |
sale/saleUdef/SuperOffice:8 | None | saledecimal | x |
appointment/completed | None | Completed: Displays a checkbox showing if an appointment is completed | x |
appointment/icon | None | Category: Displays the icon for an activity type | x |
appointment/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
appointment/time | None | Time: Time | |
appointment/type | None | Type: Displays the type of an activity | x |
appointment/recordType | None | Record type : Shows the record type | x |
appointment/text | None | Text: Displays a descriptive text for the item | x |
appointment/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
appointment/contactId | None | Company ID: Database ID of company | x |
appointment/personId | None | Contact ID: Database ID of the contact row | x |
appointment/projectId | None | Project ID: Database ID of project record | x |
appointment/saleId | None | Sale ID: The database ID of the sale record | x |
appointment/userGroup | None | User group : The user group that owns the record | x |
appointment/who | None | Who: Contact and/or company | |
appointment/updatedBy | None | Updated by: The user who last updated the data | x |
appointment/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
appointment/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
appointment/registeredBy | None | Registered by: The user who registered the data | x |
appointment/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
appointment/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
appointment/appointmentId | None | DB ID: Displays the database ID of a row | x |
appointment/endDate | None | End date: Displays the deadline for a follow-up/sale | x |
appointment/priority | None | Priority: Displays the priority of the activity | x |
appointment/alarm | None | Has alarm: Displays the alarm state of a follow-up | x |
appointment/recurring | None | Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up | x |
appointment/booking | None | Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip. | x |
appointment/intention | None | Intention: Displays the intention of the follow-up type | x |
appointment/location | None | Location: Display the location where the follow-up will take place. | x |
appointment/recurrenceRuleId | None | RR-ID: Repetition rule ID of follow-up | x |
appointment/rawType | None | Type: Type field for appointment, not decoded or formatted | x |
appointment/rawStatus | None | Status: Status field for the follow-up, not decoded or formatted | x |
appointment/cautionWarning | None | Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems. | x |
appointment/visibleInDiary | None | ExcludeBook: Is the activity visible in the diary? | x |
appointment/endTime | None | End time: End time of an activity | |
appointment/suggestedAppointmentId | None | Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion | x |
appointment/completedDate | None | Completed date: Displays the actual date a follow-up/sale was marked as completed | x |
appointment/isMilestone | None | Milestone: Shows whether or not the follow-ups in this row are milestones | x |
appointment/invitedPersonId | None | ID of invited person: appointment.invitedpersonid record - utility for rd | x |
appointment/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
appointment/joinVideomeetUrl | None | Video meeting URL: URL for joining the video meeting | x |
appointment/duration | None | Duration: The duration of the chat session | |
appointment/createdByWorkflow | None | Created by flow: Created by flow | x |
appointment/visibleFor | None | Visible for | |
appointment/appointmentPublish/isPublished | None | Published: Displays an icon indicating if the project or sale has been published | x |
appointment/appointmentPublish/publishedFrom | None | From date: Start date for publishing. The record will not be visible prior to this date | x |
appointment/appointmentPublish/publishedTo | None | To date: End date for publishing. The record will not be visible after this date | x |
appointment/appointmentPublish/publishedBy | None | Published by: Published by | |
appointment/appointmentUdef/SuperOffice:1 | None | followupshorttext | x |
appointment/appointmentUdef/SuperOffice:2 | None | followuplongtext | x |
appointment/appointmentUdef/SuperOffice:3 | None | followupnumber | x |
appointment/appointmentUdef/SuperOffice:4 | None | followupdate | x |
appointment/appointmentUdef/SuperOffice:5 | None | followupunlimiteddate | x |
appointment/appointmentUdef/SuperOffice:6 | None | followupcheckbox | x |
appointment/appointmentUdef/SuperOffice:7 | None | followupdropdownlistbox | x |
appointment/appointmentUdef/SuperOffice:8 | None | followupdecimal | x |
appointment/associate/firstName | None | First name: Displays the contact's first name | x |
appointment/associate/lastName | None | Last name: Displays the contact's last name | x |
appointment/associate/middleName | None | Middle Name : Displays the contact's middle name. | x |
appointment/associate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
appointment/associate/contactId | None | Company ID: Database ID of the company the user belongs to | |
appointment/associate/personId | None | Contact ID: Database ID of the contact row |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
appointment/associate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
appointment/associate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
appointment/associate/associateDbId | None | ID | x |
appointment/associate/contactName | None | Owning company: Name of the company the user belongs to | x |
appointment/associate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
appointment/associate/usergroup | None | Primary group: The user's primary user group | x |
appointment/associate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
appointment/associate/contactCategory | None | Category: Category | x |
appointment/associate/role | None | Role : Role | x |
appointment/associate/assocName | None | User ID : User ID | x |
appointment/associate/assocTooltip | None | Description : Description | |
appointment/associate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
appointment/associate/ejUserId | None | Service user ID: The database ID of a Service user | |
appointment/associate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
appointment/associate/ejDisplayName | None | Nick name: User's nick name in Service | x |
appointment/associate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
appointment/associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
appointment/associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
appointment/associate/isActive | None | Active: Is this user active, and should be able to log in? | x |
appointment/associate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
appointment/associate/portraitThumbnail | None | Person image: Person image | |
appointment/associate/otherGroups | None | Other groups: Other groups | |
appointment/associate/userName | None | User name: User name | x |
appointment/associate/personEmail | None | x | |
appointment/associate/locationAddress | None | Location: Location | x |
appointment/associate/isLocation | None | Is a location: Is a location | x |
appointment/appointment/description | None | Text: Displays the text entered in the description field | x |
appointment/appointment/title | None | Title | x |
appointment/appointment/titleHtml | None | !!Title Html | x |
appointment/appointment/agenda | None | Agenda | x |
appointment/appointment/agendaHtml | None | !!Agenda Html | x |
appointment/appointment/isConverted | None | !!Is Converted | |
appointment/appointment/textId | None | Text ID | x |
appointment/appointment/internalNotes | None | Internal notes: Displays the text entered in the description field | x |
appointment/appointment/internalNotesHtml | None | !!Internal Notes Html | x |
document/completed | None | Completed: Displays a checkbox showing if an appointment is completed | x |
document/icon | None | Category: Displays the icon for an activity type | x |
document/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
document/time | None | Time: Time | |
document/type | None | Type: Displays the type of an activity | x |
document/recordType | None | Record type : Shows the record type | x |
document/text | None | Text: Displays a descriptive text for the item | x |
document/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
document/contactId | None | Company ID: Database ID of company | x |
document/personId | None | Contact ID: Database ID of the contact row | x |
document/projectId | None | Project ID: Database ID of project record | x |
document/saleId | None | Sale ID: The database ID of the sale record | x |
document/userGroup | None | User group : The user group that owns the record | x |
document/who | None | Who: Contact and/or company | |
document/updatedBy | None | Updated by: The user who last updated the data | x |
document/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
document/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
document/registeredBy | None | Registered by: The user who registered the data | x |
document/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
document/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
document/documentId | None | Document ID: Database ID of document record | x |
document/keywords | None | Keywords | x |
document/ourref | None | Our ref. | x |
document/yourref | None | Your ref. | x |
document/attention | None | Salutation | x |
document/subject | None | Subject | x |
document/name | None | File name | x |
document/mailMergeDraft | None | Mail merge draft : Indicates whether the document is a mail merge template | x |
document/snum | None | Document number: Serial number of document. It can be generated by the number allocation system for a dedicated document template. | x |
document/isReport | None | Report: Is this document a saved report run? | |
document/suggestedDocumentId | None | Document ID (suggestion: The database ID of a document that originates in a suggestion | x |
document/isMail | None | ||
document/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
document/visibleFor | None | Visible for | |
document/documentPublish/isPublished | None | Published: Displays an icon indicating if the project or sale has been published | x |
document/documentPublish/publishedFrom | None | From date: Start date for publishing. The record will not be visible prior to this date | x |
document/documentPublish/publishedTo | None | To date: End date for publishing. The record will not be visible after this date | x |
document/documentPublish/publishedBy | None | Published by: Published by | |
document/associate/firstName | None | First name: Displays the contact's first name | x |
document/associate/lastName | None | Last name: Displays the contact's last name | x |
document/associate/middleName | None | Middle Name : Displays the contact's middle name. | x |
document/associate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
document/associate/contactId | None | Company ID: Database ID of the company the user belongs to | |
document/associate/personId | None | Contact ID: Database ID of the contact row | |
document/associate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
document/associate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
document/associate/associateDbId | None | ID | x |
document/associate/contactName | None | Owning company: Name of the company the user belongs to | x |
document/associate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
document/associate/usergroup | None | Primary group: The user's primary user group | x |
document/associate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
document/associate/contactCategory | None | Category: Category | x |
document/associate/role | None | Role : Role | x |
document/associate/assocName | None | User ID : User ID | x |
document/associate/assocTooltip | None | Description : Description | |
document/associate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
document/associate/ejUserId | None | Service user ID: The database ID of a Service user | |
document/associate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
document/associate/ejDisplayName | None | Nick name: User's nick name in Service | x |
document/associate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
document/associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
document/associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
document/associate/isActive | None | Active: Is this user active, and should be able to log in? | x |
document/associate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
document/associate/portraitThumbnail | None | Person image: Person image |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
document/associate/otherGroups | None | Other groups: Other groups | |
document/associate/userName | None | User name: User name | x |
document/associate/personEmail | None | x | |
document/associate/locationAddress | None | Location: Location | x |
document/associate/isLocation | None | Is a location: Is a location | x |
document/documentUdef/SuperOffice:1 | None | documentshorttext | x |
document/documentUdef/SuperOffice:2 | None | documentlongtext | x |
document/documentUdef/SuperOffice:3 | None | documentnumber | x |
document/documentUdef/SuperOffice:4 | None | documentdate | x |
document/documentUdef/SuperOffice:5 | None | documentunlimiteddate | x |
document/documentUdef/SuperOffice:6 | None | documentcheckbox | x |
document/documentUdef/SuperOffice:7 | None | documentdropdownlistbox | x |
document/documentUdef/SuperOffice:8 | None | documentdecimal | x |
document/document/textId | None | Text ID | x |
document/document/description | None | Text: Displays the text entered in the description field | x |
personId | int | DB ID: Displays the database ID of a contact | x |
firstName | string | First name: Displays the contact's first name | x |
lastName | string | Last name: Displays the contact's last name | x |
middleName | string | Middle name: Displays the contact's middle name. | x |
fullName | stringorPK | Contact: Displays the contact to which an item is linked | x |
personHasInterests | bool | Has interests: Displays an Icon indicating if the contact has active interests | x |
mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
position | listAny | Position | x |
personNumber | string | Number: Displays the contact's number | x |
title | string | Title: Displays the contact's job title | x |
personCountry | listAny | Country: Country | x |
personCountryId | int | Country ID: Country ID | x |
personNoMail | bool | No Mailings: Displays the contact's No Mailings checkbox | x |
rank | int | Rank: Displays a contact's current rank | x |
birthdate | None | Birthdate: Displays the contact's date of birth | |
associateType | None | User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading. | |
useAsMailingAddress | bool | Use as postal address: Use as postal address | x |
personSource | listAny | Source: Source (Contact) | x |
retired | bool | Former employee: Indicates whether the contact has retired/left the company | x |
birthYear | int | Birth year: Displays contact's birth year | x |
birthMonth | int | Birth month: Displays contact's birth month | x |
birthDay | int | Birth day: Displays contact's birth day (day of month) | x |
kanaFirstName | string | First name, kana: Contact's first name, in kana alphabet | x |
kanaLastName | string | Last name, kana: Contact's last name, in kana alphabet | x |
personUpdatedBy | associate | Updated by: The user who last updated the data | x |
personUpdatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
personUpdatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
personRegisteredBy | associate | Registered by: The user who registered the data | x |
personRegisteredByFullName | associate | Registered by - Full name: The user who registered the data | x |
personRegisteredDate | date | Registered date: The date/time the data was registered in UTC. | x |
portraitThumbnail | None | Person image: Person image | |
personActiveErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
ticketPriority | listAny | Service priority: Default service priority for this contact | x |
supportLanguage | listAny | Preferred language: Preferred language used for reply templates and more | x |
supportAssociate | associate | Our service contact: Default service contact for this contact | x |
supportAssociateFullName | associate | Our service contact - Full name: Default service contact for this contact | x |
personAssociateId | associate | Our contact: Displays our contact | x |
personAssociateFullName | associate | Our contact - Full name: Displays our contact | x |
personCategory | listAny | Category | x |
personBusiness | listAny | Business | x |
personDeletedDate | datetime | Deleted date: Deleted date | |
hasCompany | bool | Has company: The contact is associated with a company | x |
isProjectMember | bool | Is project member: This person is a project member | x |
isStakeholder | bool | Is stakeholder: This person is a sale stakeholder | x |
updatedByWorkflow | listAny | Updated by flow: Updated by flow | x |
whenUpdatedByWorkflow | datetime | When updated by flow: When updated by flow | x |
createdByForm | listAny | Created by form: Created by form | x |
personInfo/textId | int | Text ID | x |
personInfo/infoText | positiveString | Information: Displays the text entered in the description field | x |
personUdef/SuperOffice:1 | string | contactshorttext: tooltipshorttext | x |
personUdef/SuperOffice:2 | string | contactlongtext: tooltiplongtext | x |
personUdef/SuperOffice:3 | int | contactnumber | x |
personUdef/SuperOffice:4 | date | contactdate | x |
personUdef/SuperOffice:5 | unlimitedDate | contactunlimiteddate: tooltipunlimiteddate | x |
personUdef/SuperOffice:6 | bool | contactcheckbox | x |
personUdef/SuperOffice:7 | listAny | contactdropdownlistbox | x |
personUdef/SuperOffice:8 | decimal | contactdecimal | x |
personUdef/SuperOffice:9 | string | page1saleonly | x |
personUdef/SuperOffice:10 | string | page1marketingonly | x |
personUdef/SuperOffice:11 | string | page1adminonly | x |
personExtra/x_person_integer | int | Extra Integer: Custom person integer | x |
personExtra/x_person_float | decimal | Extra float: Custom float field | x |
personExtra/x_person_longtext | string | Extra Long Text: Custom long text field on person, keep HTML tags. Simple input, not text area. Default value = 'Hello there' | x |
personExtra/x_person_date | date | Extra date: Custom date field on person. Default value = 28.03.2019 | x |
personExtra/x_person_datetime | datetime | Extra DateTime: Custom person date and time field. No default | x |
personExtra/x_person_time | None | Extra time: Custom time field on person. Current time as default | x |
personExtra/x_person_boolean | bool | Extra Boolean: Custom boolean field on person. Default checked | x |
personExtra/x_person_timespan | timeSpan | Extra timespan: Custom timespan on person. Minutes only in 15 units | x |
personExtra/x_person_shorttext | string | Extra short text: Custom short text on person. With index. Do not keep HTML tags | x |
personExtra/x_person_shorttext_list | listAny | Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent | x |
personExtra/x_person_user_relation | associate | Extra user relation: Custom person-user relation field | x |
personExtra/x_person_category_relation | listAny | Extra category relation: Custom person-category relation | x |
personExtra/x_person_priority_relation | listAny | Extra priority relation: Custom person-priority relation | x |
personExtra/x_person_request_relation | stringorPK | Extra request relation: Request relation on contact | x |
personExtra/x_person_appointment_relation | stringorPK | Extra appointment relation: Appointment relation on person | x |
personExtra/x_person_contact_relation | stringorPK | Extra company relation: Company relation on contact | x |
personExtra/y_rental/id | int | Rental - id: Displays the row's primary key (y_rental) | x |
personExtra/y_rental/x_start | date | Rental - Start rental | x |
personExtra/y_rental/x_end | date | Rental - End | x |
personExtra/y_rental/x_amount | int | Rental - Amount: Number to rent. Default = 1 | x |
personExtra/y_rental/x_contact | stringorPK | Rental - Renter: Company that rents equipment | x |
personExtra/y_rental/y_equipment/x_name | string | Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table | x |
personExtra/y_car/id | int | Car - id: Displays the row's primary key (y_car) | x |
isMailingRecipient | bool | Is mailing recipient: isMailingRecipient | x |
hasStoreConsent | bool | Consent - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
withdrawnStoreConsent | bool | Consent is withdrawn - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | |
hasEmarketingConsent | bool | Consent - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | |
withdrawnEmarketingConsent | bool | Consent is withdrawn - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | |
subscription | listAny | Subscription: Subscription for marketing | x |
legalBaseStore | listAny | Legal basis - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | x |
legalBaseEmarketing | listAny | Legal basis - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | x |
consentSourceStore | listAny | Source - Sales and service: The purpose to store data about this contact is to sell to and/or provide services to this contact. This purpose is usually used when storing contacts who are defined as potential or existing customers. | x |
consentSourceEmarketing | listAny | Source - E-marketing: The purpose is to gain the explicit consent to communicate electronically (bulk e-mail) on topics related to our products and services. This might include newsletters, invitations and product-related content. The subscription system is used to refine the individual marketing choices this contact makes. | x |
fullNameWithContact | None | Contact and company: The fully formatted contact name, and full company name | x |
personDirectPhone/formattedNumber | None | Direct - Phone: Displays phone number | |
personDirectPhone/description | None | Direct - Description: Phone number description | x |
personMobilePhone/formattedNumber | None | Mobile - Phone: Displays phone number | |
personMobilePhone/description | None | Mobile - Description: Phone number description | x |
personPrivate/formattedNumber | None | Private - Phone: Displays phone number | |
personPrivate/description | None | Private - Description: Phone number description | x |
personPager/formattedNumber | None | Other - Phone: Displays phone number | |
personPager/description | None | Other - Description: Phone number description | x |
personDirectFax/formattedNumber | None | Fax - Phone: Displays phone number | |
personDirectFax/description | None | Fax - Description: Phone number description | x |
personEmail/emailProtocol | None | Protocol: E-mail protocol, such as SMTP | x |
personEmail/emailAddress | None | x | |
personEmail/emailDescription | None | Description | x |
personEmail/emailId | None | ID | x |
personEmail/emailLastSent | None | Last sent: The date and time an e-mail was last sent to this address | x |
personEmail/emailBounceCount | None | Bounce count: Bounce count for this e-mail address | x |
personEmail/emailLastBounce | None | Last bounce: Date and time for last bounce to this e-mail address | x |
personEmail/emailHasBounced | None | Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
personUrl/URLAddress | None | URL | x |
personUrl/URLDescription | None | Description | x |
personAddress/addressId | None | Contact address - Address ID: Database ID for the address record | x |
personAddress/line1 | None | Contact address - Address 1: First line of the address | x |
personAddress/line2 | None | Contact address - Address 2: Second line of the address | x |
personAddress/line3 | None | Contact address - Address 3: Third line of the address | x |
personAddress/county | None | Contact address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country's address format. | x |
personAddress/city | None | Contact address - City: This criterion corresponds to the City field on the Company card. | x |
personAddress/zip | None | Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
personAddress/state | None | Contact address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country's address format. | x |
personAddress/wgs84latitude | None | Contact address - Latitude: Latitude | x |
personAddress/wgs84longitude | None | Contact address - Longitude: Longitude | x |
personAddress/formattedAddress | None | Contact address - {formattedAddress}: {formattedAddress} | |
personAddress/formattedMultiLineAddress | None | Contact address - {formattedAddress}: {formattedAddress} | |
personInterestIds | None | Contact interest: This criterion corresponds to a contact's interests. It is available via the Contact dialog's Interests tab. | |
personSourceRelation/personId | None | Source - DB ID: Displays the database ID of a contact | x |
personSourceRelation/firstName | None | Source - First name: Displays the contact's first name | x |
personSourceRelation/lastName | None | Source - Last name: Displays the contact's last name | x |
personSourceRelation/middleName | None | Source - Middle name: Displays the contact's middle name. | x |
personSourceRelation/fullName | None | Source - Contact: Displays the contact to which an item is linked | x |
personSourceRelation/contactId | None | Source - Company ID: Database ID of company | x |
personSourceRelation/hasInfoText | None | Source - Has note: Displays an icon indicating if there is additional information available about the contact | x |
personSourceRelation/hasInterests | None | Source - Has interests: Displays an Icon indicating if the contact has active interests | x |
personSourceRelation/personHasInterests | None | Source - Has interests: Displays an Icon indicating if the contact has active interests | x |
personSourceRelation/mrMrs | None | Source - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
personSourceRelation/position | None | Source - Position | x |
personSourceRelation/personNumber | None | Source - Number: Displays the contact's number | x |
personSourceRelation/title | None | Source - Title: Displays the contact's job title | x |
personSourceRelation/personCountry | None | Source - Country: Country | x |
personSourceRelation/personCountryId | None | Source - Country ID: Country ID | x |
personSourceRelation/personNoMail | None | Source - No Mailings: Displays the contact's No Mailings checkbox | x |
personSourceRelation/rank | None | Source - Rank: Displays a contact's current rank | x |
personSourceRelation/birthdate | None | Source - Birthdate: Displays the contact's date of birth | |
personSourceRelation/associateType | None | Source - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading. | |
personSourceRelation/useAsMailingAddress | None | Source - Use as postal address: Use as postal address | x |
personSourceRelation/personSource | None | Source - Source: Source (Contact) | x |
personSourceRelation/retired | None | Source - Former employee: Indicates whether the contact has retired/left the company | x |
personSourceRelation/birthYear | None | Source - Birth year: Displays contact's birth year | x |
personSourceRelation/birthMonth | None | Source - Birth month: Displays contact's birth month | x |
personSourceRelation/birthDay | None | Source - Birth day: Displays contact's birth day (day of month) | x |
personSourceRelation/kanaFirstName | None | Source - First name, kana: Contact's first name, in kana alphabet | x |
personSourceRelation/kanaLastName | None | Source - Last name, kana: Contact's last name, in kana alphabet | x |
personSourceRelation/personUpdatedBy | None | Source - Updated by: The user who last updated the data | x |
personSourceRelation/personUpdatedByFullName | None | Source - Updated by - Full name: The user who last updated the data | x |
personSourceRelation/personUpdatedDate | None | Source - Updated: The date/time the data was last updated in UTC. | x |
personSourceRelation/personRegisteredBy | None | Source - Registered by: The user who registered the data | x |
personSourceRelation/personRegisteredByFullName | None | Source - Registered by - Full name: The user who registered the data | x |
personSourceRelation/personRegisteredDate | None | Source - Registered date: The date/time the data was registered in UTC. | x |
personSourceRelation/portraitThumbnail | None | Source - Person image: Person image | |
personSourceRelation/personActiveErpLinks | None | Source - ERP connected: Is there an active ERP Sync? | x |
personSourceRelation/ticketPriority | None | Source - Service priority: Default service priority for this contact | x |
personSourceRelation/supportLanguage | None | Source - Preferred language: Preferred language used for reply templates and more | x |
personSourceRelation/supportAssociate | None | Source - Our service contact: Default service contact for this contact | x |
personSourceRelation/supportAssociateFullName | None | Source - Our service contact - Full name: Default service contact for this contact | x |
personSourceRelation/personAssociateId | None | Source - Our contact: Displays our contact | x |
personSourceRelation/personAssociateFullName | None | Source - Our contact - Full name: Displays our contact | x |
personSourceRelation/personCategory | None | Source - Category | x |
personSourceRelation/personBusiness | None | Source - Business | x |
personSourceRelation/personDeletedDate | None | Source - Deleted date: Deleted date | |
personSourceRelation/hasCompany | None | Source - Has company: The contact is associated with a company | x |
personSourceRelation/isProjectMember | None | Source - Is project member: This person is a project member | x |
personSourceRelation/isStakeholder | None | Source - Is stakeholder: This person is a sale stakeholder | x |
personSourceRelation/updatedByWorkflow | None | Source - Updated by flow: Updated by flow | x |
personSourceRelation/whenUpdatedByWorkflow | None | Source - When updated by flow: When updated by flow | x |
personSourceRelation/createdByForm | None | Source - Created by form: Created by form | x |
personSourceRelation/restrictionContactId | None | Source - Company ID: Database ID of company to fetch relations for | |
personSourceRelation/restrictionPersonId | None | Source - Company ID: Database ID of company to fetch relations for | |
personSourceRelation/who | None | Source - Full name: Full name of company/contact | x |
personSourceRelation/personPersonRelation | None | Source - Contact-to-contact relation: Name of relation, not taking into account the relation direction | x |
personTargetRelation/personId | None | Target - DB ID: Displays the database ID of a contact | x |
personTargetRelation/firstName | None | Target - First name: Displays the contact's first name | x |
personTargetRelation/lastName | None | Target - Last name: Displays the contact's last name | x |
personTargetRelation/middleName | None | Target - Middle name: Displays the contact's middle name. | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
personTargetRelation/fullName | None | Target - Contact: Displays the contact to which an item is linked | x |
personTargetRelation/contactId | None | Target - Company ID: Database ID of company | x |
personTargetRelation/hasInfoText | None | Target - Has note: Displays an icon indicating if there is additional information available about the contact | x |
personTargetRelation/hasInterests | None | Target - Has interests: Displays an Icon indicating if the contact has active interests | x |
personTargetRelation/personHasInterests | None | Target - Has interests: Displays an Icon indicating if the contact has active interests | x |
personTargetRelation/mrMrs | None | Target - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
personTargetRelation/position | None | Target - Position | x |
personTargetRelation/personNumber | None | Target - Number: Displays the contact's number | x |
personTargetRelation/title | None | Target - Title: Displays the contact's job title | x |
personTargetRelation/personCountry | None | Target - Country: Country | x |
personTargetRelation/personCountryId | None | Target - Country ID: Country ID | x |
personTargetRelation/personNoMail | None | Target - No Mailings: Displays the contact's No Mailings checkbox | x |
personTargetRelation/rank | None | Target - Rank: Displays a contact's current rank | x |
personTargetRelation/birthdate | None | Target - Birthdate: Displays the contact's date of birth | |
personTargetRelation/associateType | None | Target - User type: Displays an icon indicating if a contact is an associate or external contact with log-in rights and currently online. This information is updated only once while the archive is loading. | |
personTargetRelation/useAsMailingAddress | None | Target - Use as postal address: Use as postal address | x |
personTargetRelation/personSource | None | Target - Source: Source (Contact) | x |
personTargetRelation/retired | None | Target - Former employee: Indicates whether the contact has retired/left the company | x |
personTargetRelation/birthYear | None | Target - Birth year: Displays contact's birth year | x |
personTargetRelation/birthMonth | None | Target - Birth month: Displays contact's birth month | x |
personTargetRelation/birthDay | None | Target - Birth day: Displays contact's birth day (day of month) | x |
personTargetRelation/kanaFirstName | None | Target - First name, kana: Contact's first name, in kana alphabet | x |
personTargetRelation/kanaLastName | None | Target - Last name, kana: Contact's last name, in kana alphabet | x |
personTargetRelation/personUpdatedBy | None | Target - Updated by: The user who last updated the data | x |
personTargetRelation/personUpdatedByFullName | None | Target - Updated by - Full name: The user who last updated the data | x |
personTargetRelation/personUpdatedDate | None | Target - Updated: The date/time the data was last updated in UTC. | x |
personTargetRelation/personRegisteredBy | None | Target - Registered by: The user who registered the data | x |
personTargetRelation/personRegisteredByFullName | None | Target - Registered by - Full name: The user who registered the data | x |
personTargetRelation/personRegisteredDate | None | Target - Registered date: The date/time the data was registered in UTC. | x |
personTargetRelation/portraitThumbnail | None | Target - Person image: Person image | |
personTargetRelation/personActiveErpLinks | None | Target - ERP connected: Is there an active ERP Sync? | x |
personTargetRelation/ticketPriority | None | Target - Service priority: Default service priority for this contact | x |
personTargetRelation/supportLanguage | None | Target - Preferred language: Preferred language used for reply templates and more | x |
personTargetRelation/supportAssociate | None | Target - Our service contact: Default service contact for this contact | x |
personTargetRelation/supportAssociateFullName | None | Target - Our service contact - Full name: Default service contact for this contact | x |
personTargetRelation/personAssociateId | None | Target - Our contact: Displays our contact | x |
personTargetRelation/personAssociateFullName | None | Target - Our contact - Full name: Displays our contact | x |
personTargetRelation/personCategory | None | Target - Category | x |
personTargetRelation/personBusiness | None | Target - Business | x |
personTargetRelation/personDeletedDate | None | Target - Deleted date: Deleted date | |
personTargetRelation/hasCompany | None | Target - Has company: The contact is associated with a company | x |
personTargetRelation/isProjectMember | None | Target - Is project member: This person is a project member | x |
personTargetRelation/isStakeholder | None | Target - Is stakeholder: This person is a sale stakeholder | x |
personTargetRelation/updatedByWorkflow | None | Target - Updated by flow: Updated by flow | x |
personTargetRelation/whenUpdatedByWorkflow | None | Target - When updated by flow: When updated by flow | x |
personTargetRelation/createdByForm | None | Target - Created by form: Created by form | x |
personTargetRelation/restrictionContactId | None | Target - Company ID: Database ID of company to fetch relations for | |
personTargetRelation/restrictionPersonId | None | Target - Company ID: Database ID of company to fetch relations for | |
personTargetRelation/who | None | Target - Full name: Full name of company/contact | x |
personTargetRelation/personPersonRelation | None | Target - Contact-to-contact relation: Name of relation, not taking into account the relation direction | x |
personSourceRelation/personContactRelation | None | Source - Contact-to-company relation: Name of relation, not taking into account the relation direction | x |
personTargetRelation/contactPersonRelation | None | Target - Company-to-contact relation: Name of relation, not taking into account the relation direction | x |
personAssociate/firstName | None | First name: Displays the contact's first name | x |
personAssociate/lastName | None | Last name: Displays the contact's last name | x |
personAssociate/middleName | None | Middle Name : Displays the contact's middle name. | x |
personAssociate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
personAssociate/contactId | None | Company ID: Database ID of the company the user belongs to | |
personAssociate/personId | None | Contact ID: Database ID of the contact row | |
personAssociate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
personAssociate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
personAssociate/associateDbId | None | ID | x |
personAssociate/contactName | None | Owning company: Name of the company the user belongs to | x |
personAssociate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
personAssociate/usergroup | None | Primary group: The user's primary user group | x |
personAssociate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
personAssociate/contactCategory | None | Category: Category | x |
personAssociate/role | None | Role : Role | x |
personAssociate/assocName | None | User ID : User ID | x |
personAssociate/assocTooltip | None | Description : Description | |
personAssociate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
personAssociate/ejUserId | None | Service user ID: The database ID of a Service user | |
personAssociate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
personAssociate/ejDisplayName | None | Nick name: User's nick name in Service | x |
personAssociate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
personAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
personAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
personAssociate/isActive | None | Active: Is this user active, and should be able to log in? | x |
personAssociate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
personAssociate/portraitThumbnail | None | Person image: Person image | |
personAssociate/otherGroups | None | Other groups: Other groups | |
personAssociate/userName | None | User name: User name | x |
personAssociate/personEmail | None | x | |
personAssociate/locationAddress | None | Location: Location | x |
personAssociate/isLocation | None | Is a location: Is a location | x |
correspondingAssociate/firstName | None | First name: Displays the contact's first name | x |
correspondingAssociate/lastName | None | Last name: Displays the contact's last name | x |
correspondingAssociate/middleName | None | Middle Name : Displays the contact's middle name. | x |
correspondingAssociate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
correspondingAssociate/contactId | None | Company ID: Database ID of the company the user belongs to | |
correspondingAssociate/personId | None | Contact ID: Database ID of the contact row | |
correspondingAssociate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
correspondingAssociate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
correspondingAssociate/associateDbId | None | ID | x |
correspondingAssociate/contactName | None | Owning company: Name of the company the user belongs to | x |
correspondingAssociate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
correspondingAssociate/usergroup | None | Primary group: The user's primary user group | x |
correspondingAssociate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
correspondingAssociate/contactCategory | None | Category: Category | x |
correspondingAssociate/role | None | Role : Role | x |
correspondingAssociate/assocName | None | User ID : User ID | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
correspondingAssociate/assocTooltip | None | Description : Description | |
correspondingAssociate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
correspondingAssociate/ejUserId | None | Service user ID: The database ID of a Service user | |
correspondingAssociate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
correspondingAssociate/ejDisplayName | None | Nick name: User's nick name in Service | x |
correspondingAssociate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
correspondingAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
correspondingAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
correspondingAssociate/isActive | None | Active: Is this user active, and should be able to log in? | x |
correspondingAssociate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
correspondingAssociate/portraitThumbnail | None | Person image: Person image | |
correspondingAssociate/otherGroups | None | Other groups: Other groups | |
correspondingAssociate/userName | None | User name: User name | x |
correspondingAssociate/personEmail | None | x | |
correspondingAssociate/locationAddress | None | Location: Location | x |
correspondingAssociate/isLocation | None | Is a location: Is a location | x |
request/contactId | None | Company ID: Database ID of company | x |
request/personId | None | Contact ID: Database ID of the contact row | x |
request/saleId | None | Sale ID: The database ID of the sale record | x |
request/projectId | None | Project ID: Database ID of project record | x |
request/ticketTypeName | None | Request type: Request type | x |
request/ticketStatusName | None | Status: Request status | x |
request/categoryFullName | None | Category: Request category | x |
request/priorityName | None | Priority: Service priority | x |
request/ticketId | None | ID: Displays request ID | x |
request/title | None | Title: Displays the request title | x |
request/createdAt | None | Created: Displays when the request was created | x |
request/lastChanged | None | Last changed: Displays when the request was last changed | x |
request/author | None | Author: Displays the author of the request | x |
request/readByOwner | None | Read by owner: Displays when the request was read by the owner | x |
request/firstReadByOwner | None | First read by owner: Displays when the request was read by owner for the first time | x |
request/firstReadByUser | None | First read by user: Displays when the request was read by user for the first time | x |
request/readByCustomer | None | Read by contact: Displays when the request was read by the contact | x |
request/status | None | Internal status: Shows only system defined statuses for a request | x |
request/origin | None | Origin: Origin | x |
request/slevel | None | Access level: Access level | x |
request/numberOfMessages | None | Number of messages: Number of messages | x |
request/numberOfReplies | None | Number of replies: Number of replies | x |
request/connectId | None | Merged with request: Merged with request | x |
request/readStatus | None | Read: Read | x |
request/realTimeSpentQueue | None | Real time in queue: Real time in queue | x |
request/realTimeSpentExternally | None | Real time externally: Real time externally | x |
request/realTimeSpentInternally | None | Real time internally: Real time internally | x |
request/timeSpentQueue | None | Time spent in queue: Time spent in queue | x |
request/timeSpentExternally | None | Time spent externally: Time spent externally | x |
request/timeSpentInternally | None | Time spent internally: Time spent internally | x |
request/timeSpent | None | Time spent: Time spent | x |
request/timeToReply | None | Time to reply: Time to reply | x |
request/timeToClose | None | Time to close: Time to close | x |
request/realTimeToReply | None | Real time to reply: Real time to reply | x |
request/realTimeToClose | None | Real time to close: Real time to close | x |
request/repliedAt | None | Replied at: Replied at | x |
request/closedAt | None | Closed at: Closed at | x |
request/activated | None | Postponed to: Postponed to | x |
request/deadline | None | Deadline: Deadline | x |
request/has_attachment | None | Has attachment: Indicates whether the e-mail has one or more attachments | x |
request/tags | None | Tags: Tags connected to a request | x |
request/ownedBy | None | Owner: The owner of the request | x |
request/createdBy | None | Created by: Created by | x |
request/content | None | Content: Search for content in messages related to requests | x |
request/messageLanguage | None | Language: Recognized language in messages | |
request/sentimentScore | None | Sentiment: Sentiment score, -100 to +100 | |
request/suggestedCategory | None | Suggested category: Suggested service category | |
request/createdByWorkflow | None | Created by flow: Created by flow | x |
request/createdBy/firstName | None | Created by - First name: Displays the contact's first name | x |
request/createdBy/lastName | None | Created by - Last name: Displays the contact's last name | x |
request/createdBy/middleName | None | Created by - Middle Name: Displays the contact's middle name. | x |
request/createdBy/fullName | None | Created by - Full name: Displays full name of user (first, middle, last - according to settings) | x |
request/createdBy/contactId | None | Created by - Company ID: Database ID of the company the user belongs to | |
request/createdBy/personId | None | Created by - Contact ID: Database ID of the contact row | |
request/createdBy/mrMrs | None | Created by - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
request/createdBy/title | None | Created by - Title: Displays whether the contact is addressed as Mr or Ms | x |
request/createdBy/associateDbId | None | Created by - ID | x |
request/createdBy/contactName | None | Created by - Owning company: Name of the company the user belongs to | x |
request/createdBy/contactDepartment | None | Created by - Owning department: Name of the department at the company the user belongs to | x |
request/createdBy/usergroup | None | Created by - Primary group: The user's primary user group | x |
request/createdBy/contactFullName | None | Created by - Owner: Name and department of the company the user belongs to | x |
request/createdBy/contactCategory | None | Created by - Category: Category | x |
request/createdBy/role | None | Created by - Role: Role | x |
request/createdBy/assocName | None | Created by - User ID: User ID | x |
request/createdBy/assocTooltip | None | Created by - Description: Description | |
request/createdBy/assocType | None | Created by - Type: Type of user: associate, external user, system user, anonymous account | x |
request/createdBy/ejUserId | None | Created by - Service user ID: The database ID of a Service user | |
request/createdBy/simultaneousEjUser | None | Created by - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
request/createdBy/ejDisplayName | None | Created by - Nick name: User's nick name in Service | x |
request/createdBy/ejStatus | None | Created by - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
request/createdBy/credentialType | None | Created by - Auth. type: What type of credentials to use when this user logs in | x |
request/createdBy/credentialDisplayValue | None | Created by - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
request/createdBy/isActive | None | Created by - Active: Is this user active, and should be able to log in? | x |
request/createdBy/isActiveText | None | Created by - Active status: Is this user active, and should be able to log in? | x |
request/createdBy/portraitThumbnail | None | Created by - Person image: Person image | |
request/createdBy/otherGroups | None | Created by - Other groups: Other groups | |
request/createdBy/userName | None | Created by - User name: User name | x |
request/createdBy/personEmail | None | Created by - E-mail | x |
request/createdBy/locationAddress | None | Created by - Location: Location | x |
request/createdBy/isLocation | None | Created by - Is a location: Is a location | x |
request/ownedBy/firstName | None | Owner - First name: Displays the contact's first name | x |
request/ownedBy/lastName | None | Owner - Last name: Displays the contact's last name | x |
request/ownedBy/middleName | None | Owner - Middle Name: Displays the contact's middle name. | x |
request/ownedBy/fullName | None | Owner - Full name: Displays full name of user (first, middle, last - according to settings) | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
request/ownedBy/contactId | None | Owner - Company ID: Database ID of the company the user belongs to | |
request/ownedBy/personId | None | Owner - Contact ID: Database ID of the contact row | |
request/ownedBy/mrMrs | None | Owner - Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
request/ownedBy/title | None | Owner - Title: Displays whether the contact is addressed as Mr or Ms | x |
request/ownedBy/associateDbId | None | Owner - ID | x |
request/ownedBy/contactName | None | Owner - Owning company: Name of the company the user belongs to | x |
request/ownedBy/contactDepartment | None | Owner - Owning department: Name of the department at the company the user belongs to | x |
request/ownedBy/usergroup | None | Owner - Primary group: The user's primary user group | x |
request/ownedBy/contactFullName | None | Owner - Owner: Name and department of the company the user belongs to | x |
request/ownedBy/contactCategory | None | Owner - Category: Category | x |
request/ownedBy/role | None | Owner - Role: Role | x |
request/ownedBy/assocName | None | Owner - User ID: User ID | x |
request/ownedBy/assocTooltip | None | Owner - Description: Description | |
request/ownedBy/assocType | None | Owner - Type: Type of user: associate, external user, system user, anonymous account | x |
request/ownedBy/ejUserId | None | Owner - Service user ID: The database ID of a Service user | |
request/ownedBy/simultaneousEjUser | None | Owner - Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
request/ownedBy/ejDisplayName | None | Owner - Nick name: User's nick name in Service | x |
request/ownedBy/ejStatus | None | Owner - Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
request/ownedBy/credentialType | None | Owner - Auth. type: What type of credentials to use when this user logs in | x |
request/ownedBy/credentialDisplayValue | None | Owner - Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
request/ownedBy/isActive | None | Owner - Active: Is this user active, and should be able to log in? | x |
request/ownedBy/isActiveText | None | Owner - Active status: Is this user active, and should be able to log in? | x |
request/ownedBy/portraitThumbnail | None | Owner - Person image: Person image | |
request/ownedBy/otherGroups | None | Owner - Other groups: Other groups | |
request/ownedBy/userName | None | Owner - User name: User name | x |
request/ownedBy/personEmail | None | Owner - E-mail | x |
request/ownedBy/locationAddress | None | Owner - Location: Location | x |
request/ownedBy/isLocation | None | Owner - Is a location: Is a location | x |
request/extra/x_ticket_integer | None | Extra integer: Custom ticket integer. Default 123. External. Show in properties | x |
request/extra/x_ticket_float | None | Extra float: Custom float on Request. 2 decimal places | x |
request/extra/x_ticket_longtext | None | Extra long text: Custom long text on Request. Keep HTML tags. 9 line text area. Show in props | x |
request/extra/x_ticket_date | None | Extra date: Custom date field on Request. No default value | x |
request/extra/x_ticket_datetime | None | Extra DateTime: Custom date+time on ticket. Default = 28.03.2019 2:24 pm. External. Show in properties. Display for new request | x |
request/extra/x_ticket_time | None | Extra time: Custom time field on Request. Default = 13min Display for new. | x |
request/extra/x_ticket_boolean | None | Extra boolean: Custom boolean on Ticket. | x |
request/extra/x_ticket_timespan | None | Extra timespan: Custom timespan field on Request. Default = 1 hr 25 minutes. Show in props | x |
request/extra/x_ticket_short_text | None | Extra short text: Custom short text field on Request. Do not keep HTML tags. Display on new request | x |
request/extra/x_ticket_shorttext_list | None | Extra Dropdown: Custom short text with list for Request Pink, Orange, Yellow, Polkadot | x |
request/extra/x_ticket_project_relation | None | Extra project: Custom project relation on Request | x |
request/extra/x_ticket_faq | None | Extra FAQ Relation | x |
request/extra/x_ticket_category_relation | None | Extra category relation: Category relation on request | x |
request/extra/y_equipment/x_name | None | Equipment - Name: Equpment name custom field. Cannot be null., show in table | x |
request/extra/y_car/id | None | Car - id: Displays the row's primary key (y_car) | x |
projectMembers/completed | None | Completed: Displays a check mark indicating if the project has been completed. | x |
projectMembers/projectId | None | DB ID: Displays the database ID for a project row | x |
projectMembers/name | None | Project name: Displays the Project's name | x |
projectMembers/number | None | Number: Displays the project's number | x |
projectMembers/type | None | Project type: Displays the project's type | x |
projectMembers/status | None | Status: Displays the project's status | x |
projectMembers/statusRank | None | Status rank: Rank of the project status in the status list | x |
projectMembers/associateId | None | ID: Displays login ID of the associate who owns the project | x |
projectMembers/hasInfoText | None | Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip. | x |
projectMembers/icon | None | Category: Displays the icon for an activity type | x |
projectMembers/text | None | Text: Displays a descriptive text for the item | x |
projectMembers/description | None | Description : Description | x |
projectMembers/updatedBy | None | Updated by: The user who last updated the data | x |
projectMembers/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
projectMembers/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
projectMembers/registeredBy | None | Registered by: The user who registered the data | x |
projectMembers/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
projectMembers/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
projectMembers/hasGuide | None | Guided: Does this sale have a Sales Guide | x |
projectMembers/nextMilestone | None | Next milestone: Date of next non-completed activity that is marked as a milestone | x |
projectMembers/endDate | None | End date: End date of project | x |
projectMembers/imageThumbnail | None | Thumbnail: Scaled-down image of project image | |
projectMembers/activeErpLinks | None | ERP connected: Is there an active ERP Sync? | x |
projectMembers/function | None | Function: Displays the project member's function in the project | x |
projectMembers/projectPublish/isPublished | None | Published: Displays an icon indicating if the project or sale has been published | x |
projectMembers/projectPublish/publishedFrom | None | From date: Start date for publishing. The record will not be visible prior to this date | x |
projectMembers/projectPublish/publishedTo | None | To date: End date for publishing. The record will not be visible after this date | x |
projectMembers/projectPublish/publishedBy | None | Published by: Published by | |
projectMembers/projectEvent/isExternalEvent | None | Event: Is this an external event | x |
projectMembers/projectEvent/eventDate | None | Event date: Event date | x |
projectMembers/projectEvent/hasSignOn | None | Sign On: Does this event have the Sign On function enabled | x |
projectMembers/projectEvent/hasSignOff | None | Sign Off: Does this event have the Sign Off function enabled | x |
projectMembers/projectUrl/URLAddress | None | URL | x |
projectMembers/projectUrl/URLDescription | None | Description | x |
projectMembers/projectAssociate/firstName | None | First name: Displays the contact's first name | x |
projectMembers/projectAssociate/lastName | None | Last name: Displays the contact's last name | x |
projectMembers/projectAssociate/middleName | None | Middle Name : Displays the contact's middle name. | x |
projectMembers/projectAssociate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
projectMembers/projectAssociate/contactId | None | Company ID: Database ID of the company the user belongs to | |
projectMembers/projectAssociate/personId | None | Contact ID: Database ID of the contact row | |
projectMembers/projectAssociate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
projectMembers/projectAssociate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
projectMembers/projectAssociate/associateDbId | None | ID | x |
projectMembers/projectAssociate/contactName | None | Owning company: Name of the company the user belongs to | x |
projectMembers/projectAssociate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
projectMembers/projectAssociate/usergroup | None | Primary group: The user's primary user group | x |
projectMembers/projectAssociate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
projectMembers/projectAssociate/contactCategory | None | Category: Category | x |
projectMembers/projectAssociate/role | None | Role : Role | x |
projectMembers/projectAssociate/assocName | None | User ID : User ID | x |
projectMembers/projectAssociate/assocTooltip | None | Description : Description | |
projectMembers/projectAssociate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
projectMembers/projectAssociate/ejUserId | None | Service user ID: The database ID of a Service user | |
projectMembers/projectAssociate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
projectMembers/projectAssociate/ejDisplayName | None | Nick name: User's nick name in Service | x |
projectMembers/projectAssociate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
projectMembers/projectAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
projectMembers/projectAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
projectMembers/projectAssociate/isActive | None | Active: Is this user active, and should be able to log in? | x |
projectMembers/projectAssociate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
projectMembers/projectAssociate/portraitThumbnail | None | Person image: Person image | |
projectMembers/projectAssociate/otherGroups | None | Other groups: Other groups | |
projectMembers/projectAssociate/userName | None | User name: User name | x |
projectMembers/projectAssociate/personEmail | None | x | |
projectMembers/projectAssociate/locationAddress | None | Location: Location | x |
projectMembers/projectAssociate/isLocation | None | Is a location: Is a location | x |
projectMembers/projectUdef/SuperOffice:1 | None | projectshorttext | x |
projectMembers/projectUdef/SuperOffice:2 | None | projectlongtext | x |
projectMembers/projectUdef/SuperOffice:3 | None | projectnumber | x |
projectMembers/projectUdef/SuperOffice:4 | None | projectdate | x |
projectMembers/projectUdef/SuperOffice:5 | None | projectunlimiteddate | x |
projectMembers/projectUdef/SuperOffice:6 | None | projectcheckbox | x |
projectMembers/projectUdef/SuperOffice:7 | None | projectdropdownlistbox | x |
projectMembers/projectUdef/SuperOffice:8 | None | projectdecimal | x |
projectMembers/projectUdef/SuperOffice:9 | None | page1saleandmarketing | x |
projectMembers/projectUdef/SuperOffice:10 | None | page1saleandadmin | x |
projectMembers/NumberOfActivities | None | Number of activities | |
projectMembers/NumberOfActivitiesInPeriod | None | Number of activities in last 90 days | |
projectMembers/NumberOfNotCompletedActivities | None | Number of non-completed activities | |
projectMembers/NumberOfNotCompletedActivitiesInPeriod | None | Number of non-completed activities in last 90 days | |
projectMembers/LastActivity | None | Date of last activity | |
projectMembers/LastCompletedActivity | None | Date of last completed activity | |
projectMembers/LastDoByActivity | None | Date of last non-completed activity | |
projectMembers/NumberOfSales | None | Number of sales | |
projectMembers/NumberOfSalesInPeriod | None | Number of sales in last 90 days | |
projectMembers/NumberOfNotCompletedSales | None | Number of non-completed sales | |
projectMembers/NumberOfNotCompletedSalesInPeriod | None | Number of non-completed sales in last 90 days | |
projectMembers/LastSale | None | Date of last sale | |
projectMembers/LastCompletedSale | None | Date of last completed sale | |
projectMembers/LastDoBySale | None | Date of last non-completed sale | |
projectMembers/SaintStatus3 | None | Not completed activites with intention sale: Number of not completed activities for intention sale > 0. | |
projectMembers/saintSaleStatus | None | With status | |
projectMembers/saintAmountClass | None | Amount class | |
projectMembers/saintActivityType | None | SAINT type | |
projectMembers/saintDirection | None | Direction | |
projectMembers/saintIntention | None | Intention | |
projectMembers/saintTicketStatus | None | Status | |
projectMembers/saintTicketCategory | None | Category | |
projectMembers/project/textId | None | Text ID | x |
projectMembers/project/infoText | None | Information: Displays the text entered in the description field | x |
personAppointment/completed | None | Completed: Displays a checkbox showing if an appointment is completed | x |
personAppointment/icon | None | Category: Displays the icon for an activity type | x |
personAppointment/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
personAppointment/time | None | Time: Time | |
personAppointment/type | None | Type: Displays the type of an activity | x |
personAppointment/recordType | None | Record type : Shows the record type | x |
personAppointment/text | None | Text: Displays a descriptive text for the item | x |
personAppointment/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
personAppointment/contactId | None | Company ID: Database ID of company | x |
personAppointment/personId | None | Contact ID: Database ID of the contact row | x |
personAppointment/projectId | None | Project ID: Database ID of project record | x |
personAppointment/saleId | None | Sale ID: The database ID of the sale record | x |
personAppointment/userGroup | None | User group : The user group that owns the record | x |
personAppointment/who | None | Who: Contact and/or company | |
personAppointment/updatedBy | None | Updated by: The user who last updated the data | x |
personAppointment/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
personAppointment/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
personAppointment/registeredBy | None | Registered by: The user who registered the data | x |
personAppointment/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
personAppointment/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
personAppointment/appointmentId | None | DB ID: Displays the database ID of a row | x |
personAppointment/endDate | None | End date: Displays the deadline for a follow-up/sale | x |
personAppointment/priority | None | Priority: Displays the priority of the activity | x |
personAppointment/alarm | None | Has alarm: Displays the alarm state of a follow-up | x |
personAppointment/recurring | None | Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up | x |
personAppointment/booking | None | Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip. | x |
personAppointment/intention | None | Intention: Displays the intention of the follow-up type | x |
personAppointment/location | None | Location: Display the location where the follow-up will take place. | x |
personAppointment/recurrenceRuleId | None | RR-ID: Repetition rule ID of follow-up | x |
personAppointment/rawType | None | Type: Type field for appointment, not decoded or formatted | x |
personAppointment/rawStatus | None | Status: Status field for the follow-up, not decoded or formatted | x |
personAppointment/cautionWarning | None | Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems. | x |
personAppointment/visibleInDiary | None | ExcludeBook: Is the activity visible in the diary? | x |
personAppointment/endTime | None | End time: End time of an activity | |
personAppointment/suggestedAppointmentId | None | Follow-up ID (suggestion: The database ID of a follow-up that originates in a suggestion | x |
personAppointment/completedDate | None | Completed date: Displays the actual date a follow-up/sale was marked as completed | x |
personAppointment/isMilestone | None | Milestone: Shows whether or not the follow-ups in this row are milestones | x |
personAppointment/invitedPersonId | None | ID of invited person: appointment.invitedpersonid record - utility for rd | x |
personAppointment/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
personAppointment/joinVideomeetUrl | None | Video meeting URL: URL for joining the video meeting | x |
personAppointment/duration | None | Duration: The duration of the chat session | |
personAppointment/createdByWorkflow | None | Created by flow: Created by flow | x |
personAppointment/visibleFor | None | Visible for | |
personAppointment/appointmentPublish/isPublished | None | Published: Displays an icon indicating if the project or sale has been published | x |
personAppointment/appointmentPublish/publishedFrom | None | From date: Start date for publishing. The record will not be visible prior to this date | x |
personAppointment/appointmentPublish/publishedTo | None | To date: End date for publishing. The record will not be visible after this date | x |
personAppointment/appointmentPublish/publishedBy | None | Published by: Published by | |
personAppointment/appointmentUdef/SuperOffice:1 | None | followupshorttext | x |
personAppointment/appointmentUdef/SuperOffice:2 | None | followuplongtext | x |
personAppointment/appointmentUdef/SuperOffice:3 | None | followupnumber | x |
personAppointment/appointmentUdef/SuperOffice:4 | None | followupdate | x |
personAppointment/appointmentUdef/SuperOffice:5 | None | followupunlimiteddate | x |
personAppointment/appointmentUdef/SuperOffice:6 | None | followupcheckbox | x |
personAppointment/appointmentUdef/SuperOffice:7 | None | followupdropdownlistbox | x |
personAppointment/appointmentUdef/SuperOffice:8 | None | followupdecimal | x |
personAppointment/associate/firstName | None | First name: Displays the contact's first name | x |
personAppointment/associate/lastName | None | Last name: Displays the contact's last name | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
personAppointment/associate/middleName | None | Middle Name : Displays the contact's middle name. | x |
personAppointment/associate/fullName | None | Full name: Displays full name of user (first, middle, last - according to settings) | x |
personAppointment/associate/contactId | None | Company ID: Database ID of the company the user belongs to | |
personAppointment/associate/personId | None | Contact ID: Database ID of the contact row | |
personAppointment/associate/mrMrs | None | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
personAppointment/associate/title | None | Title: Displays whether the contact is addressed as Mr or Ms | x |
personAppointment/associate/associateDbId | None | ID | x |
personAppointment/associate/contactName | None | Owning company: Name of the company the user belongs to | x |
personAppointment/associate/contactDepartment | None | Owning department: Name of the department at the company the user belongs to | x |
personAppointment/associate/usergroup | None | Primary group: The user's primary user group | x |
personAppointment/associate/contactFullName | None | Owner: Name and department of the company the user belongs to | x |
personAppointment/associate/contactCategory | None | Category: Category | x |
personAppointment/associate/role | None | Role : Role | x |
personAppointment/associate/assocName | None | User ID : User ID | x |
personAppointment/associate/assocTooltip | None | Description : Description | |
personAppointment/associate/assocType | None | Type: Type of user: associate, external user, system user, anonymous account | x |
personAppointment/associate/ejUserId | None | Service user ID: The database ID of a Service user | |
personAppointment/associate/simultaneousEjUser | None | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
personAppointment/associate/ejDisplayName | None | Nick name: User's nick name in Service | x |
personAppointment/associate/ejStatus | None | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
personAppointment/associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
personAppointment/associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
personAppointment/associate/isActive | None | Active: Is this user active, and should be able to log in? | x |
personAppointment/associate/isActiveText | None | Active status: Is this user active, and should be able to log in? | x |
personAppointment/associate/portraitThumbnail | None | Person image: Person image | |
personAppointment/associate/otherGroups | None | Other groups: Other groups | |
personAppointment/associate/userName | None | User name: User name | x |
personAppointment/associate/personEmail | None | x | |
personAppointment/associate/locationAddress | None | Location: Location | x |
personAppointment/associate/isLocation | None | Is a location: Is a location | x |
personAppointment/appointment/description | None | Text: Displays the text entered in the description field | x |
personAppointment/appointment/title | None | Title | x |
personAppointment/appointment/titleHtml | None | !!Title Html | x |
personAppointment/appointment/agenda | None | Agenda | x |
personAppointment/appointment/agendaHtml | None | !!Agenda Html | x |
personAppointment/appointment/isConverted | None | !!Is Converted | |
personAppointment/appointment/textId | None | Text ID | x |
personAppointment/appointment/internalNotes | None | Internal notes: Displays the text entered in the description field | x |
personAppointment/appointment/internalNotesHtml | None | !!Internal Notes Html | x |
includePersonRestriction | None | Include main contact: Specifies which contacts should be included in the result ('none', 'main', 'all') | |
includePersonWithNoDMRestriction | None | Include contacts with No Mailings: Should contacts with the 'No Mailings' flag set be included | |
linkClicked/linkId | None | Link ID: Link ID | |
linkClicked/shipmentId | None | ID: Displays the ID of the mailing | |
formSubmission/formSubmissionId | None | Form submission ID: ID of the form submission record | x |
formSubmission/formSubmissionFormId | None | Id: Id of the form | x |
formSubmission/formSubmissionName | None | Form name: Displays a descriptive text for the item | x |
formSubmission/formSubmissionStatus | None | Status: Status of the form submission record | x |
formSubmission/formSubmissionEmail | None | E-mail: The e-mail address of the person who submitted the form | x |
formSubmission/icon | None | Category: Displays the icon for an activity type | x |
formSubmission/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
formSubmission/time | None | Time: Time | |
formSubmission/type | None | Type: Displays the type of an activity | x |
formSubmission/text | None | Text: Displays a descriptive text for the item | x |
formSubmission/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
formSubmission/contactId | None | Company ID: Database ID of company | x |
formSubmission/personId | None | Contact ID: Database ID of the contact row | x |
formSubmission/updatedBy | None | Updated by: The user who last updated the data | x |
formSubmission/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
formSubmission/registeredBy | None | Registered by: The user who registered the data | x |
formSubmission/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
formSubmission/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
workflowInstance/workflowInstanceId | None | Instance id: Id of the running flow instance | x |
workflowInstance/workflowInstanceStatus | None | Participant status: Status of the running flow instance | x |
workflowInstance/workflowInstanceWaitUntil | None | Wait until: Wait until | x |
workflowInstance/workflowInstanceStepStarted | None | Step started: Step started at this time | x |
workflowInstance/workflowInstanceCurrentStepDescription | None | Current step: Current step description | |
workflowInstance/workflowInstanceCurrentStepId | None | !!workflowInstanceCurrentStepId: !!workflowInstanceCurrentStepId_TOOLTIP | |
workflowInstance/workflowInstanceLastCommunicationStepDescription | None | Last communication: Last communication step description | |
workflowInstance/workflowInstanceDropoutReason | None | Dropout reason: Dropout reason | |
workflowInstance/workflowInstanceLastCommunicationBounceInfo | None | Bounce info: Bounce information for the last communication step | |
workflowInstance/workflowInstanceLastCommunicationTime | None | Sending time: When the message was sent | x |
workflowInstance/workflowInstanceLastCommunicationStatus | None | Last email status: Status of mailing recipient | x |
workflowInstance/updatedBy | None | Updated by: The user who last updated the data | x |
workflowInstance/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
workflowInstance/registeredBy | None | Registered by: The user who registered the data | x |
workflowInstance/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
workflowInstance/emailFlow/emailFlowId | None | Email flow Id: The database Id of the email flow | x |
workflowInstance/emailFlow/emailFlowHierarchyId | None | Hierarchy ID: Foreign key to hierarchy table | x |
workflowInstance/emailFlow/shipmentType | None | Mailing type: Mailing type this e-mail flow represents | x |
workflowInstance/emailFlow/overrideConsentSubscription | None | Override consent: Should consent subscriptions be overridden for this flow? | x |
workflowInstance/emailFlow/thumbnail | None | Thumbnail | |
workflowInstance/emailFlow/mediumThumbnail | None | Thumbnail | |
workflowInstance/emailFlow/workflowId | None | Flow id: Id of a flow definition | x |
workflowInstance/emailFlow/workflowName | None | Name: Name of the flow definition | x |
workflowInstance/emailFlow/workflowDescription | None | Description: Description of flow definition | x |
workflowInstance/emailFlow/workflowDefinitionStatus | None | Status: Status of the flow definition | x |
workflowInstance/emailFlow/workflowDefinitionStatusId | None | Status: Status of the flow definition | x |
workflowInstance/emailFlow/jumpToFinish | None | Jump to finish: Should participant jump to finish when the goals are met? | x |
workflowInstance/emailFlow/startOnlyOnce | None | Start only once: Should the participant enter the flow only once? | x |
workflowInstance/emailFlow/workflowEnrolledCount | None | Enrolled: How many times has a participant entered this flow? | |
workflowInstance/emailFlow/workflowInProgressCount | None | In progress: How many participants are in progress | |
workflowInstance/emailFlow/workflowCompletedCount | None | Completed: How many participants are completed | |
workflowInstance/emailFlow/workflowSucceededCount | None | Succeeded: How many participants have successfully completed the flow (goal criteria met)? | |
workflowInstance/emailFlow/workflowSuccessRate | None | Success rate: Success rate, based on goals criteria met | |
workflowInstance/emailFlow/updatedBy | None | Updated by: The user who last updated the data | x |
workflowInstance/emailFlow/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
workflowInstance/emailFlow/registeredBy | None | Registered by: The user who registered the data | x |
workflowInstance/emailFlow/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
chatSession/chatSessionId | None | Chat session ID: Database ID of the chat session | x |
chatSession/firstMessage | None | First message: The first message submitted in the chat | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
chatSession/lastMessage | None | Last message: The last message submitted in the chat | x |
chatSession/whenRequested | None | Chat requested: When was this chat requested by the customer? | x |
chatSession/whenStarted | None | Chat started: When was this chat started between the customer and the agent? | x |
chatSession/whenEnded | None | Chat ended: When did this chat end? | x |
chatSession/duration | None | Duration: The duration of the chat session | |
chatSession/timeInQueue | None | Time in queue: The time spent waiting in the queue | x |
chatSession/queueLength | None | Queue length: Queue length when the session was requested | x |
chatSession/rating | None | Rating: Rating of chat session | x |
chatSession/agent | None | Agent: The agent of the chat | x |
chatSession/status | None | Status: Status for the chat session | x |
chatSession/icon | None | Category: Displays the icon for an activity type | x |
chatSession/date | None | Date: Displays start date of a follow-up / sale date of a sale | x |
chatSession/type | None | Type: Displays the type of an activity | x |
chatSession/text | None | Text: Displays a descriptive text for the item | x |
chatSession/associateId | None | ID: Displays the login ID of the associate who owns the activity. | x |
chatSession/contactId | None | Company ID: Database ID of company | x |
chatSession/personId | None | Contact ID: Database ID of the contact row | x |
chatSession/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
chatSession/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
chatSession/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
chatSession/chatTopic/chatTopicId | None | ID: The database ID of the chat channel | x |
chatSession/chatTopic/name | None | Name: Name | x |
chatSession/chatTopic/description | None | Description: The description of the chat channel | x |
chatSession/chatTopic/badgeHeader | None | Badge header: The value of the badge header for the chat channel | x |
sale/quote/quoteId | None | Quote ID: SuperOffice database ID of quote record | x |
sale/quote/poNumber | None | P.O. Number: Customer's purchase order number | x |
sale/quote/orderComment | None | Comment: Customer's comment | x |
sale/quote/connectionId | None | DB-ID: Database ID | x |
sale/quote/registeredDate | None | Registered at: Displays the date when the quote was registered. | x |
sale/quote/version/quoteVersionId | None | ID: Database ID of QuoteVersion record | x |
sale/quote/version/description | None | Description: Description of the quote version | x |
sale/quote/version/number | None | Number: Reference number for the quote version | x |
sale/quote/version/sent | None | Sent: The date the quote (version) was sent to the customer | x |
sale/quote/version/expiration | None | Expiry date: The last date that the quote is valid | x |
sale/quote/version/state | None | State: The current state the quote is in | x |
sale/quote/version/status | None | Quote status: Status field showing the status of each line. | x |
sale/quote/version/reason | None | Quote reason: The reason or explanation for any status other than 'OK'. | x |
sale/quote/version/paymentTerms | None | Payment terms: Payment terms | |
sale/quote/version/paymentType | None | Payment type: Payment type | |
sale/quote/version/deliveryTerms | None | Delivery terms: Delivery terms | |
sale/quote/version/deliveryType | None | Delivery type: Delivery type | |
sale/quote/version/approvedBy | None | Approved by: Associate who approved a quote that broke one or more of the workflow rules that trigger an approval process | x |
sale/quote/version/approvalRegisteredBy | None | 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. | x |
sale/quote/version/approvedText | None | Approval comment: Comment added to the approval of a quote that broke one or more of the workflow rules that trigger an approval process | x |
sale/quote/version/approvedDate | None | Approved date: Date of approval of a quote that broke one or more of the workflow rules that trigger an approval process | x |
sale/quote/version/extraField1 | None | Extra field 1: One of the extra fields on the product; meaning is installation dependent | x |
sale/quote/version/extraField2 | None | Extra field 2: One of the extra fields on the product; meaning is installation dependent | x |
sale/quote/version/extraField3 | None | Extra field 3: One of the extra fields on the product; meaning is installation dependent | x |
sale/quote/version/extraField4 | None | Extra field 4: One of the extra fields on the product; meaning is installation dependent | x |
sale/quote/version/extraField5 | None | Extra field 5: One of the extra fields on the product; meaning is installation dependent | x |
sale/quote/version/alternative/quoteAlternativeId | None | QuoteAlternative ID: SuperOffice database ID of the quote alternative record | x |
sale/quote/version/alternative/quoteVersionId | None | ID: Database ID of QuoteVersion record | x |
sale/quote/version/alternative/name | None | Name: Name of the quote alternative | x |
sale/quote/version/alternative/description | None | Description: Description of the quote alternative | x |
sale/quote/version/alternative/status | None | Quote status: Status field showing the status of each line. | x |
sale/quote/version/alternative/reason | None | Quote reason: The reason or explanation for any status other than 'OK'. | x |
sale/quote/version/alternative/erpDiscountPercent | None | ERP Discount %: Discount percentage suggested by ERP system | x |
sale/quote/version/alternative/erpDiscountAmount | None | ERP Discount: Discount amount suggested by ERP system | x |
sale/quote/version/alternative/discountPercent | None | Discount %: Enter discount in percent for entire alternative | x |
sale/quote/version/alternative/discountAmount | None | Discount: Enter total discount for entire alternative | x |
sale/quote/version/alternative/vatInfo | None | VAT Info: Information about value-added and other taxes | x |
sale/quote/version/alternative/vat | None | VAT: Value-added and other taxes, total amount | x |
sale/quote/version/alternative/earningPercent | None | Earnings %: Total Earnings as a percentage of the total price, of all lines in the quote alternative, including all discounts | x |
sale/quote/version/alternative/earningAmount | None | Earnings: Total Earnings for all lines in the quote alternative, including all discounts | x |
sale/quote/version/alternative/totalPrice | None | Total: Total price of all items in the quote alternative, including all discounts | x |
sale/quote/version/alternative/extraField1 | None | Extra 1: Extra field 1 on the quote alternative | x |
sale/quote/version/alternative/extraField2 | None | Extra 2: Extra field 2 on the quote alternative | x |
sale/quote/version/alternative/extraField3 | None | Extra 3: Extra field 3on the quote alternative | x |
sale/quote/version/alternative/extraField4 | None | Extra 4: Extra field 4 on the quote alternative | x |
sale/quote/version/alternative/extraField5 | None | Extra 5: Extra field 5 on the quote alternative | x |
sale/quote/version/alternative/alternativeOrdering | None | QuoteAlternative ID: SuperOffice database ID of the quote alternative record | x |
sale/quote/version/alternative/subTotal | None | Total before discount: Total of all lines, before applying the Alternative discount | x |
sale/quote/version/alternative/totalPriceIncVAT | None | Total incl. VAT: Total of all lines, including VAT | x |
sale/quote/version/alternative/vatAmount | None | VAT: VAT (amount) for the alternative | x |
sale/quote/version/alternative/quoteline/quoteLineId | None | Quote line ID: Database identity of the quote line | x |
sale/quote/version/alternative/quoteline/quoteAlternativeId | None | Alternative ID: The database identity of the quote alternative | x |
sale/quote/version/alternative/quoteline/erpProductKey | None | Product key: The foreign key of the product the quote line is based on. | x |
sale/quote/version/alternative/quoteline/rank | None | Rank: Shows the rank of a product | x |
sale/quote/version/alternative/quoteline/quantity | None | Quantity: The quantity that is offered | x |
sale/quote/version/alternative/quoteline/name | None | Name: The name of the product that is being offered. This name can be changed to accommodate the customer's needs. | x |
sale/quote/version/alternative/quoteline/description | None | Description: Description of the product that is offered | x |
sale/quote/version/alternative/quoteline/code | None | Code: The product or article code. This code is created to help you quickly find products you offer regularly. | x |
sale/quote/version/alternative/quoteline/quantityUnit | None | Unit: The unit of the product that is offered. | x |
sale/quote/version/alternative/quoteline/priceUnit | None | Price unit: What is the price unit defined in | x |
sale/quote/version/alternative/quoteline/url | None | Web address: The web address of the product info. | x |
sale/quote/version/alternative/quoteline/subscriptionUnit | None | Subscription unit: Unit the subscription is sold/renewed in, such as year/quarter/month | x |
sale/quote/version/alternative/quoteline/subscriptionQuantity | None | Subscription quantity: Number of subscription units offered | x |
sale/quote/version/alternative/quoteline/UnitListPriceSubscriptionQuantity | None | Subscription list price: Unit price * subscription quantity | |
sale/quote/version/alternative/quoteline/PriceUnitSubscriptionUnit | None | P/S Unit: Price unit/subscription unit | |
sale/quote/version/alternative/quoteline/PriceUnitSubscriptionQuantityUnit | None | Expanded unit: Price unit @ subscription quantity + unit | |
sale/quote/version/alternative/quoteline/vatInfo | None | VAT info: | x |
sale/quote/version/alternative/quoteline/vat | None | VAT: May be filled out by the ERP system | x |
sale/quote/version/alternative/quoteline/unitCost | None | Cost: Cost per item. | x |
sale/quote/version/alternative/quoteline/unitMinimumPrice | None | Unit minimum price: Minimum price per item. Users are not allowed to send quotes with prices lower than the minimum price. | x |
sale/quote/version/alternative/quoteline/unitListPrice | None | List price: List price of a unit | x |
sale/quote/version/alternative/quoteline/totalPrice | None | Total: List price * Quantity - Discount Amount | x |
sale/quote/version/alternative/quoteline/totalCost | None | Total cost | |
sale/quote/version/alternative/quoteline/quoteLineThumbnail | None | Thumbnail: A miniature version of the product picture | |
sale/quote/version/alternative/quoteline/quoteLineThumbnailLarge | None | Thumbnail: A miniature version of the product picture | |
sale/quote/version/alternative/quoteline/discountAmount | None | Discount: Discount amount given by salesperson | x |
Supported Columns (cont.)
Name | Restriction | Description | OrderBy |
---|---|---|---|
sale/quote/version/alternative/quoteline/discountPercent | None | Discount (%: Discount percent given by salesperson | x |
sale/quote/version/alternative/quoteline/earningAmount | None | Earnings: Amount of Earnings (Total - Cost) on the line, after discount | x |
sale/quote/version/alternative/quoteline/earningPercent | None | Earnings (%: Percentage Earnings on the line (Total - Cost / Total), after discount | x |
sale/quote/version/alternative/quoteline/updatedBy | None | Updated by: The user who last updated the data | x |
sale/quote/version/alternative/quoteline/updatedByFullName | None | Updated by - Full name: The user who last updated the data | x |
sale/quote/version/alternative/quoteline/updatedDate | None | Updated: The date/time the data was last updated in UTC. | x |
sale/quote/version/alternative/quoteline/registeredBy | None | Registered by: The user who registered the data | x |
sale/quote/version/alternative/quoteline/registeredByFullName | None | Registered by - Full name: The user who registered the data | x |
sale/quote/version/alternative/quoteline/registeredDate | None | Registered date: The date/time the data was registered in UTC. | x |
sale/quote/version/alternative/quoteline/productCategoryKey | None | Product category: The category the product is defined in | |
sale/quote/version/alternative/quoteline/productFamilyKey | None | Product family: The family the product is defined in | |
sale/quote/version/alternative/quoteline/productTypeKey | None | Product type: The type of product | |
sale/quote/version/alternative/quoteline/status | None | Quote status: Status field showing the status of each line. | x |
sale/quote/version/alternative/quoteline/subTotal | None | Sum: Sum of Quantity * Unit list price | x |
sale/quote/version/alternative/quoteline/vatAmount | None | VAT (amount: The calculated VAT amount | x |
sale/quote/version/alternative/quoteline/totalPriceIncVAT | None | Total incl. VAT: Total including VAT | x |
sale/quote/version/alternative/quoteline/totalPriceWithAlternativeDiscount | None | Total incl. alt. disc: Total, including any discount percentage set on the alternative | x |
Sample
GET /api/v1/archive/ContactPersonSelectionV2?$select=contactAssociate/personId,contactUdef/SuperOffice:5,sourceRelation/business,sale/currency,sale/associate/fullName
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv
See also: