ItemsLOVItemCategories
The association of a category to a catalog or a child category to a parent category, such as the association of the Televisions category to the Summer catalog or to the Electronics category.
Columns
| Name | Type | Description |
| ItemsLOVItemId | String | Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| ItemsLOVOrganizationId | String | Find items according to the specified primary key criteria. |
| ItemId | String | Value that uniquely identifies the part, item, product, or service. |
| OrganizationId | String | A unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. |
| ItemCategoryId | String | Value that uniquely identifies the category |
| ItemCatalog | String | Name of the item catalog. |
| CategoryId | String | Value that uniquely identifies the category. |
| CategoryName | String | Name of the category. |
| SequenceNumber | Int | Value that indicates the sequence number of the item category assignments. |
| AltItemCatCode | String | Abbreviation that identifies the item catalog. |
| ItemCategoryAssignmentId | String | Value that uniquely identifies the item category assignment. |
| CreationDateTime | Datetime | Date and time of the creation of the item catalog category assignment. |
| ObjectVersionNumber | Int | This value is set to value of 1 when the item is created and incremented every time the item is updated. |
| LastUpdateDateTime | Datetime | Date and time when the user most recently updated the item-category association. |
| OrganizationId1 | String | A unique identifier for an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. |
| InventoryItemId | String | Value that uniquely identifies the part, item, product, or service. |
| CategoryCode | String | A unique code that represents a component of the catalog used for classification of items. |
| CreatedBy | String | User who created the item category assignment. |
| LastUpdateLogin | String | Login that the user used when updating the item-category association.. |
| LastUpdatedBy | String | User who most recently updated the item-category association. |
| ItemCategoryHierarchyName | String | Value that represents category hierarchy using category names. |
| ItemCategoryHierarchyCode | String | Value that represents category hierarchy using category codes. |
| StartDate | Date | Date when the item association begins. The start date cannot be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area. |
| EndDate | Date | Date when the item association ends. The end date cannot be specified for functional area catalogs, except for the catalog assigned to the service logistics functional area. |
| RequestId | String | The request ID generated at import. Its use case is to verify the import. The items are published based on RequestID. |