Promotion Product Measure DMO

Each row represents the measure values by product, product category, and business period at the promotion level. Provides data for reporting and analyzing overall promotion performance. The Measure Definition object defines each measure.

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

• PromotionProductId has a FOREIGNKEY relationship with the Promotion Product DMO Id field.
• PromotionId has a FOREIGNKEY relationship with the Promotion DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• ProductCategoryId has a FOREIGNKEY relationship with the Product Category DMO Id field.
• BusinessPeriodId has a FOREIGNKEY relationship with the Business Period DMO Id field.
• MeasureDefinitionId has a FOREIGNKEY relationship with the Measure Definition DMO Id field.

• BusinessPeriodId
• BusinessYearNbr
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• MeasureDefinitionId
• MeasureValueNbr
• ProductCategoryId
• ProductId
• PromotionId
• PromotionProductId
• PromotionProductMeasureName

• Field API Name: std__BusinessPeriodId__c
• Data Type: TEXT
• Description: The business period that's associated with the record.

• Field API Name: std__BusinessYearNbr__c
• Data Type: DOUBLE
• Description: The year number for the business period.

• 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__Id__c
• Data Type: TEXT
• Description: A unique identifier for a promotion product measure record.

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

• Field API Name: std__MeasureDefinitionId__c
• Data Type: TEXT
• Description: The planning measure definition identifier that's associated with the record.

• Field API Name: std__MeasureValueNbr__c
• Data Type: DOUBLE
• Description: The value of the promotion product measure.

• Field API Name: std__ProductCategoryId__c
• Data Type: TEXT
• Description: The product category identifier that's associated with the record.

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: The product identifier that's associated with the record.

• Field API Name: std__PromotionId__c
• Data Type: TEXT
• Description: The promotion identifier that's associated with the record.

• Field API Name: std__PromotionProductId__c
• Data Type: TEXT
• Description: The promotion product identifier that's associated with the record.

• Field API Name: std__PromotionProductMeasureName__c
• Data Type: TEXT
• Description: The name of the record.