Store Product Summary DMO

Represents a product’s summary information at a specific store, including pricing, inventory, and localized details. Links to different store types through a polymorphic relationship.

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

• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• StoreReferenceObjectId has a FOREIGNKEY relationship with the Web Store DMO Id field.
• StoreReferenceObjectId has a FOREIGNKEY relationship with the Retail Store DMO Id field.
• StoreReferenceObjectId has a FOREIGNKEY relationship with the Sales Store DMO Id field.
• GoodsProductId has a FOREIGNKEY relationship with the Goods Product DMO Id field.
• ProductTranslationId has a FOREIGNKEY relationship with the Product Translation DMO Id field.
• PriceBookEntryId has a FOREIGNKEY relationship with the Price Book Entry DMO Id field.
• LocaleId has a FOREIGNKEY relationship with the Locale DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.

• AvailableInventoryQuantity
• cdp_sys_record_currency
• CreatedById
• CreatedDateTime
• Currency
• DataSourceId
• DataSourceObjectId
• GoodsProductId
• Id
• ImageUrl
• InternalOrganizationId
• KQ_CreatedById
• KQ_GoodsProductId
• KQ_Id
• KQ_LastModifiedById
• KQ_LocaleId
• KQ_PriceBookEntryId
• KQ_ProductId
• KQ_ProductTranslationId
• KQ_StoreReferenceObjectId
• LastModifiedById
• LastModifiedDateTime
• LocaleCode
• LocaleId
• PriceAmount
• PriceBookEntryId
• ProductId
• ProductSku
• ProductTranslationId
• ProductUrl
• StoreReferenceObjectId
• StoreReferenceObjectName

• Field API Name: AvailableInventoryQuantity__c
• Data Type: DOUBLE
• Description: The quantity of the product currently available at the store, expressed at the configured locale level.

• Field API Name: cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: CreatedById__c
• Data Type: TEXT
• Description: The ID of the user who created the record.

• Field API Name: CreatedDateTime__c
• Data Type: DATETIME
• Description: The date and time when this record was created.

• Field API Name: Currency__c
• Data Type: TEXT
• Description: The ISO currency code in which the price is expressed.

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

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

• Field API Name: GoodsProductId__c
• Data Type: TEXT
• Description: The identifier of the goods record that defines merchandise-specific attributes (SKU, packaging, dimensions, weight, sellability) for the product.

• Field API Name: Id__c
• Data Type: TEXT
• Description: The unique identifier of the store product summary record.

• Field API Name: ImageUrl__c
• Data Type: URL
• Description: The URL of a representative product image used for display in marketing communications.

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

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

• Field API Name: KQ_GoodsProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for GoodsProductId

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

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

• Field API Name: KQ_LocaleId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocaleId

• Field API Name: KQ_PriceBookEntryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PriceBookEntryId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: KQ_ProductTranslationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductTranslationId

• Field API Name: KQ_StoreReferenceObjectId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StoreReferenceObjectId

• Field API Name: LastModifiedById__c
• Data Type: TEXT
• Description: The ID of the user who most recently changed the record.

• Field API Name: LastModifiedDateTime__c
• Data Type: DATETIME
• Description: The date and time when a user last modified this record.

• Field API Name: LocaleCode__c
• Data Type: TEXT
• Description: The locale code (for example, en_US) for which this price and product information apply.

• Field API Name: LocaleId__c
• Data Type: TEXT
• Description: The identifier of the locale to which this product summary is scoped.

• Field API Name: PriceAmount__c
• Data Type: CURRENCY
• Description: The most recent known price of the product at the store.

• Field API Name: PriceBookEntryId__c
• Data Type: TEXT
• Description: The identifier of the price book entry that backs the price amount on this summary.

• Field API Name: ProductId__c
• Data Type: TEXT
• Description: The identifier of the product that this summary describes.

• Field API Name: ProductSku__c
• Data Type: TEXT
• Description: The SKU code for the product as inventoried at the store.

• Field API Name: ProductTranslationId__c
• Data Type: TEXT
• Description: The identifier of the translated product display content used for the locale of this summary.

• Field API Name: ProductUrl__c
• Data Type: URL
• Description: The URL of the product detail page at the store.

• Field API Name: StoreReferenceObjectId__c
• Data Type: TEXT
• Description: The identifier of the store-specific record (RetailStore, SalesStore, or WebStore) backing this summary.

• Field API Name: StoreReferenceObjectName__c
• Data Type: TEXT
• Description: The display name of the store (web, retail, or sales) where this product summary applies.