SaleTypeQuoteAttachment - SuperOffice

“SaleTypeQuoteAttachment”

This provider name is implemented by the class SuperOffice.CRM.ArchiveLists.SaleTypeQuoteAttachmentProvider inside NetServer’s SODatabase assembly. This is the archive Provider for the Product Archive is SoAdmin.

Supported Entities

Name	Description
”saleTypeQuoteAttachment”	Documents

Supported Columns

Name	Restriction	Description	OrderBy
getAllRows	bool	GetAll: Get all rows of archive - use with care, you may be fetching the whole database
getNoRows	bool	GetNone: Do not get any rows from the archive
defaultIncluded	bool	Include: If set, then this attachment will be included by default in the quote.	x
saleTypeId	int	Sale type: Database ID of sale type	x
saleTypeQuoteAttachmentId	int	STQATTach. Id: Database ID of SaleTypeQuoteAttachment record	x
document/completed	bool	Completed: Displays a checkbox showing if an appointment is completed	x
document/icon	listAny	Category: Displays the icon for an activity type	x
document/date	date	Date: Displays start date of a follow-up / sale date of a sale	x
document/time	None	Time: Time
document/type	listAny	Type: Displays the type of an activity	x
document/recordType	string	Record type : Shows the record type	x
document/text	positiveString	Text: Displays a descriptive text for the item	x
document/associateId	associate	ID: Displays the login ID of the associate who owns the activity.	x
document/contactId	listAny	Company ID: Database ID of company	x
document/personId	listAny	Contact ID: Database ID of the contact row	x
document/projectId	listAny	Project ID: Database ID of project record	x
document/saleId	int	Sale ID: The database ID of the sale record	x
document/userGroup	userGroup	User group : The user group that owns the record	x
document/who	None	Who: Contact and/or company
document/updatedBy	associate	Updated by: The user who last updated the data	x
document/updatedByFullName	associate	Updated by - Full name: The user who last updated the data	x
document/updatedDate	date	Updated: The date/time the data was last updated in UTC.	x
document/registeredBy	associate	Registered by: The user who registered the data	x
document/registeredByFullName	associate	Registered by - Full name: The user who registered the data	x
document/registeredDate	date	Registered date: The date/time the data was registered in UTC.	x
document/documentId	int	Document ID: Database ID of document record	x
document/keywords	string	Keywords	x
document/ourref	string	Our ref.	x
document/yourref	string	Your ref.	x
document/attention	string	Salutation	x
document/subject	string	Subject	x
document/name	string	File name	x
document/mailMergeDraft	bool	Mail merge draft : Indicates whether the document is a mail merge template	x
document/snum	int	Document number: Serial number of document. It can be generated by the number allocation system for a dedicated document template.	x
document/isReport	bool	Report: Is this document a saved report run?
document/suggestedDocumentId	int	Document ID (suggestion): The database ID of a document that originates in a suggestion	x
document/isMail	bool	E-mail
document/recordTypeText	None	Activity type: The type of the activity (appointment, phone call, etc)	x
document/visibleFor	listAny	Visible for
document/documentPublish/isPublished	bool	Published: Displays an icon indicating if the project or sale has been published	x
document/documentPublish/publishedFrom	date	From date: Start date for publishing. The record will not be visible prior to this date	x
document/documentPublish/publishedTo	date	To date: End date for publishing. The record will not be visible after this date	x
document/documentPublish/publishedBy	None	Published by: Published by
document/associate/firstName	string	First name: Displays the contact’s first name	x
document/associate/lastName	string	Last name: Displays the contact’s last name	x
document/associate/middleName	string	Middle Name : Displays the contact’s middle name.	x
document/associate/fullName	string	Full name: Displays full name of user (first, middle, last - according to settings)	x
document/associate/contactId	int	Company ID: Database ID of the company the user belongs to
document/associate/personId	int	Contact ID: Database ID of the contact row
document/associate/mrMrs	string	Mr/Ms: Displays whether the contact is addressed as Mr or Ms	x
document/associate/title	string	Title: Displays whether the contact is addressed as Mr or Ms	x
document/associate/associateDbId	associate	ID	x
document/associate/contactName	string	Owning company: Name of the company the user belongs to	x
document/associate/contactDepartment	string	Owning department: Name of the department at the company the user belongs to	x
document/associate/usergroup	userGroup	Primary group: The user’s primary user group	x
document/associate/usergroupId	int	Group ID: The user’s primary user group	x
document/associate/contactFullName	string	Owner: Name and department of the company the user belongs to	x
document/associate/contactCategory	listAny	Category: Category	x
document/associate/role	listAny	Role : Role	x
document/associate/assocName	associate	User ID : User ID	x
document/associate/assocTooltip	string	Description : Description
document/associate/assocType	listAny	Type: Type of user: associate, external user, system user, anonymous account	x
document/associate/ejUserId	int	Service user ID: The database ID of a Service user
document/associate/simultaneousEjUser	bool	Simultaneous Service user: If this flag is set, then the user will only have access if the maximum number of simultaneous users is not exceeded
document/associate/ejDisplayName	string	Nickname: User’s nickname in Service	x
document/associate/ejStatus	int	Service status: Status for Service user: Normal; Unavailable / holiday; Deleted; Read-only
document/associate/credentialType	None	Auth. type: What type of credentials to use when this user logs in	x
document/associate/credentialDisplayValue	None	Auth. value: Credential value (public, visible part) to be used when this user logs in	x
document/associate/isActive	bool	Active: Is this user active, and should be able to log in?	x
document/associate/isActiveText	bool	Active status: Is this user active, and should be able to log in?	x
document/associate/portraitThumbnail	None	Person image: Person image
document/associate/otherGroups	userGroup	Other groups: Other groups
document/associate/userName	string	User name: User name	x
document/associate/personEmail	string	E-mail	x
document/associate/locationAddress	string	Location: Location	x
document/associate/isLocation	bool	Is a location: Is a location	x
document/documentUdef/SuperOffice:1	string	documentshorttext	x
document/documentUdef/SuperOffice:2	string	documentlongtext	x
document/documentUdef/SuperOffice:3	int	documentnumber	x
document/documentUdef/SuperOffice:4	date	documentdate	x
document/documentUdef/SuperOffice:5	unlimitedDate	documentunlimiteddate	x
document/documentUdef/SuperOffice:6	bool	documentcheckbox	x
document/documentUdef/SuperOffice:7	listAny	documentdropdownlistbox	x
document/documentUdef/SuperOffice:8	decimal	documentdecimal	x
document/document/textId	int	Text ID	x
document/document/description	positiveString	Text: Displays the text entered in the description field	x

Sample

GET /api/v1/archive/SaleTypeQuoteAttachment?$select=document/document/description,document/yourref,document/associate/firstName
Authorization: Basic dGplMDpUamUw
Accept: application/json; charset=utf-8
Accept-Language: sv

See also: IArchiveAgent.

Related topics

SaleTypeQuoteAttachment table document table SaleType table Delete Sale Type Quote Attachment Add Sale Type Quote Attachment Toggle Sale Type Quote Attachment Default Included

⌘I