ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemsV2ItemGlobalDFF

Manages global descriptive flexfields for items, standardizing attributes across the system.

Columns

Name Type Description
ItemsV2ItemId [KEY] Long The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to global descriptive flexfields (DFFs), allowing customization of item attributes for different business needs.
ItemsV2OrganizationId [KEY] Long The unique identifier for the organization that owns or manages the item. This identifier ensures that global DFFs are properly associated with the relevant business unit, supporting access control and organizational data governance.
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, ensuring accurate classification of globally defined item attributes.
OrganizationId [KEY] Long The unique identifier representing the organization to which the item belongs. This identifier ensures that item-level global DFFs are correctly applied across business units and align with enterprise reporting standards.
_FLEX_Context String The DFF context name assigned to the item. This context name determines how additional attributes are applied to items globally, enabling customization of item records based on operational needs.
_FLEX_Context_DisplayValue String A human-readable display value for the DFF context. This value provides an easy-to-understand label for users interacting with item attributes in various modules such as procurement, sales, and inventory.
AcdType String The classification type assigned to the item, which determines how the item is processed within the system. This classification type affects workflows such as tax determination, pricing structures, and business rules related to global product categorization.
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 at a global level, supporting version control, audit tracking, and compliance.
Finder String The reference to an internal search or query mechanism that allows users to efficiently locate item records with associated global DFFs. This reference enhances navigation and usability within enterprise applications.
InventoryOrganizationId Long The unique identifier of the inventory organization responsible for managing the item. This identifier ensures that globally defined item attributes align with inventory processes, stock movement, and warehouse management.
ItemId Long The unique identifier for the item, serving as a reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to their global DFFs 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 to provide quick reference and ensure consistency in global item tracking.
OrganizationCode String The standardized alphanumeric code representing the organization responsible for the item. This code ensures uniformity 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 modifications to global DFFs, ensuring compliance with regulatory and business reporting requirements.

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