CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemsV2ItemDFF

Manages contextual descriptive flexfields specific to items, allowing for tailored attribute definitions.

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 descriptive flexfields (DFFs), ensuring accurate classification, reporting, and business rule enforcement.
ItemsV2OrganizationId [KEY] Long The unique identifier for the organization managing the item. This identifier ensures that item-related DFFs are correctly mapped to the relevant business unit, supporting access control and data segregation.
InventoryItemId [KEY] Long The unique identifier assigned to a specific inventory part, item, product, or service. This identifier is critical for tracking products across procurement, warehouse management, sales, and financial reporting.
OrganizationId [KEY] Long The identifier representing the organization to which the item belongs. This identifier is essential for maintaining accurate inventory and financial records and should be reviewed and updated using the Setup and Maintenance work area under the Manage Inventory Organizations task.
_FLEX_Context String The DFF context name assigned to the item. This field is used to capture additional custom attributes that vary based on business requirements, allowing greater flexibility in item classification and reporting.
_FLEX_Context_DisplayValue String The human-readable display value of the DFF context. This value provides a user-friendly label for custom attributes associated with the item.
AcdType String The classification type assigned to the item, which determines 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 field 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 DFFs and ensuring accurate data tracking.
ItemNumber String The 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