Planning Dimension Node Relation DMO

Defines the relationships between different dimensions.

Object Properties

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

Relationships

• DimensionNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• RelatedDimensionNodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DimensionNodeId
• DimensionType
• EndDate
• Id
• InternalOrganizationId
• KQ_DimensionNodeId
• KQ_Id
• KQ_RelatedDimensionNodeId
• RelatedDimensionNodeId
• RelatedDimensionType
• StartDate

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.

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.

DimensionNodeId

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

DimensionType

• Field API Name: DimensionType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the dimension type.

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_DimensionNodeId

• Field API Name: KQ_DimensionNodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DimensionNodeId

KQ_Id

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

KQ_RelatedDimensionNodeId

• Field API Name: KQ_RelatedDimensionNodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RelatedDimensionNodeId

RelatedDimensionNodeId

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

RelatedDimensionType

• Field API Name: RelatedDimensionType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the related dimension type.

StartDate

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