ItemsV2ItemRevision
Tracks and manages revision details for items, ensuring accurate record-keeping of changes over time.
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 their associated revisions, ensuring traceability of changes and historical tracking of modifications. |
| ItemsV2OrganizationId [KEY] | Long | The unique identifier for the organization that owns or manages the item. This identifier ensures that revisions are correctly mapped to the appropriate business unit, supporting compliance and revision control. |
| RevisionId [KEY] | Long | The unique system-generated identifier that distinguishes a specific revision of an item. This identifier allows businesses to track modifications over time and manage engineering or design updates. |
| ItemId | Long | The unique identifier assigned to a specific part, item, product, or service. This identifier is crucial for maintaining the link between items and their revision history, ensuring that updates and modifications are properly recorded. |
| OrganizationId [KEY] | Long | The unique identifier representing the organization to which the item belongs. Proper assignment ensures that revision control aligns with the correct business unit and operational processes. |
| RevisionCode | String | The code assigned to the revision of an item. This helps categorize and track changes. This code allows businesses to differentiate between multiple versions of a product or component. |
| ItemRevisionDescription | String | The detailed description of the item revision. This description provides insight into the purpose of the revision, documenting changes such as design updates, compliance modifications, or process improvements. |
| RevisionReasonValue | String | The reason for the revision, selected from a predefined list of accepted values under the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. This field provides structured documentation of why an item was revised, supporting compliance and process standardization. |
| EffectivityDate | Datetime | The date when the revision goes into effect. This date ensures that business processes such as manufacturing, procurement, and sales recognize the correct version of the item at the appropriate time. |
| ImplementationDate | Datetime | The date when the revised item is officially implemented in operations. This date is critical for synchronizing production schedules, supplier updates, and inventory adjustments. |
| EndEffectivityDate | Datetime | The date when the item revision is no longer in effect. This date businesses transition to newer revisions while maintaining accurate historical records for audit and compliance. |
| RevisionExtensibleFlexfieldCategoryCode | String | The abbreviation that identifies the item class associated with the item revision's extensible flexfield (EFF). This abbreviation allows for additional customized attributes relevant to specific product categories and can be configured using the Manage Item Classes task in the Setup and Maintenance work area. |
| CreationDateTime | Datetime | The timestamp indicating when the item revision was first created. This timestamp helps track historical changes and ensure proper version control. |
| LastUpdateDateTime | Datetime | The timestamp of the most recent update to the item revision record. This timestamp ensures traceability of modifications and supports compliance with revision control policies. |
| CreatedBy | String | The username or system entity that originally created the item revision. This username or entity is essential for audit trails and accountability in revision management. |
| LastUpdateLogin | String | The session login or system reference associated with the last update to the item revision. This information is useful for security audits and tracking user activity. |
| LastUpdatedBy | String | The username or system entity responsible for the most recent modification to the item revision. This username or entity helps maintain accountability and track changes made to revision records. |
| RequestId | Long | The unique identifier assigned to an import request related to item revisions. This identifier is generated during data imports and is used for tracking and verifying the success or failure of revision updates. |
| AcdType | String | The classification type assigned to the item revision, determining how the revision is processed within the system. This classification type is critical for business rules such as compliance tracking, engineering change orders, and procurement updates. |
| ChangeLineId | Long | The unique identifier linking the item revision 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 allows users to efficiently locate item revision records. This reference improves 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 within inventory tracking, warehouse management, and supply chain operations. |
| 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. 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 revision record. This identifier allows historical tracking of modifications, ensuring compliance with regulatory and business reporting requirements. |