entitygroup
Contains information on entity groups, used for organizing entities into specific categories for reporting or business purposes.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the record, used to track and reference it within the system. | |
| comments | String | Additional comments or notes associated with the record, often used for internal communication or clarifications. | |
| String | The email address associated with the record, typically used for communication purposes. | ||
| externalid | String | An external identifier used to link the record with external systems or services, facilitating integration. | |
| groupmembership | String | The membership type or classification of the entity within a group, typically used for role-based access or categorization. | |
| groupname | String | The name of the group, used for identification and reference within the system. | |
| groupowner | String | The individual or entity that owns or manages the group, typically responsible for overseeing the group’s activities. | |
| grouptypename | String | The type of group, such as 'Sales Group', 'Support Group', or other classifications, used to differentiate between various types of groups. | |
| isinactive | Boolean | Indicates whether the group or record is marked as inactive, meaning it is no longer in use or relevant. | |
| ismanufacturingworkcenter | Boolean | Indicates whether the group or entity is associated with a manufacturing work center, typically used in production management. | |
| isprivate | Boolean | Indicates whether the group or record is marked as private, restricting access or visibility to certain users. | |
| issalesrep | Boolean | Indicates whether the group is a sales representative group, responsible for generating revenue through sales activities. | |
| issupportrep | Boolean | Indicates whether the group is a support representative group, responsible for assisting customers or clients. | |
| laborresources | Double | The number of labor resources allocated to the group or work center, typically used for resource management and planning. | |
| machineresources | Double | The number of machine resources allocated to the group or work center, typically used for production or operational planning. | |
| restrictedtoowner | Boolean | Indicates whether editing the group is restricted to the owner, ensuring only authorized individuals can modify the group. | |
| restrictiongroup | String | The group to which restrictions apply, used for limiting access or permissions to specific entities or users. | |
| savedsearch | String | The saved search or report associated with the group, used for filtering or querying specific records or data. | |
| size | Integer | The size of the group or record, often used to categorize or manage the scale of the group (for example, number of members). | |
| subsidiary | String | The subsidiary associated with the record or group, used for tracking transactions or activities within a larger organizational structure. |