DW_ITEM_REL_SPOKE_SYSTEM_D (Preview)
This table requires activation of Item Management functional area. This table stores spoke system 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 | |
| SPOKE_SOURCE_SYSTEM_ID | NUMBER | Spoke Source System Identifier | DW_SOURCE_SYSTEMS_TL | SOURCE_SYSTEM_ID | |||
| SPOKE_SOURCE_ITEM | VARCHAR2 | 512 | Spoke Source System Item | ||||
| SPOKE_START_TIMESTAMP | TIMESTAMP | Spoke System Start Timestamp | |||||
| SPOKE_END_TIMESTAMP | TIMESTAMP | Spoke System End Timestamp | |||||
| SPOKE_ACD_TYPE | VARCHAR2 | 32 | Spoke System ACD Type | ||||
| SPOKE_CREATION_TIMESTAMP | TIMESTAMP | Spoke Source System Creation Timestamp | |||||
| SPOKE_LAST_UPDATE_TIMESTAMP | TIMESTAMP | Spoke Source System Last Update Timestamp |