# Cc Fact Inv Rec Snapshot Hourly DMO

This DMO stores hourly inventory record snapshots. Each record represents the inventory state for a SKU at a specific location and hourly timestamp.

## Object Properties

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

## Relationships

- **UtcRecordDayId** has a FOREIGNKEY relationship with the [Cc Dim Date DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimdatedmo-dmo.md) `Id` field.
- **UtcRecordTimeId** has a FOREIGNKEY relationship with the [Cc Dim Time DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimedmo-dmo.md) `Id` field.
- **LocationId** has a FOREIGNKEY relationship with the [Cc Dim Location DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimlocationdmo-dmo.md) `Id` field.
- **LocationGroupId** has a FOREIGNKEY relationship with the [Cc Dim Location Group DMO](/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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimproductdmo-dmo.md) `Id` field.

## Fields

- [AvailableToFulfill](#availabletofulfill)
- [AvailableToFulfillAlloc](#availabletofulfillalloc)
- [AvailableToOrder](#availabletoorder)
- [AvailableToOrderAlloc](#availabletoorderalloc)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_LocationGroupId](#kq_locationgroupid)
- [KQ_LocationId](#kq_locationid)
- [KQ_SkuId](#kq_skuid)
- [KQ_UtcRecordDayId](#kq_utcrecorddayid)
- [KQ_UtcRecordTimeId](#kq_utcrecordtimeid)
- [LocationGroupId](#locationgroupid)
- [LocationId](#locationid)
- [OnHand](#onhand)
- [OnHandAlloc](#onhandalloc)
- [Reserved](#reserved)
- [ReservedAlloc](#reservedalloc)
- [SafetyStockCount](#safetystockcount)
- [SafetyStockCountAlloc](#safetystockcountalloc)
- [SkuId](#skuid)
- [SoftReserved](#softreserved)
- [SoftReservedAlloc](#softreservedalloc)
- [TotalFuturesQuantity](#totalfuturesquantity)
- [UtcRecordDayId](#utcrecorddayid)
- [UtcRecordTimeId](#utcrecordtimeid)
- [UtcRecordTimestamp](#utcrecordtimestamp)
- [UtcUpdateTimestamp](#utcupdatetimestamp)

### AvailableToFulfill

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

### AvailableToFulfillAlloc

- **Field API Name:** `AvailableToFulfillAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity available to fulfill orders.

### AvailableToOrder

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

### AvailableToOrderAlloc

- **Field API Name:** `AvailableToOrderAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity available to be ordered.

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

### Id

- **Field API Name:** `Id__c`
- **Data Type:** DOUBLE
- **Description:** Unique identifier for an inventory record snapshot.

### InternalOrganizationId

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

### KQ_Id

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

### KQ_LocationGroupId

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

### KQ_LocationId

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

### KQ_SkuId

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

### KQ_UtcRecordDayId

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

### KQ_UtcRecordTimeId

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

### LocationGroupId

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

### LocationId

- **Field API Name:** `LocationId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_location.

### OnHand

- **Field API Name:** `OnHand__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity currently on hand.

### OnHandAlloc

- **Field API Name:** `OnHandAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity currently on hand.

### Reserved

- **Field API Name:** `Reserved__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity that is reserved.

### ReservedAlloc

- **Field API Name:** `ReservedAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity that is reserved.

### SafetyStockCount

- **Field API Name:** `SafetyStockCount__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity for safety stock.

### SafetyStockCountAlloc

- **Field API Name:** `SafetyStockCountAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity for safety stock.

### 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 that is soft reserved.

### SoftReservedAlloc

- **Field API Name:** `SoftReservedAlloc__c`
- **Data Type:** DOUBLE
- **Description:** Allocated quantity that is soft reserved.

### TotalFuturesQuantity

- **Field API Name:** `TotalFuturesQuantity__c`
- **Data Type:** DOUBLE
- **Description:** Total quantity of future inventory.

### UtcRecordDayId

- **Field API Name:** `UtcRecordDayId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_date for the UTC record day.

### UtcRecordTimeId

- **Field API Name:** `UtcRecordTimeId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_time for the UTC record time.

### UtcRecordTimestamp

- **Field API Name:** `UtcRecordTimestamp__c`
- **Data Type:** DATETIME
- **Description:** UTC timestamp of the inventory record snapshot.

### UtcUpdateTimestamp

- **Field API Name:** `UtcUpdateTimestamp__c`
- **Data Type:** DATETIME
- **Description:** UTC timestamp of the last update to the inventory record snapshot.