ItemCatalogscategoryHierarchiescategoryHierarchies
Manages the hierarchical relationships between item catalog categories, ensuring logical structuring and grouping.
Columns
| Name | Type | Description |
| ItemCatalogsCatalogId [KEY] | Long | The unique identifier of the item catalog associated with this category hierarchy. This identifier establishes the link between an item catalog and its hierarchical category structure. |
| CategoryhierarchiesCatalogId [KEY] | Long | The unique identifier of the catalog that contains the category hierarchy. This identifier ensures that hierarchical relationships between categories are maintained within the correct catalog. |
| CategoryhierarchiesCategoryId [KEY] | Long | The unique identifier of the category within the hierarchy. This identifier is used to track and manage category relationships across multiple hierarchies. |
| CategoryId [KEY] | Long | The unique identifier assigned to the category in the catalog hierarchy. This identifier ensures accurate categorization and data integrity. |
| CategoryCode | String | The code that uniquely identifies the category within the catalog hierarchy. This code is used in integrations, reporting, and user interfaces to reference specific categories. |
| CategoryName | String | The name of the category in the catalog hierarchy. This name provides a human-readable reference for organizing and displaying category information. |
| CatalogId [KEY] | Long | The unique identifier of the catalog that contains this category hierarchy. This identifier ensures proper association between catalogs and their hierarchical structures. |
| CatalogCode | String | The unique code assigned to the catalog that contains this category hierarchy. This code is used for quick identification and reference in system processes. |
| ParentCategoryId | Long | The unique identifier of the parent category within the hierarchy. This identifier establishes the parent-child relationship between categories, enabling hierarchical organization. |
| ParentCategoryCode | String | The unique code assigned to the parent category in the hierarchy. This code defines category structures where multiple subcategories exist under a single parent category. |
| Description | String | A detailed description of the category hierarchy. This field provides context for the category’s purpose, use cases, and functional role in the catalog. |
| StartDate | Date | The date when this category hierarchy becomes active. This date ensures that categories are available only within the intended time period. |
| EndDate | Date | The date when this category hierarchy is no longer valid. This date prevents inactive or obsolete 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 this category hierarchy is shared across multiple catalogs. A value of 'true' means the category can be used in multiple item catalogs, allowing for cross-catalog relationships. |
| CreationDateTime | Datetime | The timestamp when the category hierarchy was created. This timestamp is used for historical tracking, auditing, and reporting purposes. |
| LastUpdateDateTime | Datetime | The timestamp of the most recent update to the category hierarchy. This timestamp helps track modifications, ensuring data integrity and version control. |
| Finder | String | The name of the predefined finder query used to retrieve category hierarchy records dynamically. This query optimizes search performance and facilitates efficient category management. |