---
schema_version: "1"
id: 0811c3f96efcd984dda233ef02ccf78934ec823508bcbf69a4de85d809d6e5a1
title: Cc Aggr Inventory By Location Grp DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-ccaggrinventorybylocationgrpdmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccaggrinventorybylocationgrpdmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a5fdec25d94ffc92cac7520830111da2deae33fadb539225fda2a197de61614a
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Cc Aggr Inventory By Location Grp DMO

This DMO aggregates inventory data by location group, date, and SKU.

## Object Properties

**Object API Name:** `CcAggrInventoryByLocationGrp_std__dlm`  
**Category:** Unassigned  
**Availability:** Available in 260 and later versions  
**Primary Key Field:** SkuId  

## Relationships

- **LocationGroupId** has a FOREIGNKEY relationship with the [Cc Dim Location Group DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimlocationgroupdmo-dmo.md) `Id` field.
- **SkuId** has a FOREIGNKEY relationship with the [Cc Dim Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.


## Fields

- [AvailableToFulfill](#availabletofulfill)
- [AvailableToOrder](#availabletoorder)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_LocationGroupId](#kq_locationgroupid)
- [KQ_SkuId](#kq_skuid)
- [LocationGroupId](#locationgroupid)
- [OnHand](#onhand)
- [RecordDate](#recorddate)
- [Reserved](#reserved)
- [SkuId](#skuid)
- [SoftReserved](#softreserved)

### AvailableToFulfill

- **Field API Name:** `AvailableToFulfill__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity available to fulfill orders for this location group.

### AvailableToOrder

- **Field API Name:** `AvailableToOrder__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity available to be ordered for this location group.

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

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

### InternalOrganizationId

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

### KQ_LocationGroupId

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

### KQ_SkuId

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

### LocationGroupId

- **Field API Name:** `LocationGroupId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_location_group.

### OnHand

- **Field API Name:** `OnHand__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity on hand for this location group.

### RecordDate

- **Field API Name:** `RecordDate__c`
- **Data Type:** DATEONLY
- **Description:** Date of the inventory record.

### Reserved

- **Field API Name:** `Reserved__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity reserved for this location group.

### SkuId

- **Field API Name:** `SkuId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_product for the SKU.

### SoftReserved

- **Field API Name:** `SoftReserved__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity soft reserved for this location group.