Planning Monthly Read Measure DMO

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

Object Properties

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

Relationships

• 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.

Fields

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

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.

Dimension01NodeId

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

Dimension01Type

• Field API Name: Dimension01Type__c
• Data Type: TEXT
• Description: Alphanumeric string representing the dimension01 type.

Dimension02NodeId

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

Dimension02Type

• Field API Name: Dimension02Type__c
• Data Type: TEXT
• Description: Alphanumeric string representing the dimension02 type.

Dimension03NodeId

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

Dimension03Type

• Field API Name: Dimension03Type__c
• Data Type: TEXT
• Description: Alphanumeric string representing the dimension03 type.

Dimension04NodeId

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

Dimension04Type

• Field API Name: Dimension04Type__c
• Data Type: TEXT
• Description: Alphanumeric string representing the dimension04 type.

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_Dimension01NodeId

• Field API Name: KQ_Dimension01NodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for Dimension01NodeId

KQ_Dimension02NodeId

• Field API Name: KQ_Dimension02NodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for Dimension02NodeId

KQ_Dimension03NodeId

• Field API Name: KQ_Dimension03NodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for Dimension03NodeId

KQ_Dimension04NodeId

• Field API Name: KQ_Dimension04NodeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for Dimension04NodeId

KQ_Id

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

KQ_YearPeriodId

• Field API Name: KQ_YearPeriodId__c
• Data Type: TEXT
• Description: Key Qualifier system field for YearPeriodId

MeasureCode

• Field API Name: MeasureCode__c
• Data Type: TEXT
• Description: Alphanumeric string representing the measure code.

MeasureValueType

• Field API Name: MeasureValueType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the measure value type.

Month01MeasureValueNbr

• Field API Name: Month01MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month01 measure value nbr. Do not include currency symbols or commas.

Month02MeasureValueNbr

• Field API Name: Month02MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month02 measure value nbr. Do not include currency symbols or commas.

Month03MeasureValueNbr

• Field API Name: Month03MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month03 measure value nbr. Do not include currency symbols or commas.

Month04MeasureValueNbr

• Field API Name: Month04MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month04 measure value nbr. Do not include currency symbols or commas.

Month05MeasureValueNbr

• Field API Name: Month05MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month05 measure value nbr. Do not include currency symbols or commas.

Month06MeasureValueNbr

• Field API Name: Month06MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month06 measure value nbr. Do not include currency symbols or commas.

Month07MeasureValueNbr

• Field API Name: Month07MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month07 measure value nbr. Do not include currency symbols or commas.

Month08MeasureValueNbr

• Field API Name: Month08MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month08 measure value nbr. Do not include currency symbols or commas.

Month09MeasureValueNbr

• Field API Name: Month09MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month09 measure value nbr. Do not include currency symbols or commas.

Month10MeasureValueNbr

• Field API Name: Month10MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month10 measure value nbr. Do not include currency symbols or commas.

Month11MeasureValueNbr

• Field API Name: Month11MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month11 measure value nbr. Do not include currency symbols or commas.

Month12MeasureValueNbr

• Field API Name: Month12MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month12 measure value nbr. Do not include currency symbols or commas.

Month13MeasureValueNbr

• Field API Name: Month13MeasureValueNbr__c
• Data Type: DOUBLE
• Description: Numeric value representing the month13 measure value nbr. Do not include currency symbols or commas.

YearPeriodId

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