> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# TaskMenu table

> List items to merge into menues

## TaskMenu Table (465)

List items to merge into menues

## Fields

| Name                      | Description                                                                     | Type                                                          | Nullable |
| ------------------------- | ------------------------------------------------------------------------------- | ------------------------------------------------------------- | :------: |
| taskmenu\_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   |
| tableName                 | The name of entity that this task item can be used at                           | String(256)                                                   |    Yes   |
| area                      | Can be Task or other that can identify which menu recipe to merge the item into | String(256)                                                   |    Yes   |
| urlOrSoprotocol           | The url or soprotocol                                                           | String(1024)                                                  |    Yes   |
| taskType                  | Type of task item Url, SoProtocol or CRMScript.                                 | Enum [TaskListItemType](./enums/tasklistitemtype.mdx)         |    Yes   |
| crmScript\_id             | The CRMScript or Macro which will be run task item is selected.                 | FK [ejscript](./ejscript.mdx)                                 |    Yes   |
| showInClient              | Show task list item in which clients (web, mobile)                              | Enum [ShowTaskItemInClient](./enums/showtaskiteminclient.mdx) |    Yes   |
| archiveBehaviour          | None, rightclick on, multiselect                                                | Enum [ArchiveBehaviour](./enums/archivebehaviour.mdx)         |    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    |
| encoding                  | Encoding for url                                                                | Enum [UrlEncoding](./enums/urlencoding.mdx)                   |    Yes   |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/A8Y_bcgEblTh4XOv/media/loc/en/database/tables/TaskMenu.png?fit=max&auto=format&n=A8Y_bcgEblTh4XOv&q=85&s=e0d4c7bd57ccb3d2b0b5ea8f819fb7a6" alt="TaskMenu table relationship diagram" width="964" height="873" data-path="media/loc/en/database/tables/TaskMenu.png" />

## Indexes

| Fields | Types       | Description |
| ------ | ----------- | ----------- |
| name   | String(239) | Unique      |

## Relationships

| Table                                        | Description                                                        |
| -------------------------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)                     | Employees, resources and other users - except for External persons |
| [ejscript](./ejscript)                       | ejscript                                                           |
| [TaskMenuGroupLink](./taskmenugrouplink)     | User group link table for TaskMenu, for MDO item hiding            |
| [TaskMenuHeadingLink](./taskmenuheadinglink) | Heading link table for TaskMenu, for MDO headers                   |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.