Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemCategories

Manages item categories, which define the classification and organization of items within catalogs.

Columns

Name Type Description
CategoryId [KEY] Long The unique identifier assigned to the item category. This identifier is used for reference but should not be included in service calls to create categories within catalogs.
CategoryCode String The unique code that identifies the item category in the user interface. This code is used for quick reference and system integration.
CategoryName String The name of the category, providing a human-readable identifier for organizing and managing item classifications.
CatalogId [KEY] Long The unique identifier assigned to the catalog that contains this category. This identifier ensures that the category is correctly linked to the appropriate catalog.
CatalogCode String The unique code that identifies the catalog in which this category resides. This code is used for navigation and reporting within the system.
ParentCategoryCode String The unique code that identifies the parent category in a category hierarchy. This code establishes the hierarchical relationship between parent and child categories.
Description String A detailed description of the item category. This field provides context on the category’s intended purpose, scope, and business use case.
StartDate Date The date when the item category becomes active. This date determines when the category is available for use in item classification.
EndDate Date The date when the item category becomes inactive. This date prevents the use of obsolete categories in new assignments.
ItemsOnlyFlag Bool Indicates whether the category can contain only items or both items and child categories. A value of 'true' means the category is restricted to items only, while 'false' allows both items and subcategories.
SharedFlag Bool Indicates whether the category is shared across multiple catalogs. A value of 'true' means the category is available for use in multiple item catalogs.
CreationDateTime Datetime The timestamp when the category was created. This timestamp helps track the category's creation for auditing and historical reference.
LastUpdateDateTime Datetime The timestamp of the most recent update to the category. This timestamp ensures proper version control and change tracking.
Bind_CatalogCode String The catalog code used for binding category data during service calls or data retrieval operations. This code ensures consistency in catalog-category relationships.
Finder String The name of the predefined finder query used to retrieve category records dynamically. This query improves search efficiency and category management.
FunctionalAreaId Long The unique identifier of the functional area associated with this category. This identifier ensures that categories are correctly linked to relevant business functions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175