CatalogCategoryHierarchyNodes
Organizes catalog categories in a hierarchical structure, enabling guided navigation for items or services in procurement.
Columns
| Name | Type | Description |
| CategoryId [KEY] | Long | Unique identifier for the category in the CatalogCategoryHierarchyNodes table. This ID is used to reference and manage specific categories in the catalog hierarchy. |
| CategoryName | String | The name of the category within the catalog hierarchy. This value is used to label and identify the category in various views or reports. |
| CategoryImageUrl | String | The URL to the image representing the category. This image is typically displayed in the user interface to visually represent the category in the catalog. |
| ItemCategoryFlag | Bool | A flag indicating whether the category is an item category. This value helps to distinguish between categories that contain items and those that may serve other purposes. |
| CategoryDescription | String | A textual description of the category. This field provides more detailed information about the category and is often used to explain its purpose or contents. |
| FeaturedCategoryFlag | Bool | A flag that identifies whether the category is featured within the catalog. Featured categories are typically given prominence in the user interface to attract attention. |
| ParentCategoryId [KEY] | Long | The unique identifier of the parent category in the catalog hierarchy. This value helps establish the hierarchical relationship between categories, indicating which category is the parent of the current category. |
| ParentCategoryName | String | The name of the parent category in the catalog hierarchy. This field provides context by identifying the higher-level category under which the current category is nested. |
| CreatedBy | String | The user or system that created the category record. This field tracks the origin of the category and is important for auditing and data management. |
| CreationDate | Datetime | The date and time when the category record was created. This timestamp helps track when the category was first introduced into the catalog system. |
| LastUpdatedBy | String | The user or system that last updated the category record. This field is important for tracking changes made to the category and can be used in audits. |
| LastUpdateDate | Datetime | The date and time when the category record was last updated. This timestamp allows users to track when the category was last modified, ensuring data currency. |
| Finder | String | A field used for searching or locating specific category records within the system. It may contain keywords or other criteria to assist in identifying the category quickly. |
| Keyword | String | Keywords associated with the category to help improve searchability. This field is used to store relevant terms that can be used to locate the category in search queries. |
| UserPreferenceId | Long | Unique identifier for the user preference associated with the category. This field links a user's preferences to specific categories, influencing the presentation of the catalog to the user. |