> ## 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.

# ProductCategoryGroupLink table

> User group link table for ProductCategory, for MDO item hiding

## ProductCategoryGroupLink Table (409)

User group link table for ProductCategory, for MDO item hiding

## Fields

| Name                         | Description                           | Type                                        | Nullable |
| ---------------------------- | ------------------------------------- | ------------------------------------------- | :------: |
| productcategorygrouplink\_id | Primary key                           | PK                                          |    No    |
| productcategory\_id          | Link to ProductCategory list table    | FK [ProductCategory](./productcategory.mdx) |    No    |
| group\_id                    | Link to Group table                   | FK [UserGroup](./usergroup.mdx)             |    No    |
| 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    |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/ProductCategoryGroupLink.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=59f30cdabdff1c2a15f641b1e801bf96" alt="ProductCategoryGroupLink table relationship diagram" width="829" height="783" data-path="media/loc/en/database/tables/ProductCategoryGroupLink.png" />

## Indexes

| Fields              | Types | Description |
| ------------------- | ----- | ----------- |
| productcategory\_id | FK    | Index       |
| group\_id           | FK    | Index       |

## Relationships

| Table                                | Description                                                                |
| ------------------------------------ | -------------------------------------------------------------------------- |
| [associate](./associate)             | Employees, resources and other users - except for External persons         |
| [ProductCategory](./productcategory) | List for the ProductCategory field of the Product table (Quote Management) |
| [UserGroup](./usergroup)             | Secondary user groups                                                      |

## 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

- [ProductFamilyGroupLink table](/en/database/tables/productfamilygrouplink.md)
- [ProductTypeGroupLink table](/en/database/tables/producttypegrouplink.md)
- [ProductCategoryHeadingLink table](/en/database/tables/productcategoryheadinglink.md)
- [CategoryGroupLink table](/en/database/tables/categorygrouplink.md)
- [EjCategoryGroupLink table](/en/database/tables/ejcategorygrouplink.md)
- [ProductCategory table](/en/database/tables/productcategory.md)