ItemCatalogscategoryHierarchies
Defines and manages hierarchical structures for organizing item catalog categories for better navigation and classification.
Columns
| Name | Type | Description |
| ItemCatalogsCatalogId [KEY] | Long | The unique identifier of the catalog associated with this category hierarchy. This identifier establishes the relationship between an item catalog and its category structure. |
| CategoryId [KEY] | Long | The unique identifier assigned to the category within the catalog hierarchy. This identifier is used to track and manage category-level details. |
| CategoryCode | String | The code that uniquely identifies the category within the catalog. This code is used in reports, integrations, and user interfaces to reference specific categories. |
| CategoryName | String | The name of the category within the catalog hierarchy. This name provides a human-readable identifier for organizing and displaying category information. |
| CatalogId [KEY] | Long | The unique identifier of the catalog that contains this category hierarchy. This identifier ensures that categories are correctly linked to their respective catalogs. |
| CatalogCode | String | The unique code assigned to the catalog that contains this category hierarchy. This code is used for quick identification and reference within the system. |
| ParentCategoryId | Long | The unique identifier of the parent category in the hierarchy. This identifier establishes the parent-child relationship between categories, enabling hierarchical organization. |
| ParentCategoryCode | String | The unique code assigned to the parent category. This code helps define category structures where multiple subcategories exist under a single parent category. |
| Description | String | A detailed description of the category hierarchy. This field provides additional information on the category's purpose, usage, and scope within the catalog. |
| StartDate | Date | The date when this category hierarchy becomes active. This date ensures that categories are available only during the intended time period. |
| EndDate | Date | The date when this category hierarchy is no longer valid. This date prevents deprecated categories from being assigned to new items. |
| ItemsOnlyFlag | Bool | Indicates whether only items can be assigned to this category. If set to 'true', the category cannot have subcategories and is used exclusively for item assignments. |
| SharedFlag | Bool | Indicates whether the category hierarchy is shared across multiple catalogs. If set to 'true', the category can be used in multiple item catalogs. |
| CreationDateTime | Datetime | The timestamp when the category hierarchy was created. This timestamp is used for historical tracking and auditing purposes. |
| LastUpdateDateTime | Datetime | The timestamp of the most recent update to the category hierarchy. This timestamp helps track modifications and maintain version control. |
| Finder | String | The name of the predefined finder query used to retrieve category hierarchy records dynamically. This query improves efficiency in category structure searches and reporting. |