# DW_ITEM_REL_GTIN_D (Preview)

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

## Details

Module: Product Model

## Key Columns

ITEM_RELATIONSHIP_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ITEM_RELATIONSHIP_ID | NUMBER | 38 | 0 | True | Item Relationship Identifier | DW_ITEM_RELATIONSHIPS_D_TL | ITEM_RELATIONSHIP_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
GTIN | VARCHAR2 | 512 |  |  | GTIN Number |  |
GTIN_UOM_CODE | VARCHAR2 | 32 |  |  | GTIN Unit of Measure Code | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
GTIN_PARTY_TYPE_CODE | VARCHAR2 | 32 |  |  | GTIN Treading Partner Type Code | DW_EGP_GTIN_PARTY_TYPES_LKP_TL | EGP_GTIN_PARTY_TYPES_CODE
GTIN_TRADING_PARTNER_ID | NUMBER | 38 | 0 |  | GTIN Trading Partner Identifier | DW_PARTY_D | PARTY_ID
EPC_GTIN_SERIAL | NUMBER |  |  |  | EPC or Global Trade Identification Number Serial Value |  |
REVISION_ID | NUMBER |  |  |  | Attribute to specify the item revision identifier. | DW_ITEM_REVISIONS_D | REVISION_ID
GTIN_ACD_TYPE | VARCHAR2 | 32 |  |  | GTIN ACD Type |  |
GTIN_CREATION_TIMESTAMP | TIMESTAMP |  |  |  | GTIN Creation Timestamp |  |
GTIN_LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | GTIN Last Update Timestamp |  |

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