# DW_ITEM_REVISIONS_D (Preview)

This table requires activation of Item Management functional area. This table stores item revision details.

## Details

Module: Product Hub

## Key Columns

REVISION_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
REVISION_ID | NUMBER | 38 | 0 | True | Revision Identifier | DW_ITEM_REVISIONS_D_TL | REVISION_ID
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source Record Identifier |  |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Inventory Item Identifier | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
ORGANIZATION_ID | NUMBER | 38 | 0 |  | Organization Identifier | DW_INVENTORY_ITEM_D | ORGANIZATION_ID
REVISION | VARCHAR2 | 32 |  |  | Revision Code |  |
REVISION_ID_CHAR | VARCHAR2 | 64 |  |  | Revision Identifier(in char datatype). |  |
REVISION_REASON_CODE | VARCHAR2 | 32 |  |  | Revision Reson Code |  |
REVISION_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Revision Creation Timestamp |  |
REVISION_CREATION_DATE | DATE |  |  |  | Revision Creation Date | DW_DAY_D | CALENDAR_DATE
REVISION_INITIATION_TIMESTAMP | TIMESTAMP |  |  |  | Revision Initiation Timestamp |  |
REVISION_INITIATION_DATE | DATE |  |  |  | Revision Initiation Date | DW_DAY_D | CALENDAR_DATE
REVISION_IMPLEMENTATION_TIMESTAMP | TIMESTAMP |  |  |  | Revision Implementation Timestamp |  |
REVISION_IMPLEMENTATION_DATE | DATE |  |  |  | Revision Implementation Date | DW_DAY_D | CALENDAR_DATE
REVISION_EFFECTIVITY_TIMESTAMP_SOURCE | TIMESTAMP |  |  |  | Revision Effective Timestamp - Same as source |  |
REVISION_EFFECTIVITY_TIMESTAMP | TIMESTAMP |  |  |  | Revision Effective Timestamp |  |
REVISION_EFFECTIVITY_DATE | DATE |  |  |  | Revision Effective Date | DW_DAY_D | CALENDAR_DATE
REVISION_END_EFFECTIVITY_TIMESTAMP_SOURCE | TIMESTAMP |  |  |  | Revision End Effective Timestamp - Same as source |  |
REVISION_END_EFFECTIVITY_TIMESTAMP | TIMESTAMP |  |  |  | Revision End Effective Timestamp |  |
REVISION_END_EFFECTIVITY_DATE | DATE |  |  |  | Revision End Effective Date | DW_DAY_D | CALENDAR_DATE
REVISION_CHANGE_LINE_ID | NUMBER | 38 | 0 |  | Change Line Identifier |  |
REVISION_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Revision Last Update Date |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.