“ContactPersonDynamicSelectionV2”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.Archive.ContactPersonSelectionDynamicProviderV2 inside NetServer’s SODatabase assembly. Contact + Person selection archive with OR-able selection groups. Each group is represented with the SaleSelectionDynamicProviderSingleCriteriaGroup.Supported Entities
| Name | Description |
|---|---|
| ”contact" | |
| "person” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| selectionId | int | ||
| rowKind | None | ||
| getAllRows | bool | ||
| getNoRows | bool | ||
| contactId | int | x | |
| name | stringorPK | x | |
| department | string | x | |
| nameDepartment | string | x | |
| hasInfoText | bool | x | |
| hasInterests | bool | x | |
| associateId | associate | x | |
| category | listAny | x | |
| categoryGroup | listAny | x | |
| companyCategoryRank | int | x | |
| business | listAny | x | |
| country | listAny | x | |
| countryId | int | x | |
| number | string | x | |
| code | string | x | |
| orgnr | string | x | |
| stop | bool | x | |
| contactNoMail | bool | x | |
| updatedBy | associate | x | |
| updatedByFullName | associate | x | |
| updatedDate | date | x | |
| registeredBy | associate | x | |
| registeredByFullName | associate | x | |
| registeredDate | date | x | |
| contactSource | listAny | x | |
| contactDeleted | bool | x | |
| phone/formattedNumber | string | ||
| activeErpLinks | bool | x | |
| numEmployees | int | x | |
| yearFounded | int | x | |
| revenueYear | int | x | |
| revenueBasecurrency | decimal | x | |
| sharecapitalBasecurrency | decimal | x | |
| sourcedFrom | string | x | |
| linkedinUrl | string | x | |
| deletedDate | datetime | ||
| mainContact | None | x | |
| forceCompany | bool | ||
| who | None | x | |
| contactPhone/formattedNumber | string | ||
| contactPhone/description | string | x | |
| contactFax/formattedNumber | string | ||
| contactFax/description | string | x | |
| searchPhone/formattedNumber | string | ||
| searchPhone/description | string | x | |
| email/emailProtocol | string | x | |
| email/emailAddress | string | x | |
| email/emailDescription | string | x | |
| email/emailId | int | x | |
| email/emailLastSent | datetime | x | |
| email/emailBounceCount | int | x | |
| email/emailLastBounce | datetime | x | |
| email/emailHasBounced | bool | x | |
| postAddress/addressId | int | x | |
| postAddress/line1 | string | x | |
| postAddress/line2 | string | x | |
| postAddress/line3 | string | x | |
| postAddress/county | string | x | |
| postAddress/city | string | x | |
| postAddress/zip | string | x | |
| postAddress/state | string | x | |
| postAddress/wgs84latitude | decimal | x | |
| postAddress/wgs84longitude | decimal | x | |
| postAddress/formattedAddress | None | ||
| postAddress/formattedMultiLineAddress | None | ||
| streetAddress/addressId | int | x | |
| streetAddress/line1 | string | x | |
| streetAddress/line2 | string | x | |
| streetAddress/line3 | string | x | |
| streetAddress/county | string | x | |
| streetAddress/city | string | x | |
| streetAddress/zip | string | x | |
| streetAddress/state | string | x | |
| streetAddress/wgs84latitude | decimal | x | |
| streetAddress/wgs84longitude | decimal | x | |
| streetAddress/formattedAddress | None | ||
| streetAddress/formattedMultiLineAddress | None | ||
| restrictionAddress/addressId | int | x | |
| restrictionAddress/line1 | string | x | |
| restrictionAddress/line2 | string | x | |
| restrictionAddress/line3 | string | x | |
| restrictionAddress/county | string | x | |
| restrictionAddress/city | string | x | |
| restrictionAddress/zip | string | x | |
| restrictionAddress/state | string | x | |
| restrictionAddress/wgs84latitude | decimal | x | |
| restrictionAddress/wgs84longitude | decimal | x | |
| restrictionAddress/formattedAddress | None | ||
| restrictionAddress/formattedMultiLineAddress | None | ||
| url/URLAddress | string | x | |
| url/URLDescription | string | x | |
| contactAssociate/firstName | string | x | |
| contactAssociate/lastName | string | x | |
| contactAssociate/middleName | string | x | |
| contactAssociate/fullName | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| contactAssociate/contactId | int | ||
| contactAssociate/personId | int | ||
| contactAssociate/mrMrs | string | x | |
| contactAssociate/title | string | x | |
| contactAssociate/associateDbId | associate | x | |
| contactAssociate/contactName | string | x | |
| contactAssociate/contactDepartment | string | x | |
| contactAssociate/usergroup | userGroup | x | |
| contactAssociate/usergroupId | int | x | |
| contactAssociate/contactFullName | string | x | |
| contactAssociate/contactCategory | listAny | x | |
| contactAssociate/role | listAny | x | |
| contactAssociate/assocName | associate | x | |
| contactAssociate/assocTooltip | string | ||
| contactAssociate/assocType | listAny | x | |
| contactAssociate/ejUserId | int | ||
| contactAssociate/simultaneousEjUser | bool | ||
| contactAssociate/ejDisplayName | string | x | |
| contactAssociate/ejStatus | int | ||
| contactAssociate/credentialType | None | x | |
| contactAssociate/credentialDisplayValue | None | x | |
| contactAssociate/isActive | bool | x | |
| contactAssociate/isActiveText | bool | x | |
| contactAssociate/portraitThumbnail | None | ||
| contactAssociate/otherGroups | userGroup | ||
| contactAssociate/userName | string | x | |
| contactAssociate/personEmail | string | x | |
| contactAssociate/locationAddress | string | x | |
| contactAssociate/isLocation | bool | x | |
| contactInterestIds | listInterest | ||
| contactInfo/textId | int | x | |
| contactInfo/infoText | positiveString | x | |
| contactUdef/SuperOffice:1 | string | x | |
| contactUdef/SuperOffice:2 | string | x | |
| contactUdef/SuperOffice:3 | int | x | |
| contactUdef/SuperOffice:4 | date | x | |
| contactUdef/SuperOffice:5 | unlimitedDate | x | |
| contactUdef/SuperOffice:6 | bool | x | |
| contactUdef/SuperOffice:7 | listAny | x | |
| contactUdef/SuperOffice:8 | decimal | x | |
| contactUdef/SuperOffice:9 | string | x | |
| contactUdef/SuperOffice:10 | string | x | |
| contactUdef/SuperOffice:11 | string | x | |
| contactUdef/SuperOffice:12 | listAny | x | |
| contactUdef/SuperOffice:13 | listAny | x | |
| contactExtra/x_contact_integer | int | x | |
| contactExtra/x_contact_hidden_integer | int | x | |
| contactExtra/x_contact_default_integer | int | x | |
| contactExtra/x_contact_float | decimal | x | |
| contactExtra/x_contact_longtext | string | x | |
| contactExtra/x_contact_dropdown | listAny | x | |
| contactExtra/x_contact_date | date | x | |
| contactExtra/x_contact_datetime | datetime | x | |
| contactExtra/x_contact_time | None | x | |
| contactExtra/x_contact_boolean | bool | x | |
| contactExtra/x_contact_timespan | timeSpan | x | |
| contactExtra/x_contact_shorttext | string | x | |
| contactExtra/x_contact_short_dropdown | listAny | x | |
| contactExtra/x_contact_contact_relation | stringorPK | x | |
| contactExtra/x_contact_request_relation | stringorPK | x | |
| contactExtra/x_contact_contact | stringorPK | x | |
| contactExtra/y_organization/x_name | string | x | |
| NumberOfActivities | int | ||
| NumberOfActivitiesInPeriod | int | ||
| NumberOfNotCompletedActivities | int | ||
| NumberOfNotCompletedActivitiesInPeriod | int | ||
| LastActivity | date | ||
| LastCompletedActivity | date | ||
| LastDoByActivity | date | ||
| NumberOfSales | int | ||
| NumberOfSalesInPeriod | int | ||
| NumberOfNotCompletedSales | int | ||
| NumberOfNotCompletedSalesInPeriod | int | ||
| LastSale | date | ||
| LastCompletedSale | date | ||
| LastDoBySale | date | ||
| NumberOfTickets | int | ||
| NumberOfTicketsInPeriod | int | ||
| NumberOfNotCompletedTickets | int | ||
| NumberOfNotCompletedTicketsInPeriod | int | ||
| LastTicket | date | ||
| LastCompletedTicket | date | ||
| LastDoByTicket | date | ||
| SaintStatus1 | saintStatus | ||
| SaintStatus2 | saintStatus | ||
| saintSaleStatus | listAny | ||
| saintAmountClass | listAny | ||
| saintActivityType | listAny | ||
| saintDirection | listAny | ||
| saintIntention | listAny | ||
| saintTicketStatus | listAny | ||
| saintTicketCategory | listAny | ||
| sourceRelation/contactId | int | x | |
| sourceRelation/name | stringorPK | x | |
| sourceRelation/department | string | x | |
| sourceRelation/nameDepartment | string | x | |
| sourceRelation/hasInfoText | bool | x | |
| sourceRelation/hasInterests | bool | x | |
| sourceRelation/associateId | associate | x | |
| sourceRelation/category | listAny | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| sourceRelation/categoryGroup | listAny | x | |
| sourceRelation/companyCategoryRank | int | x | |
| sourceRelation/business | listAny | x | |
| sourceRelation/country | listAny | x | |
| sourceRelation/countryId | int | x | |
| sourceRelation/number | string | x | |
| sourceRelation/code | string | x | |
| sourceRelation/orgnr | string | x | |
| sourceRelation/stop | bool | x | |
| sourceRelation/contactNoMail | bool | x | |
| sourceRelation/updatedBy | associate | x | |
| sourceRelation/updatedByFullName | associate | x | |
| sourceRelation/updatedDate | date | x | |
| sourceRelation/registeredBy | associate | x | |
| sourceRelation/registeredByFullName | associate | x | |
| sourceRelation/registeredDate | date | x | |
| sourceRelation/contactSource | listAny | x | |
| sourceRelation/contactDeleted | bool | x | |
| sourceRelation/activeErpLinks | bool | x | |
| sourceRelation/numEmployees | int | x | |
| sourceRelation/yearFounded | int | x | |
| sourceRelation/revenueYear | int | x | |
| sourceRelation/revenueBasecurrency | decimal | x | |
| sourceRelation/sharecapitalBasecurrency | decimal | x | |
| sourceRelation/sourcedFrom | string | x | |
| sourceRelation/linkedinUrl | string | x | |
| sourceRelation/deletedDate | datetime | ||
| sourceRelation/mainContact | None | x | |
| sourceRelation/forceCompany | bool | ||
| sourceRelation/restrictionContactId | int | ||
| sourceRelation/who | None | x | |
| sourceRelation/csRelation | listAny | x | |
| targetRelation/contactId | int | x | |
| targetRelation/name | stringorPK | x | |
| targetRelation/department | string | x | |
| targetRelation/nameDepartment | string | x | |
| targetRelation/hasInfoText | bool | x | |
| targetRelation/hasInterests | bool | x | |
| targetRelation/associateId | associate | x | |
| targetRelation/category | listAny | x | |
| targetRelation/categoryGroup | listAny | x | |
| targetRelation/companyCategoryRank | int | x | |
| targetRelation/business | listAny | x | |
| targetRelation/country | listAny | x | |
| targetRelation/countryId | int | x | |
| targetRelation/number | string | x | |
| targetRelation/code | string | x | |
| targetRelation/orgnr | string | x | |
| targetRelation/stop | bool | x | |
| targetRelation/contactNoMail | bool | x | |
| targetRelation/updatedBy | associate | x | |
| targetRelation/updatedByFullName | associate | x | |
| targetRelation/updatedDate | date | x | |
| targetRelation/registeredBy | associate | x | |
| targetRelation/registeredByFullName | associate | x | |
| targetRelation/registeredDate | date | x | |
| targetRelation/contactSource | listAny | x | |
| targetRelation/contactDeleted | bool | x | |
| targetRelation/activeErpLinks | bool | x | |
| targetRelation/numEmployees | int | x | |
| targetRelation/yearFounded | int | x | |
| targetRelation/revenueYear | int | x | |
| targetRelation/revenueBasecurrency | decimal | x | |
| targetRelation/sharecapitalBasecurrency | decimal | x | |
| targetRelation/sourcedFrom | string | x | |
| targetRelation/linkedinUrl | string | x | |
| targetRelation/deletedDate | datetime | ||
| targetRelation/mainContact | None | x | |
| targetRelation/forceCompany | bool | ||
| targetRelation/restrictionContactId | int | ||
| targetRelation/who | None | x | |
| targetRelation/csRelation | listAny | x | |
| sourceRelation/contactPersonRelation | listAny | x | |
| targetRelation/personContactRelation | listAny | x | |
| sale/completed | bool | x | |
| sale/icon | listAny | x | |
| sale/date | date | x | |
| sale/time | None | ||
| sale/type | listAny | x | |
| sale/recordType | string | x | |
| sale/text | positiveString | x | |
| sale/associateId | associate | x | |
| sale/contactId | listAny | x | |
| sale/personId | listAny | x | |
| sale/projectId | listAny | x | |
| sale/saleId | int | x | |
| sale/userGroup | userGroup | x | |
| sale/who | None | ||
| sale/updatedBy | associate | x | |
| sale/updatedByFullName | associate | x | |
| sale/updatedDate | date | x | |
| sale/registeredBy | associate | x | |
| sale/registeredByFullName | associate | x | |
| sale/registeredDate | date | x | |
| sale/currencyId | int | x | |
| sale/currency | listAny | x | |
| sale/credited | listAny | x | |
| sale/lossReason | listAny | x | |
| sale/source | listAny | x | |
| sale/competitor | listAny | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| sale/heading | stringorPK | x | |
| sale/amount | decimal | x | |
| sale/amountWeighted | decimal | x | |
| sale/earning | decimal | x | |
| sale/earningPercent | decimal | x | |
| sale/probPercent | int | x | |
| sale/originalStage | listAny | x | |
| sale/stage | listAny | x | |
| sale/stageName | None | x | |
| sale/saleStatus | listAny | x | |
| sale/stageRank | None | x | |
| sale/saleType | listAny | x | |
| sale/saleTypeId | None | x | |
| sale/stageId | None | x | |
| sale/nextDueDate | date | x | |
| sale/reopenDate | date | x | |
| sale/stalledComment | listAny | x | |
| sale/saleTypeCategory | listAny | x | |
| sale/soldReason | listAny | x | |
| sale/saleNumber | string | x | |
| sale/hasStakeholders | bool | x | |
| sale/stakeholdersEnabled | bool | x | |
| sale/hasQuote | bool | x | |
| sale/hasGuide | bool | x | |
| sale/description | string | ||
| sale/activeErpLinks | bool | x | |
| sale/createdByWorkflow | listAny | x | |
| sale/amountInBaseCurrency | None | x | |
| sale/amountWeightedInBaseCurrency | None | x | |
| sale/daysInStage | int | x | |
| sale/saleCycle | int | x | |
| sale/visibleFor | listAny | ||
| sale/sale/textId | int | x | |
| sale/sale/description | positiveString | x | |
| sale/salePublish/isPublished | bool | x | |
| sale/salePublish/publishedFrom | date | x | |
| sale/salePublish/publishedTo | date | x | |
| sale/salePublish/publishedBy | None | ||
| sale/associate/firstName | string | x | |
| sale/associate/lastName | string | x | |
| sale/associate/middleName | string | x | |
| sale/associate/fullName | string | x | |
| sale/associate/contactId | int | ||
| sale/associate/personId | int | ||
| sale/associate/mrMrs | string | x | |
| sale/associate/title | string | x | |
| sale/associate/associateDbId | associate | x | |
| sale/associate/contactName | string | x | |
| sale/associate/contactDepartment | string | x | |
| sale/associate/usergroup | userGroup | x | |
| sale/associate/usergroupId | int | x | |
| sale/associate/contactFullName | string | x | |
| sale/associate/contactCategory | listAny | x | |
| sale/associate/role | listAny | x | |
| sale/associate/assocName | associate | x | |
| sale/associate/assocTooltip | string | ||
| sale/associate/assocType | listAny | x | |
| sale/associate/ejUserId | int | ||
| sale/associate/simultaneousEjUser | bool | ||
| sale/associate/ejDisplayName | string | x | |
| sale/associate/ejStatus | int | ||
| sale/associate/credentialType | None | x | |
| sale/associate/credentialDisplayValue | None | x | |
| sale/associate/isActive | bool | x | |
| sale/associate/isActiveText | bool | x | |
| sale/associate/portraitThumbnail | None | ||
| sale/associate/otherGroups | userGroup | ||
| sale/associate/userName | string | x | |
| sale/associate/personEmail | string | x | |
| sale/associate/locationAddress | string | x | |
| sale/associate/isLocation | bool | x | |
| sale/saleUdef/SuperOffice:1 | string | x | |
| sale/saleUdef/SuperOffice:2 | string | x | |
| sale/saleUdef/SuperOffice:3 | int | x | |
| sale/saleUdef/SuperOffice:4 | date | x | |
| sale/saleUdef/SuperOffice:5 | unlimitedDate | x | |
| sale/saleUdef/SuperOffice:6 | bool | x | |
| sale/saleUdef/SuperOffice:7 | listAny | x | |
| sale/saleUdef/SuperOffice:8 | decimal | x | |
| appointment/completed | bool | x | |
| appointment/icon | listAny | x | |
| appointment/date | date | x | |
| appointment/time | None | ||
| appointment/type | listAny | x | |
| appointment/recordType | string | x | |
| appointment/text | positiveString | x | |
| appointment/associateId | associate | x | |
| appointment/contactId | listAny | x | |
| appointment/personId | listAny | x | |
| appointment/projectId | listAny | x | |
| appointment/saleId | int | x | |
| appointment/userGroup | userGroup | x | |
| appointment/who | None | ||
| appointment/updatedBy | associate | x | |
| appointment/updatedByFullName | associate | x | |
| appointment/updatedDate | date | x | |
| appointment/registeredBy | associate | x | |
| appointment/registeredByFullName | associate | x | |
| appointment/registeredDate | date | x | |
| appointment/appointmentId | int | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointment/endDate | date | x | |
| appointment/priority | listAny | x | |
| appointment/alarm | bool | x | |
| appointment/isFree | bool | x | |
| appointment/recurring | bool | x | |
| appointment/booking | bool | x | |
| appointment/excludeParticipants | bool | ||
| appointment/intention | listAny | x | |
| appointment/location | string | x | |
| appointment/recurrenceRuleId | int | x | |
| appointment/rawType | int | x | |
| appointment/rawStatus | int | x | |
| appointment/cautionWarning | listAny | x | |
| appointment/visibleInDiary | bool | x | |
| appointment/endTime | None | ||
| appointment/suggestedAppointmentId | int | x | |
| appointment/completedDate | date | x | |
| appointment/isMilestone | bool | x | |
| appointment/invitedPersonId | int | x | |
| appointment/recordTypeText | listAny | x | |
| appointment/joinVideomeetUrl | None | x | |
| appointment/duration | timeSpan | ||
| appointment/createdByWorkflow | listAny | x | |
| appointment/colorIndex | listAny | x | |
| appointment/visibleFor | listAny | ||
| appointment/appointmentPublish/isPublished | bool | x | |
| appointment/appointmentPublish/publishedFrom | date | x | |
| appointment/appointmentPublish/publishedTo | date | x | |
| appointment/appointmentPublish/publishedBy | None | ||
| appointment/appointmentUdef/SuperOffice:1 | string | x | |
| appointment/appointmentUdef/SuperOffice:2 | string | x | |
| appointment/appointmentUdef/SuperOffice:3 | int | x | |
| appointment/appointmentUdef/SuperOffice:4 | date | x | |
| appointment/appointmentUdef/SuperOffice:5 | unlimitedDate | x | |
| appointment/appointmentUdef/SuperOffice:6 | bool | x | |
| appointment/appointmentUdef/SuperOffice:7 | listAny | x | |
| appointment/appointmentUdef/SuperOffice:8 | decimal | x | |
| appointment/associate/firstName | string | x | |
| appointment/associate/lastName | string | x | |
| appointment/associate/middleName | string | x | |
| appointment/associate/fullName | string | x | |
| appointment/associate/contactId | int | ||
| appointment/associate/personId | int | ||
| appointment/associate/mrMrs | string | x | |
| appointment/associate/title | string | x | |
| appointment/associate/associateDbId | associate | x | |
| appointment/associate/contactName | string | x | |
| appointment/associate/contactDepartment | string | x | |
| appointment/associate/usergroup | userGroup | x | |
| appointment/associate/usergroupId | int | x | |
| appointment/associate/contactFullName | string | x | |
| appointment/associate/contactCategory | listAny | x | |
| appointment/associate/role | listAny | x | |
| appointment/associate/assocName | associate | x | |
| appointment/associate/assocTooltip | string | ||
| appointment/associate/assocType | listAny | x | |
| appointment/associate/ejUserId | int | ||
| appointment/associate/simultaneousEjUser | bool | ||
| appointment/associate/ejDisplayName | string | x | |
| appointment/associate/ejStatus | int | ||
| appointment/associate/credentialType | None | x | |
| appointment/associate/credentialDisplayValue | None | x | |
| appointment/associate/isActive | bool | x | |
| appointment/associate/isActiveText | bool | x | |
| appointment/associate/portraitThumbnail | None | ||
| appointment/associate/otherGroups | userGroup | ||
| appointment/associate/userName | string | x | |
| appointment/associate/personEmail | string | x | |
| appointment/associate/locationAddress | string | x | |
| appointment/associate/isLocation | bool | x | |
| appointment/appointment/text | positiveString | x | |
| appointment/appointment/description | positiveString | x | |
| appointment/appointment/title | positiveString | x | |
| appointment/appointment/titleHtml | None | x | |
| appointment/appointment/agenda | positiveString | x | |
| appointment/appointment/agendaHtml | None | x | |
| appointment/appointment/isConverted | None | ||
| appointment/appointment/textId | int | x | |
| appointment/appointment/internalNotes | positiveString | x | |
| appointment/appointment/internalNotesHtml | positiveString | x | |
| document/completed | bool | x | |
| document/icon | listAny | x | |
| document/date | date | x | |
| document/time | None | ||
| document/type | listAny | x | |
| document/recordType | string | x | |
| document/text | positiveString | x | |
| document/associateId | associate | x | |
| document/contactId | listAny | x | |
| document/personId | listAny | x | |
| document/projectId | listAny | x | |
| document/saleId | int | x | |
| document/userGroup | userGroup | x | |
| document/who | None | ||
| document/updatedBy | associate | x | |
| document/updatedByFullName | associate | x | |
| document/updatedDate | date | x | |
| document/registeredBy | associate | x | |
| document/registeredByFullName | associate | x | |
| document/registeredDate | date | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| document/documentId | int | x | |
| document/keywords | string | x | |
| document/ourref | string | x | |
| document/yourref | string | x | |
| document/attention | string | x | |
| document/subject | string | x | |
| document/name | string | x | |
| document/mailMergeDraft | bool | x | |
| document/snum | int | x | |
| document/isReport | bool | ||
| document/suggestedDocumentId | int | x | |
| document/isMail | bool | ||
| document/recordTypeText | None | x | |
| document/visibleFor | listAny | ||
| document/documentPublish/isPublished | bool | x | |
| document/documentPublish/publishedFrom | date | x | |
| document/documentPublish/publishedTo | date | x | |
| document/documentPublish/publishedBy | None | ||
| document/associate/firstName | string | x | |
| document/associate/lastName | string | x | |
| document/associate/middleName | string | x | |
| document/associate/fullName | string | x | |
| document/associate/contactId | int | ||
| document/associate/personId | int | ||
| document/associate/mrMrs | string | x | |
| document/associate/title | string | x | |
| document/associate/associateDbId | associate | x | |
| document/associate/contactName | string | x | |
| document/associate/contactDepartment | string | x | |
| document/associate/usergroup | userGroup | x | |
| document/associate/usergroupId | int | x | |
| document/associate/contactFullName | string | x | |
| document/associate/contactCategory | listAny | x | |
| document/associate/role | listAny | x | |
| document/associate/assocName | associate | x | |
| document/associate/assocTooltip | string | ||
| document/associate/assocType | listAny | x | |
| document/associate/ejUserId | int | ||
| document/associate/simultaneousEjUser | bool | ||
| document/associate/ejDisplayName | string | x | |
| document/associate/ejStatus | int | ||
| document/associate/credentialType | None | x | |
| document/associate/credentialDisplayValue | None | x | |
| document/associate/isActive | bool | x | |
| document/associate/isActiveText | bool | x | |
| document/associate/portraitThumbnail | None | ||
| document/associate/otherGroups | userGroup | ||
| document/associate/userName | string | x | |
| document/associate/personEmail | string | x | |
| document/associate/locationAddress | string | x | |
| document/associate/isLocation | bool | x | |
| document/documentUdef/SuperOffice:1 | string | x | |
| document/documentUdef/SuperOffice:2 | string | x | |
| document/documentUdef/SuperOffice:3 | int | x | |
| document/documentUdef/SuperOffice:4 | date | x | |
| document/documentUdef/SuperOffice:5 | unlimitedDate | x | |
| document/documentUdef/SuperOffice:6 | bool | x | |
| document/documentUdef/SuperOffice:7 | listAny | x | |
| document/documentUdef/SuperOffice:8 | decimal | x | |
| document/document/textId | int | x | |
| document/document/description | positiveString | x | |
| personId | int | x | |
| firstName | string | x | |
| lastName | string | x | |
| middleName | string | x | |
| fullName | string | x | |
| personHasInterests | bool | x | |
| mrMrs | string | x | |
| position | listAny | x | |
| personNumber | string | x | |
| title | string | x | |
| personCountry | listAny | x | |
| personCountryId | int | x | |
| personNoMail | bool | x | |
| rank | int | x | |
| birthdate | None | ||
| associateType | None | ||
| useAsMailingAddress | bool | x | |
| personSource | listAny | x | |
| retired | bool | x | |
| birthYear | int | x | |
| birthMonth | int | x | |
| birthDay | int | x | |
| kanaFirstName | string | x | |
| kanaLastName | string | x | |
| personUpdatedBy | associate | x | |
| personUpdatedByFullName | associate | x | |
| personUpdatedDate | date | x | |
| personRegisteredBy | associate | x | |
| personRegisteredByFullName | associate | x | |
| personRegisteredDate | date | x | |
| portraitThumbnail | None | ||
| personActiveErpLinks | bool | x | |
| personSourcedFrom | string | x | |
| personLinkedinUrl | string | x | |
| ticketPriority | listAny | x | |
| supportLanguage | listAny | x | |
| supportAssociate | associate | x | |
| supportAssociateFullName | associate | x | |
| personAssociateId | associate | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personAssociateFullName | associate | x | |
| personCategory | listAny | x | |
| personCategoryGroup | listAny | x | |
| personCategoryRank | int | x | |
| personBusiness | listAny | x | |
| leadStatus | listAny | x | |
| leadstatusRank | int | x | |
| personDeletedDate | datetime | ||
| hasCompany | bool | x | |
| isProjectMember | bool | x | |
| isStakeholder | bool | x | |
| updatedByWorkflow | listAny | x | |
| whenUpdatedByWorkflow | datetime | x | |
| createdByForm | listAny | x | |
| includePersonRestriction | string | ||
| includePersonWithNoDMRestriction | bool | ||
| personDirectPhone/formattedNumber | string | ||
| personDirectPhone/description | string | x | |
| personMobilePhone/formattedNumber | string | ||
| personMobilePhone/description | string | x | |
| personPrivate/formattedNumber | string | ||
| personPrivate/description | string | x | |
| personPager/formattedNumber | string | ||
| personPager/description | string | x | |
| personDirectFax/formattedNumber | string | ||
| personDirectFax/description | string | x | |
| personInfo/textId | int | x | |
| personInfo/infoText | positiveString | x | |
| personEmail/emailProtocol | string | x | |
| personEmail/emailAddress | string | x | |
| personEmail/emailDescription | string | x | |
| personEmail/emailId | int | x | |
| personEmail/emailLastSent | datetime | x | |
| personEmail/emailBounceCount | int | x | |
| personEmail/emailLastBounce | datetime | x | |
| personEmail/emailHasBounced | bool | x | |
| personUrl/URLAddress | string | x | |
| personUrl/URLDescription | string | x | |
| personAddress/addressId | int | x | |
| personAddress/line1 | string | x | |
| personAddress/line2 | string | x | |
| personAddress/line3 | string | x | |
| personAddress/county | string | x | |
| personAddress/city | string | x | |
| personAddress/zip | string | x | |
| personAddress/state | string | x | |
| personAddress/wgs84latitude | decimal | x | |
| personAddress/wgs84longitude | decimal | x | |
| personAddress/formattedAddress | None | ||
| personAddress/formattedMultiLineAddress | None | ||
| personInterestIds | listInterest | ||
| personUdef/SuperOffice:1 | string | x | |
| personUdef/SuperOffice:2 | string | x | |
| personUdef/SuperOffice:3 | int | x | |
| personUdef/SuperOffice:4 | date | x | |
| personUdef/SuperOffice:5 | unlimitedDate | x | |
| personUdef/SuperOffice:6 | bool | x | |
| personUdef/SuperOffice:7 | listAny | x | |
| personUdef/SuperOffice:8 | decimal | x | |
| personUdef/SuperOffice:9 | string | x | |
| personUdef/SuperOffice:10 | string | x | |
| personUdef/SuperOffice:11 | string | x | |
| personExtra/x_person_integer | int | x | |
| personExtra/x_person_hidden_integer | int | x | |
| personExtra/x_person_float | decimal | x | |
| personExtra/x_person_longtext | string | x | |
| personExtra/x_person_date | date | x | |
| personExtra/x_person_datetime | datetime | x | |
| personExtra/x_person_time | None | x | |
| personExtra/x_person_boolean | bool | x | |
| personExtra/x_person_timespan | timeSpan | x | |
| personExtra/x_person_shorttext | string | x | |
| personExtra/x_person_shorttext_list | listAny | x | |
| personExtra/x_person_user_relation | associate | x | |
| personExtra/x_person_category_relation | listAny | x | |
| personExtra/x_person_priority_relation | listAny | x | |
| personExtra/x_person_request_relation | stringorPK | x | |
| personExtra/x_person_appointment_relation | stringorPK | x | |
| personExtra/x_person_contact_relation | stringorPK | x | |
| personExtra/y_rental/id | int | x | |
| personExtra/y_rental/x_start | date | x | |
| personExtra/y_rental/x_end | date | x | |
| personExtra/y_rental/x_amount | int | x | |
| personExtra/y_rental/x_contact | stringorPK | x | |
| personExtra/y_rental/y_equipment/x_name | string | x | |
| personExtra/y_car/id | int | x | |
| personSourceRelation/personId | int | x | |
| personSourceRelation/firstName | string | x | |
| personSourceRelation/lastName | string | x | |
| personSourceRelation/middleName | string | x | |
| personSourceRelation/fullName | string | x | |
| personSourceRelation/contactId | int | x | |
| personSourceRelation/hasInfoText | bool | x | |
| personSourceRelation/hasInterests | bool | x | |
| personSourceRelation/personHasInterests | bool | x | |
| personSourceRelation/mrMrs | string | x | |
| personSourceRelation/position | listAny | x | |
| personSourceRelation/personNumber | string | x | |
| personSourceRelation/title | string | x | |
| personSourceRelation/personCountry | listAny | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personSourceRelation/personCountryId | int | x | |
| personSourceRelation/personNoMail | bool | x | |
| personSourceRelation/rank | int | x | |
| personSourceRelation/birthdate | None | ||
| personSourceRelation/associateType | None | ||
| personSourceRelation/useAsMailingAddress | bool | x | |
| personSourceRelation/personSource | listAny | x | |
| personSourceRelation/retired | bool | x | |
| personSourceRelation/birthYear | int | x | |
| personSourceRelation/birthMonth | int | x | |
| personSourceRelation/birthDay | int | x | |
| personSourceRelation/kanaFirstName | string | x | |
| personSourceRelation/kanaLastName | string | x | |
| personSourceRelation/personUpdatedBy | associate | x | |
| personSourceRelation/personUpdatedByFullName | associate | x | |
| personSourceRelation/personUpdatedDate | date | x | |
| personSourceRelation/personRegisteredBy | associate | x | |
| personSourceRelation/personRegisteredByFullName | associate | x | |
| personSourceRelation/personRegisteredDate | date | x | |
| personSourceRelation/portraitThumbnail | None | ||
| personSourceRelation/personActiveErpLinks | bool | x | |
| personSourceRelation/personSourcedFrom | string | x | |
| personSourceRelation/personLinkedinUrl | string | x | |
| personSourceRelation/ticketPriority | listAny | x | |
| personSourceRelation/supportLanguage | listAny | x | |
| personSourceRelation/supportAssociate | associate | x | |
| personSourceRelation/supportAssociateFullName | associate | x | |
| personSourceRelation/personAssociateId | associate | x | |
| personSourceRelation/personAssociateFullName | associate | x | |
| personSourceRelation/personCategory | listAny | x | |
| personSourceRelation/personCategoryGroup | listAny | x | |
| personSourceRelation/personCategoryRank | int | x | |
| personSourceRelation/personBusiness | listAny | x | |
| personSourceRelation/leadStatus | listAny | x | |
| personSourceRelation/leadstatusRank | int | x | |
| personSourceRelation/personDeletedDate | datetime | ||
| personSourceRelation/hasCompany | bool | x | |
| personSourceRelation/isProjectMember | bool | x | |
| personSourceRelation/isStakeholder | bool | x | |
| personSourceRelation/updatedByWorkflow | listAny | x | |
| personSourceRelation/whenUpdatedByWorkflow | datetime | x | |
| personSourceRelation/createdByForm | listAny | x | |
| personSourceRelation/restrictionContactId | int | ||
| personSourceRelation/restrictionPersonId | int | ||
| personSourceRelation/who | None | x | |
| personSourceRelation/personPersonRelation | listAny | x | |
| personTargetRelation/personId | int | x | |
| personTargetRelation/firstName | string | x | |
| personTargetRelation/lastName | string | x | |
| personTargetRelation/middleName | string | x | |
| personTargetRelation/fullName | string | x | |
| personTargetRelation/contactId | int | x | |
| personTargetRelation/hasInfoText | bool | x | |
| personTargetRelation/hasInterests | bool | x | |
| personTargetRelation/personHasInterests | bool | x | |
| personTargetRelation/mrMrs | string | x | |
| personTargetRelation/position | listAny | x | |
| personTargetRelation/personNumber | string | x | |
| personTargetRelation/title | string | x | |
| personTargetRelation/personCountry | listAny | x | |
| personTargetRelation/personCountryId | int | x | |
| personTargetRelation/personNoMail | bool | x | |
| personTargetRelation/rank | int | x | |
| personTargetRelation/birthdate | None | ||
| personTargetRelation/associateType | None | ||
| personTargetRelation/useAsMailingAddress | bool | x | |
| personTargetRelation/personSource | listAny | x | |
| personTargetRelation/retired | bool | x | |
| personTargetRelation/birthYear | int | x | |
| personTargetRelation/birthMonth | int | x | |
| personTargetRelation/birthDay | int | x | |
| personTargetRelation/kanaFirstName | string | x | |
| personTargetRelation/kanaLastName | string | x | |
| personTargetRelation/personUpdatedBy | associate | x | |
| personTargetRelation/personUpdatedByFullName | associate | x | |
| personTargetRelation/personUpdatedDate | date | x | |
| personTargetRelation/personRegisteredBy | associate | x | |
| personTargetRelation/personRegisteredByFullName | associate | x | |
| personTargetRelation/personRegisteredDate | date | x | |
| personTargetRelation/portraitThumbnail | None | ||
| personTargetRelation/personActiveErpLinks | bool | x | |
| personTargetRelation/personSourcedFrom | string | x | |
| personTargetRelation/personLinkedinUrl | string | x | |
| personTargetRelation/ticketPriority | listAny | x | |
| personTargetRelation/supportLanguage | listAny | x | |
| personTargetRelation/supportAssociate | associate | x | |
| personTargetRelation/supportAssociateFullName | associate | x | |
| personTargetRelation/personAssociateId | associate | x | |
| personTargetRelation/personAssociateFullName | associate | x | |
| personTargetRelation/personCategory | listAny | x | |
| personTargetRelation/personCategoryGroup | listAny | x | |
| personTargetRelation/personCategoryRank | int | x | |
| personTargetRelation/personBusiness | listAny | x | |
| personTargetRelation/leadStatus | listAny | x | |
| personTargetRelation/leadstatusRank | int | x | |
| personTargetRelation/personDeletedDate | datetime | ||
| personTargetRelation/hasCompany | bool | x | |
| personTargetRelation/isProjectMember | bool | x | |
| personTargetRelation/isStakeholder | bool | x | |
| personTargetRelation/updatedByWorkflow | listAny | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personTargetRelation/whenUpdatedByWorkflow | datetime | x | |
| personTargetRelation/createdByForm | listAny | x | |
| personTargetRelation/restrictionContactId | int | ||
| personTargetRelation/restrictionPersonId | int | ||
| personTargetRelation/who | None | x | |
| personTargetRelation/personPersonRelation | listAny | x | |
| personSourceRelation/personContactRelation | listAny | x | |
| personTargetRelation/contactPersonRelation | listAny | x | |
| personAssociate/firstName | string | x | |
| personAssociate/lastName | string | x | |
| personAssociate/middleName | string | x | |
| personAssociate/fullName | string | x | |
| personAssociate/contactId | int | ||
| personAssociate/personId | int | ||
| personAssociate/mrMrs | string | x | |
| personAssociate/title | string | x | |
| personAssociate/associateDbId | associate | x | |
| personAssociate/contactName | string | x | |
| personAssociate/contactDepartment | string | x | |
| personAssociate/usergroup | userGroup | x | |
| personAssociate/usergroupId | int | x | |
| personAssociate/contactFullName | string | x | |
| personAssociate/contactCategory | listAny | x | |
| personAssociate/role | listAny | x | |
| personAssociate/assocName | associate | x | |
| personAssociate/assocTooltip | string | ||
| personAssociate/assocType | listAny | x | |
| personAssociate/ejUserId | int | ||
| personAssociate/simultaneousEjUser | bool | ||
| personAssociate/ejDisplayName | string | x | |
| personAssociate/ejStatus | int | ||
| personAssociate/credentialType | None | x | |
| personAssociate/credentialDisplayValue | None | x | |
| personAssociate/isActive | bool | x | |
| personAssociate/isActiveText | bool | x | |
| personAssociate/portraitThumbnail | None | ||
| personAssociate/otherGroups | userGroup | ||
| personAssociate/userName | string | x | |
| personAssociate/personEmail | string | x | |
| personAssociate/locationAddress | string | x | |
| personAssociate/isLocation | bool | x | |
| correspondingAssociate/firstName | string | x | |
| correspondingAssociate/lastName | string | x | |
| correspondingAssociate/middleName | string | x | |
| correspondingAssociate/fullName | string | x | |
| correspondingAssociate/contactId | int | ||
| correspondingAssociate/personId | int | ||
| correspondingAssociate/mrMrs | string | x | |
| correspondingAssociate/title | string | x | |
| correspondingAssociate/associateDbId | associate | x | |
| correspondingAssociate/contactName | string | x | |
| correspondingAssociate/contactDepartment | string | x | |
| correspondingAssociate/usergroup | userGroup | x | |
| correspondingAssociate/usergroupId | int | x | |
| correspondingAssociate/contactFullName | string | x | |
| correspondingAssociate/contactCategory | listAny | x | |
| correspondingAssociate/role | listAny | x | |
| correspondingAssociate/assocName | associate | x | |
| correspondingAssociate/assocTooltip | string | ||
| correspondingAssociate/assocType | listAny | x | |
| correspondingAssociate/ejUserId | int | ||
| correspondingAssociate/simultaneousEjUser | bool | ||
| correspondingAssociate/ejDisplayName | string | x | |
| correspondingAssociate/ejStatus | int | ||
| correspondingAssociate/credentialType | None | x | |
| correspondingAssociate/credentialDisplayValue | None | x | |
| correspondingAssociate/isActive | bool | x | |
| correspondingAssociate/isActiveText | bool | x | |
| correspondingAssociate/portraitThumbnail | None | ||
| correspondingAssociate/otherGroups | userGroup | ||
| correspondingAssociate/userName | string | x | |
| correspondingAssociate/personEmail | string | x | |
| correspondingAssociate/locationAddress | string | x | |
| correspondingAssociate/isLocation | bool | x | |
| linkClicked/linkId | int | ||
| linkClicked/shipmentId | int | ||
| formSubmission/formSubmissionId | int | x | |
| formSubmission/formSubmissionFormId | int | x | |
| formSubmission/formSubmissionName | string | x | |
| formSubmission/formSubmissionStatus | listAny | x | |
| formSubmission/formSubmissionEmail | string | x | |
| formSubmission/icon | None | x | |
| formSubmission/date | date | x | |
| formSubmission/time | None | ||
| formSubmission/type | listAny | x | |
| formSubmission/text | positiveString | x | |
| formSubmission/associateId | associate | x | |
| formSubmission/contactId | listAny | x | |
| formSubmission/personId | listAny | x | |
| formSubmission/updatedBy | associate | x | |
| formSubmission/updatedDate | date | x | |
| formSubmission/registeredBy | associate | x | |
| formSubmission/registeredDate | date | x | |
| formSubmission/recordTypeText | None | x | |
| workflowInstance/workflowInstanceId | int | x | |
| workflowInstance/workflowInstanceStatus | listAny | x | |
| workflowInstance/workflowInstanceWaitUntil | date | x | |
| workflowInstance/workflowInstanceStepStarted | date | x | |
| workflowInstance/workflowInstanceCurrentStepDescription | None | ||
| workflowInstance/workflowInstanceCurrentStepId | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| workflowInstance/workflowInstanceLastCommunicationStepDescription | None | ||
| workflowInstance/workflowInstanceDropoutReason | string | ||
| workflowInstance/workflowInstanceLastCommunicationBounceInfo | None | ||
| workflowInstance/workflowInstanceLastCommunicationTime | datetime | x | |
| workflowInstance/workflowInstanceLastCommunicationStatus | listAny | x | |
| workflowInstance/updatedBy | associate | x | |
| workflowInstance/updatedDate | date | x | |
| workflowInstance/registeredBy | associate | x | |
| workflowInstance/registeredDate | date | x | |
| workflowInstance/emailFlow/emailFlowId | int | x | |
| workflowInstance/emailFlow/emailFlowHierarchyId | int | x | |
| workflowInstance/emailFlow/shipmentType | listAny | x | |
| workflowInstance/emailFlow/overrideConsentSubscription | bool | x | |
| workflowInstance/emailFlow/thumbnail | None | ||
| workflowInstance/emailFlow/mediumThumbnail | None | ||
| workflowInstance/emailFlow/workflowId | int | x | |
| workflowInstance/emailFlow/workflowName | string | x | |
| workflowInstance/emailFlow/workflowDescription | string | x | |
| workflowInstance/emailFlow/workflowDefinitionStatus | listAny | x | |
| workflowInstance/emailFlow/workflowDefinitionStatusId | listAny | x | |
| workflowInstance/emailFlow/jumpToFinish | bool | x | |
| workflowInstance/emailFlow/startOnlyOnce | bool | x | |
| workflowInstance/emailFlow/workflowEnrolledCount | None | ||
| workflowInstance/emailFlow/workflowInProgressCount | None | ||
| workflowInstance/emailFlow/workflowCompletedCount | None | ||
| workflowInstance/emailFlow/workflowSucceededCount | None | ||
| workflowInstance/emailFlow/workflowSuccessRate | None | ||
| workflowInstance/emailFlow/updatedBy | associate | x | |
| workflowInstance/emailFlow/updatedDate | date | x | |
| workflowInstance/emailFlow/registeredBy | associate | x | |
| workflowInstance/emailFlow/registeredDate | date | x | |
| chatSession/chatSessionId | int | x | |
| chatSession/firstMessage | string | x | |
| chatSession/lastMessage | string | x | |
| chatSession/whenRequested | datetime | x | |
| chatSession/whenStarted | datetime | x | |
| chatSession/whenEnded | datetime | x | |
| chatSession/duration | timeSpan | ||
| chatSession/timeInQueue | timeSpan | x | |
| chatSession/queueLength | int | x | |
| chatSession/rating | int | x | |
| chatSession/agent | ejUser | x | |
| chatSession/status | listAny | x | |
| chatSession/icon | None | x | |
| chatSession/date | date | x | |
| chatSession/type | listAny | x | |
| chatSession/text | positiveString | x | |
| chatSession/associateId | associate | x | |
| chatSession/contactId | listAny | x | |
| chatSession/personId | listAny | x | |
| chatSession/updatedDate | date | x | |
| chatSession/registeredDate | date | x | |
| chatSession/recordTypeText | None | x | |
| chatSession/chatTopic/chatTopicId | int | x | |
| chatSession/chatTopic/name | string | x | |
| chatSession/chatTopic/description | string | x | |
| chatSession/chatTopic/badgeHeader | string | x | |
| isMailingRecipient | bool | x | |
| hasStoreConsent | bool | ||
| withdrawnStoreConsent | bool | ||
| hasEmarketingConsent | bool | ||
| withdrawnEmarketingConsent | bool | ||
| subscription | listAny | x | |
| legalBaseStore | listAny | x | |
| legalBaseEmarketing | listAny | x | |
| consentSourceStore | listAny | x | |
| consentSourceEmarketing | listAny | x | |
| request/contactId | int | x | |
| request/personId | int | x | |
| request/saleId | int | x | |
| request/projectId | int | x | |
| request/ticketStatusId | int | x | |
| request/priorityId | int | x | |
| request/categoryId | int | x | |
| request/ticketTypeName | listAny | x | |
| request/ticketStatusName | listAny | x | |
| request/categoryFullName | ejCategory | x | |
| request/priorityName | listAny | x | |
| request/ownedBy | ejUser | x | |
| request/ticketId | int | x | |
| request/title | string | x | |
| request/createdAt | datetime | x | |
| request/createdDate | date | x | |
| request/lastChanged | datetime | x | |
| request/author | string | x | |
| request/readByOwner | datetime | x | |
| request/firstReadByOwner | datetime | x | |
| request/firstReadByUser | datetime | x | |
| request/readByCustomer | datetime | x | |
| request/status | listAny | x | |
| request/origin | listAny | x | |
| request/slevel | listAny | x | |
| request/numberOfMessages | int | x | |
| request/numberOfReplies | int | x | |
| request/connectId | int | x | |
| request/readStatus | listAny | x | |
| request/realTimeSpentQueue | timeSpan | x | |
| request/realTimeSpentExternally | timeSpan | x | |
| request/realTimeSpentInternally | timeSpan | x | |
| request/timeSpentQueue | timeSpan | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| request/timeSpentExternally | timeSpan | x | |
| request/timeSpentInternally | timeSpan | x | |
| request/timeSpent | timeSpan | x | |
| request/timeToReply | timeSpan | x | |
| request/timeToClose | timeSpan | x | |
| request/realTimeToReply | timeSpan | x | |
| request/realTimeToClose | timeSpan | x | |
| request/repliedAt | datetime | x | |
| request/closedAt | datetime | x | |
| request/activated | datetime | x | |
| request/deadline | datetime | x | |
| request/has_attachment | bool | x | |
| request/tags | intArray | x | |
| request/createdBy | ejUser | x | |
| request/content | string | x | |
| request/messageLanguage | listAny | ||
| request/sentimentScore | listAny | ||
| request/sentimentConfidence | int | x | |
| request/suggestedCategory | listAny | ||
| request/createdByWorkflow | listAny | x | |
| request/createdBy/firstName | string | x | |
| request/createdBy/lastName | string | x | |
| request/createdBy/middleName | string | x | |
| request/createdBy/fullName | string | x | |
| request/createdBy/contactId | int | ||
| request/createdBy/personId | int | ||
| request/createdBy/mrMrs | string | x | |
| request/createdBy/title | string | x | |
| request/createdBy/associateDbId | associate | x | |
| request/createdBy/contactName | string | x | |
| request/createdBy/contactDepartment | string | x | |
| request/createdBy/usergroup | userGroup | x | |
| request/createdBy/usergroupId | int | x | |
| request/createdBy/contactFullName | string | x | |
| request/createdBy/contactCategory | listAny | x | |
| request/createdBy/role | listAny | x | |
| request/createdBy/assocName | associate | x | |
| request/createdBy/assocTooltip | string | ||
| request/createdBy/assocType | listAny | x | |
| request/createdBy/ejUserId | int | ||
| request/createdBy/simultaneousEjUser | bool | ||
| request/createdBy/ejDisplayName | string | x | |
| request/createdBy/ejStatus | int | ||
| request/createdBy/credentialType | None | x | |
| request/createdBy/credentialDisplayValue | None | x | |
| request/createdBy/isActive | bool | x | |
| request/createdBy/isActiveText | bool | x | |
| request/createdBy/portraitThumbnail | None | ||
| request/createdBy/otherGroups | userGroup | ||
| request/createdBy/userName | string | x | |
| request/createdBy/personEmail | string | x | |
| request/createdBy/locationAddress | string | x | |
| request/createdBy/isLocation | bool | x | |
| request/ownedBy/firstName | string | x | |
| request/ownedBy/lastName | string | x | |
| request/ownedBy/middleName | string | x | |
| request/ownedBy/fullName | string | x | |
| request/ownedBy/contactId | int | ||
| request/ownedBy/personId | int | ||
| request/ownedBy/mrMrs | string | x | |
| request/ownedBy/title | string | x | |
| request/ownedBy/associateDbId | associate | x | |
| request/ownedBy/contactName | string | x | |
| request/ownedBy/contactDepartment | string | x | |
| request/ownedBy/usergroup | userGroup | x | |
| request/ownedBy/usergroupId | int | x | |
| request/ownedBy/contactFullName | string | x | |
| request/ownedBy/contactCategory | listAny | x | |
| request/ownedBy/role | listAny | x | |
| request/ownedBy/assocName | associate | x | |
| request/ownedBy/assocTooltip | string | ||
| request/ownedBy/assocType | listAny | x | |
| request/ownedBy/ejUserId | int | ||
| request/ownedBy/simultaneousEjUser | bool | ||
| request/ownedBy/ejDisplayName | string | x | |
| request/ownedBy/ejStatus | int | ||
| request/ownedBy/credentialType | None | x | |
| request/ownedBy/credentialDisplayValue | None | x | |
| request/ownedBy/isActive | bool | x | |
| request/ownedBy/isActiveText | bool | x | |
| request/ownedBy/portraitThumbnail | None | ||
| request/ownedBy/otherGroups | userGroup | ||
| request/ownedBy/userName | string | x | |
| request/ownedBy/personEmail | string | x | |
| request/ownedBy/locationAddress | string | x | |
| request/ownedBy/isLocation | bool | x | |
| request/ticketStatus/ticketStatusId | int | x | |
| request/ticketStatus/name | string | x | |
| request/ticketStatus/rank | int | x | |
| request/ticketPriority/ticketPriorityId | int | x | |
| request/ticketPriority/name | string | x | |
| request/ticketPriority/rank | int | x | |
| request/extra/x_ticket_integer | int | x | |
| request/extra/x_ticket_float | decimal | x | |
| request/extra/x_ticket_longtext | string | x | |
| request/extra/x_ticket_date | date | x | |
| request/extra/x_ticket_datetime | datetime | x | |
| request/extra/x_ticket_time | None | x | |
| request/extra/x_ticket_boolean | bool | x | |
| request/extra/x_ticket_timespan | timeSpan | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| request/extra/x_ticket_short_text | string | x | |
| request/extra/x_ticket_shorttext_list | listAny | x | |
| request/extra/x_ticket_timestamp | datetime | x | |
| request/extra/x_ticket_project_relation | stringorPK | x | |
| request/extra/x_ticket_faq | stringorPK | x | |
| request/extra/x_ticket_category_relation | listAny | x | |
| request/extra/y_equipment/x_name | string | x | |
| request/extra/y_car/id | int | x | |
| projectMembers/completed | bool | x | |
| projectMembers/projectId | int | x | |
| projectMembers/name | stringorPK | x | |
| projectMembers/number | string | x | |
| projectMembers/type | listAny | x | |
| projectMembers/status | listAny | x | |
| projectMembers/statusRank | None | x | |
| projectMembers/associateId | associate | x | |
| projectMembers/hasInfoText | bool | x | |
| projectMembers/icon | None | x | |
| projectMembers/text | string | x | |
| projectMembers/description | string | x | |
| projectMembers/updatedBy | associate | x | |
| projectMembers/updatedByFullName | associate | x | |
| projectMembers/updatedDate | date | x | |
| projectMembers/registeredBy | associate | x | |
| projectMembers/registeredByFullName | associate | x | |
| projectMembers/registeredDate | date | x | |
| projectMembers/hasGuide | bool | x | |
| projectMembers/nextMilestone | date | x | |
| projectMembers/endDate | date | x | |
| projectMembers/imageThumbnail | None | ||
| projectMembers/activeErpLinks | bool | x | |
| projectMembers/eventId | int | x | |
| projectMembers/startDate | date | x | |
| projectMembers/function | listAny | x | |
| projectMembers/eventParticipantStatus | listAny | x | |
| projectMembers/projectPublish/isPublished | bool | x | |
| projectMembers/projectPublish/publishedFrom | date | x | |
| projectMembers/projectPublish/publishedTo | date | x | |
| projectMembers/projectPublish/publishedBy | None | ||
| projectMembers/projectEvent/isExternalEvent | bool | x | |
| projectMembers/projectEvent/eventDate | date | x | |
| projectMembers/projectEvent/hasSignOn | bool | x | |
| projectMembers/projectEvent/hasSignOff | bool | x | |
| projectMembers/projectUrl/URLAddress | string | x | |
| projectMembers/projectUrl/URLDescription | string | x | |
| projectMembers/projectAssociate/firstName | string | x | |
| projectMembers/projectAssociate/lastName | string | x | |
| projectMembers/projectAssociate/middleName | string | x | |
| projectMembers/projectAssociate/fullName | string | x | |
| projectMembers/projectAssociate/contactId | int | ||
| projectMembers/projectAssociate/personId | int | ||
| projectMembers/projectAssociate/mrMrs | string | x | |
| projectMembers/projectAssociate/title | string | x | |
| projectMembers/projectAssociate/associateDbId | associate | x | |
| projectMembers/projectAssociate/contactName | string | x | |
| projectMembers/projectAssociate/contactDepartment | string | x | |
| projectMembers/projectAssociate/usergroup | userGroup | x | |
| projectMembers/projectAssociate/usergroupId | int | x | |
| projectMembers/projectAssociate/contactFullName | string | x | |
| projectMembers/projectAssociate/contactCategory | listAny | x | |
| projectMembers/projectAssociate/role | listAny | x | |
| projectMembers/projectAssociate/assocName | associate | x | |
| projectMembers/projectAssociate/assocTooltip | string | ||
| projectMembers/projectAssociate/assocType | listAny | x | |
| projectMembers/projectAssociate/ejUserId | int | ||
| projectMembers/projectAssociate/simultaneousEjUser | bool | ||
| projectMembers/projectAssociate/ejDisplayName | string | x | |
| projectMembers/projectAssociate/ejStatus | int | ||
| projectMembers/projectAssociate/credentialType | None | x | |
| projectMembers/projectAssociate/credentialDisplayValue | None | x | |
| projectMembers/projectAssociate/isActive | bool | x | |
| projectMembers/projectAssociate/isActiveText | bool | x | |
| projectMembers/projectAssociate/portraitThumbnail | None | ||
| projectMembers/projectAssociate/otherGroups | userGroup | ||
| projectMembers/projectAssociate/userName | string | x | |
| projectMembers/projectAssociate/personEmail | string | x | |
| projectMembers/projectAssociate/locationAddress | string | x | |
| projectMembers/projectAssociate/isLocation | bool | x | |
| projectMembers/projectUdef/SuperOffice:1 | string | x | |
| projectMembers/projectUdef/SuperOffice:2 | string | x | |
| projectMembers/projectUdef/SuperOffice:3 | int | x | |
| projectMembers/projectUdef/SuperOffice:4 | date | x | |
| projectMembers/projectUdef/SuperOffice:5 | unlimitedDate | x | |
| projectMembers/projectUdef/SuperOffice:6 | bool | x | |
| projectMembers/projectUdef/SuperOffice:7 | listAny | x | |
| projectMembers/projectUdef/SuperOffice:8 | decimal | x | |
| projectMembers/projectUdef/SuperOffice:9 | int | x | |
| projectMembers/projectUdef/SuperOffice:10 | int | x | |
| projectMembers/NumberOfActivities | int | ||
| projectMembers/NumberOfActivitiesInPeriod | int | ||
| projectMembers/NumberOfNotCompletedActivities | int | ||
| projectMembers/NumberOfNotCompletedActivitiesInPeriod | int | ||
| projectMembers/LastActivity | date | ||
| projectMembers/LastCompletedActivity | date | ||
| projectMembers/LastDoByActivity | date | ||
| projectMembers/NumberOfSales | int | ||
| projectMembers/NumberOfSalesInPeriod | int | ||
| projectMembers/NumberOfNotCompletedSales | int | ||
| projectMembers/NumberOfNotCompletedSalesInPeriod | int | ||
| projectMembers/LastSale | date |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| projectMembers/LastCompletedSale | date | ||
| projectMembers/LastDoBySale | date | ||
| projectMembers/SaintStatus3 | saintStatus | ||
| projectMembers/saintSaleStatus | listAny | ||
| projectMembers/saintAmountClass | listAny | ||
| projectMembers/saintActivityType | listAny | ||
| projectMembers/saintDirection | listAny | ||
| projectMembers/saintIntention | listAny | ||
| projectMembers/saintTicketStatus | listAny | ||
| projectMembers/saintTicketCategory | listAny | ||
| projectMembers/project/textId | int | x | |
| projectMembers/project/infoText | positiveString | x | |
| personAppointment/completed | bool | x | |
| personAppointment/icon | listAny | x | |
| personAppointment/date | date | x | |
| personAppointment/time | None | ||
| personAppointment/type | listAny | x | |
| personAppointment/recordType | string | x | |
| personAppointment/text | positiveString | x | |
| personAppointment/associateId | associate | x | |
| personAppointment/contactId | listAny | x | |
| personAppointment/personId | listAny | x | |
| personAppointment/projectId | listAny | x | |
| personAppointment/saleId | int | x | |
| personAppointment/userGroup | userGroup | x | |
| personAppointment/who | None | ||
| personAppointment/updatedBy | associate | x | |
| personAppointment/updatedByFullName | associate | x | |
| personAppointment/updatedDate | date | x | |
| personAppointment/registeredBy | associate | x | |
| personAppointment/registeredByFullName | associate | x | |
| personAppointment/registeredDate | date | x | |
| personAppointment/appointmentId | int | x | |
| personAppointment/endDate | date | x | |
| personAppointment/priority | listAny | x | |
| personAppointment/alarm | bool | x | |
| personAppointment/isFree | bool | x | |
| personAppointment/recurring | bool | x | |
| personAppointment/booking | bool | x | |
| personAppointment/excludeParticipants | bool | ||
| personAppointment/intention | listAny | x | |
| personAppointment/location | string | x | |
| personAppointment/recurrenceRuleId | int | x | |
| personAppointment/rawType | int | x | |
| personAppointment/rawStatus | int | x | |
| personAppointment/cautionWarning | listAny | x | |
| personAppointment/visibleInDiary | bool | x | |
| personAppointment/endTime | None | ||
| personAppointment/suggestedAppointmentId | int | x | |
| personAppointment/completedDate | date | x | |
| personAppointment/isMilestone | bool | x | |
| personAppointment/invitedPersonId | int | x | |
| personAppointment/recordTypeText | listAny | x | |
| personAppointment/joinVideomeetUrl | None | x | |
| personAppointment/duration | timeSpan | ||
| personAppointment/createdByWorkflow | listAny | x | |
| personAppointment/colorIndex | listAny | x | |
| personAppointment/visibleFor | listAny | ||
| personAppointment/appointmentPublish/isPublished | bool | x | |
| personAppointment/appointmentPublish/publishedFrom | date | x | |
| personAppointment/appointmentPublish/publishedTo | date | x | |
| personAppointment/appointmentPublish/publishedBy | None | ||
| personAppointment/appointmentUdef/SuperOffice:1 | string | x | |
| personAppointment/appointmentUdef/SuperOffice:2 | string | x | |
| personAppointment/appointmentUdef/SuperOffice:3 | int | x | |
| personAppointment/appointmentUdef/SuperOffice:4 | date | x | |
| personAppointment/appointmentUdef/SuperOffice:5 | unlimitedDate | x | |
| personAppointment/appointmentUdef/SuperOffice:6 | bool | x | |
| personAppointment/appointmentUdef/SuperOffice:7 | listAny | x | |
| personAppointment/appointmentUdef/SuperOffice:8 | decimal | x | |
| personAppointment/associate/firstName | string | x | |
| personAppointment/associate/lastName | string | x | |
| personAppointment/associate/middleName | string | x | |
| personAppointment/associate/fullName | string | x | |
| personAppointment/associate/contactId | int | ||
| personAppointment/associate/personId | int | ||
| personAppointment/associate/mrMrs | string | x | |
| personAppointment/associate/title | string | x | |
| personAppointment/associate/associateDbId | associate | x | |
| personAppointment/associate/contactName | string | x | |
| personAppointment/associate/contactDepartment | string | x | |
| personAppointment/associate/usergroup | userGroup | x | |
| personAppointment/associate/usergroupId | int | x | |
| personAppointment/associate/contactFullName | string | x | |
| personAppointment/associate/contactCategory | listAny | x | |
| personAppointment/associate/role | listAny | x | |
| personAppointment/associate/assocName | associate | x | |
| personAppointment/associate/assocTooltip | string | ||
| personAppointment/associate/assocType | listAny | x | |
| personAppointment/associate/ejUserId | int | ||
| personAppointment/associate/simultaneousEjUser | bool | ||
| personAppointment/associate/ejDisplayName | string | x | |
| personAppointment/associate/ejStatus | int | ||
| personAppointment/associate/credentialType | None | x | |
| personAppointment/associate/credentialDisplayValue | None | x | |
| personAppointment/associate/isActive | bool | x | |
| personAppointment/associate/isActiveText | bool | x | |
| personAppointment/associate/portraitThumbnail | None | ||
| personAppointment/associate/otherGroups | userGroup | ||
| personAppointment/associate/userName | string | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| personAppointment/associate/personEmail | string | x | |
| personAppointment/associate/locationAddress | string | x | |
| personAppointment/associate/isLocation | bool | x | |
| personAppointment/appointment/text | positiveString | x | |
| personAppointment/appointment/description | positiveString | x | |
| personAppointment/appointment/title | positiveString | x | |
| personAppointment/appointment/titleHtml | None | x | |
| personAppointment/appointment/agenda | positiveString | x | |
| personAppointment/appointment/agendaHtml | None | x | |
| personAppointment/appointment/isConverted | None | ||
| personAppointment/appointment/textId | int | x | |
| personAppointment/appointment/internalNotes | positiveString | x | |
| personAppointment/appointment/internalNotesHtml | positiveString | x | |
| fullNameWithContact | None | x | |
| selectionMemberId | int | ||
| selectionIdRequest | int | ||
| sale/quote/quoteId | int | x | |
| sale/quote/poNumber | string | x | |
| sale/quote/orderComment | string | x | |
| sale/quote/connectionId | int | x | |
| sale/quote/registeredDate | date | x | |
| sale/quote/version/quoteVersionId | int | x | |
| sale/quote/version/description | string | x | |
| sale/quote/version/number | string | x | |
| sale/quote/version/sent | date | x | |
| sale/quote/version/expiration | date | x | |
| sale/quote/version/state | listAny | x | |
| sale/quote/version/status | listAny | x | |
| sale/quote/version/reason | string | x | |
| sale/quote/version/paymentTerms | listExternal | ||
| sale/quote/version/paymentType | listExternal | ||
| sale/quote/version/deliveryTerms | listExternal | ||
| sale/quote/version/deliveryType | listExternal | ||
| sale/quote/version/approvedBy | associate | x | |
| sale/quote/version/approvalRegisteredBy | associate | x | |
| sale/quote/version/approvedText | string | x | |
| sale/quote/version/approvedDate | date | x | |
| sale/quote/version/extraField1 | string | x | |
| sale/quote/version/extraField2 | string | x | |
| sale/quote/version/extraField3 | string | x | |
| sale/quote/version/extraField4 | string | x | |
| sale/quote/version/extraField5 | string | x | |
| sale/quote/version/alternative/quoteAlternativeId | int | x | |
| sale/quote/version/alternative/quoteVersionId | int | x | |
| sale/quote/version/alternative/name | string | x | |
| sale/quote/version/alternative/description | string | x | |
| sale/quote/version/alternative/status | listAny | x | |
| sale/quote/version/alternative/reason | string | x | |
| sale/quote/version/alternative/erpDiscountPercent | decimal | x | |
| sale/quote/version/alternative/erpDiscountAmount | decimal | x | |
| sale/quote/version/alternative/discountPercent | decimal | x | |
| sale/quote/version/alternative/discountAmount | decimal | x | |
| sale/quote/version/alternative/vatInfo | string | x | |
| sale/quote/version/alternative/vat | decimal | x | |
| sale/quote/version/alternative/earningPercent | decimal | x | |
| sale/quote/version/alternative/earningAmount | decimal | x | |
| sale/quote/version/alternative/totalPrice | decimal | x | |
| sale/quote/version/alternative/extraField1 | string | x | |
| sale/quote/version/alternative/extraField2 | string | x | |
| sale/quote/version/alternative/extraField3 | string | x | |
| sale/quote/version/alternative/extraField4 | string | x | |
| sale/quote/version/alternative/extraField5 | string | x | |
| sale/quote/version/alternative/alternativeOrdering | int | x | |
| sale/quote/version/alternative/subTotal | decimal | x | |
| sale/quote/version/alternative/totalPriceIncVAT | decimal | x | |
| sale/quote/version/alternative/vatAmount | decimal | x | |
| sale/quote/version/alternative/quoteline/quoteLineId | int | x | |
| sale/quote/version/alternative/quoteline/quoteAlternativeId | int | x | |
| sale/quote/version/alternative/quoteline/erpProductKey | string | x | |
| sale/quote/version/alternative/quoteline/rank | int | x | |
| sale/quote/version/alternative/quoteline/quantity | decimal | x | |
| sale/quote/version/alternative/quoteline/name | string | x | |
| sale/quote/version/alternative/quoteline/description | string | x | |
| sale/quote/version/alternative/quoteline/code | string | x | |
| sale/quote/version/alternative/quoteline/quantityUnit | string | x | |
| sale/quote/version/alternative/quoteline/priceUnit | string | x | |
| sale/quote/version/alternative/quoteline/url | string | x | |
| sale/quote/version/alternative/quoteline/subscriptionUnit | string | x | |
| sale/quote/version/alternative/quoteline/subscriptionQuantity | decimal | x | |
| sale/quote/version/alternative/quoteline/UnitListPriceSubscriptionQuantity | None | ||
| sale/quote/version/alternative/quoteline/PriceUnitSubscriptionUnit | None | ||
| sale/quote/version/alternative/quoteline/PriceUnitSubscriptionQuantityUnit | None | ||
| sale/quote/version/alternative/quoteline/vatInfo | string | x | |
| sale/quote/version/alternative/quoteline/vat | decimal | x | |
| sale/quote/version/alternative/quoteline/unitCost | decimal | x | |
| sale/quote/version/alternative/quoteline/unitMinimumPrice | decimal | x | |
| sale/quote/version/alternative/quoteline/unitListPrice | decimal | x | |
| sale/quote/version/alternative/quoteline/totalPrice | decimal | x | |
| sale/quote/version/alternative/quoteline/totalCost | decimal | x | |
| sale/quote/version/alternative/quoteline/quoteLineThumbnail | None | ||
| sale/quote/version/alternative/quoteline/quoteLineThumbnailLarge | None | ||
| sale/quote/version/alternative/quoteline/discountAmount | decimal | x | |
| sale/quote/version/alternative/quoteline/discountPercent | decimal | x | |
| sale/quote/version/alternative/quoteline/earningAmount | decimal | x | |
| sale/quote/version/alternative/quoteline/earningPercent | decimal | x | |
| sale/quote/version/alternative/quoteline/updatedBy | associate | x | |
| sale/quote/version/alternative/quoteline/updatedByFullName | associate | x | |
| sale/quote/version/alternative/quoteline/updatedDate | date | x | |
| sale/quote/version/alternative/quoteline/registeredBy | associate | x | |
| sale/quote/version/alternative/quoteline/registeredByFullName | associate | x |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| sale/quote/version/alternative/quoteline/registeredDate | date | x | |
| sale/quote/version/alternative/quoteline/productCategoryKey | listExternal | x | |
| sale/quote/version/alternative/quoteline/productFamilyKey | listExternal | x | |
| sale/quote/version/alternative/quoteline/productTypeKey | listExternal | x | |
| sale/quote/version/alternative/quoteline/status | listAny | x | |
| sale/quote/version/alternative/quoteline/subTotal | decimal | x | |
| sale/quote/version/alternative/quoteline/vatAmount | decimal | x | |
| sale/quote/version/alternative/quoteline/totalPriceIncVAT | decimal | x | |
| sale/quote/version/alternative/quoteline/totalPriceWithAlternativeDiscount | decimal | x |
Sample
GET /api/v1/archive/ContactPersonDynamicSelectionV2?$select=postAddress/county,contactAssociate/ejDisplayName,sourceRelation/country,appointment/associate/portraitThumbnail,appointment/appointment/agendaHtml
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv