# 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 Properties

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

## Relationships

- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Web Store DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-webstoredmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Retail Store DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-retailstoredmo-dmo.md) `Id` field.
- **StoreReferenceObjectId** has a FOREIGNKEY relationship with the [Sales Store DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesstoredmo-dmo.md) `Id` field.
- **GoodsProductId** has a FOREIGNKEY relationship with the [Goods Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-goodsproductdmo-dmo.md) `Id` field.
- **ProductTranslationId** has a FOREIGNKEY relationship with the [Product Translation DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-producttranslationdmo-dmo.md) `Id` field.
- **PriceBookEntryId** has a FOREIGNKEY relationship with the [Price Book Entry DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookentrydmo-dmo.md) `Id` field.
- **LocaleId** has a FOREIGNKEY relationship with the [Locale DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-localedmo-dmo.md) `Id` field.
- **CreatedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [AvailableInventoryQuantity](#availableinventoryquantity)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedById](#createdbyid)
- [CreatedDateTime](#createddatetime)
- [Currency](#currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [GoodsProductId](#goodsproductid)
- [Id](#id)
- [ImageUrl](#imageurl)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_GoodsProductId](#kq_goodsproductid)
- [KQ_Id](#kq_id)
- [KQ_LastModifiedById](#kq_lastmodifiedbyid)
- [KQ_LocaleId](#kq_localeid)
- [KQ_PriceBookEntryId](#kq_pricebookentryid)
- [KQ_ProductId](#kq_productid)
- [KQ_ProductTranslationId](#kq_producttranslationid)
- [KQ_StoreReferenceObjectId](#kq_storereferenceobjectid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDateTime](#lastmodifieddatetime)
- [LocaleCode](#localecode)
- [LocaleId](#localeid)
- [PriceAmount](#priceamount)
- [PriceBookEntryId](#pricebookentryid)
- [ProductId](#productid)
- [ProductSku](#productsku)
- [ProductTranslationId](#producttranslationid)
- [ProductUrl](#producturl)
- [StoreReferenceObjectId](#storereferenceobjectid)
- [StoreReferenceObjectName](#storereferenceobjectname)

### AvailableInventoryQuantity

- **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.

### 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.

### CreatedById

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

### CreatedDateTime

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

### Currency

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

### 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.

### GoodsProductId

- **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.

### Id

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

### ImageUrl

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

### InternalOrganizationId

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

### KQ_CreatedById

- **Field API Name:** `KQ_CreatedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for CreatedById

### KQ_GoodsProductId

- **Field API Name:** `KQ_GoodsProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for GoodsProductId

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_LastModifiedById

- **Field API Name:** `KQ_LastModifiedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LastModifiedById

### KQ_LocaleId

- **Field API Name:** `KQ_LocaleId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LocaleId

### KQ_PriceBookEntryId

- **Field API Name:** `KQ_PriceBookEntryId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PriceBookEntryId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### KQ_ProductTranslationId

- **Field API Name:** `KQ_ProductTranslationId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductTranslationId

### KQ_StoreReferenceObjectId

- **Field API Name:** `KQ_StoreReferenceObjectId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for StoreReferenceObjectId

### LastModifiedById

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

### LastModifiedDateTime

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

### LocaleCode

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

### LocaleId

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

### PriceAmount

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

### PriceBookEntryId

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

### ProductId

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

### ProductSku

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

### ProductTranslationId

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

### ProductUrl

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

### StoreReferenceObjectId

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

### StoreReferenceObjectName

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