> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # SuggestedDocument table > Unique owner of a set of licensed modules ## SuggestedDocument Table (126) Unique owner of a set of licensed modules ## Fields | Name | Description | Type | Nullable | | ------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------- | :------: | | SuggestedDocument\_id | Primary key | PK | No | | name | Item name, visible in Guide | String(239) | No | | rank | Rank, controls rank of non-instantiated items in Guide | UShort | Yes | | tooltip | Tooltip / description | String(254) | Yes | | deleted | 0 -> record is active 1 -> record is 'deleted' and should not be shown in lists | UShort | Yes | | saleTypeStageLinkId | Link to saleTypeStageLink, the anchor for sale guide items. Either this OR projectAnchorId should be set, not both at the same time. | FK [SaleTypeStageLink](./saletypestagelink.mdx) | Yes | | projectTypeStatusLinkId | Link to projectTypeStatusLink, the anchor for project guide items. Either this OR saleAnchorId should be set, not both at the same time. | FK [ProjectTypeStatusLink](./projecttypestatuslink.mdx) | Yes | | doctmpl\_id | Type of the suggested document | FK [DocTmpl](./doctmpl.mdx) | Yes | | header | Suggested 'header' | String(219) | Yes | | our\_ref | Suggested 'our reference' | String(99) | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | SuggestedDocument table relationship diagram ## Indexes | Fields | Types | Description | | ----------------------- | ----------- | ----------- | | name | String(239) | Index | | saleTypeStageLinkId | FK | Index | | projectTypeStatusLinkId | FK | Index | ## Relationships | Table | Description | | ------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [appointment](./appointment) | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. | | [associate](./associate) | Employees, resources and other users - except for External persons | | [DocTmpl](./doctmpl) | DocTmpl list table. Describes templates available for writing new documents. | | [ProjectTypeStatusLink](./projecttypestatuslink) | Many-many link table between project type and status, similar to sale type-stage link; and an anchor point for guide items | | [SaleTypeStageLink](./saletypestagelink) | Many-many link table between sale type and stage; and an anchor point for guide items | ## 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 - [Project guides](/en/automation/crmscript/howto/project/guides.md) - [suggesteddocument](/en/api/mdo-providers/reference/suggesteddocument.md) - [SuperOffice.WebApi.Data.SuggestedDocumentEntity](/en/api/reference/webapi/SuperOffice.WebApi.Data.SuggestedDocumentEntity.md) - [SaleTypeStageLink table](/en/database/tables/saletypestagelink.md) - [ProjectTypeStatusLink table](/en/database/tables/projecttypestatuslink.md) - [Document properties](/en/automation/crmscript/howto/document/properties.md)