Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemsV2ItemEffCategory

Handles extensible fields for items, enabling the capture of additional characteristics such as color or size.

Columns

Name Type Description
ItemsV2ItemId [KEY] Long The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated effective categories, ensuring proper classification and business rule enforcement.
ItemsV2OrganizationId [KEY] Long The unique identifier for the organization managing the item. This identifier ensures that item-related effective categories are correctly mapped to the relevant business unit, supporting access control and data integrity.
InventoryItemId [KEY] Long The unique identifier assigned to an inventory-managed part, item, product, or service. This identifier plays a crucial role in inventory tracking, procurement, and demand planning processes.
OrganizationId [KEY] Long The unique identifier representing the organization to which the item belongs. Proper assignment of this identifier ensures that category management and classification rules are applied to the correct business unit.
StyleItemId Long The unique identifier assigned to a style item, which represents a base model or template for configurable or variant items. This identifier is essential for managing items with multiple styles or variations in industries such as fashion and manufacturing.
MasterOrganizationId Long The unique identifier for the master organization that governs the item and its associated category across multiple inventory organizations. This identifier enables central management of item definitions while allowing local customization.
CategoryCode String The standardized category code assigned to the item for classification purposes. Categories help group similar items together, enabling structured inventory management, pricing models, and reporting consistency.
StyleItemFlag Bool A flag that indicates whether the item is a style item. A style item serves as a base template for different product variations, commonly used in industries that support configurable items, such as apparel and electronics.
TemplateItemFlag String A flag that determines whether the item serves as a template for predefined item configurations. Template items are often used to streamline the creation of new products with predefined attributes.
AcdType String The classification type assigned to the item, determining how it is processed within the system. This classification type is essential for defining item behavior, influencing workflows such as pricing models, tax applicability, and supply chain rules.
ChangeLineId Long The unique identifier that links the item record to a specific change request or modification. This identifier ensures traceability of changes made to items, supporting version control and audit tracking.
Finder String The reference to an internal search or query mechanism that helps users efficiently locate item records within the system. This reference improves navigation and usability, particularly in environments with large datasets.
InventoryOrganizationId Long The unique identifier of the inventory organization responsible for managing the item. This identifier is critical for aligning inventory transactions, ensuring stock availability, and managing warehouse operations.
ItemId Long The unique identifier for the item, serving as a key reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to effective categories and ensuring accurate data tracking.
ItemNumber String A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference and item identification.
OrganizationCode String The standardized alphanumeric code representing the organization responsible for the item. This code ensures consistency across financial reporting, inventory tracking, and business unit operations.
VersionId Long The system-generated identifier representing the version of the item record. This identifier allows historical tracking of changes, ensuring compliance with regulatory and business reporting requirements.

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