Planning Monthly Read Measure DMO

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

Object API Name: std__PlanningMonthlyReadMeasureDmo__dlm
Category: Unassigned
Availability: Available in 262 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.

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Dimension01NodeId
• Dimension01Type
• Dimension02NodeId
• Dimension02Type
• Dimension03NodeId
• Dimension03Type
• Dimension04NodeId
• Dimension04Type
• Id
• InternalOrganizationId
• MeasureCode
• MeasureValueType
• Month01MeasureValueNbr
• Month02MeasureValueNbr
• Month03MeasureValueNbr
• Month04MeasureValueNbr
• Month05MeasureValueNbr
• Month06MeasureValueNbr
• Month07MeasureValueNbr
• Month08MeasureValueNbr
• Month09MeasureValueNbr
• Month10MeasureValueNbr
• Month11MeasureValueNbr
• Month12MeasureValueNbr
• Month13MeasureValueNbr
• YearPeriodId

• 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 node of the first dimension used for aggregation, such as Account ID.

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

• Field API Name: std__Dimension02NodeId__c
• Data Type: TEXT
• Description: The unique ID of the node of the second dimension used for aggregation, such as Product ID.

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

• Field API Name: std__Dimension03NodeId__c
• Data Type: TEXT
• Description: The unique ID of the node of the third dimension used for aggregation, such as Account ID.

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

• Field API Name: std__Dimension04NodeId__c
• Data Type: TEXT
• Description: The unique ID of the node of the fourth dimension used for aggregation, such as Product ID.

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

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: A unique identifier for this specific monthly 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 unique identifier or code for the specific metric being measured, such as 'Order-Quantity' or 'Revenue'.

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

• Field API Name: std__Month01MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 1 of the year.

• Field API Name: std__Month02MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 2 of the year.

• Field API Name: std__Month03MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 3 of the year.

• Field API Name: std__Month04MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 4 of the year.

• Field API Name: std__Month05MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 5 of the year.

• Field API Name: std__Month06MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 6 of the year.

• Field API Name: std__Month07MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 7 of the year.

• Field API Name: std__Month08MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 8 of the year.

• Field API Name: std__Month09MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 9 of the year.

• Field API Name: std__Month10MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 10 of the year.

• Field API Name: std__Month11MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 11 of the year.

• Field API Name: std__Month12MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 12 of the year.

• Field API Name: std__Month13MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The measured numerical value recorded for month 13 of the year.

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