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

Fields

• 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

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.