SaleSelection - SuperOffice

“SaleSelection”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.Archive.SaleSelectionProvider inside NetServer’s SODatabase assembly. This is the archive Provider for the Selection sale archive.

Supported Entities

Name	Description
”sale”

Supported Columns

Name	Restriction	OrderBy
getAllRows	bool
getNoRows	bool
completed	bool	x
icon	listAny	x
date	date	x
time	None
type	listAny	x
recordType	string	x
text	positiveString	x
associateId	associate	x
contactId	listAny	x
personId	listAny	x
projectId	listAny	x
saleId	int	x
userGroup	userGroup	x
who	None
updatedBy	associate	x
updatedByFullName	associate	x
updatedDate	date	x
registeredBy	associate	x
registeredByFullName	associate	x
registeredDate	date	x
currencyId	int	x
currency	listAny	x
credited	listAny	x
lossReason	listAny	x
source	listAny	x
competitor	listAny	x
heading	stringorPK	x
amount	decimal	x
amountWeighted	decimal	x
earning	decimal	x
earningPercent	decimal	x
probPercent	int	x
originalStage	listAny	x
stage	listAny	x
stageName	None	x
saleStatus	listAny	x
stageRank	None	x
saleType	listAny	x
saleTypeId	None	x
stageId	None	x
nextDueDate	date	x
reopenDate	date	x
stalledComment	listAny	x
saleTypeCategory	listAny	x
soldReason	listAny	x
saleNumber	string	x
hasStakeholders	bool	x
stakeholdersEnabled	bool	x
hasQuote	bool	x
hasGuide	bool	x
description	string
activeErpLinks	bool	x
createdByWorkflow	listAny	x
amountInBaseCurrency	None	x
amountWeightedInBaseCurrency	None	x
daysInStage	int	x
saleCycle	int	x
visibleFor	listAny
sale/textId	int	x
sale/description	positiveString	x
salePublish/isPublished	bool	x
salePublish/publishedFrom	date	x
salePublish/publishedTo	date	x
salePublish/publishedBy	None
person/personId	int	x
person/firstName	string	x
person/lastName	string	x
person/middleName	string	x
person/fullName	string	x
person/contactId	int	x
person/hasInfoText	bool	x
person/hasInterests	bool	x
person/personHasInterests	bool	x
person/mrMrs	string	x
person/position	listAny	x
person/personNumber	string	x
person/title	string	x
person/personCountry	listAny	x
person/personCountryId	int	x
person/personNoMail	bool	x
person/rank	int	x
person/birthdate	None
person/associateType	None
person/useAsMailingAddress	bool	x
person/personSource	listAny	x
person/retired	bool	x
person/birthYear	int	x
person/birthMonth	int	x
person/birthDay	int	x
person/kanaFirstName	string	x
person/kanaLastName	string	x
person/personUpdatedBy	associate	x
person/personUpdatedByFullName	associate	x
person/personUpdatedDate	date	x
person/personRegisteredBy	associate	x
person/personRegisteredByFullName	associate	x
person/personRegisteredDate	date	x

Supported Columns (cont.)

Name	Restriction	OrderBy
person/portraitThumbnail	None
person/personActiveErpLinks	bool	x
person/personSourcedFrom	string	x
person/personLinkedinUrl	string	x
person/ticketPriority	listAny	x
person/supportLanguage	listAny	x
person/supportAssociate	associate	x
person/supportAssociateFullName	associate	x
person/personAssociateId	associate	x
person/personAssociateFullName	associate	x
person/personCategory	listAny	x
person/personCategoryGroup	listAny	x
person/personCategoryRank	int	x
person/personBusiness	listAny	x
person/leadStatus	listAny	x
person/leadstatusRank	int	x
person/personDeletedDate	datetime
person/hasCompany	bool	x
person/isProjectMember	bool	x
person/isStakeholder	bool	x
person/updatedByWorkflow	listAny	x
person/whenUpdatedByWorkflow	datetime	x
person/createdByForm	listAny	x
person/phone/formattedNumber	string
person/personDirectPhone/formattedNumber	string
person/personDirectPhone/description	string	x
person/personMobilePhone/formattedNumber	string
person/personMobilePhone/description	string	x
person/personPrivate/formattedNumber	string
person/personPrivate/description	string	x
person/personPager/formattedNumber	string
person/personPager/description	string	x
person/personDirectFax/formattedNumber	string
person/personDirectFax/description	string	x
person/searchPhone/formattedNumber	string
person/searchPhone/description	string	x
person/personInfo/textId	int	x
person/personInfo/infoText	positiveString	x
person/email/emailProtocol	string	x
person/email/emailAddress	string	x
person/email/emailDescription	string	x
person/email/emailId	int	x
person/email/emailLastSent	datetime	x
person/email/emailBounceCount	int	x
person/email/emailLastBounce	datetime	x
person/email/emailHasBounced	bool	x
person/personUrl/URLAddress	string	x
person/personUrl/URLDescription	string	x
person/personAddress/addressId	int	x
person/personAddress/line1	string	x
person/personAddress/line2	string	x
person/personAddress/line3	string	x
person/personAddress/county	string	x
person/personAddress/city	string	x
person/personAddress/zip	string	x
person/personAddress/state	string	x
person/personAddress/wgs84latitude	decimal	x
person/personAddress/wgs84longitude	decimal	x
person/personAddress/formattedAddress	None
person/personAddress/formattedMultiLineAddress	None
person/restrictionAddress/addressId	int	x
person/restrictionAddress/line1	string	x
person/restrictionAddress/line2	string	x
person/restrictionAddress/line3	string	x
person/restrictionAddress/county	string	x
person/restrictionAddress/city	string	x
person/restrictionAddress/zip	string	x
person/restrictionAddress/state	string	x
person/restrictionAddress/wgs84latitude	decimal	x
person/restrictionAddress/wgs84longitude	decimal	x
person/restrictionAddress/formattedAddress	None
person/restrictionAddress/formattedMultiLineAddress	None
person/personInterestIds	listInterest
person/personUdef/SuperOffice:1	string	x
person/personUdef/SuperOffice:2	string	x
person/personUdef/SuperOffice:3	int	x
person/personUdef/SuperOffice:4	date	x
person/personUdef/SuperOffice:5	unlimitedDate	x
person/personUdef/SuperOffice:6	bool	x
person/personUdef/SuperOffice:7	listAny	x
person/personUdef/SuperOffice:8	decimal	x
person/personUdef/SuperOffice:9	string	x
person/personUdef/SuperOffice:10	string	x
person/personUdef/SuperOffice:11	string	x
person/personExtra/x_person_integer	int	x
person/personExtra/x_person_hidden_integer	int	x
person/personExtra/x_person_float	decimal	x
person/personExtra/x_person_longtext	string	x
person/personExtra/x_person_date	date	x
person/personExtra/x_person_datetime	datetime	x
person/personExtra/x_person_time	None	x
person/personExtra/x_person_boolean	bool	x
person/personExtra/x_person_timespan	timeSpan	x
person/personExtra/x_person_shorttext	string	x
person/personExtra/x_person_shorttext_list	listAny	x
person/personExtra/x_person_user_relation	associate	x
person/personExtra/x_person_category_relation	listAny	x
person/personExtra/x_person_priority_relation	listAny	x
person/personExtra/x_person_request_relation	stringorPK	x
person/personExtra/x_person_appointment_relation	stringorPK	x

Supported Columns (cont.)

