Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemsV2ItemRevisionItemRevisionDFF

Handles descriptive flexfields specific to item revisions for contextual customization.

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 revision-level descriptive flexfields (DFFs), allowing customization of attributes specific to item revisions.
ItemsV2OrganizationId [KEY] Long The unique identifier for the organization managing the item. This identifier ensures that item revision-level DFFs are correctly assigned to the appropriate business unit, supporting data governance and access control.
ItemrevisionInventoryItemId [KEY] Long The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures proper classification and version tracking within inventory management processes.
ItemrevisionOrganizationId [KEY] Long The identifier representing the organization responsible for managing the item revision. This identifier helps maintain accurate revision tracking and ensures compliance with organizational structures and business rules.
ItemrevisionRevisionId [KEY] Long The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of changes to the item and aligns with product lifecycle management (PLM) and engineering change order (ECO) processes.
RevisionId [KEY] Long The system-generated identifier that uniquely defines a specific revision of an item. This identifier supports revision control, enabling businesses to manage engineering changes, compliance updates, and version tracking.
_FLEX_ValidationDate Date The date when the DFF attributes for the item revision were validated. This date helps enforce data accuracy and ensures that DFF attributes comply with predefined validation rules.
_FLEX_Context String The DFF context name assigned to the item revision. This context name determines how additional attributes are applied to revisions, allowing flexibility in managing item-specific and industry-specific details.
_FLEX_NumOfSegments Int The total number of segments (fields) configured within the DFF structure for item revisions. This field helps define how much metadata is associated with a revision.
_FLEX_NumOfVisibleSegments Int The number of segments (fields) that are visible to users within the DFF structure. This field determines the level of detail available for viewing or editing revision-specific attributes.
AcdType String The classification type assigned to the item revision, determining how it is processed within the system. This classification type influences business rules such as compliance tracking, product change approvals, and workflow automation.
ChangeLineId Long The unique identifier that links the item revision DFF record to a specific change request or modification. This identifier ensures traceability of revisions and supports audit tracking and compliance verification.
Finder String The reference to an internal search or query mechanism that helps users efficiently locate item revision records within the system. This reference enhances usability and enables quick retrieval of historical revisions.
InventoryOrganizationId Long The unique identifier of the inventory organization responsible for managing the item revision. This identifier ensures that revisions are properly accounted for in inventory tracking, warehouse management, and supply chain operations.
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 revision-specific DFFs.
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 revision tracking.
OrganizationCode String The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures uniformity across financial reporting, inventory tracking, and business unit operations.
OrganizationId Long The unique identifier representing the organization associated with the item revision DFF record. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards.
VersionId Long The system-generated identifier representing the version of the item revision DFF record. This identifier allows historical tracking of modifications, ensuring compliance with regulatory and business reporting requirements.

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