---
schema_version: "1"
id: 0283dc5f10db54d3913ecd779834221e206cdcdc25e683eec79a7e18e295a94c
title: Planning Dimension Node Hierarchy DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-planningdimensionnodehierarchydmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-planningdimensionnodehierarchydmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 3b50189484b4f67d6b08c2106e5b2694c9b0d1ef26df9dca80f7d7a2781fdc37
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Planning Dimension Node Hierarchy DMO

Defines the parent-child relationships between dimension nodes in the dimension hierarchy.

## Object Properties

**Object API Name:** `PlanningDimensionNodeHierarchy_std__dlm`  
**Category:** Unassigned  
**Availability:** Available in 262 and later versions  
**Primary Key Field:** Id  

## Relationships

- **ParentNodeId** has a FOREIGNKEY relationship with the [Planning Dimension Node DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-planningdimensionnodedmo-dmo.md) `Id` field.
- **ChildNodeId** has a FOREIGNKEY relationship with the [Planning Dimension Node DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-planningdimensionnodedmo-dmo.md) `Id` field.


## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ChildNodeId](#childnodeid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EndDate](#enddate)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_ChildNodeId](#kq_childnodeid)
- [KQ_Id](#kq_id)
- [KQ_ParentNodeId](#kq_parentnodeid)
- [ParentNodeId](#parentnodeid)
- [StartDate](#startdate)
- [StructureType](#structuretype)
- [UsageType](#usagetype)

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### ChildNodeId

- **Field API Name:** `ChildNodeId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### EndDate

- **Field API Name:** `EndDate__c`
- **Data Type:** DATEONLY
- **Description:** Date and time when the record or activity ended.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_ChildNodeId

- **Field API Name:** `KQ_ChildNodeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ChildNodeId

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_ParentNodeId

- **Field API Name:** `KQ_ParentNodeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ParentNodeId

### ParentNodeId

- **Field API Name:** `ParentNodeId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### StartDate

- **Field API Name:** `StartDate__c`
- **Data Type:** DATEONLY
- **Description:** Date and time when the record or activity began.

### StructureType

- **Field API Name:** `StructureType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the structure type.

### UsageType

- **Field API Name:** `UsageType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the usage type.