Name	Restriction	OrderBy
person/personExtra/x_person_contact_relation	stringorPK	x
person/personExtra/y_rental/id	int	x
person/personExtra/y_rental/x_start	date	x
person/personExtra/y_rental/x_end	date	x
person/personExtra/y_rental/x_amount	int	x
person/personExtra/y_rental/x_contact	stringorPK	x
person/personExtra/y_rental/y_equipment/x_name	string	x
person/personExtra/y_car/id	int	x
person/personAssociate/firstName	string	x
person/personAssociate/lastName	string	x
person/personAssociate/middleName	string	x
person/personAssociate/fullName	string	x
person/personAssociate/contactId	int
person/personAssociate/personId	int
person/personAssociate/mrMrs	string	x
person/personAssociate/title	string	x
person/personAssociate/associateDbId	associate	x
person/personAssociate/contactName	string	x
person/personAssociate/contactDepartment	string	x
person/personAssociate/usergroup	userGroup	x
person/personAssociate/usergroupId	int	x
person/personAssociate/contactFullName	string	x
person/personAssociate/contactCategory	listAny	x
person/personAssociate/role	listAny	x
person/personAssociate/assocName	associate	x
person/personAssociate/assocTooltip	string
person/personAssociate/assocType	listAny	x
person/personAssociate/ejUserId	int
person/personAssociate/simultaneousEjUser	bool
person/personAssociate/ejDisplayName	string	x
person/personAssociate/ejStatus	int
person/personAssociate/credentialType	None	x
person/personAssociate/credentialDisplayValue	None	x
person/personAssociate/isActive	bool	x
person/personAssociate/isActiveText	bool	x
person/personAssociate/portraitThumbnail	None
person/personAssociate/otherGroups	userGroup
person/personAssociate/userName	string	x
person/personAssociate/personEmail	string	x
person/personAssociate/locationAddress	string	x
person/personAssociate/isLocation	bool	x
person/correspondingAssociate/firstName	string	x
person/correspondingAssociate/lastName	string	x
person/correspondingAssociate/middleName	string	x
person/correspondingAssociate/fullName	string	x
person/correspondingAssociate/contactId	int
person/correspondingAssociate/personId	int
person/correspondingAssociate/mrMrs	string	x
person/correspondingAssociate/title	string	x
person/correspondingAssociate/associateDbId	associate	x
person/correspondingAssociate/contactName	string	x
person/correspondingAssociate/contactDepartment	string	x
person/correspondingAssociate/usergroup	userGroup	x
person/correspondingAssociate/usergroupId	int	x
person/correspondingAssociate/contactFullName	string	x
person/correspondingAssociate/contactCategory	listAny	x
person/correspondingAssociate/role	listAny	x
person/correspondingAssociate/assocName	associate	x
person/correspondingAssociate/assocTooltip	string
person/correspondingAssociate/assocType	listAny	x
person/correspondingAssociate/ejUserId	int
person/correspondingAssociate/simultaneousEjUser	bool
person/correspondingAssociate/ejDisplayName	string	x
person/correspondingAssociate/ejStatus	int
person/correspondingAssociate/credentialType	None	x
person/correspondingAssociate/credentialDisplayValue	None	x
person/correspondingAssociate/isActive	bool	x
person/correspondingAssociate/isActiveText	bool	x
person/correspondingAssociate/portraitThumbnail	None
person/correspondingAssociate/otherGroups	userGroup
person/correspondingAssociate/userName	string	x
person/correspondingAssociate/personEmail	string	x
person/correspondingAssociate/locationAddress	string	x
person/correspondingAssociate/isLocation	bool	x
person/isMailingRecipient	bool	x
person/hasStoreConsent	bool
person/withdrawnStoreConsent	bool
person/hasEmarketingConsent	bool
person/withdrawnEmarketingConsent	bool
person/subscription	listAny	x
person/legalBaseStore	listAny	x
person/legalBaseEmarketing	listAny	x
person/consentSourceStore	listAny	x
person/consentSourceEmarketing	listAny	x
contact/contactId	int	x
contact/name	stringorPK	x
contact/department	string	x
contact/nameDepartment	string	x
contact/hasInfoText	bool	x
contact/hasInterests	bool	x
contact/associateId	associate	x
contact/category	listAny	x
contact/categoryGroup	listAny	x
contact/companyCategoryRank	int	x
contact/business	listAny	x
contact/country	listAny	x
contact/countryId	int	x
contact/number	string	x
contact/code	string	x
contact/orgnr	string	x

Supported Columns (cont.)

Name	Restriction	OrderBy
contact/stop	bool	x
contact/contactNoMail	bool	x
contact/updatedBy	associate	x
contact/updatedByFullName	associate	x
contact/updatedDate	date	x
contact/registeredBy	associate	x
contact/registeredByFullName	associate	x
contact/registeredDate	date	x
contact/contactSource	listAny	x
contact/contactDeleted	bool	x
contact/phone/formattedNumber	string
contact/activeErpLinks	bool	x
contact/numEmployees	int	x
contact/yearFounded	int	x
contact/revenueYear	int	x
contact/revenueBasecurrency	decimal	x
contact/sharecapitalBasecurrency	decimal	x
contact/sourcedFrom	string	x
contact/linkedinUrl	string	x
contact/deletedDate	datetime
contact/mainContact	None	x
contact/forceCompany	bool
contact/contactPhone/formattedNumber	string
contact/contactPhone/description	string	x
contact/contactFax/formattedNumber	string
contact/contactFax/description	string	x
contact/searchPhone/formattedNumber	string
contact/searchPhone/description	string	x
contact/email/emailProtocol	string	x
contact/email/emailAddress	string	x
contact/email/emailDescription	string	x
contact/email/emailId	int	x
contact/email/emailLastSent	datetime	x
contact/email/emailBounceCount	int	x
contact/email/emailLastBounce	datetime	x
contact/email/emailHasBounced	bool	x
contact/postAddress/addressId	int	x
contact/postAddress/line1	string	x
contact/postAddress/line2	string	x
contact/postAddress/line3	string	x
contact/postAddress/county	string	x
contact/postAddress/city	string	x
contact/postAddress/zip	string	x
contact/postAddress/state	string	x
contact/postAddress/wgs84latitude	decimal	x
contact/postAddress/wgs84longitude	decimal	x
contact/postAddress/formattedAddress	None
contact/postAddress/formattedMultiLineAddress	None
contact/streetAddress/addressId	int	x
contact/streetAddress/line1	string	x
contact/streetAddress/line2	string	x
contact/streetAddress/line3	string	x
contact/streetAddress/county	string	x
contact/streetAddress/city	string	x
contact/streetAddress/zip	string	x
contact/streetAddress/state	string	x
contact/streetAddress/wgs84latitude	decimal	x
contact/streetAddress/wgs84longitude	decimal	x
contact/streetAddress/formattedAddress	None
contact/streetAddress/formattedMultiLineAddress	None
contact/restrictionAddress/addressId	int	x
contact/restrictionAddress/line1	string	x
contact/restrictionAddress/line2	string	x
contact/restrictionAddress/line3	string	x
contact/restrictionAddress/county	string	x
contact/restrictionAddress/city	string	x
contact/restrictionAddress/zip	string	x
contact/restrictionAddress/state	string	x
contact/restrictionAddress/wgs84latitude	decimal	x
contact/restrictionAddress/wgs84longitude	decimal	x
contact/restrictionAddress/formattedAddress	None
contact/restrictionAddress/formattedMultiLineAddress	None
contact/url/URLAddress	string	x
contact/url/URLDescription	string	x
contact/contactAssociate/firstName	string	x
contact/contactAssociate/lastName	string	x
contact/contactAssociate/middleName	string	x
contact/contactAssociate/fullName	string	x
contact/contactAssociate/contactId	int
contact/contactAssociate/personId	int
contact/contactAssociate/mrMrs	string	x
contact/contactAssociate/title	string	x
contact/contactAssociate/associateDbId	associate	x
contact/contactAssociate/contactName	string	x
contact/contactAssociate/contactDepartment	string	x
contact/contactAssociate/usergroup	userGroup	x
contact/contactAssociate/usergroupId	int	x
contact/contactAssociate/contactFullName	string	x
contact/contactAssociate/contactCategory	listAny	x
contact/contactAssociate/role	listAny	x
contact/contactAssociate/assocName	associate	x
contact/contactAssociate/assocTooltip	string
contact/contactAssociate/assocType	listAny	x
contact/contactAssociate/ejUserId	int
contact/contactAssociate/simultaneousEjUser	bool
contact/contactAssociate/ejDisplayName	string	x
contact/contactAssociate/ejStatus	int
contact/contactAssociate/credentialType	None	x
contact/contactAssociate/credentialDisplayValue	None	x
contact/contactAssociate/isActive	bool	x

