Planning Annual Read Measure DMO

Stores specific measurement values (e.g., quantity) for dimensions aggregated annually.

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

• Dimension01NodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• Dimension02NodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• Dimension03NodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• Dimension04NodeId has a FOREIGNKEY relationship with the Planning Dimension Node DMO Id field.
• YearPeriodId has a FOREIGNKEY relationship with the Business Period DMO Id field.

• AnnualMeasureValueNbr
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Dimension01NodeId
• Dimension01Type
• Dimension02NodeId
• Dimension02Type
• Dimension03NodeId
• Dimension03Type
• Dimension04NodeId
• Dimension04Type
• Id
• InternalOrganizationId
• MeasureCode
• MeasureValueType
• YearPeriodId

• Field API Name: std__AnnualMeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measure value recorded for a complete year.

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

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

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

• Field API Name: std__Dimension01NodeId__c
• Data Type: TEXT
• Description: The unique ID of the first planning dimension node associated with this measure value, such as an account ID.

• Field API Name: std__Dimension01Type__c
• Data Type: TEXT
• Description: The classification of the first planning dimension node, such as Account or Product.

• Field API Name: std__Dimension02NodeId__c
• Data Type: TEXT
• Description: The unique ID of the second planning dimension node associated with this measure value, such as an product ID.

• Field API Name: std__Dimension02Type__c
• Data Type: TEXT
• Description: The classification of the second planning dimension node, such as Account or Product.

• Field API Name: std__Dimension03NodeId__c
• Data Type: TEXT
• Description: The unique ID of the third planning dimension node associated with this measure value, such as an account ID.

• Field API Name: std__Dimension03Type__c
• Data Type: TEXT
• Description: The classification of the third planning dimension node, such as Account or Product.

• Field API Name: std__Dimension04NodeId__c
• Data Type: TEXT
• Description: The unique ID of the fourth planning dimension node associated with this measure value, such as an account ID.

• Field API Name: std__Dimension04Type__c
• Data Type: TEXT
• Description: The classification of the fourth planning dimension node, such as Account or Product.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: A unique identifier for this specific yearly measure record.

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

• Field API Name: std__MeasureCode__c
• Data Type: TEXT
• Description: The code identifying the metric associated with this measure value, such as Order-Quantity or Revenue.

• Field API Name: std__MeasureValueType__c
• Data Type: TEXT
• Description: The data format or unit of measure for the metric values stored.

• Field API Name: std__YearPeriodId__c
• Data Type: TEXT
• Description: The ID of the year period associated with the annual measure values.