task
Stores information related to task management, including assignments, statuses, and relationships with other entities.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Stores the internal identifier for the task, used for system reference and tracking. | |
| accesslevel | Boolean | Indicates whether the task is private. If the value is true, only authorized users can view it. | |
| assigned | String | Specifies the user or team assigned to complete the task. | |
| bom | String | References the Bill of Materials (BOM) associated with the task, detailing required components. | |
| bomrevision | String | Stores the revision details of the associated BOM. | |
| company | String | Indicates the company linked to the task, typically for business or project tracking. | |
| completeddate | Date | Records the date when the task was marked as completed. | |
| contact | String | Links a contact to the task, useful for communication and follow-ups. | |
| createddate | Date | Stores the date when the task was initially created. | |
| duedate | Date | Specifies the deadline by which the task should be completed. | |
| externalid | String | Holds an external identifier for integration with external systems. | |
| lastmodifieddate | Date | Tracks the date when the task was last modified. | |
| message | String | Contains comments or notes related to the task. | |
| mfgrouting | String | Stores the manufacturing routing details associated with the task, guiding production processes. | |
| milestone | String | Represents a milestone associated with the task, marking key progress points. | |
| order | String | Determines where the task should be inserted in a sequence or workflow. | |
| owner | String | Indicates the user who created the task. | |
| parent | String | Specifies the parent task if this task is part of a hierarchical structure. | |
| percentcomplete | Double | Represents the percentage of task completion based on progress tracking. | |
| percenttimecomplete | Double | Indicates task completion percentage based on time spent versus estimated duration. | |
| priority | String | Defines the priority level of the task, such as high, medium, or low. | |
| relateditem | String | Links an item to the task, often used for inventory or work order tracking. | |
| reminderminutes | String | Specifies the number of minutes before the due date when a reminder should be triggered. | |
| remindertype | String | Defines the type of reminder associated with the task, such as email or popup notification. | |
| startdate | Date | Records the planned start date of the task. | |
| status | String | Indicates the current status of the task, such as open, in progress, or completed. | |
| supportcase | String | Links the task to a support case, tracking its relation to customer issues. | |
| timedevent | Boolean | Indicates whether the task is a timed event that follows a predefined schedule. | |
| title | String | Stores the title or name of the task, summarizing its purpose. |