Supported Columns (cont.)

Name	Restriction	OrderBy
contact/contactAssociate/isActiveText	bool	x
contact/contactAssociate/portraitThumbnail	None
contact/contactAssociate/otherGroups	userGroup
contact/contactAssociate/userName	string	x
contact/contactAssociate/personEmail	string	x
contact/contactAssociate/locationAddress	string	x
contact/contactAssociate/isLocation	bool	x
contact/contactInterestIds	listInterest
contact/contactUdef/SuperOffice:1	string	x
contact/contactUdef/SuperOffice:2	string	x
contact/contactUdef/SuperOffice:3	int	x
contact/contactUdef/SuperOffice:4	date	x
contact/contactUdef/SuperOffice:5	unlimitedDate	x
contact/contactUdef/SuperOffice:6	bool	x
contact/contactUdef/SuperOffice:7	listAny	x
contact/contactUdef/SuperOffice:8	decimal	x
contact/contactUdef/SuperOffice:9	string	x
contact/contactUdef/SuperOffice:10	string	x
contact/contactUdef/SuperOffice:11	string	x
contact/contactUdef/SuperOffice:12	listAny	x
contact/contactUdef/SuperOffice:13	listAny	x
contact/contactExtra/x_contact_integer	int	x
contact/contactExtra/x_contact_hidden_integer	int	x
contact/contactExtra/x_contact_default_integer	int	x
contact/contactExtra/x_contact_float	decimal	x
contact/contactExtra/x_contact_longtext	string	x
contact/contactExtra/x_contact_dropdown	listAny	x
contact/contactExtra/x_contact_date	date	x
contact/contactExtra/x_contact_datetime	datetime	x
contact/contactExtra/x_contact_time	None	x
contact/contactExtra/x_contact_boolean	bool	x
contact/contactExtra/x_contact_timespan	timeSpan	x
contact/contactExtra/x_contact_shorttext	string	x
contact/contactExtra/x_contact_short_dropdown	listAny	x
contact/contactExtra/x_contact_contact_relation	stringorPK	x
contact/contactExtra/x_contact_request_relation	stringorPK	x
contact/contactExtra/x_contact_contact	stringorPK	x
contact/contactExtra/y_organization/x_name	string	x
contact/NumberOfActivities	int
contact/NumberOfActivitiesInPeriod	int
contact/NumberOfNotCompletedActivities	int
contact/NumberOfNotCompletedActivitiesInPeriod	int
contact/LastActivity	date
contact/LastCompletedActivity	date
contact/LastDoByActivity	date
contact/NumberOfSales	int
contact/NumberOfSalesInPeriod	int
contact/NumberOfNotCompletedSales	int
contact/NumberOfNotCompletedSalesInPeriod	int
contact/LastSale	date
contact/LastCompletedSale	date
contact/LastDoBySale	date
contact/NumberOfTickets	int
contact/NumberOfTicketsInPeriod	int
contact/NumberOfNotCompletedTickets	int
contact/NumberOfNotCompletedTicketsInPeriod	int
contact/LastTicket	date
contact/LastCompletedTicket	date
contact/LastDoByTicket	date
contact/SaintStatus1	saintStatus
contact/SaintStatus2	saintStatus
contact/saintSaleStatus	listAny
contact/saintAmountClass	listAny
contact/saintActivityType	listAny
contact/saintDirection	listAny
contact/saintIntention	listAny
contact/saintTicketStatus	listAny
contact/saintTicketCategory	listAny
associate/firstName	string	x
associate/lastName	string	x
associate/middleName	string	x
associate/fullName	string	x
associate/contactId	int
associate/personId	int
associate/mrMrs	string	x
associate/title	string	x
associate/associateDbId	associate	x
associate/contactName	string	x
associate/contactDepartment	string	x
associate/usergroup	userGroup	x
associate/usergroupId	int	x
associate/contactFullName	string	x
associate/contactCategory	listAny	x
associate/role	listAny	x
associate/assocName	associate	x
associate/assocTooltip	string
associate/assocType	listAny	x
associate/ejUserId	int
associate/simultaneousEjUser	bool
associate/ejDisplayName	string	x
associate/ejStatus	int
associate/credentialType	None	x
associate/credentialDisplayValue	None	x
associate/isActive	bool	x
associate/isActiveText	bool	x
associate/portraitThumbnail	None
associate/otherGroups	userGroup
associate/userName	string	x
associate/personEmail	string	x
associate/locationAddress	string	x

Supported Columns (cont.)

Name	Restriction	OrderBy
associate/isLocation	bool	x
saleUdef/SuperOffice:1	string	x
saleUdef/SuperOffice:2	string	x
saleUdef/SuperOffice:3	int	x
saleUdef/SuperOffice:4	date	x
saleUdef/SuperOffice:5	unlimitedDate	x
saleUdef/SuperOffice:6	bool	x
saleUdef/SuperOffice:7	listAny	x
saleUdef/SuperOffice:8	decimal	x
appointment/completed	bool	x
appointment/icon	listAny	x
appointment/date	date	x
appointment/time	None
appointment/type	listAny	x
appointment/recordType	string	x
appointment/text	positiveString	x
appointment/associateId	associate	x
appointment/contactId	listAny	x
appointment/personId	listAny	x
appointment/projectId	listAny	x
appointment/saleId	int	x
appointment/userGroup	userGroup	x
appointment/who	None
appointment/updatedBy	associate	x
appointment/updatedByFullName	associate	x
appointment/updatedDate	date	x
appointment/registeredBy	associate	x
appointment/registeredByFullName	associate	x
appointment/registeredDate	date	x
appointment/appointmentId	int	x
appointment/endDate	date	x
appointment/priority	listAny	x
appointment/alarm	bool	x
appointment/isFree	bool	x
appointment/recurring	bool	x
appointment/booking	bool	x
appointment/excludeParticipants	bool
appointment/intention	listAny	x
appointment/location	string	x
appointment/recurrenceRuleId	int	x
appointment/rawType	int	x
appointment/rawStatus	int	x
appointment/cautionWarning	listAny	x
appointment/visibleInDiary	bool	x
appointment/endTime	None
appointment/suggestedAppointmentId	int	x
appointment/completedDate	date	x
appointment/isMilestone	bool	x
appointment/invitedPersonId	int	x
appointment/recordTypeText	listAny	x
appointment/joinVideomeetUrl	None	x
appointment/duration	timeSpan
appointment/createdByWorkflow	listAny	x
appointment/colorIndex	listAny	x
appointment/visibleFor	listAny
appointment/appointmentPublish/isPublished	bool	x
appointment/appointmentPublish/publishedFrom	date	x
appointment/appointmentPublish/publishedTo	date	x
appointment/appointmentPublish/publishedBy	None
appointment/appointmentUdef/SuperOffice:1	string	x
appointment/appointmentUdef/SuperOffice:2	string	x
appointment/appointmentUdef/SuperOffice:3	int	x
appointment/appointmentUdef/SuperOffice:4	date	x
appointment/appointmentUdef/SuperOffice:5	unlimitedDate	x
appointment/appointmentUdef/SuperOffice:6	bool	x
appointment/appointmentUdef/SuperOffice:7	listAny	x
appointment/appointmentUdef/SuperOffice:8	decimal	x
appointment/associate/firstName	string	x
appointment/associate/lastName	string	x
appointment/associate/middleName	string	x
appointment/associate/fullName	string	x
appointment/associate/contactId	int
appointment/associate/personId	int
appointment/associate/mrMrs	string	x
appointment/associate/title	string	x
appointment/associate/associateDbId	associate	x
appointment/associate/contactName	string	x
appointment/associate/contactDepartment	string	x
appointment/associate/usergroup	userGroup	x
appointment/associate/usergroupId	int	x
appointment/associate/contactFullName	string	x
appointment/associate/contactCategory	listAny	x
appointment/associate/role	listAny	x
appointment/associate/assocName	associate	x
appointment/associate/assocTooltip	string
appointment/associate/assocType	listAny	x
appointment/associate/ejUserId	int
appointment/associate/simultaneousEjUser	bool
appointment/associate/ejDisplayName	string	x
appointment/associate/ejStatus	int
appointment/associate/credentialType	None	x
appointment/associate/credentialDisplayValue	None	x
appointment/associate/isActive	bool	x
appointment/associate/isActiveText	bool	x
appointment/associate/portraitThumbnail	None
appointment/associate/otherGroups	userGroup
appointment/associate/userName	string	x
appointment/associate/personEmail	string	x
appointment/associate/locationAddress	string	x
appointment/associate/isLocation	bool	x

