SaleType table - SuperOffice

SaleType Table (149)

SaleType MDO list item table. Type of sale - large solution, incremental, whatever fits the organization

Fields

Name	Description	Type	Nullable
SaleType_Id	Primary key	PK	No
name	The list item	String(239)	No
rank	Rank order	UShort	Yes
tooltip	Tooltip or other description	String(254)	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	Yes
saleDuration	Expected number of dales from initiation to close of sale	Int	Yes
durationUnit	Units for the duration (day, week, whatever)	Enum DurationUnit	Yes
hasGuide	Does this sale type have a guide attached	Bool	Yes
isAutoAdvance	Does the sale stage advance automatically, when the last guided activity in a stage is completed?	Bool	Yes
saleTypeCat_id	Category of sale type, copied to sale	FK SaleTypeCat	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
hasStakeholders	Does this sale type have stakeholders	UShort	Yes
allowQuoteAlternatives	Can quotes linked to sales of this type, have multiple Alternatives	Bool	Yes
defaultQuoteValidity	Default valid days for quotes linked to sales of this type (valid from quote transmission)	Int	Yes
quoteLinesTemplate	The template that this sale type should use when producing the product lines offer document; the template must have DocTmplQuoteType=QuoteLines	FK DocTmpl	Yes
maxDiscountPercentSet	Is there a limit, in percent, to the total discount on quotes linked to sales of this type	Bool	Yes
minEarningPercentSet	Is there a limit, in earning as percent of total, on quotes linked to sales of this type	Bool	Yes
maxDiscountPercent	The maximum discount in percent of total, if set, on quotes linked to sales of this type	Int	Yes
minEarningPercent	The minimum earning in percent of total, if set, on quotes linked to sales of this type	Int	Yes
confirmationLinesTemplate	The template that this sale type should use when producing the order confirmation lines document; the template must have DocTmplQuoteType=ConfirmationLines	FK DocTmpl	Yes
documentGroupingFields	Comma-separated names of grouping fields for quote lines, when generating the documents	String(59)	Yes
archiveGroupingFields	Comma-separated names of grouping fields for quote lines, in the quote lines archive	String(59)	Yes

SaleType table relationship diagram

Indexes

Fields	Types	Description
name	String(239)	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
DocTmpl	DocTmpl list table. Describes templates available for writing new documents.
sale	Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels.
SaleHist	Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here.
SaleTypeCat	Category for sale type
SaleTypeGroupLink	User group link table for SaleType, for MDO item hiding
SaleTypeHeadingLink	Heading link table for SaleType, for MDO headers
SaleTypeQuoteAttachment	Default attachments to quotes linked to sales of this type
SaleTypeStageLink	Many-many link table between sale type and stage; and an anchor point for guide items
target_dimension	Defining target dimension

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

SaleTypeCat table SaleTypeHeadingLink table SaleTypeGroupLink table SaleTypeStageLink table SaleTypeQuoteAttachment table SaleTypeCatHeadingLink table

⌘I