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: std__StoreProductSummaryDmo__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
• LastModifiedById
• LastModifiedDateTime
• LocaleCode
• LocaleId
• PriceAmount
• PriceBookEntryId
• ProductId
• ProductSku
• ProductTranslationId
• ProductUrl
• StoreReferenceObjectId
• StoreReferenceObjectName

• Field API Name: std__AvailableInventoryQuantity__c
• Data Type: DOUBLE
• Description: A simplified piece of inventory data specified at the locale level.

• 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__CreatedById__c
• Data Type: TEXT
• Description: The user who created the record

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

• Field API Name: std__Currency__c
• Data Type: TEXT
• Description: Currency

• 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__GoodsProductId__c
• Data Type: TEXT
• Description: Links product to a merchandise-specific attributes such as SKU, packaging, dimensions, weight, manufacturer, and sellability.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Primary key (synthetic)

• Field API Name: std__ImageUrl__c
• Data Type: URL
• Description: An URL representing a single image for the product

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

• Field API Name: std__LastModifiedById__c
• Data Type: TEXT
• Description: The user who most recently changed the record

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

• Field API Name: std__LocaleCode__c
• Data Type: TEXT
• Description: The locale to which this price applies

• Field API Name: std__LocaleId__c
• Data Type: TEXT
• Description: Links a product to a language-and-region locale used for localization

• Field API Name: std__PriceAmount__c
• Data Type: CURRENCY
• Description: Last known price

• Field API Name: std__PriceBookEntryId__c
• Data Type: TEXT
• Description: Links a product to a price book and stores its sales price details.

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: FK to Product

• Field API Name: std__ProductSku__c
• Data Type: TEXT
• Description: Product sku

• Field API Name: std__ProductTranslationId__c
• Data Type: TEXT
• Description: Links product to a translated product display content for a specific language or locale.

• Field API Name: std__ProductUrl__c
• Data Type: URL
• Description: An URL representing the product

• Field API Name: std__StoreReferenceObjectId__c
• Data Type: TEXT
• Description: Links store to specific implementation of store for a given usecase. Examples: Retail, Sales, Web.

• Field API Name: std__StoreReferenceObjectName__c
• Data Type: TEXT
• Description: A website by means of which goods, services, or software may be purchased or obtained