Supported Columns (cont.)

Name	Restriction	OrderBy
appointment/appointment/text	positiveString	x
appointment/appointment/description	positiveString	x
appointment/appointment/title	positiveString	x
appointment/appointment/titleHtml	None	x
appointment/appointment/agenda	positiveString	x
appointment/appointment/agendaHtml	None	x
appointment/appointment/isConverted	None
appointment/appointment/textId	int	x
appointment/appointment/internalNotes	positiveString	x
appointment/appointment/internalNotesHtml	positiveString	x
document/completed	bool	x
document/icon	listAny	x
document/date	date	x
document/time	None
document/type	listAny	x
document/recordType	string	x
document/text	positiveString	x
document/associateId	associate	x
document/contactId	listAny	x
document/personId	listAny	x
document/projectId	listAny	x
document/saleId	int	x
document/userGroup	userGroup	x
document/who	None
document/updatedBy	associate	x
document/updatedByFullName	associate	x
document/updatedDate	date	x
document/registeredBy	associate	x
document/registeredByFullName	associate	x
document/registeredDate	date	x
document/documentId	int	x
document/keywords	string	x
document/ourref	string	x
document/yourref	string	x
document/attention	string	x
document/subject	string	x
document/name	string	x
document/mailMergeDraft	bool	x
document/snum	int	x
document/isReport	bool
document/suggestedDocumentId	int	x
document/isMail	bool
document/recordTypeText	None	x
document/visibleFor	listAny
document/documentPublish/isPublished	bool	x
document/documentPublish/publishedFrom	date	x
document/documentPublish/publishedTo	date	x
document/documentPublish/publishedBy	None
document/associate/firstName	string	x
document/associate/lastName	string	x
document/associate/middleName	string	x
document/associate/fullName	string	x
document/associate/contactId	int
document/associate/personId	int
document/associate/mrMrs	string	x
document/associate/title	string	x
document/associate/associateDbId	associate	x
document/associate/contactName	string	x
document/associate/contactDepartment	string	x
document/associate/usergroup	userGroup	x
document/associate/usergroupId	int	x
document/associate/contactFullName	string	x
document/associate/contactCategory	listAny	x
document/associate/role	listAny	x
document/associate/assocName	associate	x
document/associate/assocTooltip	string
document/associate/assocType	listAny	x
document/associate/ejUserId	int
document/associate/simultaneousEjUser	bool
document/associate/ejDisplayName	string	x
document/associate/ejStatus	int
document/associate/credentialType	None	x
document/associate/credentialDisplayValue	None	x
document/associate/isActive	bool	x
document/associate/isActiveText	bool	x
document/associate/portraitThumbnail	None
document/associate/otherGroups	userGroup
document/associate/userName	string	x
document/associate/personEmail	string	x
document/associate/locationAddress	string	x
document/associate/isLocation	bool	x
document/documentUdef/SuperOffice:1	string	x
document/documentUdef/SuperOffice:2	string	x
document/documentUdef/SuperOffice:3	int	x
document/documentUdef/SuperOffice:4	date	x
document/documentUdef/SuperOffice:5	unlimitedDate	x
document/documentUdef/SuperOffice:6	bool	x
document/documentUdef/SuperOffice:7	listAny	x
document/documentUdef/SuperOffice:8	decimal	x
document/document/textId	int	x
document/document/description	positiveString	x
project/completed	bool	x
project/projectId	int	x
project/name	stringorPK	x
project/number	string	x
project/type	listAny	x
project/status	listAny	x
project/statusRank	None	x
project/associateId	associate	x
project/hasInfoText	bool	x

Supported Columns (cont.)

Name	Restriction	OrderBy
project/icon	None	x
project/text	string	x
project/description	string	x
project/updatedBy	associate	x
project/updatedByFullName	associate	x
project/updatedDate	date	x
project/registeredBy	associate	x
project/registeredByFullName	associate	x
project/registeredDate	date	x
project/hasGuide	bool	x
project/nextMilestone	date	x
project/endDate	date	x
project/imageThumbnail	None
project/activeErpLinks	bool	x
project/eventId	int	x
project/startDate	date	x
project/projectPublish/isPublished	bool	x
project/projectPublish/publishedFrom	date	x
project/projectPublish/publishedTo	date	x
project/projectPublish/publishedBy	None
project/projectEvent/isExternalEvent	bool	x
project/projectEvent/eventDate	date	x
project/projectEvent/hasSignOn	bool	x
project/projectEvent/hasSignOff	bool	x
project/projectUrl/URLAddress	string	x
project/projectUrl/URLDescription	string	x
project/projectAssociate/firstName	string	x
project/projectAssociate/lastName	string	x
project/projectAssociate/middleName	string	x
project/projectAssociate/fullName	string	x
project/projectAssociate/contactId	int
project/projectAssociate/personId	int
project/projectAssociate/mrMrs	string	x
project/projectAssociate/title	string	x
project/projectAssociate/associateDbId	associate	x
project/projectAssociate/contactName	string	x
project/projectAssociate/contactDepartment	string	x
project/projectAssociate/usergroup	userGroup	x
project/projectAssociate/usergroupId	int	x
project/projectAssociate/contactFullName	string	x
project/projectAssociate/contactCategory	listAny	x
project/projectAssociate/role	listAny	x
project/projectAssociate/assocName	associate	x
project/projectAssociate/assocTooltip	string
project/projectAssociate/assocType	listAny	x
project/projectAssociate/ejUserId	int
project/projectAssociate/simultaneousEjUser	bool
project/projectAssociate/ejDisplayName	string	x
project/projectAssociate/ejStatus	int
project/projectAssociate/credentialType	None	x
project/projectAssociate/credentialDisplayValue	None	x
project/projectAssociate/isActive	bool	x
project/projectAssociate/isActiveText	bool	x
project/projectAssociate/portraitThumbnail	None
project/projectAssociate/otherGroups	userGroup
project/projectAssociate/userName	string	x
project/projectAssociate/personEmail	string	x
project/projectAssociate/locationAddress	string	x
project/projectAssociate/isLocation	bool	x
project/projectUdef/SuperOffice:1	string	x
project/projectUdef/SuperOffice:2	string	x
project/projectUdef/SuperOffice:3	int	x
project/projectUdef/SuperOffice:4	date	x
project/projectUdef/SuperOffice:5	unlimitedDate	x
project/projectUdef/SuperOffice:6	bool	x
project/projectUdef/SuperOffice:7	listAny	x
project/projectUdef/SuperOffice:8	decimal	x
project/projectUdef/SuperOffice:9	int	x
project/projectUdef/SuperOffice:10	int	x
project/NumberOfActivities	int
project/NumberOfActivitiesInPeriod	int
project/NumberOfNotCompletedActivities	int
project/NumberOfNotCompletedActivitiesInPeriod	int
project/LastActivity	date
project/LastCompletedActivity	date
project/LastDoByActivity	date
project/NumberOfSales	int
project/NumberOfSalesInPeriod	int
project/NumberOfNotCompletedSales	int
project/NumberOfNotCompletedSalesInPeriod	int
project/LastSale	date
project/LastCompletedSale	date
project/LastDoBySale	date
project/SaintStatus3	saintStatus
project/saintSaleStatus	listAny
project/saintAmountClass	listAny
project/saintActivityType	listAny
project/saintDirection	listAny
project/saintIntention	listAny
project/saintTicketStatus	listAny
project/saintTicketCategory	listAny
project/project/textId	int	x
project/project/infoText	positiveString	x
saleStakeholder/saleStakeholderId	int	x
saleStakeholder/saleId	int	x
saleStakeholder/comment	string	x
saleStakeholder/salesRoleId	listAny	x
saleStakeholder/hasInfoText	bool	x
saleStakeholder/person/personId	int	x
saleStakeholder/person/firstName	string	x

