ItemsV2ItemCategory
Manages the relationship between items and their assigned categories within the catalog.
Columns
| Name | Type | Description |
| ItemsV2ItemId [KEY] | Long | The unique identifier for an item in the ItemsV2 module, establishing a direct link between the item and its category assignment. This identifier ensures proper classification within the inventory system. |
| ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization that owns or manages the item. This identifier ensures that the item's category assignment is correctly linked to the appropriate business entity. |
| ItemId | Long | The unique identifier assigned to a specific part, item, product, or service. This identifier is essential for accurately categorizing and managing items across multiple catalogs and classifications. |
| OrganizationId | Long | The unique identifier for the organization associated with the item category assignment. This identifier ensures that the categorization aligns with the correct business unit, controlling visibility and access. |
| ItemCatalog | String | The name of the item catalog that organizes and classifies items. Item catalogs help standardize product groupings, streamline searches, and support procurement and inventory workflows. |
| CategoryName | String | The name of the item category that defines how an item is classified within a catalog. Categories are used for reporting, searching, and enforcing business rules related to items. |
| SequenceNumber | Int | The numerical sequence used internally for organizing and ordering category assignments. This numerical sequence is system-managed and not exposed in application code but ensures structured category hierarchies. |
| ItemCategoryAssignmentId [KEY] | Long | The unique identifier for the assignment of an item to a category. This identifier record tracks the specific categorization of an item and allows users to audit classification changes over time. |
| CreationDateTime | Datetime | The timestamp indicating when the item category assignment was first created. This timestamp is useful for maintaining historical records and ensuring traceability of when an item was classified into a category. |
| LastUpdateDateTime | Datetime | The timestamp of the most recent update to the item category assignment. This timestamp helps track when and why an item’s category was modified and ensures up-to-date classification data. |
| CategoryCode | String | The standardized abbreviation used to identify an item category. This abbreviation is used in various system transactions and can be configured using the Setup and Maintenance work area in the Manage Catalogs task. |
| CreatedBy | String | The username or system entity that originally created the item category assignment. This username or system entity is essential for auditing, as it provides accountability for changes to item classifications. |
| LastUpdateLogin | String | The login session or system reference associated with the most recent update to the item category assignment. This value helps administrators track user activity and session-based modifications. |
| LastUpdatedBy | String | The username or system entity responsible for the latest modification to the item category assignment. This username or system entity is used for audit logging and tracking classification updates. |
| ItemCategoryHierarchyName | String | The name of the hierarchy structure in which the item category is placed. Item-category hierarchies provide multi-level categorization for grouping related products and services. |
| ItemCategoryHierarchyCode | String | The unique system-generated code that identifies a specific item category hierarchy. This code ensures standardization across multiple catalogs and supports structured reporting. |
| StartDate | Date | The date when the item category assignment becomes active. This date determines when an item is considered part of a category and affects category-driven system processes such as pricing and availability. Functional area catalogs, except those assigned to service logistics, do not allow a start date. |
| EndDate | Date | The date when the item category assignment is no longer valid. This date defines the end of an item's association with a specific category and is important for phasing out obsolete classifications. Functional area catalogs, except those assigned to service logistics, do not allow an end date. |
| RequestId | Long | The unique identifier assigned to an import request that processes item category assignments. This identifier is generated automatically during import and is used for tracking and validating item publishing operations. |
| AcdType | String | The classification type assigned to the item category, which determines its processing logic within the system. This classification type can influence reporting, workflows, and downstream transactions. |
| ChangeLineId | Long | The identifier linking an item category assignment to a specific change request. This identifier ensures traceability of modifications related to category updates, product reclassifications, or organizational changes. |
| Finder | String | The reference to an internal search or retrieval mechanism that allows users to quickly locate item category assignments based on filters or search parameters. |
| InventoryOrganizationId | Long | The unique identifier for the inventory organization responsible for managing the item. This identifier ensures that categorization is aligned with inventory tracking and warehouse management processes. |
| ItemNumber | String | The human-readable item number assigned to an item. This item number provides an easily recognizable reference for users searching for items in catalogs and category assignments. |
| OrganizationCode | String | The standardized alphanumeric code representing the organization responsible for the item category assignment. This code ensures consistency across reports and integrations. |
| VersionId | Long | The system-generated identifier representing the version of an item category assignment. Versioning allows tracking of changes over time, ensuring that users can reference historical classification data. |