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 Hub
Key Columns
ITEM_RELATIONSHIP_ID
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 |