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 API Name: CcFactInvRecSnapshotHourly_std__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• UtcRecordDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• UtcRecordTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• LocationId has a FOREIGNKEY relationship with the Cc Dim Location DMO Id field.
• LocationGroupId has a FOREIGNKEY relationship with the Cc Dim Location Group DMO Id field.
• SkuId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.

• AvailableToFulfill
• AvailableToFulfillAlloc
• AvailableToOrder
• AvailableToOrderAlloc
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• KQ_Id
• KQ_LocationGroupId
• KQ_LocationId
• KQ_SkuId
• KQ_UtcRecordDayId
• KQ_UtcRecordTimeId
• LocationGroupId
• LocationId
• OnHand
• OnHandAlloc
• Reserved
• ReservedAlloc
• SafetyStockCount
• SafetyStockCountAlloc
• SkuId
• SoftReserved
• SoftReservedAlloc
• TotalFuturesQuantity
• UtcRecordDayId
• UtcRecordTimeId
• UtcRecordTimestamp
• UtcUpdateTimestamp

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

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

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

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

• 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: 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: Id__c
• Data Type: DOUBLE
• Description: Unique identifier for an inventory record snapshot.

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

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

• Field API Name: KQ_LocationGroupId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationGroupId

• Field API Name: KQ_LocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationId

• Field API Name: KQ_SkuId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SkuId

• Field API Name: KQ_UtcRecordDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRecordDayId

• Field API Name: KQ_UtcRecordTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRecordTimeId

• Field API Name: LocationGroupId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_location_group.

• Field API Name: LocationId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_location.

• Field API Name: OnHand__c
• Data Type: DOUBLE
• Description: Total quantity currently on hand.

• Field API Name: OnHandAlloc__c
• Data Type: DOUBLE
• Description: Allocated quantity currently on hand.

• Field API Name: Reserved__c
• Data Type: DOUBLE
• Description: Total quantity that is reserved.

• Field API Name: ReservedAlloc__c
• Data Type: DOUBLE
• Description: Allocated quantity that is reserved.

• Field API Name: SafetyStockCount__c
• Data Type: DOUBLE
• Description: Total quantity for safety stock.

• Field API Name: SafetyStockCountAlloc__c
• Data Type: DOUBLE
• Description: Allocated quantity for safety stock.

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

• Field API Name: SoftReserved__c
• Data Type: DOUBLE
• Description: Total quantity that is soft reserved.

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

• Field API Name: TotalFuturesQuantity__c
• Data Type: DOUBLE
• Description: Total quantity of future inventory.

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

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

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

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