SaleHistory - SuperOffice

“SaleHistory”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.SaleHistoryProvider inside NetServer’s SODatabase assembly. Sale histories. Contains all changes to the sale records over time.

Supported Entities

Name	Description
”sale”

Supported Columns

Name	Restriction	Description	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
stageWhenClosed	listAny
stage	listAny
saleStatus	listAny		x
saleType	listAny		x
nextDueDate	date		x
reopenDate	date		x
stalledComment	listAny		x
soldReason	listAny		x
saleNumber	string		x
visibleFor	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
associate/isLocation	bool		x
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

Supported Columns (cont.)

Name	Restriction	Description	OrderBy
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
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
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
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/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
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
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/project/textId	int		x
project/project/infoText	positiveString		x

Sample

GET /api/v1/archive/SaleHistory?$select=type,associate/firstName,associate/ejDisplayName
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.