ProductCategories
Stores hierarchical category definitions for organizing products. This table supports catalog browsing, segmentation, and classification.
Columns
| Name | Type | ReadOnly | Description |
| Assigned_User_Id | String | False |
The identifier (Id) of the user who is assigned to this product category record. This field controls ownership and responsibility for category maintenance. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this product category record. |
| Created_By | String | True |
The Id of the user who created this product category record. |
| Created_By_Name | String | True |
The display name of the user who created this product category record. |
| Date_Entered | Datetime | True |
The date and time when this product category record was created. |
| Date_Modified | Datetime | True |
The date and time when this product category record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the product category record is flagged as deleted. It returns a value of 'false' when the record remains active. This field supports soft-delete behavior. |
| Description | String | False |
A text description of the product category. This field is commonly used to describe how the category is used or what types of products it groups together. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the product category record. It returns a value of 'false' when the record is not being followed. |
| Id [KEY] | String | True |
The unique Id of the product category record. |
| List_Order | Int | True |
The numeric position of the category in ordered lists. This value determines display and sorting priority. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field helps preserve data integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified this product category record. |
| Modified_User_Id | String | True |
The Id of the user who last modified this product category record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the product category is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The name of the product category. This value identifies the category in lists, filters, and product organization workflows. |
| Parent_Id | String | False |
The Id of the parent product category that is associated with this category. This field enables multi-level, hierarchical categorization structures. |
| Parent_Name | String | True |
The display name of the parent product category that is associated with this category. |
| Sync_Key | String | True |
An internal synchronization key that is used to align product category records across system integrations. |
| Type | String | False |
The category type, which identifies how this product category is used within the product catalog structure. |