Promotion Offer Product Measure DMO

Each row represents the measure values by product, product category, and business period at the promotion offer level. Analyzes individual promotion offers and their contribution to overall promotion performance. The Measure Definition object defines each measure.

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

• PromotionOfferProductId has a FOREIGNKEY relationship with the Promotion Offer Product DMO Id field.
• PromotionOfferId has a FOREIGNKEY relationship with the Promotion Offer 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
• PromotionOfferId
• PromotionOfferProductId
• PromotionOfferProductMeasureName

• 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 offer 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 offer 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__PromotionOfferId__c
• Data Type: TEXT
• Description: The promotion offer identifier that's associated with the record.

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

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