Planning Daily Read Measure DMO

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

Object Properties

Object API Name: PlanningDailyReadMeasure_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.
• MonthPeriodId has a FOREIGNKEY relationship with the Business Period DMO Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Day01MeasureValueNbr
• Day02MeasureValueNbr
• Day03MeasureValueNbr
• Day04MeasureValueNbr
• Day05MeasureValueNbr
• Day06MeasureValueNbr
• Day07MeasureValueNbr
• Day08MeasureValueNbr
• Day09MeasureValueNbr
• Day10MeasureValueNbr
• Day11MeasureValueNbr
• Day12MeasureValueNbr
• Day13MeasureValueNbr
• Day14MeasureValueNbr
• Day15MeasureValueNbr
• Day16MeasureValueNbr
• Day17MeasureValueNbr
• Day18MeasureValueNbr
• Day19MeasureValueNbr
• Day20MeasureValueNbr
• Day21MeasureValueNbr
• Day22MeasureValueNbr
• Day23MeasureValueNbr
• Day24MeasureValueNbr
• Day25MeasureValueNbr
• Day26MeasureValueNbr
• Day27MeasureValueNbr
• Day28MeasureValueNbr
• Day29MeasureValueNbr
• Day30MeasureValueNbr
• Day31MeasureValueNbr
• Dimension01NodeId
• Dimension01Type
• Dimension02NodeId
• Dimension02Type
• Dimension03NodeId
• Dimension03Type
• Dimension04NodeId
• Dimension04Type
• Id
• InternalOrganizationId
• KQ_Dimension01NodeId
• KQ_Dimension02NodeId
• KQ_Dimension03NodeId
• KQ_Dimension04NodeId
• KQ_Id
• KQ_MonthPeriodId
• MeasureCode
• MeasureValueType
• MonthPeriodId

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.

Day01MeasureValueNbr

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

Day02MeasureValueNbr

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

Day03MeasureValueNbr

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

Day04MeasureValueNbr

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

Day05MeasureValueNbr

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

Day06MeasureValueNbr

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

Day07MeasureValueNbr

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

Day08MeasureValueNbr

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

Day09MeasureValueNbr

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

Day10MeasureValueNbr

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

Day11MeasureValueNbr

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

Day12MeasureValueNbr

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

Day13MeasureValueNbr

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

Day14MeasureValueNbr

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

Day15MeasureValueNbr

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

Day16MeasureValueNbr

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

Day17MeasureValueNbr

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

Day18MeasureValueNbr

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

Day19MeasureValueNbr

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

Day20MeasureValueNbr

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

Day21MeasureValueNbr

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

Day22MeasureValueNbr

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

Day23MeasureValueNbr

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

Day24MeasureValueNbr

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

Day25MeasureValueNbr

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

Day26MeasureValueNbr

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

Day27MeasureValueNbr

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

Day28MeasureValueNbr

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

Day29MeasureValueNbr

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

Day30MeasureValueNbr

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

Day31MeasureValueNbr

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

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_MonthPeriodId

• Field API Name: KQ_MonthPeriodId__c
• Data Type: TEXT
• Description: Key Qualifier system field for MonthPeriodId

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.

MonthPeriodId

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