Supported Columns (cont.)

Name	Restriction	OrderBy
saleStakeholder/person/lastName	string	x
saleStakeholder/person/middleName	string	x
saleStakeholder/person/fullName	string	x
saleStakeholder/person/contactId	int	x
saleStakeholder/person/hasInfoText	bool	x
saleStakeholder/person/hasInterests	bool	x
saleStakeholder/person/personHasInterests	bool	x
saleStakeholder/person/mrMrs	string	x
saleStakeholder/person/position	listAny	x
saleStakeholder/person/personNumber	string	x
saleStakeholder/person/title	string	x
saleStakeholder/person/personCountry	listAny	x
saleStakeholder/person/personCountryId	int	x
saleStakeholder/person/personNoMail	bool	x
saleStakeholder/person/rank	int	x
saleStakeholder/person/birthdate	None
saleStakeholder/person/associateType	None
saleStakeholder/person/useAsMailingAddress	bool	x
saleStakeholder/person/personSource	listAny	x
saleStakeholder/person/retired	bool	x
saleStakeholder/person/birthYear	int	x
saleStakeholder/person/birthMonth	int	x
saleStakeholder/person/birthDay	int	x
saleStakeholder/person/kanaFirstName	string	x
saleStakeholder/person/kanaLastName	string	x
saleStakeholder/person/personUpdatedBy	associate	x
saleStakeholder/person/personUpdatedByFullName	associate	x
saleStakeholder/person/personUpdatedDate	date	x
saleStakeholder/person/personRegisteredBy	associate	x
saleStakeholder/person/personRegisteredByFullName	associate	x
saleStakeholder/person/personRegisteredDate	date	x
saleStakeholder/person/portraitThumbnail	None
saleStakeholder/person/personActiveErpLinks	bool	x
saleStakeholder/person/personSourcedFrom	string	x
saleStakeholder/person/personLinkedinUrl	string	x
saleStakeholder/person/ticketPriority	listAny	x
saleStakeholder/person/supportLanguage	listAny	x
saleStakeholder/person/supportAssociate	associate	x
saleStakeholder/person/supportAssociateFullName	associate	x
saleStakeholder/person/personAssociateId	associate	x
saleStakeholder/person/personAssociateFullName	associate	x
saleStakeholder/person/personCategory	listAny	x
saleStakeholder/person/personCategoryGroup	listAny	x
saleStakeholder/person/personCategoryRank	int	x
saleStakeholder/person/personBusiness	listAny	x
saleStakeholder/person/leadStatus	listAny	x
saleStakeholder/person/leadstatusRank	int	x
saleStakeholder/person/personDeletedDate	datetime
saleStakeholder/person/hasCompany	bool	x
saleStakeholder/person/isProjectMember	bool	x
saleStakeholder/person/isStakeholder	bool	x
saleStakeholder/person/updatedByWorkflow	listAny	x
saleStakeholder/person/whenUpdatedByWorkflow	datetime	x
saleStakeholder/person/createdByForm	listAny	x
saleStakeholder/person/phone/formattedNumber	string
saleStakeholder/person/personDirectPhone/formattedNumber	string
saleStakeholder/person/personDirectPhone/description	string	x
saleStakeholder/person/personMobilePhone/formattedNumber	string
saleStakeholder/person/personMobilePhone/description	string	x
saleStakeholder/person/personPrivate/formattedNumber	string
saleStakeholder/person/personPrivate/description	string	x
saleStakeholder/person/personPager/formattedNumber	string
saleStakeholder/person/personPager/description	string	x
saleStakeholder/person/personDirectFax/formattedNumber	string
saleStakeholder/person/personDirectFax/description	string	x
saleStakeholder/person/searchPhone/formattedNumber	string
saleStakeholder/person/searchPhone/description	string	x
saleStakeholder/person/personInfo/textId	int	x
saleStakeholder/person/personInfo/infoText	positiveString	x
saleStakeholder/person/email/emailProtocol	string	x
saleStakeholder/person/email/emailAddress	string	x
saleStakeholder/person/email/emailDescription	string	x
saleStakeholder/person/email/emailId	int	x
saleStakeholder/person/email/emailLastSent	datetime	x
saleStakeholder/person/email/emailBounceCount	int	x
saleStakeholder/person/email/emailLastBounce	datetime	x
saleStakeholder/person/email/emailHasBounced	bool	x
saleStakeholder/person/personUrl/URLAddress	string	x
saleStakeholder/person/personUrl/URLDescription	string	x
saleStakeholder/person/personAddress/addressId	int	x
saleStakeholder/person/personAddress/line1	string	x
saleStakeholder/person/personAddress/line2	string	x
saleStakeholder/person/personAddress/line3	string	x
saleStakeholder/person/personAddress/county	string	x
saleStakeholder/person/personAddress/city	string	x
saleStakeholder/person/personAddress/zip	string	x
saleStakeholder/person/personAddress/state	string	x
saleStakeholder/person/personAddress/wgs84latitude	decimal	x
saleStakeholder/person/personAddress/wgs84longitude	decimal	x
saleStakeholder/person/personAddress/formattedAddress	None
saleStakeholder/person/personAddress/formattedMultiLineAddress	None
saleStakeholder/person/restrictionAddress/addressId	int	x
saleStakeholder/person/restrictionAddress/line1	string	x
saleStakeholder/person/restrictionAddress/line2	string	x
saleStakeholder/person/restrictionAddress/line3	string	x
saleStakeholder/person/restrictionAddress/county	string	x
saleStakeholder/person/restrictionAddress/city	string	x
saleStakeholder/person/restrictionAddress/zip	string	x
saleStakeholder/person/restrictionAddress/state	string	x
saleStakeholder/person/restrictionAddress/wgs84latitude	decimal	x

Supported Columns (cont.)

