Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemsV2ItemRevisionItemRevisionEffCategory

Manages extensible flexfields for item revisions, capturing custom attributes related to changes.

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-effective categories, ensuring structured classification and version control.
ItemsV2OrganizationId [KEY] Long The unique identifier for the organization managing the item. This identifier ensures that item revision-effective categories are correctly mapped to the appropriate business unit, supporting governance, access control, and reporting.
ItemrevisionInventoryItemId [KEY] Long The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier plays a crucial role in ensuring that revised items are accurately tracked within inventory management.
ItemrevisionOrganizationId [KEY] Long The identifier representing the organization responsible for managing the item revision. This identifier at the revision is assigned to the correct organization, maintaining data integrity across business units.
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 supports version tracking across engineering, procurement, and inventory processes.
RevisionId [KEY] Long The system-generated identifier that uniquely defines a specific revision of an item. This identifier is essential for revision control, enabling businesses to manage product lifecycle changes, compliance updates, and engineering modifications.
CategoryCode String The standardized category code assigned to the item revision, determining how the revised item is classified. Categories help group similar revisions together, enabling structured management of versioned products and components.
VersionId Long The system-generated identifier representing the version of the item revision-effective category record. This identifier supports historical tracking of changes to item classification, ensuring compliance with regulatory and business reporting standards.
AcdType String The classification type assigned to the item revision, defining how it is processed within the system. This classification type affects workflows such as compliance tracking, approval processes, and category-specific business rules.
ChangeLineId Long The unique identifier that links the item revision record to a specific change request or engineering change order (ECO). This identifier ensures traceability of revisions and supports controlled change management processes.
Finder String The reference to an internal search or query mechanism that allows users to efficiently locate item revision-effective category records within the system. This reference enhances usability and enables quick retrieval of classified 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 operations, and supply chain workflows.
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-effective category assignments.
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 revision tracking.
OrganizationCode String The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures consistency across financial reporting, inventory tracking, and business unit operations.
OrganizationId Long The unique identifier representing the organization associated with the item revision-effective category. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards.

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