DW_NS_MERCHANDISE_HIERARCHY_DH
This table contains information about the items all hierarchy versions, node and the level to which the item belongs to in different versions.
Details
Module:
Key Columns
item, hierarchyversion, startdate, enddate
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| item | NUMBER | 38 | 0 | True | DW_NS_item_D | id | |
| hierarchyversion | NUMBER | 38 | 0 | True | DW_NS_MerchandiseHierarchyVersion_D | id | |
| startdate | TIMESTAMP | True | |||||
| enddate | TIMESTAMP | True | |||||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. | ||||
| hierarchylevel | NUMBER | 38 | 0 | DW_NS_MerchandiseHierarchyLevel_D | id | ||
| hierarchynode | NUMBER | 38 | 0 | DW_NS_MerchandiseHierarchyNode_D | id | ||
| parentnode | NUMBER | 38 | 0 | DW_NS_MerchandiseHierarchyNode_D | id | ||
| path | VARCHAR2 | 999 |