“ProjectStaticSelection”
This provider name is implemented by the classSupported Entities
| Name | Description |
|---|---|
| ”project” | Project |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | GetAll: Get all rows of archive - use with care, you may be fetching the whole database | |
| getNoRows | bool | GetNone: Do not get any rows from the archive | |
| completed | bool | Completed: Displays a check mark indicating if the project has been completed. | x |
| projectId | int | DB ID: Displays the database ID for a project row | x |
| name | stringorPK | Project name: Displays the Project’s name | x |
| number | string | Number: Displays the project’s number | x |
| type | listAny | Project type: Displays the project’s type | x |
| status | listAny | Status: Displays the project’s status | x |
| statusRank | None | Status rank: Rank of the project status in the status list | x |
| associateId | associate | ID: Displays login ID of the associate who owns the project | x |
| hasInfoText | bool | Info: Displays an icon indicating if the project has a description text. The text itself will be displayed in a tooltip. | x |
| icon | None | Category: Displays the icon for an activity type | x |
| text | string | Text: Displays a descriptive text for the item | x |
| description | string | Description : Description | 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 |
| hasGuide | bool | Guided: Does this sale have a Sales Guide | x |
| nextMilestone | date | Next milestone: Date of next non-completed activity that is marked as a milestone | x |
| endDate | date | End date: End date of project | x |
| imageThumbnail | None | Thumbnail: Scaled-down image of project image | |
| activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| eventId | int | Event ID: Event ID | x |
| startDate | date | Start date: Project start date | x |
| projectPublish/isPublished | bool | Published: Displays an icon indicating if the project or sale has been published | x |
| projectPublish/publishedFrom | date | From date: Start date for publishing. The record will not be visible prior to this date | x |
| projectPublish/publishedTo | date | To date: End date for publishing. The record will not be visible after this date | x |
| projectPublish/publishedBy | None | Published by: Published by | |
| projectEvent/isExternalEvent | bool | Event: Is this an external event | x |
| projectEvent/eventDate | date | Event date: Event date | x |
| projectEvent/hasSignOn | bool | Sign On: Does this event have the Sign On function enabled | x |
| projectEvent/hasSignOff | bool | Sign Off: Does this event have the Sign Off function enabled | x |
| projectUrl/URLAddress | string | URL | x |
| projectUrl/URLDescription | string | Description | x |
| projectAssociate/firstName | string | First name: Displays the contact’s first name | x |
| projectAssociate/lastName | string | Last name: Displays the contact’s last name | x |
| projectAssociate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| projectAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| projectAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| projectAssociate/personId | int | Contact ID: Database ID of the contact row | |
| projectAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| projectAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| projectAssociate/associateDbId | associate | ID | x |
| projectAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
| projectAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| projectAssociate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| projectAssociate/usergroupId | int | Group ID: The user’s primary user group | x |
| projectAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| projectAssociate/contactCategory | listAny | Category: Category | x |
| projectAssociate/role | listAny | Role : Role | x |
| projectAssociate/assocName | associate | User ID : User ID | x |
| projectAssociate/assocTooltip | string | Description : Description | |
| projectAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| projectAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| projectAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| projectAssociate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| projectAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| projectAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| projectAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| projectAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| projectAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| projectAssociate/portraitThumbnail | None | Person image: Person image | |
| projectAssociate/otherGroups | userGroup | Other groups: Other groups | |
| projectAssociate/userName | string | User name: User name | x |
| projectAssociate/personEmail | string | x | |
| projectAssociate/locationAddress | string | Location: Location | x |
| projectAssociate/isLocation | bool | Is a location: Is a location | x |
| projectUdef/SuperOffice:1 | string | projectshorttext | x |
| projectUdef/SuperOffice:2 | string | projectlongtext | x |
| projectUdef/SuperOffice:3 | int | projectnumber | x |
| projectUdef/SuperOffice:4 | date | projectdate | x |
| projectUdef/SuperOffice:5 | unlimitedDate | projectunlimiteddate | x |
| projectUdef/SuperOffice:6 | bool | projectcheckbox | x |
| projectUdef/SuperOffice:7 | listAny | projectdropdownlistbox | x |
| projectUdef/SuperOffice:8 | decimal | projectdecimal | x |
| projectUdef/SuperOffice:9 | int | page1saleandmarketing | x |
| projectUdef/SuperOffice:10 | int | page1saleandadmin | x |
| NumberOfActivities | int | Number of activities | |
| NumberOfActivitiesInPeriod | int | Number of activities in last 90 days | |
| NumberOfNotCompletedActivities | int | Number of non-completed activities | |
| NumberOfNotCompletedActivitiesInPeriod | int | Number of non-completed activities in last 90 days | |
| LastActivity | date | Date of last activity | |
| LastCompletedActivity | date | Date of last completed activity | |
| LastDoByActivity | date | Date of last non-completed activity | |
| NumberOfSales | int | Number of sales | |
| NumberOfSalesInPeriod | int | Number of sales in last 90 days | |
| NumberOfNotCompletedSales | int | Number of non-completed sales | |
| NumberOfNotCompletedSalesInPeriod | int | Number of non-completed sales in last 90 days | |
| LastSale | date | Date of last sale | |
| LastCompletedSale | date | Date of last completed sale | |
| LastDoBySale | date | Date of last non-completed sale | |
| SaintStatus3 | saintStatus | Not completed activites with intention sale: Number of not completed activities for intention sale > 0. | |
| saintSaleStatus | listAny | With status | |
| saintAmountClass | listAny | Amount class | |
| saintActivityType | listAny | SAINT type | |
| saintDirection | listAny | Direction |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| saintIntention | listAny | Intention | |
| saintTicketStatus | listAny | Status | |
| saintTicketCategory | listAny | Category | |
| sale/completed | bool | Completed: Displays a checkbox showing if an appointment is completed | x |
| sale/icon | listAny | Category: Displays the icon for an activity type | x |
| sale/date | date | Date: Displays start date of a follow-up / sale date of a sale | x |
| sale/time | None | Time: Time | |
| sale/type | listAny | Type: Displays the type of an activity | x |
| sale/recordType | string | Record type : Shows the record type | x |
| sale/text | positiveString | Text: Displays a descriptive text for the item | x |
| sale/associateId | associate | ID: Displays the login ID of the associate who owns the activity. | x |
| sale/contactId | listAny | Company ID: Database ID of company | x |
| sale/personId | listAny | Contact ID: Database ID of the contact row | x |
| sale/projectId | listAny | Project ID: Database ID of project record | x |
| sale/saleId | int | Sale ID: The database ID of the sale record | x |
| sale/userGroup | userGroup | User group : The user group that owns the record | x |
| sale/who | None | Who: Contact and/or company | |
| sale/updatedBy | associate | Updated by: The user who last updated the data | x |
| sale/updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| sale/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| sale/registeredBy | associate | Registered by: The user who registered the data | x |
| sale/registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| sale/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| sale/currencyId | int | Currency ID: The currency list item ID | x |
| sale/currency | listAny | Currency: The currency of the sale | x |
| sale/credited | listAny | Credited: The user to be credited with the sale | x |
| sale/lossReason | listAny | Reason (lost): The reason for losing the sale | x |
| sale/source | listAny | Source: The source (lead) of the sale | x |
| sale/competitor | listAny | Competitor: The competitor who won the sale | x |
| sale/heading | stringorPK | Sale: The name of the sale | x |
| sale/amount | decimal | Amount: The gross sales total | x |
| sale/amountWeighted | decimal | Weighted amount: Virtual field calculated from amount * probability percent. | x |
| sale/earning | decimal | Profit: Gross profit (gross sales total - cost) for the sale | x |
| sale/earningPercent | decimal | Profit as % : The profit as a percentage of the gross sales total | x |
| sale/probPercent | int | Probability as %: Probability as % | x |
| sale/originalStage | listAny | Stage when closed: Stage when closed | x |
| sale/stage | listAny | Stage: Displays the stage of the sale | x |
| sale/stageName | None | Stage name: Displays the stage of the sale | x |
| sale/saleStatus | listAny | 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 | listAny | Sale type: Sale type, from list | x |
| sale/saleTypeId | None | Sale type ID: Sale type, from list | x |
| sale/stageId | None | Sale stage ID: Displays the stage of the sale | x |
| sale/nextDueDate | date | Next activity: Date for next activity for a sale, updated live from the sale’s activities | x |
| sale/reopenDate | date | Reopen date: Displays the reopen date for the sale | x |
| sale/stalledComment | listAny | Reason (stalled): The reason the sale has been stalled | x |
| sale/saleTypeCategory | listAny | Sale type category: Sale type category | x |
| sale/soldReason | listAny | Reason (sold): Reason (sold) | x |
| sale/saleNumber | string | Number: Number | x |
| sale/hasStakeholders | bool | Has stakeholders: Does this sale have stakeholders | x |
| sale/stakeholdersEnabled | bool | Stakeholders enabled: Possibility to add stakeholders to the sale | x |
| sale/hasQuote | bool | Has quote?: Does the sale have a quote attached? | x |
| sale/hasGuide | bool | Guided: Does this sale have a Sales Guide | x |
| sale/description | string | Description: The long description field on Sale | |
| sale/activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| sale/createdByWorkflow | listAny | 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/daysInStage | int | Days in stage: Total number of days in this stage | x |
| sale/saleCycle | int | Sale cycle: Number of days from a sale was registered until it was closed (sold or lost) | x |
| sale/visibleFor | listAny | Visible for | |
| sale/sale/textId | int | Text ID | x |
| sale/sale/description | positiveString | Text: Displays the text entered in the description field | x |
| sale/salePublish/isPublished | bool | Published: Displays an icon indicating if the project or sale has been published | x |
| sale/salePublish/publishedFrom | date | From date: Start date for publishing. The record will not be visible prior to this date | x |
| sale/salePublish/publishedTo | date | 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 | string | First name: Displays the contact’s first name | x |
| sale/associate/lastName | string | Last name: Displays the contact’s last name | x |
| sale/associate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| sale/associate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| sale/associate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| sale/associate/personId | int | Contact ID: Database ID of the contact row | |
| sale/associate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| sale/associate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| sale/associate/associateDbId | associate | ID | x |
| sale/associate/contactName | string | Owning company: Name of the company the user belongs to | x |
| sale/associate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| sale/associate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| sale/associate/usergroupId | int | Group ID: The user’s primary user group | x |
| sale/associate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| sale/associate/contactCategory | listAny | Category: Category | x |
| sale/associate/role | listAny | Role : Role | x |
| sale/associate/assocName | associate | User ID : User ID | x |
| sale/associate/assocTooltip | string | Description : Description | |
| sale/associate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| sale/associate/ejUserId | int | Service user ID: The database ID of a Service user | |
| sale/associate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| sale/associate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| sale/associate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| sale/associate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| sale/associate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| sale/associate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| sale/associate/isActiveText | bool | 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 | userGroup | Other groups: Other groups | |
| sale/associate/userName | string | User name: User name | x |
| sale/associate/personEmail | string | x | |
| sale/associate/locationAddress | string | Location: Location | x |
| sale/associate/isLocation | bool | Is a location: Is a location | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| sale/saleUdef/SuperOffice:1 | string | saleshorttext | x |
| sale/saleUdef/SuperOffice:2 | string | salelongtext | x |
| sale/saleUdef/SuperOffice:3 | int | salenumber | x |
| sale/saleUdef/SuperOffice:4 | date | saledate | x |
| sale/saleUdef/SuperOffice:5 | unlimitedDate | saleunlimiteddate | x |
| sale/saleUdef/SuperOffice:6 | bool | salecheckbox | x |
| sale/saleUdef/SuperOffice:7 | listAny | saledropdownlistbox | x |
| sale/saleUdef/SuperOffice:8 | decimal | saledecimal | x |
| appointment/completed | bool | Completed: Displays a checkbox showing if an appointment is completed | x |
| appointment/icon | listAny | Category: Displays the icon for an activity type | x |
| appointment/date | date | Date: Displays start date of a follow-up / sale date of a sale | x |
| appointment/time | None | Time: Time | |
| appointment/type | listAny | Type: Displays the type of an activity | x |
| appointment/recordType | string | Record type : Shows the record type | x |
| appointment/text | positiveString | Text: Displays a descriptive text for the item | x |
| appointment/associateId | associate | ID: Displays the login ID of the associate who owns the activity. | x |
| appointment/contactId | listAny | Company ID: Database ID of company | x |
| appointment/personId | listAny | Contact ID: Database ID of the contact row | x |
| appointment/projectId | listAny | Project ID: Database ID of project record | x |
| appointment/saleId | int | Sale ID: The database ID of the sale record | x |
| appointment/userGroup | userGroup | User group : The user group that owns the record | x |
| appointment/who | None | Who: Contact and/or company | |
| appointment/updatedBy | associate | Updated by: The user who last updated the data | x |
| appointment/updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| appointment/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| appointment/registeredBy | associate | Registered by: The user who registered the data | x |
| appointment/registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| appointment/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| appointment/appointmentId | int | DB ID: Displays the database ID of a row | x |
| appointment/endDate | date | End date: Displays the deadline for a follow-up/sale | x |
| appointment/priority | listAny | Priority: Displays the priority of the activity | x |
| appointment/alarm | bool | Has alarm: Displays the alarm state of a follow-up | x |
| appointment/isFree | bool | Is free: Displays whether the appointment should be considered free or busy | x |
| appointment/recurring | bool | Repeating: Displays an icon indicating if the follow-up is part of a repeating follow-up | x |
| appointment/booking | bool | Invitation: Displays an icon if the follow-up is an invitation. All invitations will be displayed in a tooltip. | x |
| appointment/excludeParticipants | bool | Exclude attendees: Don’t show all participant meetings | |
| appointment/intention | listAny | Intention: Displays the intention of the follow-up type | x |
| appointment/location | string | Location: Display the location where the follow-up will take place. | x |
| appointment/recurrenceRuleId | int | RR-ID: Repetition rule ID of follow-up | x |
| appointment/rawType | int | Type: Type field for appointment, not decoded or formatted | x |
| appointment/rawStatus | int | Status: Status field for the follow-up, not decoded or formatted | x |
| appointment/cautionWarning | listAny | Warning: Warning for invitations with potential problems: not properly synchronized with an external calendar, unsupported repetition pattern, e-mail notification failed, or other problems. | x |
| appointment/visibleInDiary | bool | ExcludeBook: Is the activity visible in the diary? | x |
| appointment/endTime | None | End time: End time of an activity | |
| appointment/suggestedAppointmentId | int | Follow-up ID (suggestion): The database ID of a follow-up that originates in a suggestion | x |
| appointment/completedDate | date | Completed date: Displays the actual date a follow-up/sale was marked as completed | x |
| appointment/isMilestone | bool | Milestone: Shows whether or not the follow-ups in this row are milestones | x |
| appointment/invitedPersonId | int | ID of invited person: appointment.invitedpersonid record - utility for rd | x |
| appointment/recordTypeText | listAny | 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 | timeSpan | Duration: The duration of the chat session | |
| appointment/createdByWorkflow | listAny | Created by flow: Created by flow | x |
| appointment/visibleFor | listAny | Visible for | |
| appointment/appointmentPublish/isPublished | bool | Published: Displays an icon indicating if the project or sale has been published | x |
| appointment/appointmentPublish/publishedFrom | date | From date: Start date for publishing. The record will not be visible prior to this date | x |
| appointment/appointmentPublish/publishedTo | date | 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 | string | followupshorttext | x |
| appointment/appointmentUdef/SuperOffice:2 | string | followuplongtext | x |
| appointment/appointmentUdef/SuperOffice:3 | int | followupnumber | x |
| appointment/appointmentUdef/SuperOffice:4 | date | followupdate | x |
| appointment/appointmentUdef/SuperOffice:5 | unlimitedDate | followupunlimiteddate | x |
| appointment/appointmentUdef/SuperOffice:6 | bool | followupcheckbox | x |
| appointment/appointmentUdef/SuperOffice:7 | listAny | followupdropdownlistbox | x |
| appointment/appointmentUdef/SuperOffice:8 | decimal | followupdecimal | x |
| appointment/associate/firstName | string | First name: Displays the contact’s first name | x |
| appointment/associate/lastName | string | Last name: Displays the contact’s last name | x |
| appointment/associate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| appointment/associate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| appointment/associate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| appointment/associate/personId | int | Contact ID: Database ID of the contact row | |
| appointment/associate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| appointment/associate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| appointment/associate/associateDbId | associate | ID | x |
| appointment/associate/contactName | string | Owning company: Name of the company the user belongs to | x |
| appointment/associate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| appointment/associate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| appointment/associate/usergroupId | int | Group ID: The user’s primary user group | x |
| appointment/associate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| appointment/associate/contactCategory | listAny | Category: Category | x |
| appointment/associate/role | listAny | Role : Role | x |
| appointment/associate/assocName | associate | User ID : User ID | x |
| appointment/associate/assocTooltip | string | Description : Description | |
| appointment/associate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| appointment/associate/ejUserId | int | Service user ID: The database ID of a Service user | |
| appointment/associate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| appointment/associate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| appointment/associate/ejStatus | int | 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 | bool | Active: Is this user active, and should be able to log in? | x |
| appointment/associate/isActiveText | bool | 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 | userGroup | Other groups: Other groups | |
| appointment/associate/userName | string | User name: User name | x |
| appointment/associate/personEmail | string | x | |
| appointment/associate/locationAddress | string | Location: Location | x |
| appointment/associate/isLocation | bool | Is a location: Is a location | x |
| appointment/appointment/text | positiveString | Text: Displays a descriptive text for the item | x |
| appointment/appointment/description | positiveString | Text: Displays the text entered in the description field | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointment/appointment/title | positiveString | Title | x |
| appointment/appointment/titleHtml | None | !!Title Html | x |
| appointment/appointment/agenda | positiveString | Agenda | x |
| appointment/appointment/agendaHtml | None | !!Agenda Html | x |
| appointment/appointment/isConverted | None | !!Is Converted | |
| appointment/appointment/textId | int | Text ID | x |
| appointment/appointment/internalNotes | positiveString | Internal notes: Displays the text entered in the description field | x |
| appointment/appointment/internalNotesHtml | positiveString | !!Internal Notes Html | x |
| document/completed | bool | Completed: Displays a checkbox showing if an appointment is completed | x |
| document/icon | listAny | Category: Displays the icon for an activity type | x |
| document/date | date | Date: Displays start date of a follow-up / sale date of a sale | x |
| document/time | None | Time: Time | |
| document/type | listAny | Type: Displays the type of an activity | x |
| document/recordType | string | Record type : Shows the record type | x |
| document/text | positiveString | Text: Displays a descriptive text for the item | x |
| document/associateId | associate | ID: Displays the login ID of the associate who owns the activity. | x |
| document/contactId | listAny | Company ID: Database ID of company | x |
| document/personId | listAny | Contact ID: Database ID of the contact row | x |
| document/projectId | listAny | Project ID: Database ID of project record | x |
| document/saleId | int | Sale ID: The database ID of the sale record | x |
| document/userGroup | userGroup | User group : The user group that owns the record | x |
| document/who | None | Who: Contact and/or company | |
| document/updatedBy | associate | Updated by: The user who last updated the data | x |
| document/updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| document/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| document/registeredBy | associate | Registered by: The user who registered the data | x |
| document/registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| document/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| document/documentId | int | Document ID: Database ID of document record | x |
| document/keywords | string | Keywords | x |
| document/ourref | string | Our ref. | x |
| document/yourref | string | Your ref. | x |
| document/attention | string | Salutation | x |
| document/subject | string | Subject | x |
| document/name | string | File name | x |
| document/mailMergeDraft | bool | Mail merge draft : Indicates whether the document is a mail merge template | x |
| document/snum | int | Document number: Serial number of document. It can be generated by the number allocation system for a dedicated document template. | x |
| document/isReport | bool | Report: Is this document a saved report run? | |
| document/suggestedDocumentId | int | Document ID (suggestion): The database ID of a document that originates in a suggestion | x |
| document/isMail | bool | ||
| document/recordTypeText | None | Activity type: The type of the activity (appointment, phone call, etc) | x |
| document/visibleFor | listAny | Visible for | |
| document/documentPublish/isPublished | bool | Published: Displays an icon indicating if the project or sale has been published | x |
| document/documentPublish/publishedFrom | date | From date: Start date for publishing. The record will not be visible prior to this date | x |
| document/documentPublish/publishedTo | date | 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 | string | First name: Displays the contact’s first name | x |
| document/associate/lastName | string | Last name: Displays the contact’s last name | x |
| document/associate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| document/associate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| document/associate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| document/associate/personId | int | Contact ID: Database ID of the contact row | |
| document/associate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| document/associate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| document/associate/associateDbId | associate | ID | x |
| document/associate/contactName | string | Owning company: Name of the company the user belongs to | x |
| document/associate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| document/associate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| document/associate/usergroupId | int | Group ID: The user’s primary user group | x |
| document/associate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| document/associate/contactCategory | listAny | Category: Category | x |
| document/associate/role | listAny | Role : Role | x |
| document/associate/assocName | associate | User ID : User ID | x |
| document/associate/assocTooltip | string | Description : Description | |
| document/associate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| document/associate/ejUserId | int | Service user ID: The database ID of a Service user | |
| document/associate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| document/associate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| document/associate/ejStatus | int | 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 | bool | Active: Is this user active, and should be able to log in? | x |
| document/associate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| document/associate/portraitThumbnail | None | Person image: Person image | |
| document/associate/otherGroups | userGroup | Other groups: Other groups | |
| document/associate/userName | string | User name: User name | x |
| document/associate/personEmail | string | x | |
| document/associate/locationAddress | string | Location: Location | x |
| document/associate/isLocation | bool | Is a location: Is a location | x |
| document/documentUdef/SuperOffice:1 | string | documentshorttext | x |
| document/documentUdef/SuperOffice:2 | string | documentlongtext | x |
| document/documentUdef/SuperOffice:3 | int | documentnumber | x |
| document/documentUdef/SuperOffice:4 | date | documentdate | x |
| document/documentUdef/SuperOffice:5 | unlimitedDate | documentunlimiteddate | x |
| document/documentUdef/SuperOffice:6 | bool | documentcheckbox | x |
| document/documentUdef/SuperOffice:7 | listAny | documentdropdownlistbox | x |
| document/documentUdef/SuperOffice:8 | decimal | documentdecimal | x |
| document/document/textId | int | Text ID | x |
| document/document/description | positiveString | Text: Displays the text entered in the description field | x |
| projectMember/projectMemberId | int | Project member ID: Database ID of project member record | x |
| projectMember/projectId | int | Project ID: Project ID | x |
| projectMember/contactId | int | Company ID: Database ID of company | x |
| projectMember/personId | int | Contact ID: Database ID of the contact row | x |
| projectMember/eventParticipantStatus | listAny | Project member - Event status: Project member - Event status | x |
| projectMember/function | listAny | Project member - Function: Displays the project member’s function in the project | x |
| projectMember/hasInfoText | bool | Project member - Has info text: Displays an icon indicating that there is additional information available for the project member | x |
| projectMember/registered | datetime | Project member - Registered date: The date/time the data was registered in UTC. | x |
| projectMember/updated | datetime | Project member - Updated: The date/time the data was last updated in UTC. | x |
| projectMember/textId | int | Text ID | x |
| projectMember/infoText | positiveString | Information: Displays the text entered in the description field | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/firstName | string | First name: Displays the contact’s first name | x |
| projectMember/lastName | string | Last name: Displays the contact’s last name | x |
| projectMember/middleName | string | Middle name: Displays the contact’s middle name. | x |
| projectMember/fullName | string | Contact: Displays the contact to which an item is linked | x |
| projectMember/hasInterests | bool | Has interests: Displays an Icon indicating if the contact has active interests | x |
| projectMember/personHasInterests | bool | Has interests: Displays an Icon indicating if the contact has active interests | x |
| projectMember/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/position | listAny | Position | x |
| projectMember/personNumber | string | Number: Displays the contact’s number | x |
| projectMember/title | string | Title: Displays the contact’s job title | x |
| projectMember/personCountry | listAny | Country: Country | x |
| projectMember/personCountryId | int | Country ID: Country ID | x |
| projectMember/personNoMail | bool | No Mailings: Displays the contact’s No Mailings checkbox | x |
| projectMember/rank | int | Rank: Displays a contact’s current rank | x |
| projectMember/birthdate | None | Birthdate: Displays the contact’s date of birth | |
| projectMember/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. | |
| projectMember/useAsMailingAddress | bool | Use as postal address: Use as postal address | x |
| projectMember/personSource | listAny | Source: Source (Contact) | x |
| projectMember/retired | bool | Former employee: Indicates whether the contact has retired/left the company | x |
| projectMember/birthYear | int | Birth year: Displays contact’s birth year | x |
| projectMember/birthMonth | int | Birth month: Displays contact’s birth month | x |
| projectMember/birthDay | int | Birth day: Displays contact’s birth day (day of month) | x |
| projectMember/kanaFirstName | string | First name, kana: Contact’s first name, in kana alphabet | x |
| projectMember/kanaLastName | string | Last name, kana: Contact’s last name, in kana alphabet | x |
| projectMember/personUpdatedBy | associate | Updated by: The user who last updated the data | x |
| projectMember/personUpdatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| projectMember/personUpdatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| projectMember/personRegisteredBy | associate | Registered by: The user who registered the data | x |
| projectMember/personRegisteredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| projectMember/personRegisteredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| projectMember/portraitThumbnail | None | Person image: Person image | |
| projectMember/personActiveErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| projectMember/ticketPriority | listAny | Service priority: Default service priority for this contact | x |
| projectMember/supportLanguage | listAny | Preferred language: Preferred language used for reply templates and more | x |
| projectMember/supportAssociate | associate | Our service contact: Default service contact for this contact | x |
| projectMember/supportAssociateFullName | associate | Our service contact - Full name: Default service contact for this contact | x |
| projectMember/personAssociateId | associate | Our contact: Displays our contact | x |
| projectMember/personAssociateFullName | associate | Our contact - Full name: Displays our contact | x |
| projectMember/personCategory | listAny | Category | x |
| projectMember/personCategoryGroup | listAny | Category group | x |
| projectMember/personCategoryRank | int | !!Category rank | x |
| projectMember/personBusiness | listAny | Business | x |
| projectMember/leadStatus | listAny | Lead status | x |
| projectMember/leadstatusRank | int | !!Lead status RANK | x |
| projectMember/personDeletedDate | datetime | Deleted date: Deleted date | |
| projectMember/hasCompany | bool | Has company: The contact is associated with a company | x |
| projectMember/isProjectMember | bool | Is project member: This person is a project member | x |
| projectMember/isStakeholder | bool | Is stakeholder: This person is a sale stakeholder | x |
| projectMember/updatedByWorkflow | listAny | Updated by flow: Updated by flow | x |
| projectMember/whenUpdatedByWorkflow | datetime | When updated by flow: When updated by flow | x |
| projectMember/createdByForm | listAny | Created by form: Created by form | x |
| projectMember/phone/formattedNumber | string | Phone : Displays phone number | |
| projectMember/personDirectPhone/formattedNumber | string | Direct - Phone: Displays phone number | |
| projectMember/personDirectPhone/description | string | Direct - Description: Phone number description | x |
| projectMember/personMobilePhone/formattedNumber | string | Mobile - Phone: Displays phone number | |
| projectMember/personMobilePhone/description | string | Mobile - Description: Phone number description | x |
| projectMember/personPrivate/formattedNumber | string | Private - Phone: Displays phone number | |
| projectMember/personPrivate/description | string | Private - Description: Phone number description | x |
| projectMember/personPager/formattedNumber | string | Other - Phone: Displays phone number | |
| projectMember/personPager/description | string | Other - Description: Phone number description | x |
| projectMember/personDirectFax/formattedNumber | string | Fax - Phone: Displays phone number | |
| projectMember/personDirectFax/description | string | Fax - Description: Phone number description | x |
| projectMember/searchPhone/formattedNumber | string | Phone : Displays phone number | |
| projectMember/searchPhone/description | string | Description: Phone number description | x |
| projectMember/personInfo/textId | int | Text ID | x |
| projectMember/personInfo/infoText | positiveString | Information: Displays the text entered in the description field | x |
| projectMember/email/emailProtocol | string | Protocol: E-mail protocol, such as SMTP | x |
| projectMember/email/emailAddress | string | x | |
| projectMember/email/emailDescription | string | Description | x |
| projectMember/email/emailId | int | ID | x |
| projectMember/email/emailLastSent | datetime | Last sent: The date and time an e-mail was last sent to this address | x |
| projectMember/email/emailBounceCount | int | Bounce count: Bounce count for this e-mail address | x |
| projectMember/email/emailLastBounce | datetime | Last bounce: Date and time for last bounce to this e-mail address | x |
| projectMember/email/emailHasBounced | bool | Has bounced: This checkbox is active if delivery to this e-mail address has failed. | x |
| projectMember/personUrl/URLAddress | string | URL | x |
| projectMember/personUrl/URLDescription | string | Description | x |
| projectMember/personAddress/addressId | int | Contact address - Address ID: Database ID for the address record | x |
| projectMember/personAddress/line1 | string | Contact address - Address 1: First line of the address | x |
| projectMember/personAddress/line2 | string | Contact address - Address 2: Second line of the address | x |
| projectMember/personAddress/line3 | string | Contact address - Address 3: Third line of the address | x |
| projectMember/personAddress/county | string | Contact address - County: This criterion corresponds to the County field on the Company card. It will only be visible if required by a country’s address format. | x |
| projectMember/personAddress/city | string | Contact address - City: This criterion corresponds to the City field on the Company card. | x |
| projectMember/personAddress/zip | string | Contact address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| projectMember/personAddress/state | string | Contact address - State: This criterion corresponds to the State field on the Company card. \It will only be visible if required by a country’s address format. | x |
| projectMember/personAddress/wgs84latitude | decimal | Contact address - Latitude: Latitude | x |
| projectMember/personAddress/wgs84longitude | decimal | Contact address - Longitude: Longitude | x |
| projectMember/personAddress/formattedAddress | None | Contact address - : | |
| projectMember/personAddress/formattedMultiLineAddress | None | Contact address - : | |
| projectMember/restrictionAddress/addressId | int | Search address - Address ID: Database ID for the address record | x |
| projectMember/restrictionAddress/line1 | string | Search address - Address 1: First line of the address | x |
| projectMember/restrictionAddress/line2 | string | Search address - Address 2: Second line of the address | x |
| projectMember/restrictionAddress/line3 | string | Search address - Address 3: Third line of the address | x |
| projectMember/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 |
| projectMember/restrictionAddress/city | string | Search address - City: This criterion corresponds to the City field on the Company card. | x |
| projectMember/restrictionAddress/zip | string | Search address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| projectMember/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 |
| projectMember/restrictionAddress/wgs84latitude | decimal | Search address - Latitude: Latitude | x |
| projectMember/restrictionAddress/wgs84longitude | decimal | Search address - Longitude: Longitude | x |
| projectMember/restrictionAddress/formattedAddress | None | Search address - : | |
| projectMember/restrictionAddress/formattedMultiLineAddress | None | Search address - : |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/personInterestIds | listInterest | Contact interest: This criterion corresponds to a contact’s interests. It is available via the Contact dialog’s Interests tab. | |
| projectMember/personUdef/SuperOffice:1 | string | contactshorttext: tooltipshorttext | x |
| projectMember/personUdef/SuperOffice:2 | string | contactlongtext: tooltiplongtext | x |
| projectMember/personUdef/SuperOffice:3 | int | contactnumber | x |
| projectMember/personUdef/SuperOffice:4 | date | contactdate | x |
| projectMember/personUdef/SuperOffice:5 | unlimitedDate | contactunlimiteddate: tooltipunlimiteddate | x |
| projectMember/personUdef/SuperOffice:6 | bool | contactcheckbox | x |
| projectMember/personUdef/SuperOffice:7 | listAny | contactdropdownlistbox | x |
| projectMember/personUdef/SuperOffice:8 | decimal | contactdecimal | x |
| projectMember/personUdef/SuperOffice:9 | string | page1saleonly | x |
| projectMember/personUdef/SuperOffice:10 | string | page1marketingonly | x |
| projectMember/personUdef/SuperOffice:11 | string | page1adminonly | x |
| projectMember/personExtra/x_person_integer | int | Extra Integer: Custom person integer | x |
| projectMember/personExtra/x_person_hidden_integer | int | Extra hidden integer: Custom integer field that is hidden | x |
| projectMember/personExtra/x_person_float | decimal | Extra float: Custom float field | x |
| projectMember/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 |
| projectMember/personExtra/x_person_date | date | Extra date: Custom date field on person. Default value = 28.03.2019 | x |
| projectMember/personExtra/x_person_datetime | datetime | Extra DateTime: Custom person date and time field. No default | x |
| projectMember/personExtra/x_person_time | None | Extra time: Custom time field on person. Current time as default | x |
| projectMember/personExtra/x_person_boolean | bool | Extra Boolean: Custom boolean field on person. Default checked | x |
| projectMember/personExtra/x_person_timespan | timeSpan | Extra timespan: Custom timespan on person. Minutes only in 15 units | x |
| projectMember/personExtra/x_person_shorttext | string | Extra short text: Custom short text on person. With index. Do not keep HTML tags | x |
| projectMember/personExtra/x_person_shorttext_list | listAny | Extra short dropdown: Custom Short text dropdown field on person: black, white, transparent | x |
| projectMember/personExtra/x_person_user_relation | associate | Extra user relation: Custom person-user relation field | x |
| projectMember/personExtra/x_person_category_relation | listAny | Extra category relation: Custom person-category relation | x |
| projectMember/personExtra/x_person_priority_relation | listAny | Extra priority relation: Custom person-priority relation | x |
| projectMember/personExtra/x_person_request_relation | stringorPK | Extra request relation: Request relation on contact | x |
| projectMember/personExtra/x_person_appointment_relation | stringorPK | Extra appointment relation: Appointment relation on person | x |
| projectMember/personExtra/x_person_contact_relation | stringorPK | Extra company relation: Company relation on contact | x |
| projectMember/personExtra/y_rental/id | int | Rental - id: Displays the row’s primary key (y_rental) | x |
| projectMember/personExtra/y_rental/x_start | date | Rental - Start rental: Start rental | x |
| projectMember/personExtra/y_rental/x_end | date | Rental - End: End | x |
| projectMember/personExtra/y_rental/x_amount | int | Rental - Amount: Number to rent. Default = 1 | x |
| projectMember/personExtra/y_rental/x_contact | stringorPK | Rental - Renter: Company that rents equipment | x |
| projectMember/personExtra/y_rental/y_equipment/x_name | string | Rental - Equipment - Name: Equpment name custom field. Cannot be null., show in table | x |
| projectMember/personExtra/y_car/id | int | Car - id: Displays the row’s primary key (y_car) | x |
| projectMember/personAssociate/firstName | string | First name: Displays the contact’s first name | x |
| projectMember/personAssociate/lastName | string | Last name: Displays the contact’s last name | x |
| projectMember/personAssociate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| projectMember/personAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| projectMember/personAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| projectMember/personAssociate/personId | int | Contact ID: Database ID of the contact row | |
| projectMember/personAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/personAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/personAssociate/associateDbId | associate | ID | x |
| projectMember/personAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
| projectMember/personAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| projectMember/personAssociate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| projectMember/personAssociate/usergroupId | int | Group ID: The user’s primary user group | x |
| projectMember/personAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| projectMember/personAssociate/contactCategory | listAny | Category: Category | x |
| projectMember/personAssociate/role | listAny | Role : Role | x |
| projectMember/personAssociate/assocName | associate | User ID : User ID | x |
| projectMember/personAssociate/assocTooltip | string | Description : Description | |
| projectMember/personAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| projectMember/personAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| projectMember/personAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| projectMember/personAssociate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| projectMember/personAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| projectMember/personAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| projectMember/personAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| projectMember/personAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| projectMember/personAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| projectMember/personAssociate/portraitThumbnail | None | Person image: Person image | |
| projectMember/personAssociate/otherGroups | userGroup | Other groups: Other groups | |
| projectMember/personAssociate/userName | string | User name: User name | x |
| projectMember/personAssociate/personEmail | string | x | |
| projectMember/personAssociate/locationAddress | string | Location: Location | x |
| projectMember/personAssociate/isLocation | bool | Is a location: Is a location | x |
| projectMember/correspondingAssociate/firstName | string | First name: Displays the contact’s first name | x |
| projectMember/correspondingAssociate/lastName | string | Last name: Displays the contact’s last name | x |
| projectMember/correspondingAssociate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| projectMember/correspondingAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| projectMember/correspondingAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| projectMember/correspondingAssociate/personId | int | Contact ID: Database ID of the contact row | |
| projectMember/correspondingAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/correspondingAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/correspondingAssociate/associateDbId | associate | ID | x |
| projectMember/correspondingAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
| projectMember/correspondingAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| projectMember/correspondingAssociate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| projectMember/correspondingAssociate/usergroupId | int | Group ID: The user’s primary user group | x |
| projectMember/correspondingAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| projectMember/correspondingAssociate/contactCategory | listAny | Category: Category | x |
| projectMember/correspondingAssociate/role | listAny | Role : Role | x |
| projectMember/correspondingAssociate/assocName | associate | User ID : User ID | x |
| projectMember/correspondingAssociate/assocTooltip | string | Description : Description | |
| projectMember/correspondingAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| projectMember/correspondingAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| projectMember/correspondingAssociate/simultaneousEjUser | bool | Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded | |
| projectMember/correspondingAssociate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| projectMember/correspondingAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| projectMember/correspondingAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| projectMember/correspondingAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| projectMember/correspondingAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| projectMember/correspondingAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| projectMember/correspondingAssociate/portraitThumbnail | None | Person image: Person image | |
| projectMember/correspondingAssociate/otherGroups | userGroup | Other groups: Other groups | |
| projectMember/correspondingAssociate/userName | string | User name: User name | x |
| projectMember/correspondingAssociate/personEmail | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/correspondingAssociate/locationAddress | string | Location: Location | x |
| projectMember/correspondingAssociate/isLocation | bool | Is a location: Is a location | x |
| projectMember/isMailingRecipient | bool | Is mailing recipient: isMailingRecipient | x |
| projectMember/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. | |
| projectMember/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. | |
| projectMember/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. | |
| projectMember/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. | |
| projectMember/subscription | listAny | Subscription: Subscription for marketing | x |
| projectMember/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 |
| projectMember/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 |
| projectMember/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 |
| projectMember/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 |
| projectMember/name | stringorPK | Company name | x |
| projectMember/department | string | Department | x |
| projectMember/nameDepartment | string | Company: Displays the company an activity is linked to | x |
| projectMember/associateId | associate | Our contact: Displays our contact | x |
| projectMember/category | listAny | Category | x |
| projectMember/categoryGroup | listAny | Category group | x |
| projectMember/companyCategoryRank | int | Category rank | x |
| projectMember/business | listAny | Business | x |
| projectMember/country | listAny | Country: This criterion corresponds to the Country field on the Company card. | x |
| projectMember/countryId | int | Country ID: Country ID | x |
| projectMember/number | string | Number | x |
| projectMember/code | string | Code | x |
| projectMember/orgnr | string | VAT No. | x |
| projectMember/stop | bool | Stop | x |
| projectMember/contactNoMail | bool | No mailings (company) | x |
| projectMember/updatedBy | associate | Updated by: The user who last updated the data | x |
| projectMember/updatedByFullName | associate | Updated by - Full name: The user who last updated the data | x |
| projectMember/updatedDate | date | Updated: The date/time the data was last updated in UTC. | x |
| projectMember/registeredBy | associate | Registered by: The user who registered the data | x |
| projectMember/registeredByFullName | associate | Registered by - Full name: The user who registered the data | x |
| projectMember/registeredDate | date | Registered date: The date/time the data was registered in UTC. | x |
| projectMember/contactSource | listAny | Source: Source (Company) | x |
| projectMember/contactDeleted | bool | Deleted: Deleted | x |
| projectMember/activeErpLinks | bool | ERP connected: Is there an active ERP Sync? | x |
| projectMember/deletedDate | datetime | Deleted date: Deleted date | |
| projectMember/mainContact | None | Main contact: Main contact for this company | x |
| projectMember/forceCompany | bool | Dummy: Dummy | |
| projectMember/contactPhone/formattedNumber | string | Telephone - Phone: Displays phone number | |
| projectMember/contactPhone/description | string | Telephone - Description: Phone number description | x |
| projectMember/contactFax/formattedNumber | string | Fax - Phone: Displays phone number | |
| projectMember/contactFax/description | string | Fax - Description: Phone number description | x |
| projectMember/postAddress/addressId | int | Postal address - Address ID: Database ID for the address record | x |
| projectMember/postAddress/line1 | string | Postal address - Address 1: First line of the address | x |
| projectMember/postAddress/line2 | string | Postal address - Address 2: Second line of the address | x |
| projectMember/postAddress/line3 | string | Postal address - Address 3: Third line of the address | x |
| projectMember/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 |
| projectMember/postAddress/city | string | Postal address - City: This criterion corresponds to the City field on the Company card. | x |
| projectMember/postAddress/zip | string | Postal address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| projectMember/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 |
| projectMember/postAddress/wgs84latitude | decimal | Postal address - Latitude: Latitude | x |
| projectMember/postAddress/wgs84longitude | decimal | Postal address - Longitude: Longitude | x |
| projectMember/postAddress/formattedAddress | None | Postal address - : | |
| projectMember/postAddress/formattedMultiLineAddress | None | Postal address - : | |
| projectMember/streetAddress/addressId | int | Street address - Address ID: Database ID for the address record | x |
| projectMember/streetAddress/line1 | string | Street address - Address 1: First line of the address | x |
| projectMember/streetAddress/line2 | string | Street address - Address 2: Second line of the address | x |
| projectMember/streetAddress/line3 | string | Street address - Address 3: Third line of the address | x |
| projectMember/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 |
| projectMember/streetAddress/city | string | Street address - City: This criterion corresponds to the City field on the Company card. | x |
| projectMember/streetAddress/zip | string | Street address - Postcode: This criterion corresponds to the Zip Code field on the Company card. | x |
| projectMember/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 |
| projectMember/streetAddress/wgs84latitude | decimal | Street address - Latitude: Latitude | x |
| projectMember/streetAddress/wgs84longitude | decimal | Street address - Longitude: Longitude | x |
| projectMember/streetAddress/formattedAddress | None | Street address - : | |
| projectMember/streetAddress/formattedMultiLineAddress | None | Street address - : | |
| projectMember/url/URLAddress | string | URL | x |
| projectMember/url/URLDescription | string | Description | x |
| projectMember/contactAssociate/firstName | string | First name: Displays the contact’s first name | x |
| projectMember/contactAssociate/lastName | string | Last name: Displays the contact’s last name | x |
| projectMember/contactAssociate/middleName | string | Middle Name : Displays the contact’s middle name. | x |
| projectMember/contactAssociate/fullName | string | Full name: Displays full name of user (first, middle, last - according to settings) | x |
| projectMember/contactAssociate/contactId | int | Company ID: Database ID of the company the user belongs to | |
| projectMember/contactAssociate/personId | int | Contact ID: Database ID of the contact row | |
| projectMember/contactAssociate/mrMrs | string | Mr/Ms: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/contactAssociate/title | string | Title: Displays whether the contact is addressed as Mr or Ms | x |
| projectMember/contactAssociate/associateDbId | associate | ID | x |
| projectMember/contactAssociate/contactName | string | Owning company: Name of the company the user belongs to | x |
| projectMember/contactAssociate/contactDepartment | string | Owning department: Name of the department at the company the user belongs to | x |
| projectMember/contactAssociate/usergroup | userGroup | Primary group: The user’s primary user group | x |
| projectMember/contactAssociate/usergroupId | int | Group ID: The user’s primary user group | x |
| projectMember/contactAssociate/contactFullName | string | Owner: Name and department of the company the user belongs to | x |
| projectMember/contactAssociate/contactCategory | listAny | Category: Category | x |
| projectMember/contactAssociate/role | listAny | Role : Role | x |
| projectMember/contactAssociate/assocName | associate | User ID : User ID | x |
| projectMember/contactAssociate/assocTooltip | string | Description : Description | |
| projectMember/contactAssociate/assocType | listAny | Type: Type of user: associate, external user, system user, anonymous account | x |
| projectMember/contactAssociate/ejUserId | int | Service user ID: The database ID of a Service user | |
| projectMember/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 | |
| projectMember/contactAssociate/ejDisplayName | string | Nickname: User’s nickname in Service | x |
| projectMember/contactAssociate/ejStatus | int | Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only | |
| projectMember/contactAssociate/credentialType | None | Auth. type: What type of credentials to use when this user logs in | x |
| projectMember/contactAssociate/credentialDisplayValue | None | Auth. value: Credential value (public, visible part) to be used when this user logs in | x |
| projectMember/contactAssociate/isActive | bool | Active: Is this user active, and should be able to log in? | x |
| projectMember/contactAssociate/isActiveText | bool | Active status: Is this user active, and should be able to log in? | x |
| projectMember/contactAssociate/portraitThumbnail | None | Person image: Person image | |
| projectMember/contactAssociate/otherGroups | userGroup | Other groups: Other groups | |
| projectMember/contactAssociate/userName | string | User name: User name | x |
| projectMember/contactAssociate/personEmail | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMember/contactAssociate/locationAddress | string | Location: Location | x |
| projectMember/contactAssociate/isLocation | bool | Is a location: Is a location | x |
| projectMember/contactInterestIds | listInterest | Company Interest: This criterion corresponds to the Interests tab on the Company card. | |
| projectMember/contactUdef/SuperOffice:1 | string | companyshorttext: tooltipshorttext | x |
| projectMember/contactUdef/SuperOffice:2 | string | companylongtext: tooltiplongtext | x |
| projectMember/contactUdef/SuperOffice:3 | int | companynumber | x |
| projectMember/contactUdef/SuperOffice:4 | date | companydate | x |
| projectMember/contactUdef/SuperOffice:5 | unlimitedDate | companyunlimiteddate: tooltipunlimiteddate | x |
| projectMember/contactUdef/SuperOffice:6 | bool | companycheckbox | x |
| projectMember/contactUdef/SuperOffice:7 | listAny | companydropdownlistbox | x |
| projectMember/contactUdef/SuperOffice:8 | decimal | companydecimal | x |
| projectMember/contactUdef/SuperOffice:9 | string | page1saleonly | x |
| projectMember/contactUdef/SuperOffice:10 | string | page1marketingonly | x |
| projectMember/contactUdef/SuperOffice:11 | string | page1adminonly | x |
| projectMember/contactUdef/SuperOffice:12 | listAny | Udlist one: Static tooltip for udlist one | x |
| projectMember/contactUdef/SuperOffice:13 | listAny | Udlist two: Static tooltip for udlist two | x |
| projectMember/contactExtra/x_contact_integer | int | Extra Integer: Custom integer field | x |
| projectMember/contactExtra/x_contact_hidden_integer | int | Extra hidden integer: Custom integer field - hidden | x |
| projectMember/contactExtra/x_contact_default_integer | int | Extra Default Integer: Custom integer field with default value 123. | x |
| projectMember/contactExtra/x_contact_float | decimal | Extra Float: Custom float field with 3 decimals | x |
| projectMember/contactExtra/x_contact_longtext | string | Extra LongText: Custom long text field. DO not keep HTML. 3 Line text area editor | x |
| projectMember/contactExtra/x_contact_dropdown | listAny | Extra Long Dropdown: Custom long text field with dropdown: Volvo, Saab, etc. | x |
| projectMember/contactExtra/x_contact_date | date | Extra date: Custom date field. User current as default. | x |
| projectMember/contactExtra/x_contact_datetime | datetime | Extra DateTime: Custom Date Time field. No default value. External | x |
| projectMember/contactExtra/x_contact_time | None | Extra time: Custom time field. | x |
| projectMember/contactExtra/x_contact_boolean | bool | Extra boolean: Custom boolean field. | x |
| projectMember/contactExtra/x_contact_timespan | timeSpan | Extra timespan: Custom timespan field. Hours and minutes in 10 units | x |
| projectMember/contactExtra/x_contact_shorttext | string | Extra short text: Custom short text field. Keep HTML tags. | x |
| projectMember/contactExtra/x_contact_short_dropdown | listAny | Extra short dropdown: Custom short text with dropdown list. Red, Green or Blue or Purple. External. | x |
| projectMember/contactExtra/x_contact_contact_relation | stringorPK | Extra Company: Custom company relation. Do not show one-to-many relations. Show function buttons | x |
| projectMember/contactExtra/x_contact_request_relation | stringorPK | Extra Request relation: Request relation on company | x |
| projectMember/contactExtra/x_contact_contact | stringorPK | Extra contact relation: Contact relation on company | x |
| projectMember/contactExtra/y_organization/x_name | string | Organization - Name: Name | x |
| projectMember/NumberOfActivities | int | Number of activities | |
| projectMember/NumberOfActivitiesInPeriod | int | Number of activities in last 90 days | |
| projectMember/NumberOfNotCompletedActivities | int | Number of non-completed activities | |
| projectMember/NumberOfNotCompletedActivitiesInPeriod | int | Number of non-completed activities in last 90 days | |
| projectMember/LastActivity | date | Date of last activity | |
| projectMember/LastCompletedActivity | date | Date of last completed activity | |
| projectMember/LastDoByActivity | date | Date of last non-completed activity | |
| projectMember/NumberOfSales | int | Number of sales | |
| projectMember/NumberOfSalesInPeriod | int | Number of sales in last 90 days | |
| projectMember/NumberOfNotCompletedSales | int | Number of non-completed sales | |
| projectMember/NumberOfNotCompletedSalesInPeriod | int | Number of non-completed sales in last 90 days | |
| projectMember/LastSale | date | Date of last sale | |
| projectMember/LastCompletedSale | date | Date of last completed sale | |
| projectMember/LastDoBySale | date | Date of last non-completed sale | |
| projectMember/NumberOfTickets | int | Number of requests | |
| projectMember/NumberOfTicketsInPeriod | int | Number of requests in last 90 days | |
| projectMember/NumberOfNotCompletedTickets | int | Number of non-completed requests | |
| projectMember/NumberOfNotCompletedTicketsInPeriod | int | Number of non-completed requests in last 90 days | |
| projectMember/LastTicket | date | Date of last request | |
| projectMember/LastCompletedTicket | date | Date of last completed request | |
| projectMember/LastDoByTicket | date | Date of last non-completed request | |
| projectMember/SaintStatus1 | saintStatus | Neglected customer: Denne kunden har det vært 0 salgsaktiviteter på i perioden. | |
| projectMember/SaintStatus2 | saintStatus | C-company: Kundens navn starter med bokstaven C | |
| projectMember/saintSaleStatus | listAny | With status | |
| projectMember/saintAmountClass | listAny | Amount class | |
| projectMember/saintActivityType | listAny | SAINT type | |
| projectMember/saintDirection | listAny | Direction | |
| projectMember/saintIntention | listAny | Intention | |
| projectMember/saintTicketStatus | listAny | Status | |
| projectMember/saintTicketCategory | listAny | Category | |
| project/textId | int | Text ID | x |
| project/infoText | positiveString | Information: Displays the text entered in the description field | x |
| selectionId | int | Selection ID: The database ID of the selection | |
| selectionMemberId | int | Selection member ID: The database ID of the selection member record | |
| rowKind | None | Icon indicating whether the row comes from a static or a dynamic selection | |
| targetTableNumber | int | TargetTableNumber: TargetTableNumber | x |
| targetRecordId | int | TargetRecordId: TargetRecordId | x |
| contactId | int | Company ID: Database ID of company | x |
| personId | int | Contact ID: Database ID of the contact row | x |
Sample
GET /api/v1/archive/ProjectStaticSelection?$select=projectAssociate/lastName,sale/competitor,appointment/appointmentId,projectMember/mrMrs,projectMember/updatedByWorkflow
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv