Planning Dimension Node Hierarchy DMO

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

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

• ParentNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• ChildNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.

• cdp_sys_record_currency
• ChildNodeId
• DataSourceId
• DataSourceObjectId
• EndDate
• Id
• InternalOrganizationId
• KQ_ChildNodeId
• KQ_Id
• KQ_ParentNodeId
• ParentNodeId
• StartDate
• StructureType
• UsageType

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

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

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

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

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

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

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

• Field API Name: KQ_ChildNodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ChildNodeId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_ParentNodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentNodeId

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

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

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

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