ItemCategoryAssignments
Defines and manages the association between items and their assigned categories for proper classification.
Columns
| Name | Type | Description |
| CatalogId [KEY] | Long | The unique identifier of the catalog associated with this item category assignment. This identifier ensures that the category assignment is correctly linked to the appropriate catalog. |
| CatalogCode | String | The unique code assigned to the catalog. This code is used for quick reference and helps identify which catalog the category assignment belongs to. |
| CatalogName | String | The name of the catalog associated with the category assignment. This name provides a human-readable identifier for easier navigation and reporting. |
| CategoryId [KEY] | Long | The unique identifier of the category to which the item is assigned. This identifier ensures that items are correctly classified within the catalog structure. |
| CategoryCode | String | The unique code that identifies the item category. This code is used for reporting, system integration, and quick reference. |
| CategoryName | String | The name of the category associated with the item. This name provides a user-friendly reference to categorize items effectively. |
| ItemId [KEY] | Long | The unique identifier of the item being assigned to a category. This identifier ensures that each item is correctly linked to a category within the catalog. |
| OrganizationId [KEY] | Long | The unique identifier of the organization associated with the item category assignment. This identifier ensures that category assignments are properly scoped within the enterprise structure. |
| Item | String | The name or unique identifier of the item being assigned to the category. This identifier is used for product tracking and classification. |
| OrganizationCode | String | The unique code representing the organization associated with the item category assignment. This code ensures proper assignment across different organizational units. |
| ItemDescription | String | A detailed description of the item being assigned to the category. This description provides additional context for item classification and reporting. |
| ItemClassId | Long | The unique identifier of the item class associated with the item. This identifier ensures that the item classification follows predefined categorization standards. |
| ItemClassName | String | The name of the item class to which the item belongs. This name provides a human-readable reference to item classifications within the catalog structure. |
| StartDate | Date | The date when the item category assignment becomes active. This date ensures that the assignment is valid within a specific time range. |
| EndDate | Date | The date when the item category assignment expires. This date prevents the use of obsolete category assignments for items. |
| Finder | String | The name of the predefined finder query used to retrieve item category assignment records dynamically. This query improves efficiency in searching and managing category assignments. |