“ProjectGuide”
This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.ProjectGuideProvider inside NetServer’s SODatabase assembly. Provider for the Project Guide, common to both Appointment and Document guide items and instances This provider is a trivial aggregation of the Appointment and Document providersSupported Entities
| Name | Description |
|---|---|
| ”suggestedAppointment" | |
| "onlyInstance" | |
| "appointment" | |
| "milestone" | |
| "suggestedDocument" | |
| "document” |
Supported Columns
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| getAllRows | bool | ||
| getNoRows | bool | ||
| projectId | int | x | |
| milestone | None | ||
| completed | bool | x | |
| date | date | x | |
| text | string | x | |
| stageName | string | x | |
| stageId | int | x | |
| stageOrderBy | int | x | |
| suggestedItemId | int | x | |
| suggestedItemText | string | x | |
| suggestedItemOrderBy | int | x | |
| suggestedItemTooltip | string | x | |
| instanceItemId | None | ||
| instanceItemText | None | ||
| hasInstance | None | ||
| deleted | bool | x | |
| isMilestone | None | ||
| appointmentInstance/completed | None | ||
| appointmentInstance/icon | None | ||
| appointmentInstance/date | None | ||
| appointmentInstance/time | None | ||
| appointmentInstance/type | None | ||
| appointmentInstance/recordType | None | ||
| appointmentInstance/text | None | ||
| appointmentInstance/associateId | None | ||
| appointmentInstance/contactId | None | ||
| appointmentInstance/personId | None | ||
| appointmentInstance/projectId | None | ||
| appointmentInstance/saleId | None | ||
| appointmentInstance/userGroup | None | ||
| appointmentInstance/who | None | ||
| appointmentInstance/updatedBy | None | ||
| appointmentInstance/updatedByFullName | None | ||
| appointmentInstance/updatedDate | None | ||
| appointmentInstance/registeredBy | None | ||
| appointmentInstance/registeredByFullName | None | ||
| appointmentInstance/registeredDate | None | ||
| appointmentInstance/appointmentId | None | ||
| appointmentInstance/endDate | None | ||
| appointmentInstance/priority | None | ||
| appointmentInstance/alarm | None | ||
| appointmentInstance/isFree | None | ||
| appointmentInstance/recurring | None | ||
| appointmentInstance/booking | None | ||
| appointmentInstance/excludeParticipants | None | ||
| appointmentInstance/intention | None | ||
| appointmentInstance/location | None | ||
| appointmentInstance/recurrenceRuleId | None | ||
| appointmentInstance/rawType | None | ||
| appointmentInstance/rawStatus | None | ||
| appointmentInstance/cautionWarning | None | ||
| appointmentInstance/visibleInDiary | None | ||
| appointmentInstance/endTime | None | ||
| appointmentInstance/suggestedAppointmentId | None | ||
| appointmentInstance/completedDate | None | ||
| appointmentInstance/isMilestone | None | ||
| appointmentInstance/invitedPersonId | None | ||
| appointmentInstance/recordTypeText | None | ||
| appointmentInstance/joinVideomeetUrl | None | ||
| appointmentInstance/duration | None | ||
| appointmentInstance/createdByWorkflow | None | ||
| appointmentInstance/colorIndex | None | ||
| appointmentInstance/visibleFor | None | ||
| appointmentInstance/appointmentPublish/isPublished | None | ||
| appointmentInstance/appointmentPublish/publishedFrom | None | ||
| appointmentInstance/appointmentPublish/publishedTo | None | ||
| appointmentInstance/appointmentPublish/publishedBy | None | ||
| appointmentInstance/contact/contactId | None | ||
| appointmentInstance/contact/name | None | ||
| appointmentInstance/contact/department | None | ||
| appointmentInstance/contact/nameDepartment | None | ||
| appointmentInstance/contact/hasInfoText | None | ||
| appointmentInstance/contact/hasInterests | None | ||
| appointmentInstance/contact/associateId | None | ||
| appointmentInstance/contact/category | None | ||
| appointmentInstance/contact/categoryGroup | None | ||
| appointmentInstance/contact/companyCategoryRank | None | ||
| appointmentInstance/contact/business | None | ||
| appointmentInstance/contact/country | None | ||
| appointmentInstance/contact/countryId | None | ||
| appointmentInstance/contact/number | None | ||
| appointmentInstance/contact/code | None | ||
| appointmentInstance/contact/orgnr | None | ||
| appointmentInstance/contact/stop | None | ||
| appointmentInstance/contact/contactNoMail | None | ||
| appointmentInstance/contact/updatedBy | None | ||
| appointmentInstance/contact/updatedByFullName | None | ||
| appointmentInstance/contact/updatedDate | None | ||
| appointmentInstance/contact/registeredBy | None | ||
| appointmentInstance/contact/registeredByFullName | None | ||
| appointmentInstance/contact/registeredDate | None | ||
| appointmentInstance/contact/contactSource | None | ||
| appointmentInstance/contact/contactDeleted | None | ||
| appointmentInstance/contact/phone/formattedNumber | None | ||
| appointmentInstance/contact/activeErpLinks | None | ||
| appointmentInstance/contact/numEmployees | None | ||
| appointmentInstance/contact/yearFounded | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/contact/revenueYear | None | ||
| appointmentInstance/contact/revenueBasecurrency | None | ||
| appointmentInstance/contact/sharecapitalBasecurrency | None | ||
| appointmentInstance/contact/sourcedFrom | None | ||
| appointmentInstance/contact/linkedinUrl | None | ||
| appointmentInstance/contact/deletedDate | None | ||
| appointmentInstance/contact/mainContact | None | ||
| appointmentInstance/contact/forceCompany | None | ||
| appointmentInstance/contact/contactPhone/formattedNumber | None | ||
| appointmentInstance/contact/contactPhone/description | None | ||
| appointmentInstance/contact/contactFax/formattedNumber | None | ||
| appointmentInstance/contact/contactFax/description | None | ||
| appointmentInstance/contact/searchPhone/formattedNumber | None | ||
| appointmentInstance/contact/searchPhone/description | None | ||
| appointmentInstance/contact/email/emailProtocol | None | ||
| appointmentInstance/contact/email/emailAddress | None | ||
| appointmentInstance/contact/email/emailDescription | None | ||
| appointmentInstance/contact/email/emailId | None | ||
| appointmentInstance/contact/email/emailLastSent | None | ||
| appointmentInstance/contact/email/emailBounceCount | None | ||
| appointmentInstance/contact/email/emailLastBounce | None | ||
| appointmentInstance/contact/email/emailHasBounced | None | ||
| appointmentInstance/contact/postAddress/addressId | None | ||
| appointmentInstance/contact/postAddress/line1 | None | ||
| appointmentInstance/contact/postAddress/line2 | None | ||
| appointmentInstance/contact/postAddress/line3 | None | ||
| appointmentInstance/contact/postAddress/county | None | ||
| appointmentInstance/contact/postAddress/city | None | ||
| appointmentInstance/contact/postAddress/zip | None | ||
| appointmentInstance/contact/postAddress/state | None | ||
| appointmentInstance/contact/postAddress/wgs84latitude | None | ||
| appointmentInstance/contact/postAddress/wgs84longitude | None | ||
| appointmentInstance/contact/postAddress/formattedAddress | None | ||
| appointmentInstance/contact/postAddress/formattedMultiLineAddress | None | ||
| appointmentInstance/contact/streetAddress/addressId | None | ||
| appointmentInstance/contact/streetAddress/line1 | None | ||
| appointmentInstance/contact/streetAddress/line2 | None | ||
| appointmentInstance/contact/streetAddress/line3 | None | ||
| appointmentInstance/contact/streetAddress/county | None | ||
| appointmentInstance/contact/streetAddress/city | None | ||
| appointmentInstance/contact/streetAddress/zip | None | ||
| appointmentInstance/contact/streetAddress/state | None | ||
| appointmentInstance/contact/streetAddress/wgs84latitude | None | ||
| appointmentInstance/contact/streetAddress/wgs84longitude | None | ||
| appointmentInstance/contact/streetAddress/formattedAddress | None | ||
| appointmentInstance/contact/streetAddress/formattedMultiLineAddress | None | ||
| appointmentInstance/contact/restrictionAddress/addressId | None | ||
| appointmentInstance/contact/restrictionAddress/line1 | None | ||
| appointmentInstance/contact/restrictionAddress/line2 | None | ||
| appointmentInstance/contact/restrictionAddress/line3 | None | ||
| appointmentInstance/contact/restrictionAddress/county | None | ||
| appointmentInstance/contact/restrictionAddress/city | None | ||
| appointmentInstance/contact/restrictionAddress/zip | None | ||
| appointmentInstance/contact/restrictionAddress/state | None | ||
| appointmentInstance/contact/restrictionAddress/wgs84latitude | None | ||
| appointmentInstance/contact/restrictionAddress/wgs84longitude | None | ||
| appointmentInstance/contact/restrictionAddress/formattedAddress | None | ||
| appointmentInstance/contact/restrictionAddress/formattedMultiLineAddress | None | ||
| appointmentInstance/contact/url/URLAddress | None | ||
| appointmentInstance/contact/url/URLDescription | None | ||
| appointmentInstance/contact/contactAssociate/firstName | None | ||
| appointmentInstance/contact/contactAssociate/lastName | None | ||
| appointmentInstance/contact/contactAssociate/middleName | None | ||
| appointmentInstance/contact/contactAssociate/fullName | None | ||
| appointmentInstance/contact/contactAssociate/contactId | None | ||
| appointmentInstance/contact/contactAssociate/personId | None | ||
| appointmentInstance/contact/contactAssociate/mrMrs | None | ||
| appointmentInstance/contact/contactAssociate/title | None | ||
| appointmentInstance/contact/contactAssociate/associateDbId | None | ||
| appointmentInstance/contact/contactAssociate/contactName | None | ||
| appointmentInstance/contact/contactAssociate/contactDepartment | None | ||
| appointmentInstance/contact/contactAssociate/usergroup | None | ||
| appointmentInstance/contact/contactAssociate/usergroupId | None | ||
| appointmentInstance/contact/contactAssociate/contactFullName | None | ||
| appointmentInstance/contact/contactAssociate/contactCategory | None | ||
| appointmentInstance/contact/contactAssociate/role | None | ||
| appointmentInstance/contact/contactAssociate/assocName | None | ||
| appointmentInstance/contact/contactAssociate/assocTooltip | None | ||
| appointmentInstance/contact/contactAssociate/assocType | None | ||
| appointmentInstance/contact/contactAssociate/ejUserId | None | ||
| appointmentInstance/contact/contactAssociate/simultaneousEjUser | None | ||
| appointmentInstance/contact/contactAssociate/ejDisplayName | None | ||
| appointmentInstance/contact/contactAssociate/ejStatus | None | ||
| appointmentInstance/contact/contactAssociate/credentialType | None | ||
| appointmentInstance/contact/contactAssociate/credentialDisplayValue | None | ||
| appointmentInstance/contact/contactAssociate/isActive | None | ||
| appointmentInstance/contact/contactAssociate/isActiveText | None | ||
| appointmentInstance/contact/contactAssociate/portraitThumbnail | None | ||
| appointmentInstance/contact/contactAssociate/otherGroups | None | ||
| appointmentInstance/contact/contactAssociate/userName | None | ||
| appointmentInstance/contact/contactAssociate/personEmail | None | ||
| appointmentInstance/contact/contactAssociate/locationAddress | None | ||
| appointmentInstance/contact/contactAssociate/isLocation | None | ||
| appointmentInstance/contact/contactInterestIds | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:1 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:2 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:3 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:4 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:5 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:6 | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/contact/contactUdef/SuperOffice:7 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:8 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:9 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:10 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:11 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:12 | None | ||
| appointmentInstance/contact/contactUdef/SuperOffice:13 | None | ||
| appointmentInstance/contact/contactExtra/x_contact_integer | None | ||
| appointmentInstance/contact/contactExtra/x_contact_hidden_integer | None | ||
| appointmentInstance/contact/contactExtra/x_contact_default_integer | None | ||
| appointmentInstance/contact/contactExtra/x_contact_float | None | ||
| appointmentInstance/contact/contactExtra/x_contact_longtext | None | ||
| appointmentInstance/contact/contactExtra/x_contact_dropdown | None | ||
| appointmentInstance/contact/contactExtra/x_contact_date | None | ||
| appointmentInstance/contact/contactExtra/x_contact_datetime | None | ||
| appointmentInstance/contact/contactExtra/x_contact_time | None | ||
| appointmentInstance/contact/contactExtra/x_contact_boolean | None | ||
| appointmentInstance/contact/contactExtra/x_contact_timespan | None | ||
| appointmentInstance/contact/contactExtra/x_contact_shorttext | None | ||
| appointmentInstance/contact/contactExtra/x_contact_short_dropdown | None | ||
| appointmentInstance/contact/contactExtra/x_contact_contact_relation | None | ||
| appointmentInstance/contact/contactExtra/x_contact_request_relation | None | ||
| appointmentInstance/contact/contactExtra/x_contact_contact | None | ||
| appointmentInstance/contact/contactExtra/y_organization/x_name | None | ||
| appointmentInstance/contact/NumberOfActivities | None | ||
| appointmentInstance/contact/NumberOfActivitiesInPeriod | None | ||
| appointmentInstance/contact/NumberOfNotCompletedActivities | None | ||
| appointmentInstance/contact/NumberOfNotCompletedActivitiesInPeriod | None | ||
| appointmentInstance/contact/LastActivity | None | ||
| appointmentInstance/contact/LastCompletedActivity | None | ||
| appointmentInstance/contact/LastDoByActivity | None | ||
| appointmentInstance/contact/NumberOfSales | None | ||
| appointmentInstance/contact/NumberOfSalesInPeriod | None | ||
| appointmentInstance/contact/NumberOfNotCompletedSales | None | ||
| appointmentInstance/contact/NumberOfNotCompletedSalesInPeriod | None | ||
| appointmentInstance/contact/LastSale | None | ||
| appointmentInstance/contact/LastCompletedSale | None | ||
| appointmentInstance/contact/LastDoBySale | None | ||
| appointmentInstance/contact/NumberOfTickets | None | ||
| appointmentInstance/contact/NumberOfTicketsInPeriod | None | ||
| appointmentInstance/contact/NumberOfNotCompletedTickets | None | ||
| appointmentInstance/contact/NumberOfNotCompletedTicketsInPeriod | None | ||
| appointmentInstance/contact/LastTicket | None | ||
| appointmentInstance/contact/LastCompletedTicket | None | ||
| appointmentInstance/contact/LastDoByTicket | None | ||
| appointmentInstance/contact/SaintStatus1 | None | ||
| appointmentInstance/contact/SaintStatus2 | None | ||
| appointmentInstance/contact/saintSaleStatus | None | ||
| appointmentInstance/contact/saintAmountClass | None | ||
| appointmentInstance/contact/saintActivityType | None | ||
| appointmentInstance/contact/saintDirection | None | ||
| appointmentInstance/contact/saintIntention | None | ||
| appointmentInstance/contact/saintTicketStatus | None | ||
| appointmentInstance/contact/saintTicketCategory | None | ||
| appointmentInstance/person/personId | None | ||
| appointmentInstance/person/firstName | None | ||
| appointmentInstance/person/lastName | None | ||
| appointmentInstance/person/middleName | None | ||
| appointmentInstance/person/fullName | None | ||
| appointmentInstance/person/contactId | None | ||
| appointmentInstance/person/hasInfoText | None | ||
| appointmentInstance/person/hasInterests | None | ||
| appointmentInstance/person/personHasInterests | None | ||
| appointmentInstance/person/mrMrs | None | ||
| appointmentInstance/person/position | None | ||
| appointmentInstance/person/personNumber | None | ||
| appointmentInstance/person/title | None | ||
| appointmentInstance/person/personCountry | None | ||
| appointmentInstance/person/personCountryId | None | ||
| appointmentInstance/person/personNoMail | None | ||
| appointmentInstance/person/rank | None | ||
| appointmentInstance/person/birthdate | None | ||
| appointmentInstance/person/associateType | None | ||
| appointmentInstance/person/useAsMailingAddress | None | ||
| appointmentInstance/person/personSource | None | ||
| appointmentInstance/person/retired | None | ||
| appointmentInstance/person/birthYear | None | ||
| appointmentInstance/person/birthMonth | None | ||
| appointmentInstance/person/birthDay | None | ||
| appointmentInstance/person/kanaFirstName | None | ||
| appointmentInstance/person/kanaLastName | None | ||
| appointmentInstance/person/personUpdatedBy | None | ||
| appointmentInstance/person/personUpdatedByFullName | None | ||
| appointmentInstance/person/personUpdatedDate | None | ||
| appointmentInstance/person/personRegisteredBy | None | ||
| appointmentInstance/person/personRegisteredByFullName | None | ||
| appointmentInstance/person/personRegisteredDate | None | ||
| appointmentInstance/person/portraitThumbnail | None | ||
| appointmentInstance/person/personActiveErpLinks | None | ||
| appointmentInstance/person/personSourcedFrom | None | ||
| appointmentInstance/person/personLinkedinUrl | None | ||
| appointmentInstance/person/ticketPriority | None | ||
| appointmentInstance/person/supportLanguage | None | ||
| appointmentInstance/person/supportAssociate | None | ||
| appointmentInstance/person/supportAssociateFullName | None | ||
| appointmentInstance/person/personAssociateId | None | ||
| appointmentInstance/person/personAssociateFullName | None | ||
| appointmentInstance/person/personCategory | None | ||
| appointmentInstance/person/personCategoryGroup | None | ||
| appointmentInstance/person/personCategoryRank | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/person/personBusiness | None | ||
| appointmentInstance/person/leadStatus | None | ||
| appointmentInstance/person/leadstatusRank | None | ||
| appointmentInstance/person/personDeletedDate | None | ||
| appointmentInstance/person/hasCompany | None | ||
| appointmentInstance/person/isProjectMember | None | ||
| appointmentInstance/person/isStakeholder | None | ||
| appointmentInstance/person/updatedByWorkflow | None | ||
| appointmentInstance/person/whenUpdatedByWorkflow | None | ||
| appointmentInstance/person/createdByForm | None | ||
| appointmentInstance/person/phone/formattedNumber | None | ||
| appointmentInstance/person/personDirectPhone/formattedNumber | None | ||
| appointmentInstance/person/personDirectPhone/description | None | ||
| appointmentInstance/person/personMobilePhone/formattedNumber | None | ||
| appointmentInstance/person/personMobilePhone/description | None | ||
| appointmentInstance/person/personPrivate/formattedNumber | None | ||
| appointmentInstance/person/personPrivate/description | None | ||
| appointmentInstance/person/personPager/formattedNumber | None | ||
| appointmentInstance/person/personPager/description | None | ||
| appointmentInstance/person/personDirectFax/formattedNumber | None | ||
| appointmentInstance/person/personDirectFax/description | None | ||
| appointmentInstance/person/searchPhone/formattedNumber | None | ||
| appointmentInstance/person/searchPhone/description | None | ||
| appointmentInstance/person/personInfo/textId | None | ||
| appointmentInstance/person/personInfo/infoText | None | ||
| appointmentInstance/person/email/emailProtocol | None | ||
| appointmentInstance/person/email/emailAddress | None | ||
| appointmentInstance/person/email/emailDescription | None | ||
| appointmentInstance/person/email/emailId | None | ||
| appointmentInstance/person/email/emailLastSent | None | ||
| appointmentInstance/person/email/emailBounceCount | None | ||
| appointmentInstance/person/email/emailLastBounce | None | ||
| appointmentInstance/person/email/emailHasBounced | None | ||
| appointmentInstance/person/personUrl/URLAddress | None | ||
| appointmentInstance/person/personUrl/URLDescription | None | ||
| appointmentInstance/person/personAddress/addressId | None | ||
| appointmentInstance/person/personAddress/line1 | None | ||
| appointmentInstance/person/personAddress/line2 | None | ||
| appointmentInstance/person/personAddress/line3 | None | ||
| appointmentInstance/person/personAddress/county | None | ||
| appointmentInstance/person/personAddress/city | None | ||
| appointmentInstance/person/personAddress/zip | None | ||
| appointmentInstance/person/personAddress/state | None | ||
| appointmentInstance/person/personAddress/wgs84latitude | None | ||
| appointmentInstance/person/personAddress/wgs84longitude | None | ||
| appointmentInstance/person/personAddress/formattedAddress | None | ||
| appointmentInstance/person/personAddress/formattedMultiLineAddress | None | ||
| appointmentInstance/person/restrictionAddress/addressId | None | ||
| appointmentInstance/person/restrictionAddress/line1 | None | ||
| appointmentInstance/person/restrictionAddress/line2 | None | ||
| appointmentInstance/person/restrictionAddress/line3 | None | ||
| appointmentInstance/person/restrictionAddress/county | None | ||
| appointmentInstance/person/restrictionAddress/city | None | ||
| appointmentInstance/person/restrictionAddress/zip | None | ||
| appointmentInstance/person/restrictionAddress/state | None | ||
| appointmentInstance/person/restrictionAddress/wgs84latitude | None | ||
| appointmentInstance/person/restrictionAddress/wgs84longitude | None | ||
| appointmentInstance/person/restrictionAddress/formattedAddress | None | ||
| appointmentInstance/person/restrictionAddress/formattedMultiLineAddress | None | ||
| appointmentInstance/person/personInterestIds | None | ||
| appointmentInstance/person/personUdef/SuperOffice:1 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:2 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:3 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:4 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:5 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:6 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:7 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:8 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:9 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:10 | None | ||
| appointmentInstance/person/personUdef/SuperOffice:11 | None | ||
| appointmentInstance/person/personExtra/x_person_integer | None | ||
| appointmentInstance/person/personExtra/x_person_hidden_integer | None | ||
| appointmentInstance/person/personExtra/x_person_float | None | ||
| appointmentInstance/person/personExtra/x_person_longtext | None | ||
| appointmentInstance/person/personExtra/x_person_date | None | ||
| appointmentInstance/person/personExtra/x_person_datetime | None | ||
| appointmentInstance/person/personExtra/x_person_time | None | ||
| appointmentInstance/person/personExtra/x_person_boolean | None | ||
| appointmentInstance/person/personExtra/x_person_timespan | None | ||
| appointmentInstance/person/personExtra/x_person_shorttext | None | ||
| appointmentInstance/person/personExtra/x_person_shorttext_list | None | ||
| appointmentInstance/person/personExtra/x_person_user_relation | None | ||
| appointmentInstance/person/personExtra/x_person_category_relation | None | ||
| appointmentInstance/person/personExtra/x_person_priority_relation | None | ||
| appointmentInstance/person/personExtra/x_person_request_relation | None | ||
| appointmentInstance/person/personExtra/x_person_appointment_relation | None | ||
| appointmentInstance/person/personExtra/x_person_contact_relation | None | ||
| appointmentInstance/person/personExtra/y_rental/id | None | ||
| appointmentInstance/person/personExtra/y_rental/x_start | None | ||
| appointmentInstance/person/personExtra/y_rental/x_end | None | ||
| appointmentInstance/person/personExtra/y_rental/x_amount | None | ||
| appointmentInstance/person/personExtra/y_rental/x_contact | None | ||
| appointmentInstance/person/personExtra/y_rental/y_equipment/x_name | None | ||
| appointmentInstance/person/personExtra/y_car/id | None | ||
| appointmentInstance/person/personAssociate/firstName | None | ||
| appointmentInstance/person/personAssociate/lastName | None | ||
| appointmentInstance/person/personAssociate/middleName | None | ||
| appointmentInstance/person/personAssociate/fullName | None | ||
| appointmentInstance/person/personAssociate/contactId | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/person/personAssociate/personId | None | ||
| appointmentInstance/person/personAssociate/mrMrs | None | ||
| appointmentInstance/person/personAssociate/title | None | ||
| appointmentInstance/person/personAssociate/associateDbId | None | ||
| appointmentInstance/person/personAssociate/contactName | None | ||
| appointmentInstance/person/personAssociate/contactDepartment | None | ||
| appointmentInstance/person/personAssociate/usergroup | None | ||
| appointmentInstance/person/personAssociate/usergroupId | None | ||
| appointmentInstance/person/personAssociate/contactFullName | None | ||
| appointmentInstance/person/personAssociate/contactCategory | None | ||
| appointmentInstance/person/personAssociate/role | None | ||
| appointmentInstance/person/personAssociate/assocName | None | ||
| appointmentInstance/person/personAssociate/assocTooltip | None | ||
| appointmentInstance/person/personAssociate/assocType | None | ||
| appointmentInstance/person/personAssociate/ejUserId | None | ||
| appointmentInstance/person/personAssociate/simultaneousEjUser | None | ||
| appointmentInstance/person/personAssociate/ejDisplayName | None | ||
| appointmentInstance/person/personAssociate/ejStatus | None | ||
| appointmentInstance/person/personAssociate/credentialType | None | ||
| appointmentInstance/person/personAssociate/credentialDisplayValue | None | ||
| appointmentInstance/person/personAssociate/isActive | None | ||
| appointmentInstance/person/personAssociate/isActiveText | None | ||
| appointmentInstance/person/personAssociate/portraitThumbnail | None | ||
| appointmentInstance/person/personAssociate/otherGroups | None | ||
| appointmentInstance/person/personAssociate/userName | None | ||
| appointmentInstance/person/personAssociate/personEmail | None | ||
| appointmentInstance/person/personAssociate/locationAddress | None | ||
| appointmentInstance/person/personAssociate/isLocation | None | ||
| appointmentInstance/person/correspondingAssociate/firstName | None | ||
| appointmentInstance/person/correspondingAssociate/lastName | None | ||
| appointmentInstance/person/correspondingAssociate/middleName | None | ||
| appointmentInstance/person/correspondingAssociate/fullName | None | ||
| appointmentInstance/person/correspondingAssociate/contactId | None | ||
| appointmentInstance/person/correspondingAssociate/personId | None | ||
| appointmentInstance/person/correspondingAssociate/mrMrs | None | ||
| appointmentInstance/person/correspondingAssociate/title | None | ||
| appointmentInstance/person/correspondingAssociate/associateDbId | None | ||
| appointmentInstance/person/correspondingAssociate/contactName | None | ||
| appointmentInstance/person/correspondingAssociate/contactDepartment | None | ||
| appointmentInstance/person/correspondingAssociate/usergroup | None | ||
| appointmentInstance/person/correspondingAssociate/usergroupId | None | ||
| appointmentInstance/person/correspondingAssociate/contactFullName | None | ||
| appointmentInstance/person/correspondingAssociate/contactCategory | None | ||
| appointmentInstance/person/correspondingAssociate/role | None | ||
| appointmentInstance/person/correspondingAssociate/assocName | None | ||
| appointmentInstance/person/correspondingAssociate/assocTooltip | None | ||
| appointmentInstance/person/correspondingAssociate/assocType | None | ||
| appointmentInstance/person/correspondingAssociate/ejUserId | None | ||
| appointmentInstance/person/correspondingAssociate/simultaneousEjUser | None | ||
| appointmentInstance/person/correspondingAssociate/ejDisplayName | None | ||
| appointmentInstance/person/correspondingAssociate/ejStatus | None | ||
| appointmentInstance/person/correspondingAssociate/credentialType | None | ||
| appointmentInstance/person/correspondingAssociate/credentialDisplayValue | None | ||
| appointmentInstance/person/correspondingAssociate/isActive | None | ||
| appointmentInstance/person/correspondingAssociate/isActiveText | None | ||
| appointmentInstance/person/correspondingAssociate/portraitThumbnail | None | ||
| appointmentInstance/person/correspondingAssociate/otherGroups | None | ||
| appointmentInstance/person/correspondingAssociate/userName | None | ||
| appointmentInstance/person/correspondingAssociate/personEmail | None | ||
| appointmentInstance/person/correspondingAssociate/locationAddress | None | ||
| appointmentInstance/person/correspondingAssociate/isLocation | None | ||
| appointmentInstance/person/isMailingRecipient | None | ||
| appointmentInstance/person/hasStoreConsent | None | ||
| appointmentInstance/person/withdrawnStoreConsent | None | ||
| appointmentInstance/person/hasEmarketingConsent | None | ||
| appointmentInstance/person/withdrawnEmarketingConsent | None | ||
| appointmentInstance/person/subscription | None | ||
| appointmentInstance/person/legalBaseStore | None | ||
| appointmentInstance/person/legalBaseEmarketing | None | ||
| appointmentInstance/person/consentSourceStore | None | ||
| appointmentInstance/person/consentSourceEmarketing | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:1 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:2 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:3 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:4 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:5 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:6 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:7 | None | ||
| appointmentInstance/appointmentUdef/SuperOffice:8 | None | ||
| appointmentInstance/project/completed | None | ||
| appointmentInstance/project/projectId | None | ||
| appointmentInstance/project/name | None | ||
| appointmentInstance/project/number | None | ||
| appointmentInstance/project/type | None | ||
| appointmentInstance/project/status | None | ||
| appointmentInstance/project/statusRank | None | ||
| appointmentInstance/project/associateId | None | ||
| appointmentInstance/project/hasInfoText | None | ||
| appointmentInstance/project/icon | None | ||
| appointmentInstance/project/text | None | ||
| appointmentInstance/project/description | None | ||
| appointmentInstance/project/updatedBy | None | ||
| appointmentInstance/project/updatedByFullName | None | ||
| appointmentInstance/project/updatedDate | None | ||
| appointmentInstance/project/registeredBy | None | ||
| appointmentInstance/project/registeredByFullName | None | ||
| appointmentInstance/project/registeredDate | None | ||
| appointmentInstance/project/hasGuide | None | ||
| appointmentInstance/project/nextMilestone | None | ||
| appointmentInstance/project/endDate | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/project/imageThumbnail | None | ||
| appointmentInstance/project/activeErpLinks | None | ||
| appointmentInstance/project/eventId | None | ||
| appointmentInstance/project/startDate | None | ||
| appointmentInstance/project/projectPublish/isPublished | None | ||
| appointmentInstance/project/projectPublish/publishedFrom | None | ||
| appointmentInstance/project/projectPublish/publishedTo | None | ||
| appointmentInstance/project/projectPublish/publishedBy | None | ||
| appointmentInstance/project/projectEvent/isExternalEvent | None | ||
| appointmentInstance/project/projectEvent/eventDate | None | ||
| appointmentInstance/project/projectEvent/hasSignOn | None | ||
| appointmentInstance/project/projectEvent/hasSignOff | None | ||
| appointmentInstance/project/projectUrl/URLAddress | None | ||
| appointmentInstance/project/projectUrl/URLDescription | None | ||
| appointmentInstance/project/projectAssociate/firstName | None | ||
| appointmentInstance/project/projectAssociate/lastName | None | ||
| appointmentInstance/project/projectAssociate/middleName | None | ||
| appointmentInstance/project/projectAssociate/fullName | None | ||
| appointmentInstance/project/projectAssociate/contactId | None | ||
| appointmentInstance/project/projectAssociate/personId | None | ||
| appointmentInstance/project/projectAssociate/mrMrs | None | ||
| appointmentInstance/project/projectAssociate/title | None | ||
| appointmentInstance/project/projectAssociate/associateDbId | None | ||
| appointmentInstance/project/projectAssociate/contactName | None | ||
| appointmentInstance/project/projectAssociate/contactDepartment | None | ||
| appointmentInstance/project/projectAssociate/usergroup | None | ||
| appointmentInstance/project/projectAssociate/usergroupId | None | ||
| appointmentInstance/project/projectAssociate/contactFullName | None | ||
| appointmentInstance/project/projectAssociate/contactCategory | None | ||
| appointmentInstance/project/projectAssociate/role | None | ||
| appointmentInstance/project/projectAssociate/assocName | None | ||
| appointmentInstance/project/projectAssociate/assocTooltip | None | ||
| appointmentInstance/project/projectAssociate/assocType | None | ||
| appointmentInstance/project/projectAssociate/ejUserId | None | ||
| appointmentInstance/project/projectAssociate/simultaneousEjUser | None | ||
| appointmentInstance/project/projectAssociate/ejDisplayName | None | ||
| appointmentInstance/project/projectAssociate/ejStatus | None | ||
| appointmentInstance/project/projectAssociate/credentialType | None | ||
| appointmentInstance/project/projectAssociate/credentialDisplayValue | None | ||
| appointmentInstance/project/projectAssociate/isActive | None | ||
| appointmentInstance/project/projectAssociate/isActiveText | None | ||
| appointmentInstance/project/projectAssociate/portraitThumbnail | None | ||
| appointmentInstance/project/projectAssociate/otherGroups | None | ||
| appointmentInstance/project/projectAssociate/userName | None | ||
| appointmentInstance/project/projectAssociate/personEmail | None | ||
| appointmentInstance/project/projectAssociate/locationAddress | None | ||
| appointmentInstance/project/projectAssociate/isLocation | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:1 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:2 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:3 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:4 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:5 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:6 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:7 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:8 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:9 | None | ||
| appointmentInstance/project/projectUdef/SuperOffice:10 | None | ||
| appointmentInstance/project/NumberOfActivities | None | ||
| appointmentInstance/project/NumberOfActivitiesInPeriod | None | ||
| appointmentInstance/project/NumberOfNotCompletedActivities | None | ||
| appointmentInstance/project/NumberOfNotCompletedActivitiesInPeriod | None | ||
| appointmentInstance/project/LastActivity | None | ||
| appointmentInstance/project/LastCompletedActivity | None | ||
| appointmentInstance/project/LastDoByActivity | None | ||
| appointmentInstance/project/NumberOfSales | None | ||
| appointmentInstance/project/NumberOfSalesInPeriod | None | ||
| appointmentInstance/project/NumberOfNotCompletedSales | None | ||
| appointmentInstance/project/NumberOfNotCompletedSalesInPeriod | None | ||
| appointmentInstance/project/LastSale | None | ||
| appointmentInstance/project/LastCompletedSale | None | ||
| appointmentInstance/project/LastDoBySale | None | ||
| appointmentInstance/project/SaintStatus3 | None | ||
| appointmentInstance/project/saintSaleStatus | None | ||
| appointmentInstance/project/saintAmountClass | None | ||
| appointmentInstance/project/saintActivityType | None | ||
| appointmentInstance/project/saintDirection | None | ||
| appointmentInstance/project/saintIntention | None | ||
| appointmentInstance/project/saintTicketStatus | None | ||
| appointmentInstance/project/saintTicketCategory | None | ||
| appointmentInstance/project/project/textId | None | ||
| appointmentInstance/project/project/infoText | None | ||
| appointmentInstance/sale/completed | None | ||
| appointmentInstance/sale/icon | None | ||
| appointmentInstance/sale/date | None | ||
| appointmentInstance/sale/time | None | ||
| appointmentInstance/sale/type | None | ||
| appointmentInstance/sale/recordType | None | ||
| appointmentInstance/sale/text | None | ||
| appointmentInstance/sale/associateId | None | ||
| appointmentInstance/sale/contactId | None | ||
| appointmentInstance/sale/personId | None | ||
| appointmentInstance/sale/projectId | None | ||
| appointmentInstance/sale/saleId | None | ||
| appointmentInstance/sale/userGroup | None | ||
| appointmentInstance/sale/who | None | ||
| appointmentInstance/sale/updatedBy | None | ||
| appointmentInstance/sale/updatedByFullName | None | ||
| appointmentInstance/sale/updatedDate | None | ||
| appointmentInstance/sale/registeredBy | None | ||
| appointmentInstance/sale/registeredByFullName | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/sale/registeredDate | None | ||
| appointmentInstance/sale/currencyId | None | ||
| appointmentInstance/sale/currency | None | ||
| appointmentInstance/sale/credited | None | ||
| appointmentInstance/sale/lossReason | None | ||
| appointmentInstance/sale/source | None | ||
| appointmentInstance/sale/competitor | None | ||
| appointmentInstance/sale/heading | None | ||
| appointmentInstance/sale/amount | None | ||
| appointmentInstance/sale/amountWeighted | None | ||
| appointmentInstance/sale/earning | None | ||
| appointmentInstance/sale/earningPercent | None | ||
| appointmentInstance/sale/probPercent | None | ||
| appointmentInstance/sale/originalStage | None | ||
| appointmentInstance/sale/stage | None | ||
| appointmentInstance/sale/stageName | None | ||
| appointmentInstance/sale/saleStatus | None | ||
| appointmentInstance/sale/stageRank | None | ||
| appointmentInstance/sale/saleType | None | ||
| appointmentInstance/sale/saleTypeId | None | ||
| appointmentInstance/sale/stageId | None | ||
| appointmentInstance/sale/nextDueDate | None | ||
| appointmentInstance/sale/reopenDate | None | ||
| appointmentInstance/sale/stalledComment | None | ||
| appointmentInstance/sale/saleTypeCategory | None | ||
| appointmentInstance/sale/soldReason | None | ||
| appointmentInstance/sale/saleNumber | None | ||
| appointmentInstance/sale/hasStakeholders | None | ||
| appointmentInstance/sale/stakeholdersEnabled | None | ||
| appointmentInstance/sale/hasQuote | None | ||
| appointmentInstance/sale/hasGuide | None | ||
| appointmentInstance/sale/description | None | ||
| appointmentInstance/sale/activeErpLinks | None | ||
| appointmentInstance/sale/createdByWorkflow | None | ||
| appointmentInstance/sale/amountInBaseCurrency | None | ||
| appointmentInstance/sale/amountWeightedInBaseCurrency | None | ||
| appointmentInstance/sale/daysInStage | None | ||
| appointmentInstance/sale/saleCycle | None | ||
| appointmentInstance/sale/visibleFor | None | ||
| appointmentInstance/sale/sale/textId | None | ||
| appointmentInstance/sale/sale/description | None | ||
| appointmentInstance/sale/salePublish/isPublished | None | ||
| appointmentInstance/sale/salePublish/publishedFrom | None | ||
| appointmentInstance/sale/salePublish/publishedTo | None | ||
| appointmentInstance/sale/salePublish/publishedBy | None | ||
| appointmentInstance/sale/associate/firstName | None | ||
| appointmentInstance/sale/associate/lastName | None | ||
| appointmentInstance/sale/associate/middleName | None | ||
| appointmentInstance/sale/associate/fullName | None | ||
| appointmentInstance/sale/associate/contactId | None | ||
| appointmentInstance/sale/associate/personId | None | ||
| appointmentInstance/sale/associate/mrMrs | None | ||
| appointmentInstance/sale/associate/title | None | ||
| appointmentInstance/sale/associate/associateDbId | None | ||
| appointmentInstance/sale/associate/contactName | None | ||
| appointmentInstance/sale/associate/contactDepartment | None | ||
| appointmentInstance/sale/associate/usergroup | None | ||
| appointmentInstance/sale/associate/usergroupId | None | ||
| appointmentInstance/sale/associate/contactFullName | None | ||
| appointmentInstance/sale/associate/contactCategory | None | ||
| appointmentInstance/sale/associate/role | None | ||
| appointmentInstance/sale/associate/assocName | None | ||
| appointmentInstance/sale/associate/assocTooltip | None | ||
| appointmentInstance/sale/associate/assocType | None | ||
| appointmentInstance/sale/associate/ejUserId | None | ||
| appointmentInstance/sale/associate/simultaneousEjUser | None | ||
| appointmentInstance/sale/associate/ejDisplayName | None | ||
| appointmentInstance/sale/associate/ejStatus | None | ||
| appointmentInstance/sale/associate/credentialType | None | ||
| appointmentInstance/sale/associate/credentialDisplayValue | None | ||
| appointmentInstance/sale/associate/isActive | None | ||
| appointmentInstance/sale/associate/isActiveText | None | ||
| appointmentInstance/sale/associate/portraitThumbnail | None | ||
| appointmentInstance/sale/associate/otherGroups | None | ||
| appointmentInstance/sale/associate/userName | None | ||
| appointmentInstance/sale/associate/personEmail | None | ||
| appointmentInstance/sale/associate/locationAddress | None | ||
| appointmentInstance/sale/associate/isLocation | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:1 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:2 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:3 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:4 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:5 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:6 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:7 | None | ||
| appointmentInstance/sale/saleUdef/SuperOffice:8 | None | ||
| appointmentInstance/associate/firstName | None | ||
| appointmentInstance/associate/lastName | None | ||
| appointmentInstance/associate/middleName | None | ||
| appointmentInstance/associate/fullName | None | ||
| appointmentInstance/associate/contactId | None | ||
| appointmentInstance/associate/personId | None | ||
| appointmentInstance/associate/mrMrs | None | ||
| appointmentInstance/associate/title | None | ||
| appointmentInstance/associate/associateDbId | None | ||
| appointmentInstance/associate/contactName | None | ||
| appointmentInstance/associate/contactDepartment | None | ||
| appointmentInstance/associate/usergroup | None | ||
| appointmentInstance/associate/usergroupId | None | ||
| appointmentInstance/associate/contactFullName | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| appointmentInstance/associate/contactCategory | None | ||
| appointmentInstance/associate/role | None | ||
| appointmentInstance/associate/assocName | None | ||
| appointmentInstance/associate/assocTooltip | None | ||
| appointmentInstance/associate/assocType | None | ||
| appointmentInstance/associate/ejUserId | None | ||
| appointmentInstance/associate/simultaneousEjUser | None | ||
| appointmentInstance/associate/ejDisplayName | None | ||
| appointmentInstance/associate/ejStatus | None | ||
| appointmentInstance/associate/credentialType | None | ||
| appointmentInstance/associate/credentialDisplayValue | None | ||
| appointmentInstance/associate/isActive | None | ||
| appointmentInstance/associate/isActiveText | None | ||
| appointmentInstance/associate/portraitThumbnail | None | ||
| appointmentInstance/associate/otherGroups | None | ||
| appointmentInstance/associate/userName | None | ||
| appointmentInstance/associate/personEmail | None | ||
| appointmentInstance/associate/locationAddress | None | ||
| appointmentInstance/associate/isLocation | None | ||
| appointmentInstance/appointment/text | None | ||
| appointmentInstance/appointment/description | None | ||
| appointmentInstance/appointment/title | None | ||
| appointmentInstance/appointment/titleHtml | None | ||
| appointmentInstance/appointment/agenda | None | ||
| appointmentInstance/appointment/agendaHtml | None | ||
| appointmentInstance/appointment/isConverted | None | ||
| appointmentInstance/appointment/textId | None | ||
| appointmentInstance/appointment/internalNotes | None | ||
| appointmentInstance/appointment/internalNotesHtml | None | ||
| documentInstance/completed | None | ||
| documentInstance/icon | None | ||
| documentInstance/date | None | ||
| documentInstance/time | None | ||
| documentInstance/type | None | ||
| documentInstance/recordType | None | ||
| documentInstance/text | None | ||
| documentInstance/associateId | None | ||
| documentInstance/contactId | None | ||
| documentInstance/personId | None | ||
| documentInstance/projectId | None | ||
| documentInstance/saleId | None | ||
| documentInstance/userGroup | None | ||
| documentInstance/who | None | ||
| documentInstance/updatedBy | None | ||
| documentInstance/updatedByFullName | None | ||
| documentInstance/updatedDate | None | ||
| documentInstance/registeredBy | None | ||
| documentInstance/registeredByFullName | None | ||
| documentInstance/registeredDate | None | ||
| documentInstance/documentId | None | ||
| documentInstance/keywords | None | ||
| documentInstance/ourref | None | ||
| documentInstance/yourref | None | ||
| documentInstance/attention | None | ||
| documentInstance/subject | None | ||
| documentInstance/name | None | ||
| documentInstance/mailMergeDraft | None | ||
| documentInstance/snum | None | ||
| documentInstance/isReport | None | ||
| documentInstance/suggestedDocumentId | None | ||
| documentInstance/isMail | None | ||
| documentInstance/recordTypeText | None | ||
| documentInstance/visibleFor | None | ||
| documentInstance/documentPublish/isPublished | None | ||
| documentInstance/documentPublish/publishedFrom | None | ||
| documentInstance/documentPublish/publishedTo | None | ||
| documentInstance/documentPublish/publishedBy | None | ||
| documentInstance/person/personId | None | ||
| documentInstance/person/firstName | None | ||
| documentInstance/person/lastName | None | ||
| documentInstance/person/middleName | None | ||
| documentInstance/person/fullName | None | ||
| documentInstance/person/contactId | None | ||
| documentInstance/person/hasInfoText | None | ||
| documentInstance/person/hasInterests | None | ||
| documentInstance/person/personHasInterests | None | ||
| documentInstance/person/mrMrs | None | ||
| documentInstance/person/position | None | ||
| documentInstance/person/personNumber | None | ||
| documentInstance/person/title | None | ||
| documentInstance/person/personCountry | None | ||
| documentInstance/person/personCountryId | None | ||
| documentInstance/person/personNoMail | None | ||
| documentInstance/person/rank | None | ||
| documentInstance/person/birthdate | None | ||
| documentInstance/person/associateType | None | ||
| documentInstance/person/useAsMailingAddress | None | ||
| documentInstance/person/personSource | None | ||
| documentInstance/person/retired | None | ||
| documentInstance/person/birthYear | None | ||
| documentInstance/person/birthMonth | None | ||
| documentInstance/person/birthDay | None | ||
| documentInstance/person/kanaFirstName | None | ||
| documentInstance/person/kanaLastName | None | ||
| documentInstance/person/personUpdatedBy | None | ||
| documentInstance/person/personUpdatedByFullName | None | ||
| documentInstance/person/personUpdatedDate | None | ||
| documentInstance/person/personRegisteredBy | None | ||
| documentInstance/person/personRegisteredByFullName | None | ||
| documentInstance/person/personRegisteredDate | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/person/portraitThumbnail | None | ||
| documentInstance/person/personActiveErpLinks | None | ||
| documentInstance/person/personSourcedFrom | None | ||
| documentInstance/person/personLinkedinUrl | None | ||
| documentInstance/person/ticketPriority | None | ||
| documentInstance/person/supportLanguage | None | ||
| documentInstance/person/supportAssociate | None | ||
| documentInstance/person/supportAssociateFullName | None | ||
| documentInstance/person/personAssociateId | None | ||
| documentInstance/person/personAssociateFullName | None | ||
| documentInstance/person/personCategory | None | ||
| documentInstance/person/personCategoryGroup | None | ||
| documentInstance/person/personCategoryRank | None | ||
| documentInstance/person/personBusiness | None | ||
| documentInstance/person/leadStatus | None | ||
| documentInstance/person/leadstatusRank | None | ||
| documentInstance/person/personDeletedDate | None | ||
| documentInstance/person/hasCompany | None | ||
| documentInstance/person/isProjectMember | None | ||
| documentInstance/person/isStakeholder | None | ||
| documentInstance/person/updatedByWorkflow | None | ||
| documentInstance/person/whenUpdatedByWorkflow | None | ||
| documentInstance/person/createdByForm | None | ||
| documentInstance/person/phone/formattedNumber | None | ||
| documentInstance/person/personDirectPhone/formattedNumber | None | ||
| documentInstance/person/personDirectPhone/description | None | ||
| documentInstance/person/personMobilePhone/formattedNumber | None | ||
| documentInstance/person/personMobilePhone/description | None | ||
| documentInstance/person/personPrivate/formattedNumber | None | ||
| documentInstance/person/personPrivate/description | None | ||
| documentInstance/person/personPager/formattedNumber | None | ||
| documentInstance/person/personPager/description | None | ||
| documentInstance/person/personDirectFax/formattedNumber | None | ||
| documentInstance/person/personDirectFax/description | None | ||
| documentInstance/person/searchPhone/formattedNumber | None | ||
| documentInstance/person/searchPhone/description | None | ||
| documentInstance/person/personInfo/textId | None | ||
| documentInstance/person/personInfo/infoText | None | ||
| documentInstance/person/email/emailProtocol | None | ||
| documentInstance/person/email/emailAddress | None | ||
| documentInstance/person/email/emailDescription | None | ||
| documentInstance/person/email/emailId | None | ||
| documentInstance/person/email/emailLastSent | None | ||
| documentInstance/person/email/emailBounceCount | None | ||
| documentInstance/person/email/emailLastBounce | None | ||
| documentInstance/person/email/emailHasBounced | None | ||
| documentInstance/person/personUrl/URLAddress | None | ||
| documentInstance/person/personUrl/URLDescription | None | ||
| documentInstance/person/personAddress/addressId | None | ||
| documentInstance/person/personAddress/line1 | None | ||
| documentInstance/person/personAddress/line2 | None | ||
| documentInstance/person/personAddress/line3 | None | ||
| documentInstance/person/personAddress/county | None | ||
| documentInstance/person/personAddress/city | None | ||
| documentInstance/person/personAddress/zip | None | ||
| documentInstance/person/personAddress/state | None | ||
| documentInstance/person/personAddress/wgs84latitude | None | ||
| documentInstance/person/personAddress/wgs84longitude | None | ||
| documentInstance/person/personAddress/formattedAddress | None | ||
| documentInstance/person/personAddress/formattedMultiLineAddress | None | ||
| documentInstance/person/restrictionAddress/addressId | None | ||
| documentInstance/person/restrictionAddress/line1 | None | ||
| documentInstance/person/restrictionAddress/line2 | None | ||
| documentInstance/person/restrictionAddress/line3 | None | ||
| documentInstance/person/restrictionAddress/county | None | ||
| documentInstance/person/restrictionAddress/city | None | ||
| documentInstance/person/restrictionAddress/zip | None | ||
| documentInstance/person/restrictionAddress/state | None | ||
| documentInstance/person/restrictionAddress/wgs84latitude | None | ||
| documentInstance/person/restrictionAddress/wgs84longitude | None | ||
| documentInstance/person/restrictionAddress/formattedAddress | None | ||
| documentInstance/person/restrictionAddress/formattedMultiLineAddress | None | ||
| documentInstance/person/personInterestIds | None | ||
| documentInstance/person/personUdef/SuperOffice:1 | None | ||
| documentInstance/person/personUdef/SuperOffice:2 | None | ||
| documentInstance/person/personUdef/SuperOffice:3 | None | ||
| documentInstance/person/personUdef/SuperOffice:4 | None | ||
| documentInstance/person/personUdef/SuperOffice:5 | None | ||
| documentInstance/person/personUdef/SuperOffice:6 | None | ||
| documentInstance/person/personUdef/SuperOffice:7 | None | ||
| documentInstance/person/personUdef/SuperOffice:8 | None | ||
| documentInstance/person/personUdef/SuperOffice:9 | None | ||
| documentInstance/person/personUdef/SuperOffice:10 | None | ||
| documentInstance/person/personUdef/SuperOffice:11 | None | ||
| documentInstance/person/personExtra/x_person_integer | None | ||
| documentInstance/person/personExtra/x_person_hidden_integer | None | ||
| documentInstance/person/personExtra/x_person_float | None | ||
| documentInstance/person/personExtra/x_person_longtext | None | ||
| documentInstance/person/personExtra/x_person_date | None | ||
| documentInstance/person/personExtra/x_person_datetime | None | ||
| documentInstance/person/personExtra/x_person_time | None | ||
| documentInstance/person/personExtra/x_person_boolean | None | ||
| documentInstance/person/personExtra/x_person_timespan | None | ||
| documentInstance/person/personExtra/x_person_shorttext | None | ||
| documentInstance/person/personExtra/x_person_shorttext_list | None | ||
| documentInstance/person/personExtra/x_person_user_relation | None | ||
| documentInstance/person/personExtra/x_person_category_relation | None | ||
| documentInstance/person/personExtra/x_person_priority_relation | None | ||
| documentInstance/person/personExtra/x_person_request_relation | None | ||
| documentInstance/person/personExtra/x_person_appointment_relation | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/person/personExtra/x_person_contact_relation | None | ||
| documentInstance/person/personExtra/y_rental/id | None | ||
| documentInstance/person/personExtra/y_rental/x_start | None | ||
| documentInstance/person/personExtra/y_rental/x_end | None | ||
| documentInstance/person/personExtra/y_rental/x_amount | None | ||
| documentInstance/person/personExtra/y_rental/x_contact | None | ||
| documentInstance/person/personExtra/y_rental/y_equipment/x_name | None | ||
| documentInstance/person/personExtra/y_car/id | None | ||
| documentInstance/person/personAssociate/firstName | None | ||
| documentInstance/person/personAssociate/lastName | None | ||
| documentInstance/person/personAssociate/middleName | None | ||
| documentInstance/person/personAssociate/fullName | None | ||
| documentInstance/person/personAssociate/contactId | None | ||
| documentInstance/person/personAssociate/personId | None | ||
| documentInstance/person/personAssociate/mrMrs | None | ||
| documentInstance/person/personAssociate/title | None | ||
| documentInstance/person/personAssociate/associateDbId | None | ||
| documentInstance/person/personAssociate/contactName | None | ||
| documentInstance/person/personAssociate/contactDepartment | None | ||
| documentInstance/person/personAssociate/usergroup | None | ||
| documentInstance/person/personAssociate/usergroupId | None | ||
| documentInstance/person/personAssociate/contactFullName | None | ||
| documentInstance/person/personAssociate/contactCategory | None | ||
| documentInstance/person/personAssociate/role | None | ||
| documentInstance/person/personAssociate/assocName | None | ||
| documentInstance/person/personAssociate/assocTooltip | None | ||
| documentInstance/person/personAssociate/assocType | None | ||
| documentInstance/person/personAssociate/ejUserId | None | ||
| documentInstance/person/personAssociate/simultaneousEjUser | None | ||
| documentInstance/person/personAssociate/ejDisplayName | None | ||
| documentInstance/person/personAssociate/ejStatus | None | ||
| documentInstance/person/personAssociate/credentialType | None | ||
| documentInstance/person/personAssociate/credentialDisplayValue | None | ||
| documentInstance/person/personAssociate/isActive | None | ||
| documentInstance/person/personAssociate/isActiveText | None | ||
| documentInstance/person/personAssociate/portraitThumbnail | None | ||
| documentInstance/person/personAssociate/otherGroups | None | ||
| documentInstance/person/personAssociate/userName | None | ||
| documentInstance/person/personAssociate/personEmail | None | ||
| documentInstance/person/personAssociate/locationAddress | None | ||
| documentInstance/person/personAssociate/isLocation | None | ||
| documentInstance/person/correspondingAssociate/firstName | None | ||
| documentInstance/person/correspondingAssociate/lastName | None | ||
| documentInstance/person/correspondingAssociate/middleName | None | ||
| documentInstance/person/correspondingAssociate/fullName | None | ||
| documentInstance/person/correspondingAssociate/contactId | None | ||
| documentInstance/person/correspondingAssociate/personId | None | ||
| documentInstance/person/correspondingAssociate/mrMrs | None | ||
| documentInstance/person/correspondingAssociate/title | None | ||
| documentInstance/person/correspondingAssociate/associateDbId | None | ||
| documentInstance/person/correspondingAssociate/contactName | None | ||
| documentInstance/person/correspondingAssociate/contactDepartment | None | ||
| documentInstance/person/correspondingAssociate/usergroup | None | ||
| documentInstance/person/correspondingAssociate/usergroupId | None | ||
| documentInstance/person/correspondingAssociate/contactFullName | None | ||
| documentInstance/person/correspondingAssociate/contactCategory | None | ||
| documentInstance/person/correspondingAssociate/role | None | ||
| documentInstance/person/correspondingAssociate/assocName | None | ||
| documentInstance/person/correspondingAssociate/assocTooltip | None | ||
| documentInstance/person/correspondingAssociate/assocType | None | ||
| documentInstance/person/correspondingAssociate/ejUserId | None | ||
| documentInstance/person/correspondingAssociate/simultaneousEjUser | None | ||
| documentInstance/person/correspondingAssociate/ejDisplayName | None | ||
| documentInstance/person/correspondingAssociate/ejStatus | None | ||
| documentInstance/person/correspondingAssociate/credentialType | None | ||
| documentInstance/person/correspondingAssociate/credentialDisplayValue | None | ||
| documentInstance/person/correspondingAssociate/isActive | None | ||
| documentInstance/person/correspondingAssociate/isActiveText | None | ||
| documentInstance/person/correspondingAssociate/portraitThumbnail | None | ||
| documentInstance/person/correspondingAssociate/otherGroups | None | ||
| documentInstance/person/correspondingAssociate/userName | None | ||
| documentInstance/person/correspondingAssociate/personEmail | None | ||
| documentInstance/person/correspondingAssociate/locationAddress | None | ||
| documentInstance/person/correspondingAssociate/isLocation | None | ||
| documentInstance/person/isMailingRecipient | None | ||
| documentInstance/person/hasStoreConsent | None | ||
| documentInstance/person/withdrawnStoreConsent | None | ||
| documentInstance/person/hasEmarketingConsent | None | ||
| documentInstance/person/withdrawnEmarketingConsent | None | ||
| documentInstance/person/subscription | None | ||
| documentInstance/person/legalBaseStore | None | ||
| documentInstance/person/legalBaseEmarketing | None | ||
| documentInstance/person/consentSourceStore | None | ||
| documentInstance/person/consentSourceEmarketing | None | ||
| documentInstance/contact/contactId | None | ||
| documentInstance/contact/name | None | ||
| documentInstance/contact/department | None | ||
| documentInstance/contact/nameDepartment | None | ||
| documentInstance/contact/hasInfoText | None | ||
| documentInstance/contact/hasInterests | None | ||
| documentInstance/contact/associateId | None | ||
| documentInstance/contact/category | None | ||
| documentInstance/contact/categoryGroup | None | ||
| documentInstance/contact/companyCategoryRank | None | ||
| documentInstance/contact/business | None | ||
| documentInstance/contact/country | None | ||
| documentInstance/contact/countryId | None | ||
| documentInstance/contact/number | None | ||
| documentInstance/contact/code | None | ||
| documentInstance/contact/orgnr | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/contact/stop | None | ||
| documentInstance/contact/contactNoMail | None | ||
| documentInstance/contact/updatedBy | None | ||
| documentInstance/contact/updatedByFullName | None | ||
| documentInstance/contact/updatedDate | None | ||
| documentInstance/contact/registeredBy | None | ||
| documentInstance/contact/registeredByFullName | None | ||
| documentInstance/contact/registeredDate | None | ||
| documentInstance/contact/contactSource | None | ||
| documentInstance/contact/contactDeleted | None | ||
| documentInstance/contact/phone/formattedNumber | None | ||
| documentInstance/contact/activeErpLinks | None | ||
| documentInstance/contact/numEmployees | None | ||
| documentInstance/contact/yearFounded | None | ||
| documentInstance/contact/revenueYear | None | ||
| documentInstance/contact/revenueBasecurrency | None | ||
| documentInstance/contact/sharecapitalBasecurrency | None | ||
| documentInstance/contact/sourcedFrom | None | ||
| documentInstance/contact/linkedinUrl | None | ||
| documentInstance/contact/deletedDate | None | ||
| documentInstance/contact/mainContact | None | ||
| documentInstance/contact/forceCompany | None | ||
| documentInstance/contact/contactPhone/formattedNumber | None | ||
| documentInstance/contact/contactPhone/description | None | ||
| documentInstance/contact/contactFax/formattedNumber | None | ||
| documentInstance/contact/contactFax/description | None | ||
| documentInstance/contact/searchPhone/formattedNumber | None | ||
| documentInstance/contact/searchPhone/description | None | ||
| documentInstance/contact/email/emailProtocol | None | ||
| documentInstance/contact/email/emailAddress | None | ||
| documentInstance/contact/email/emailDescription | None | ||
| documentInstance/contact/email/emailId | None | ||
| documentInstance/contact/email/emailLastSent | None | ||
| documentInstance/contact/email/emailBounceCount | None | ||
| documentInstance/contact/email/emailLastBounce | None | ||
| documentInstance/contact/email/emailHasBounced | None | ||
| documentInstance/contact/postAddress/addressId | None | ||
| documentInstance/contact/postAddress/line1 | None | ||
| documentInstance/contact/postAddress/line2 | None | ||
| documentInstance/contact/postAddress/line3 | None | ||
| documentInstance/contact/postAddress/county | None | ||
| documentInstance/contact/postAddress/city | None | ||
| documentInstance/contact/postAddress/zip | None | ||
| documentInstance/contact/postAddress/state | None | ||
| documentInstance/contact/postAddress/wgs84latitude | None | ||
| documentInstance/contact/postAddress/wgs84longitude | None | ||
| documentInstance/contact/postAddress/formattedAddress | None | ||
| documentInstance/contact/postAddress/formattedMultiLineAddress | None | ||
| documentInstance/contact/streetAddress/addressId | None | ||
| documentInstance/contact/streetAddress/line1 | None | ||
| documentInstance/contact/streetAddress/line2 | None | ||
| documentInstance/contact/streetAddress/line3 | None | ||
| documentInstance/contact/streetAddress/county | None | ||
| documentInstance/contact/streetAddress/city | None | ||
| documentInstance/contact/streetAddress/zip | None | ||
| documentInstance/contact/streetAddress/state | None | ||
| documentInstance/contact/streetAddress/wgs84latitude | None | ||
| documentInstance/contact/streetAddress/wgs84longitude | None | ||
| documentInstance/contact/streetAddress/formattedAddress | None | ||
| documentInstance/contact/streetAddress/formattedMultiLineAddress | None | ||
| documentInstance/contact/restrictionAddress/addressId | None | ||
| documentInstance/contact/restrictionAddress/line1 | None | ||
| documentInstance/contact/restrictionAddress/line2 | None | ||
| documentInstance/contact/restrictionAddress/line3 | None | ||
| documentInstance/contact/restrictionAddress/county | None | ||
| documentInstance/contact/restrictionAddress/city | None | ||
| documentInstance/contact/restrictionAddress/zip | None | ||
| documentInstance/contact/restrictionAddress/state | None | ||
| documentInstance/contact/restrictionAddress/wgs84latitude | None | ||
| documentInstance/contact/restrictionAddress/wgs84longitude | None | ||
| documentInstance/contact/restrictionAddress/formattedAddress | None | ||
| documentInstance/contact/restrictionAddress/formattedMultiLineAddress | None | ||
| documentInstance/contact/url/URLAddress | None | ||
| documentInstance/contact/url/URLDescription | None | ||
| documentInstance/contact/contactAssociate/firstName | None | ||
| documentInstance/contact/contactAssociate/lastName | None | ||
| documentInstance/contact/contactAssociate/middleName | None | ||
| documentInstance/contact/contactAssociate/fullName | None | ||
| documentInstance/contact/contactAssociate/contactId | None | ||
| documentInstance/contact/contactAssociate/personId | None | ||
| documentInstance/contact/contactAssociate/mrMrs | None | ||
| documentInstance/contact/contactAssociate/title | None | ||
| documentInstance/contact/contactAssociate/associateDbId | None | ||
| documentInstance/contact/contactAssociate/contactName | None | ||
| documentInstance/contact/contactAssociate/contactDepartment | None | ||
| documentInstance/contact/contactAssociate/usergroup | None | ||
| documentInstance/contact/contactAssociate/usergroupId | None | ||
| documentInstance/contact/contactAssociate/contactFullName | None | ||
| documentInstance/contact/contactAssociate/contactCategory | None | ||
| documentInstance/contact/contactAssociate/role | None | ||
| documentInstance/contact/contactAssociate/assocName | None | ||
| documentInstance/contact/contactAssociate/assocTooltip | None | ||
| documentInstance/contact/contactAssociate/assocType | None | ||
| documentInstance/contact/contactAssociate/ejUserId | None | ||
| documentInstance/contact/contactAssociate/simultaneousEjUser | None | ||
| documentInstance/contact/contactAssociate/ejDisplayName | None | ||
| documentInstance/contact/contactAssociate/ejStatus | None | ||
| documentInstance/contact/contactAssociate/credentialType | None | ||
| documentInstance/contact/contactAssociate/credentialDisplayValue | None | ||
| documentInstance/contact/contactAssociate/isActive | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/contact/contactAssociate/isActiveText | None | ||
| documentInstance/contact/contactAssociate/portraitThumbnail | None | ||
| documentInstance/contact/contactAssociate/otherGroups | None | ||
| documentInstance/contact/contactAssociate/userName | None | ||
| documentInstance/contact/contactAssociate/personEmail | None | ||
| documentInstance/contact/contactAssociate/locationAddress | None | ||
| documentInstance/contact/contactAssociate/isLocation | None | ||
| documentInstance/contact/contactInterestIds | None | ||
| documentInstance/contact/contactUdef/SuperOffice:1 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:2 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:3 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:4 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:5 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:6 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:7 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:8 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:9 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:10 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:11 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:12 | None | ||
| documentInstance/contact/contactUdef/SuperOffice:13 | None | ||
| documentInstance/contact/contactExtra/x_contact_integer | None | ||
| documentInstance/contact/contactExtra/x_contact_hidden_integer | None | ||
| documentInstance/contact/contactExtra/x_contact_default_integer | None | ||
| documentInstance/contact/contactExtra/x_contact_float | None | ||
| documentInstance/contact/contactExtra/x_contact_longtext | None | ||
| documentInstance/contact/contactExtra/x_contact_dropdown | None | ||
| documentInstance/contact/contactExtra/x_contact_date | None | ||
| documentInstance/contact/contactExtra/x_contact_datetime | None | ||
| documentInstance/contact/contactExtra/x_contact_time | None | ||
| documentInstance/contact/contactExtra/x_contact_boolean | None | ||
| documentInstance/contact/contactExtra/x_contact_timespan | None | ||
| documentInstance/contact/contactExtra/x_contact_shorttext | None | ||
| documentInstance/contact/contactExtra/x_contact_short_dropdown | None | ||
| documentInstance/contact/contactExtra/x_contact_contact_relation | None | ||
| documentInstance/contact/contactExtra/x_contact_request_relation | None | ||
| documentInstance/contact/contactExtra/x_contact_contact | None | ||
| documentInstance/contact/contactExtra/y_organization/x_name | None | ||
| documentInstance/contact/NumberOfActivities | None | ||
| documentInstance/contact/NumberOfActivitiesInPeriod | None | ||
| documentInstance/contact/NumberOfNotCompletedActivities | None | ||
| documentInstance/contact/NumberOfNotCompletedActivitiesInPeriod | None | ||
| documentInstance/contact/LastActivity | None | ||
| documentInstance/contact/LastCompletedActivity | None | ||
| documentInstance/contact/LastDoByActivity | None | ||
| documentInstance/contact/NumberOfSales | None | ||
| documentInstance/contact/NumberOfSalesInPeriod | None | ||
| documentInstance/contact/NumberOfNotCompletedSales | None | ||
| documentInstance/contact/NumberOfNotCompletedSalesInPeriod | None | ||
| documentInstance/contact/LastSale | None | ||
| documentInstance/contact/LastCompletedSale | None | ||
| documentInstance/contact/LastDoBySale | None | ||
| documentInstance/contact/NumberOfTickets | None | ||
| documentInstance/contact/NumberOfTicketsInPeriod | None | ||
| documentInstance/contact/NumberOfNotCompletedTickets | None | ||
| documentInstance/contact/NumberOfNotCompletedTicketsInPeriod | None | ||
| documentInstance/contact/LastTicket | None | ||
| documentInstance/contact/LastCompletedTicket | None | ||
| documentInstance/contact/LastDoByTicket | None | ||
| documentInstance/contact/SaintStatus1 | None | ||
| documentInstance/contact/SaintStatus2 | None | ||
| documentInstance/contact/saintSaleStatus | None | ||
| documentInstance/contact/saintAmountClass | None | ||
| documentInstance/contact/saintActivityType | None | ||
| documentInstance/contact/saintDirection | None | ||
| documentInstance/contact/saintIntention | None | ||
| documentInstance/contact/saintTicketStatus | None | ||
| documentInstance/contact/saintTicketCategory | None | ||
| documentInstance/project/completed | None | ||
| documentInstance/project/projectId | None | ||
| documentInstance/project/name | None | ||
| documentInstance/project/number | None | ||
| documentInstance/project/type | None | ||
| documentInstance/project/status | None | ||
| documentInstance/project/statusRank | None | ||
| documentInstance/project/associateId | None | ||
| documentInstance/project/hasInfoText | None | ||
| documentInstance/project/icon | None | ||
| documentInstance/project/text | None | ||
| documentInstance/project/description | None | ||
| documentInstance/project/updatedBy | None | ||
| documentInstance/project/updatedByFullName | None | ||
| documentInstance/project/updatedDate | None | ||
| documentInstance/project/registeredBy | None | ||
| documentInstance/project/registeredByFullName | None | ||
| documentInstance/project/registeredDate | None | ||
| documentInstance/project/hasGuide | None | ||
| documentInstance/project/nextMilestone | None | ||
| documentInstance/project/endDate | None | ||
| documentInstance/project/imageThumbnail | None | ||
| documentInstance/project/activeErpLinks | None | ||
| documentInstance/project/eventId | None | ||
| documentInstance/project/startDate | None | ||
| documentInstance/project/projectPublish/isPublished | None | ||
| documentInstance/project/projectPublish/publishedFrom | None | ||
| documentInstance/project/projectPublish/publishedTo | None | ||
| documentInstance/project/projectPublish/publishedBy | None | ||
| documentInstance/project/projectEvent/isExternalEvent | None | ||
| documentInstance/project/projectEvent/eventDate | None | ||
| documentInstance/project/projectEvent/hasSignOn | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/project/projectEvent/hasSignOff | None | ||
| documentInstance/project/projectUrl/URLAddress | None | ||
| documentInstance/project/projectUrl/URLDescription | None | ||
| documentInstance/project/projectAssociate/firstName | None | ||
| documentInstance/project/projectAssociate/lastName | None | ||
| documentInstance/project/projectAssociate/middleName | None | ||
| documentInstance/project/projectAssociate/fullName | None | ||
| documentInstance/project/projectAssociate/contactId | None | ||
| documentInstance/project/projectAssociate/personId | None | ||
| documentInstance/project/projectAssociate/mrMrs | None | ||
| documentInstance/project/projectAssociate/title | None | ||
| documentInstance/project/projectAssociate/associateDbId | None | ||
| documentInstance/project/projectAssociate/contactName | None | ||
| documentInstance/project/projectAssociate/contactDepartment | None | ||
| documentInstance/project/projectAssociate/usergroup | None | ||
| documentInstance/project/projectAssociate/usergroupId | None | ||
| documentInstance/project/projectAssociate/contactFullName | None | ||
| documentInstance/project/projectAssociate/contactCategory | None | ||
| documentInstance/project/projectAssociate/role | None | ||
| documentInstance/project/projectAssociate/assocName | None | ||
| documentInstance/project/projectAssociate/assocTooltip | None | ||
| documentInstance/project/projectAssociate/assocType | None | ||
| documentInstance/project/projectAssociate/ejUserId | None | ||
| documentInstance/project/projectAssociate/simultaneousEjUser | None | ||
| documentInstance/project/projectAssociate/ejDisplayName | None | ||
| documentInstance/project/projectAssociate/ejStatus | None | ||
| documentInstance/project/projectAssociate/credentialType | None | ||
| documentInstance/project/projectAssociate/credentialDisplayValue | None | ||
| documentInstance/project/projectAssociate/isActive | None | ||
| documentInstance/project/projectAssociate/isActiveText | None | ||
| documentInstance/project/projectAssociate/portraitThumbnail | None | ||
| documentInstance/project/projectAssociate/otherGroups | None | ||
| documentInstance/project/projectAssociate/userName | None | ||
| documentInstance/project/projectAssociate/personEmail | None | ||
| documentInstance/project/projectAssociate/locationAddress | None | ||
| documentInstance/project/projectAssociate/isLocation | None | ||
| documentInstance/project/projectUdef/SuperOffice:1 | None | ||
| documentInstance/project/projectUdef/SuperOffice:2 | None | ||
| documentInstance/project/projectUdef/SuperOffice:3 | None | ||
| documentInstance/project/projectUdef/SuperOffice:4 | None | ||
| documentInstance/project/projectUdef/SuperOffice:5 | None | ||
| documentInstance/project/projectUdef/SuperOffice:6 | None | ||
| documentInstance/project/projectUdef/SuperOffice:7 | None | ||
| documentInstance/project/projectUdef/SuperOffice:8 | None | ||
| documentInstance/project/projectUdef/SuperOffice:9 | None | ||
| documentInstance/project/projectUdef/SuperOffice:10 | None | ||
| documentInstance/project/NumberOfActivities | None | ||
| documentInstance/project/NumberOfActivitiesInPeriod | None | ||
| documentInstance/project/NumberOfNotCompletedActivities | None | ||
| documentInstance/project/NumberOfNotCompletedActivitiesInPeriod | None | ||
| documentInstance/project/LastActivity | None | ||
| documentInstance/project/LastCompletedActivity | None | ||
| documentInstance/project/LastDoByActivity | None | ||
| documentInstance/project/NumberOfSales | None | ||
| documentInstance/project/NumberOfSalesInPeriod | None | ||
| documentInstance/project/NumberOfNotCompletedSales | None | ||
| documentInstance/project/NumberOfNotCompletedSalesInPeriod | None | ||
| documentInstance/project/LastSale | None | ||
| documentInstance/project/LastCompletedSale | None | ||
| documentInstance/project/LastDoBySale | None | ||
| documentInstance/project/SaintStatus3 | None | ||
| documentInstance/project/saintSaleStatus | None | ||
| documentInstance/project/saintAmountClass | None | ||
| documentInstance/project/saintActivityType | None | ||
| documentInstance/project/saintDirection | None | ||
| documentInstance/project/saintIntention | None | ||
| documentInstance/project/saintTicketStatus | None | ||
| documentInstance/project/saintTicketCategory | None | ||
| documentInstance/project/project/textId | None | ||
| documentInstance/project/project/infoText | None | ||
| documentInstance/associate/firstName | None | ||
| documentInstance/associate/lastName | None | ||
| documentInstance/associate/middleName | None | ||
| documentInstance/associate/fullName | None | ||
| documentInstance/associate/contactId | None | ||
| documentInstance/associate/personId | None | ||
| documentInstance/associate/mrMrs | None | ||
| documentInstance/associate/title | None | ||
| documentInstance/associate/associateDbId | None | ||
| documentInstance/associate/contactName | None | ||
| documentInstance/associate/contactDepartment | None | ||
| documentInstance/associate/usergroup | None | ||
| documentInstance/associate/usergroupId | None | ||
| documentInstance/associate/contactFullName | None | ||
| documentInstance/associate/contactCategory | None | ||
| documentInstance/associate/role | None | ||
| documentInstance/associate/assocName | None | ||
| documentInstance/associate/assocTooltip | None | ||
| documentInstance/associate/assocType | None | ||
| documentInstance/associate/ejUserId | None | ||
| documentInstance/associate/simultaneousEjUser | None | ||
| documentInstance/associate/ejDisplayName | None | ||
| documentInstance/associate/ejStatus | None | ||
| documentInstance/associate/credentialType | None | ||
| documentInstance/associate/credentialDisplayValue | None | ||
| documentInstance/associate/isActive | None | ||
| documentInstance/associate/isActiveText | None | ||
| documentInstance/associate/portraitThumbnail | None | ||
| documentInstance/associate/otherGroups | None | ||
| documentInstance/associate/userName | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/associate/personEmail | None | ||
| documentInstance/associate/locationAddress | None | ||
| documentInstance/associate/isLocation | None | ||
| documentInstance/documentUdef/SuperOffice:1 | None | ||
| documentInstance/documentUdef/SuperOffice:2 | None | ||
| documentInstance/documentUdef/SuperOffice:3 | None | ||
| documentInstance/documentUdef/SuperOffice:4 | None | ||
| documentInstance/documentUdef/SuperOffice:5 | None | ||
| documentInstance/documentUdef/SuperOffice:6 | None | ||
| documentInstance/documentUdef/SuperOffice:7 | None | ||
| documentInstance/documentUdef/SuperOffice:8 | None | ||
| documentInstance/sale/completed | None | ||
| documentInstance/sale/icon | None | ||
| documentInstance/sale/date | None | ||
| documentInstance/sale/time | None | ||
| documentInstance/sale/type | None | ||
| documentInstance/sale/recordType | None | ||
| documentInstance/sale/text | None | ||
| documentInstance/sale/associateId | None | ||
| documentInstance/sale/contactId | None | ||
| documentInstance/sale/personId | None | ||
| documentInstance/sale/projectId | None | ||
| documentInstance/sale/saleId | None | ||
| documentInstance/sale/userGroup | None | ||
| documentInstance/sale/who | None | ||
| documentInstance/sale/updatedBy | None | ||
| documentInstance/sale/updatedByFullName | None | ||
| documentInstance/sale/updatedDate | None | ||
| documentInstance/sale/registeredBy | None | ||
| documentInstance/sale/registeredByFullName | None | ||
| documentInstance/sale/registeredDate | None | ||
| documentInstance/sale/currencyId | None | ||
| documentInstance/sale/currency | None | ||
| documentInstance/sale/credited | None | ||
| documentInstance/sale/lossReason | None | ||
| documentInstance/sale/source | None | ||
| documentInstance/sale/competitor | None | ||
| documentInstance/sale/heading | None | ||
| documentInstance/sale/amount | None | ||
| documentInstance/sale/amountWeighted | None | ||
| documentInstance/sale/earning | None | ||
| documentInstance/sale/earningPercent | None | ||
| documentInstance/sale/probPercent | None | ||
| documentInstance/sale/originalStage | None | ||
| documentInstance/sale/stage | None | ||
| documentInstance/sale/stageName | None | ||
| documentInstance/sale/saleStatus | None | ||
| documentInstance/sale/stageRank | None | ||
| documentInstance/sale/saleType | None | ||
| documentInstance/sale/saleTypeId | None | ||
| documentInstance/sale/stageId | None | ||
| documentInstance/sale/nextDueDate | None | ||
| documentInstance/sale/reopenDate | None | ||
| documentInstance/sale/stalledComment | None | ||
| documentInstance/sale/saleTypeCategory | None | ||
| documentInstance/sale/soldReason | None | ||
| documentInstance/sale/saleNumber | None | ||
| documentInstance/sale/hasStakeholders | None | ||
| documentInstance/sale/stakeholdersEnabled | None | ||
| documentInstance/sale/hasQuote | None | ||
| documentInstance/sale/hasGuide | None | ||
| documentInstance/sale/description | None | ||
| documentInstance/sale/activeErpLinks | None | ||
| documentInstance/sale/createdByWorkflow | None | ||
| documentInstance/sale/amountInBaseCurrency | None | ||
| documentInstance/sale/amountWeightedInBaseCurrency | None | ||
| documentInstance/sale/daysInStage | None | ||
| documentInstance/sale/saleCycle | None | ||
| documentInstance/sale/visibleFor | None | ||
| documentInstance/sale/sale/textId | None | ||
| documentInstance/sale/sale/description | None | ||
| documentInstance/sale/salePublish/isPublished | None | ||
| documentInstance/sale/salePublish/publishedFrom | None | ||
| documentInstance/sale/salePublish/publishedTo | None | ||
| documentInstance/sale/salePublish/publishedBy | None | ||
| documentInstance/sale/associate/firstName | None | ||
| documentInstance/sale/associate/lastName | None | ||
| documentInstance/sale/associate/middleName | None | ||
| documentInstance/sale/associate/fullName | None | ||
| documentInstance/sale/associate/contactId | None | ||
| documentInstance/sale/associate/personId | None | ||
| documentInstance/sale/associate/mrMrs | None | ||
| documentInstance/sale/associate/title | None | ||
| documentInstance/sale/associate/associateDbId | None | ||
| documentInstance/sale/associate/contactName | None | ||
| documentInstance/sale/associate/contactDepartment | None | ||
| documentInstance/sale/associate/usergroup | None | ||
| documentInstance/sale/associate/usergroupId | None | ||
| documentInstance/sale/associate/contactFullName | None | ||
| documentInstance/sale/associate/contactCategory | None | ||
| documentInstance/sale/associate/role | None | ||
| documentInstance/sale/associate/assocName | None | ||
| documentInstance/sale/associate/assocTooltip | None | ||
| documentInstance/sale/associate/assocType | None | ||
| documentInstance/sale/associate/ejUserId | None | ||
| documentInstance/sale/associate/simultaneousEjUser | None | ||
| documentInstance/sale/associate/ejDisplayName | None | ||
| documentInstance/sale/associate/ejStatus | None | ||
| documentInstance/sale/associate/credentialType | None | ||
| documentInstance/sale/associate/credentialDisplayValue | None |
Supported Columns (cont.)
| Name | Restriction | Description | OrderBy |
|---|---|---|---|
| documentInstance/sale/associate/isActive | None | ||
| documentInstance/sale/associate/isActiveText | None | ||
| documentInstance/sale/associate/portraitThumbnail | None | ||
| documentInstance/sale/associate/otherGroups | None | ||
| documentInstance/sale/associate/userName | None | ||
| documentInstance/sale/associate/personEmail | None | ||
| documentInstance/sale/associate/locationAddress | None | ||
| documentInstance/sale/associate/isLocation | None | ||
| documentInstance/sale/saleUdef/SuperOffice:1 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:2 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:3 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:4 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:5 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:6 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:7 | None | ||
| documentInstance/sale/saleUdef/SuperOffice:8 | None | ||
| documentInstance/document/textId | None | ||
| documentInstance/document/description | None |
Sample
GET /api/v1/archive/ProjectGuide?$select=text,appointmentInstance/priority,appointmentInstance/contact/contactAssociate/mrMrs,appointmentInstance/person/rank,appointmentInstance/project/projectUdef/SuperOffice:9
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv