DW_NS_MerchandiseHierarchyVersion_D
This table contains information about the hierarchy versions which contain complete hierarchy definition, including all the levels, nodes and assigned items in the hierarchy.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Internal ID | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| description | VARCHAR2 | 999 | Description | ||||
| enddate | TIMESTAMP | End Date | |||||
| name | VARCHAR2 | 512 | Name | ||||
| startdate | TIMESTAMP | Start Date |