Name	Restriction	OrderBy
saleStakeholder/person/restrictionAddress/wgs84longitude	decimal	x
saleStakeholder/person/restrictionAddress/formattedAddress	None
saleStakeholder/person/restrictionAddress/formattedMultiLineAddress	None
saleStakeholder/person/personInterestIds	listInterest
saleStakeholder/person/personUdef/SuperOffice:1	string	x
saleStakeholder/person/personUdef/SuperOffice:2	string	x
saleStakeholder/person/personUdef/SuperOffice:3	int	x
saleStakeholder/person/personUdef/SuperOffice:4	date	x
saleStakeholder/person/personUdef/SuperOffice:5	unlimitedDate	x
saleStakeholder/person/personUdef/SuperOffice:6	bool	x
saleStakeholder/person/personUdef/SuperOffice:7	listAny	x
saleStakeholder/person/personUdef/SuperOffice:8	decimal	x
saleStakeholder/person/personUdef/SuperOffice:9	string	x
saleStakeholder/person/personUdef/SuperOffice:10	string	x
saleStakeholder/person/personUdef/SuperOffice:11	string	x
saleStakeholder/person/personExtra/x_person_integer	int	x
saleStakeholder/person/personExtra/x_person_hidden_integer	int	x
saleStakeholder/person/personExtra/x_person_float	decimal	x
saleStakeholder/person/personExtra/x_person_longtext	string	x
saleStakeholder/person/personExtra/x_person_date	date	x
saleStakeholder/person/personExtra/x_person_datetime	datetime	x
saleStakeholder/person/personExtra/x_person_time	None	x
saleStakeholder/person/personExtra/x_person_boolean	bool	x
saleStakeholder/person/personExtra/x_person_timespan	timeSpan	x
saleStakeholder/person/personExtra/x_person_shorttext	string	x
saleStakeholder/person/personExtra/x_person_shorttext_list	listAny	x
saleStakeholder/person/personExtra/x_person_user_relation	associate	x
saleStakeholder/person/personExtra/x_person_category_relation	listAny	x
saleStakeholder/person/personExtra/x_person_priority_relation	listAny	x
saleStakeholder/person/personExtra/x_person_request_relation	stringorPK	x
saleStakeholder/person/personExtra/x_person_appointment_relation	stringorPK	x
saleStakeholder/person/personExtra/x_person_contact_relation	stringorPK	x
saleStakeholder/person/personExtra/y_rental/id	int	x
saleStakeholder/person/personExtra/y_rental/x_start	date	x
saleStakeholder/person/personExtra/y_rental/x_end	date	x
saleStakeholder/person/personExtra/y_rental/x_amount	int	x
saleStakeholder/person/personExtra/y_rental/x_contact	stringorPK	x
saleStakeholder/person/personExtra/y_rental/y_equipment/x_name	string	x
saleStakeholder/person/personExtra/y_car/id	int	x
saleStakeholder/person/personAssociate/firstName	string	x
saleStakeholder/person/personAssociate/lastName	string	x
saleStakeholder/person/personAssociate/middleName	string	x
saleStakeholder/person/personAssociate/fullName	string	x
saleStakeholder/person/personAssociate/contactId	int
saleStakeholder/person/personAssociate/personId	int
saleStakeholder/person/personAssociate/mrMrs	string	x
saleStakeholder/person/personAssociate/title	string	x
saleStakeholder/person/personAssociate/associateDbId	associate	x
saleStakeholder/person/personAssociate/contactName	string	x
saleStakeholder/person/personAssociate/contactDepartment	string	x
saleStakeholder/person/personAssociate/usergroup	userGroup	x
saleStakeholder/person/personAssociate/usergroupId	int	x
saleStakeholder/person/personAssociate/contactFullName	string	x
saleStakeholder/person/personAssociate/contactCategory	listAny	x
saleStakeholder/person/personAssociate/role	listAny	x
saleStakeholder/person/personAssociate/assocName	associate	x
saleStakeholder/person/personAssociate/assocTooltip	string
saleStakeholder/person/personAssociate/assocType	listAny	x
saleStakeholder/person/personAssociate/ejUserId	int
saleStakeholder/person/personAssociate/simultaneousEjUser	bool
saleStakeholder/person/personAssociate/ejDisplayName	string	x
saleStakeholder/person/personAssociate/ejStatus	int
saleStakeholder/person/personAssociate/credentialType	None	x
saleStakeholder/person/personAssociate/credentialDisplayValue	None	x
saleStakeholder/person/personAssociate/isActive	bool	x
saleStakeholder/person/personAssociate/isActiveText	bool	x
saleStakeholder/person/personAssociate/portraitThumbnail	None
saleStakeholder/person/personAssociate/otherGroups	userGroup
saleStakeholder/person/personAssociate/userName	string	x
saleStakeholder/person/personAssociate/personEmail	string	x
saleStakeholder/person/personAssociate/locationAddress	string	x
saleStakeholder/person/personAssociate/isLocation	bool	x
saleStakeholder/person/correspondingAssociate/firstName	string	x
saleStakeholder/person/correspondingAssociate/lastName	string	x
saleStakeholder/person/correspondingAssociate/middleName	string	x
saleStakeholder/person/correspondingAssociate/fullName	string	x
saleStakeholder/person/correspondingAssociate/contactId	int
saleStakeholder/person/correspondingAssociate/personId	int
saleStakeholder/person/correspondingAssociate/mrMrs	string	x
saleStakeholder/person/correspondingAssociate/title	string	x
saleStakeholder/person/correspondingAssociate/associateDbId	associate	x
saleStakeholder/person/correspondingAssociate/contactName	string	x
saleStakeholder/person/correspondingAssociate/contactDepartment	string	x
saleStakeholder/person/correspondingAssociate/usergroup	userGroup	x
saleStakeholder/person/correspondingAssociate/usergroupId	int	x
saleStakeholder/person/correspondingAssociate/contactFullName	string	x
saleStakeholder/person/correspondingAssociate/contactCategory	listAny	x
saleStakeholder/person/correspondingAssociate/role	listAny	x
saleStakeholder/person/correspondingAssociate/assocName	associate	x
saleStakeholder/person/correspondingAssociate/assocTooltip	string
saleStakeholder/person/correspondingAssociate/assocType	listAny	x
saleStakeholder/person/correspondingAssociate/ejUserId	int
saleStakeholder/person/correspondingAssociate/simultaneousEjUser	bool
saleStakeholder/person/correspondingAssociate/ejDisplayName	string	x
saleStakeholder/person/correspondingAssociate/ejStatus	int
saleStakeholder/person/correspondingAssociate/credentialType	None	x
saleStakeholder/person/correspondingAssociate/credentialDisplayValue	None	x
saleStakeholder/person/correspondingAssociate/isActive	bool	x
saleStakeholder/person/correspondingAssociate/isActiveText	bool	x
saleStakeholder/person/correspondingAssociate/portraitThumbnail	None

Supported Columns (cont.)

