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