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
| 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 |