Name	Restriction	OrderBy
saleStakeholder/person/correspondingAssociate/otherGroups	userGroup
saleStakeholder/person/correspondingAssociate/userName	string	x
saleStakeholder/person/correspondingAssociate/personEmail	string	x
saleStakeholder/person/correspondingAssociate/locationAddress	string	x
saleStakeholder/person/correspondingAssociate/isLocation	bool	x
saleStakeholder/person/isMailingRecipient	bool	x
saleStakeholder/person/hasStoreConsent	bool
saleStakeholder/person/withdrawnStoreConsent	bool
saleStakeholder/person/hasEmarketingConsent	bool
saleStakeholder/person/withdrawnEmarketingConsent	bool
saleStakeholder/person/subscription	listAny	x
saleStakeholder/person/legalBaseStore	listAny	x
saleStakeholder/person/legalBaseEmarketing	listAny	x
saleStakeholder/person/consentSourceStore	listAny	x
saleStakeholder/person/consentSourceEmarketing	listAny	x
saleStakeholder/contact/contactId	int	x
saleStakeholder/contact/name	stringorPK	x
saleStakeholder/contact/department	string	x
saleStakeholder/contact/nameDepartment	string	x
saleStakeholder/contact/hasInfoText	bool	x
saleStakeholder/contact/hasInterests	bool	x
saleStakeholder/contact/associateId	associate	x
saleStakeholder/contact/category	listAny	x
saleStakeholder/contact/categoryGroup	listAny	x
saleStakeholder/contact/companyCategoryRank	int	x
saleStakeholder/contact/business	listAny	x
saleStakeholder/contact/country	listAny	x
saleStakeholder/contact/countryId	int	x
saleStakeholder/contact/number	string	x
saleStakeholder/contact/code	string	x
saleStakeholder/contact/orgnr	string	x
saleStakeholder/contact/stop	bool	x
saleStakeholder/contact/contactNoMail	bool	x
saleStakeholder/contact/updatedBy	associate	x
saleStakeholder/contact/updatedByFullName	associate	x
saleStakeholder/contact/updatedDate	date	x
saleStakeholder/contact/registeredBy	associate	x
saleStakeholder/contact/registeredByFullName	associate	x
saleStakeholder/contact/registeredDate	date	x
saleStakeholder/contact/contactSource	listAny	x
saleStakeholder/contact/contactDeleted	bool	x
saleStakeholder/contact/phone/formattedNumber	string
saleStakeholder/contact/activeErpLinks	bool	x
saleStakeholder/contact/numEmployees	int	x
saleStakeholder/contact/yearFounded	int	x
saleStakeholder/contact/revenueYear	int	x
saleStakeholder/contact/revenueBasecurrency	decimal	x
saleStakeholder/contact/sharecapitalBasecurrency	decimal	x
saleStakeholder/contact/sourcedFrom	string	x
saleStakeholder/contact/linkedinUrl	string	x
saleStakeholder/contact/deletedDate	datetime
saleStakeholder/contact/mainContact	None	x
saleStakeholder/contact/forceCompany	bool
saleStakeholder/contact/contactPhone/formattedNumber	string
saleStakeholder/contact/contactPhone/description	string	x
saleStakeholder/contact/contactFax/formattedNumber	string
saleStakeholder/contact/contactFax/description	string	x
saleStakeholder/contact/searchPhone/formattedNumber	string
saleStakeholder/contact/searchPhone/description	string	x
saleStakeholder/contact/email/emailProtocol	string	x
saleStakeholder/contact/email/emailAddress	string	x
saleStakeholder/contact/email/emailDescription	string	x
saleStakeholder/contact/email/emailId	int	x
saleStakeholder/contact/email/emailLastSent	datetime	x
saleStakeholder/contact/email/emailBounceCount	int	x
saleStakeholder/contact/email/emailLastBounce	datetime	x
saleStakeholder/contact/email/emailHasBounced	bool	x
saleStakeholder/contact/postAddress/addressId	int	x
saleStakeholder/contact/postAddress/line1	string	x
saleStakeholder/contact/postAddress/line2	string	x
saleStakeholder/contact/postAddress/line3	string	x
saleStakeholder/contact/postAddress/county	string	x
saleStakeholder/contact/postAddress/city	string	x
saleStakeholder/contact/postAddress/zip	string	x
saleStakeholder/contact/postAddress/state	string	x
saleStakeholder/contact/postAddress/wgs84latitude	decimal	x
saleStakeholder/contact/postAddress/wgs84longitude	decimal	x
saleStakeholder/contact/postAddress/formattedAddress	None
saleStakeholder/contact/postAddress/formattedMultiLineAddress	None
saleStakeholder/contact/streetAddress/addressId	int	x
saleStakeholder/contact/streetAddress/line1	string	x
saleStakeholder/contact/streetAddress/line2	string	x
saleStakeholder/contact/streetAddress/line3	string	x
saleStakeholder/contact/streetAddress/county	string	x
saleStakeholder/contact/streetAddress/city	string	x
saleStakeholder/contact/streetAddress/zip	string	x
saleStakeholder/contact/streetAddress/state	string	x
saleStakeholder/contact/streetAddress/wgs84latitude	decimal	x
saleStakeholder/contact/streetAddress/wgs84longitude	decimal	x
saleStakeholder/contact/streetAddress/formattedAddress	None
saleStakeholder/contact/streetAddress/formattedMultiLineAddress	None
saleStakeholder/contact/restrictionAddress/addressId	int	x
saleStakeholder/contact/restrictionAddress/line1	string	x
saleStakeholder/contact/restrictionAddress/line2	string	x
saleStakeholder/contact/restrictionAddress/line3	string	x
saleStakeholder/contact/restrictionAddress/county	string	x
saleStakeholder/contact/restrictionAddress/city	string	x
saleStakeholder/contact/restrictionAddress/zip	string	x
saleStakeholder/contact/restrictionAddress/state	string	x
saleStakeholder/contact/restrictionAddress/wgs84latitude	decimal	x

Supported Columns (cont.)

Name	Restriction	OrderBy
saleStakeholder/contact/restrictionAddress/wgs84longitude	decimal	x
saleStakeholder/contact/restrictionAddress/formattedAddress	None
saleStakeholder/contact/restrictionAddress/formattedMultiLineAddress	None
saleStakeholder/contact/url/URLAddress	string	x
saleStakeholder/contact/url/URLDescription	string	x
saleStakeholder/contact/contactAssociate/firstName	string	x
saleStakeholder/contact/contactAssociate/lastName	string	x
saleStakeholder/contact/contactAssociate/middleName	string	x
saleStakeholder/contact/contactAssociate/fullName	string	x
saleStakeholder/contact/contactAssociate/contactId	int
saleStakeholder/contact/contactAssociate/personId	int
saleStakeholder/contact/contactAssociate/mrMrs	string	x
saleStakeholder/contact/contactAssociate/title	string	x
saleStakeholder/contact/contactAssociate/associateDbId	associate	x
saleStakeholder/contact/contactAssociate/contactName	string	x
saleStakeholder/contact/contactAssociate/contactDepartment	string	x
saleStakeholder/contact/contactAssociate/usergroup	userGroup	x
saleStakeholder/contact/contactAssociate/usergroupId	int	x
saleStakeholder/contact/contactAssociate/contactFullName	string	x
saleStakeholder/contact/contactAssociate/contactCategory	listAny	x
saleStakeholder/contact/contactAssociate/role	listAny	x
saleStakeholder/contact/contactAssociate/assocName	associate	x
saleStakeholder/contact/contactAssociate/assocTooltip	string
saleStakeholder/contact/contactAssociate/assocType	listAny	x
saleStakeholder/contact/contactAssociate/ejUserId	int
saleStakeholder/contact/contactAssociate/simultaneousEjUser	bool
saleStakeholder/contact/contactAssociate/ejDisplayName	string	x
saleStakeholder/contact/contactAssociate/ejStatus	int
saleStakeholder/contact/contactAssociate/credentialType	None	x
saleStakeholder/contact/contactAssociate/credentialDisplayValue	None	x
saleStakeholder/contact/contactAssociate/isActive	bool	x
saleStakeholder/contact/contactAssociate/isActiveText	bool	x
saleStakeholder/contact/contactAssociate/portraitThumbnail	None
saleStakeholder/contact/contactAssociate/otherGroups	userGroup
saleStakeholder/contact/contactAssociate/userName	string	x
saleStakeholder/contact/contactAssociate/personEmail	string	x
saleStakeholder/contact/contactAssociate/locationAddress	string	x
saleStakeholder/contact/contactAssociate/isLocation	bool	x
saleStakeholder/contact/contactInterestIds	listInterest
saleStakeholder/contact/contactUdef/SuperOffice:1	string	x
saleStakeholder/contact/contactUdef/SuperOffice:2	string	x
saleStakeholder/contact/contactUdef/SuperOffice:3	int	x
saleStakeholder/contact/contactUdef/SuperOffice:4	date	x
saleStakeholder/contact/contactUdef/SuperOffice:5	unlimitedDate	x
saleStakeholder/contact/contactUdef/SuperOffice:6	bool	x
saleStakeholder/contact/contactUdef/SuperOffice:7	listAny	x
saleStakeholder/contact/contactUdef/SuperOffice:8	decimal	x
saleStakeholder/contact/contactUdef/SuperOffice:9	string	x
saleStakeholder/contact/contactUdef/SuperOffice:10	string	x
saleStakeholder/contact/contactUdef/SuperOffice:11	string	x
saleStakeholder/contact/contactUdef/SuperOffice:12	listAny	x
saleStakeholder/contact/contactUdef/SuperOffice:13	listAny	x
saleStakeholder/contact/contactExtra/x_contact_integer	int	x
saleStakeholder/contact/contactExtra/x_contact_hidden_integer	int	x
saleStakeholder/contact/contactExtra/x_contact_default_integer	int	x
saleStakeholder/contact/contactExtra/x_contact_float	decimal	x
saleStakeholder/contact/contactExtra/x_contact_longtext	string	x
saleStakeholder/contact/contactExtra/x_contact_dropdown	listAny	x
saleStakeholder/contact/contactExtra/x_contact_date	date	x
saleStakeholder/contact/contactExtra/x_contact_datetime	datetime	x
saleStakeholder/contact/contactExtra/x_contact_time	None	x
saleStakeholder/contact/contactExtra/x_contact_boolean	bool	x
saleStakeholder/contact/contactExtra/x_contact_timespan	timeSpan	x
saleStakeholder/contact/contactExtra/x_contact_shorttext	string	x
saleStakeholder/contact/contactExtra/x_contact_short_dropdown	listAny	x
saleStakeholder/contact/contactExtra/x_contact_contact_relation	stringorPK	x
saleStakeholder/contact/contactExtra/x_contact_request_relation	stringorPK	x
saleStakeholder/contact/contactExtra/x_contact_contact	stringorPK	x
saleStakeholder/contact/contactExtra/y_organization/x_name	string	x
saleStakeholder/contact/NumberOfActivities	int
saleStakeholder/contact/NumberOfActivitiesInPeriod	int
saleStakeholder/contact/NumberOfNotCompletedActivities	int
saleStakeholder/contact/NumberOfNotCompletedActivitiesInPeriod	int
saleStakeholder/contact/LastActivity	date
saleStakeholder/contact/LastCompletedActivity	date
saleStakeholder/contact/LastDoByActivity	date
saleStakeholder/contact/NumberOfSales	int
saleStakeholder/contact/NumberOfSalesInPeriod	int
saleStakeholder/contact/NumberOfNotCompletedSales	int
saleStakeholder/contact/NumberOfNotCompletedSalesInPeriod	int
saleStakeholder/contact/LastSale	date
saleStakeholder/contact/LastCompletedSale	date
saleStakeholder/contact/LastDoBySale	date
saleStakeholder/contact/NumberOfTickets	int
saleStakeholder/contact/NumberOfTicketsInPeriod	int
saleStakeholder/contact/NumberOfNotCompletedTickets	int
saleStakeholder/contact/NumberOfNotCompletedTicketsInPeriod	int
saleStakeholder/contact/LastTicket	date
saleStakeholder/contact/LastCompletedTicket	date
saleStakeholder/contact/LastDoByTicket	date
saleStakeholder/contact/SaintStatus1	saintStatus
saleStakeholder/contact/SaintStatus2	saintStatus
saleStakeholder/contact/saintSaleStatus	listAny
saleStakeholder/contact/saintAmountClass	listAny
saleStakeholder/contact/saintActivityType	listAny
saleStakeholder/contact/saintDirection	listAny
saleStakeholder/contact/saintIntention	listAny
saleStakeholder/contact/saintTicketStatus	listAny
saleStakeholder/contact/saintTicketCategory	listAny
quote/quoteId	int	x

