SaleTypeQuoteAttachment table - SuperOffice

SaleTypeQuoteAttachment Table (446)

Default attachments to quotes linked to sales of this type

Fields

Name	Description	Type	Nullable
saletypequoteattachment_id	Primary key	PK	No
SaleTypeId	Link to sale type	FK SaleType	No
DocumentId	Link to document	FK document	No
DefaultIncluded	Should this be a standard attachment (default state is ‘include’)	Bool	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

SaleTypeQuoteAttachment table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
document	Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this.
SaleType	Type of sale - large solution, incremental, whatever fits the organization

Replication Flags

None

Security Flags

No access control via user’s Role.