Supported Columns (cont.)

Name	Restriction	OrderBy
quote/poNumber	string	x
quote/orderComment	string	x
quote/connectionId	int	x
quote/registeredDate	date	x
quote/version/quoteVersionId	int	x
quote/version/description	string	x
quote/version/number	string	x
quote/version/sent	date	x
quote/version/expiration	date	x
quote/version/state	listAny	x
quote/version/status	listAny	x
quote/version/reason	string	x
quote/version/paymentTerms	listExternal
quote/version/paymentType	listExternal
quote/version/deliveryTerms	listExternal
quote/version/deliveryType	listExternal
quote/version/approvedBy	associate	x
quote/version/approvalRegisteredBy	associate	x
quote/version/approvedText	string	x
quote/version/approvedDate	date	x
quote/version/extraField1	string	x
quote/version/extraField2	string	x
quote/version/extraField3	string	x
quote/version/extraField4	string	x
quote/version/extraField5	string	x
quote/version/alternative/quoteAlternativeId	int	x
quote/version/alternative/quoteVersionId	int	x
quote/version/alternative/name	string	x
quote/version/alternative/description	string	x
quote/version/alternative/status	listAny	x
quote/version/alternative/reason	string	x
quote/version/alternative/erpDiscountPercent	decimal	x
quote/version/alternative/erpDiscountAmount	decimal	x
quote/version/alternative/discountPercent	decimal	x
quote/version/alternative/discountAmount	decimal	x
quote/version/alternative/vatInfo	string	x
quote/version/alternative/vat	decimal	x
quote/version/alternative/earningPercent	decimal	x
quote/version/alternative/earningAmount	decimal	x
quote/version/alternative/totalPrice	decimal	x
quote/version/alternative/extraField1	string	x
quote/version/alternative/extraField2	string	x
quote/version/alternative/extraField3	string	x
quote/version/alternative/extraField4	string	x
quote/version/alternative/extraField5	string	x
quote/version/alternative/alternativeOrdering	int	x
quote/version/alternative/subTotal	decimal	x
quote/version/alternative/totalPriceIncVAT	decimal	x
quote/version/alternative/vatAmount	decimal	x
quote/version/alternative/quoteline/quoteLineId	int	x
quote/version/alternative/quoteline/quoteAlternativeId	int	x
quote/version/alternative/quoteline/erpProductKey	string	x
quote/version/alternative/quoteline/rank	int	x
quote/version/alternative/quoteline/quantity	decimal	x
quote/version/alternative/quoteline/name	string	x
quote/version/alternative/quoteline/description	string	x
quote/version/alternative/quoteline/code	string	x
quote/version/alternative/quoteline/quantityUnit	string	x
quote/version/alternative/quoteline/priceUnit	string	x
quote/version/alternative/quoteline/url	string	x
quote/version/alternative/quoteline/subscriptionUnit	string	x
quote/version/alternative/quoteline/subscriptionQuantity	decimal	x
quote/version/alternative/quoteline/UnitListPriceSubscriptionQuantity	None
quote/version/alternative/quoteline/PriceUnitSubscriptionUnit	None
quote/version/alternative/quoteline/PriceUnitSubscriptionQuantityUnit	None
quote/version/alternative/quoteline/vatInfo	string	x
quote/version/alternative/quoteline/vat	decimal	x
quote/version/alternative/quoteline/unitCost	decimal	x
quote/version/alternative/quoteline/unitMinimumPrice	decimal	x
quote/version/alternative/quoteline/unitListPrice	decimal	x
quote/version/alternative/quoteline/totalPrice	decimal	x
quote/version/alternative/quoteline/totalCost	decimal	x
quote/version/alternative/quoteline/quoteLineThumbnail	None
quote/version/alternative/quoteline/quoteLineThumbnailLarge	None
quote/version/alternative/quoteline/discountAmount	decimal	x
quote/version/alternative/quoteline/discountPercent	decimal	x
quote/version/alternative/quoteline/earningAmount	decimal	x
quote/version/alternative/quoteline/earningPercent	decimal	x
quote/version/alternative/quoteline/updatedBy	associate	x
quote/version/alternative/quoteline/updatedByFullName	associate	x
quote/version/alternative/quoteline/updatedDate	date	x
quote/version/alternative/quoteline/registeredBy	associate	x
quote/version/alternative/quoteline/registeredByFullName	associate	x
quote/version/alternative/quoteline/registeredDate	date	x
quote/version/alternative/quoteline/productCategoryKey	listExternal	x
quote/version/alternative/quoteline/productFamilyKey	listExternal	x
quote/version/alternative/quoteline/productTypeKey	listExternal	x
quote/version/alternative/quoteline/status	listAny	x
quote/version/alternative/quoteline/subTotal	decimal	x
quote/version/alternative/quoteline/vatAmount	decimal	x
quote/version/alternative/quoteline/totalPriceIncVAT	decimal	x
quote/version/alternative/quoteline/totalPriceWithAlternativeDiscount	decimal	x
selectionId	int
selectionMemberId	None
rowKind	None
targetTableNumber	None	x
targetRecordId	None	x

Sample

GET /api/v1/archive/SaleSelection?$select=person/personBusiness,person/personUdef/SuperOffice:10,person/personExtra/x_person_category_relation,person/personAssociate/portraitThumbnail,associate/title
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

​“SaleSelection”

​Supported Entities

​Supported Columns

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Supported Columns (cont.)

​Sample

“SaleSelection”

Supported Entities

Supported Columns

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Supported Columns (cont.)

Sample