Cc Fact Inv Rec Snapshot DMO

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

Object API Name: std__CcFactInvRecSnapshotDmo__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
• LocationGroupId
• LocationId
• OnHand
• OnHandAlloc
• Reserved
• ReservedAlloc
• SafetyStockCount
• SafetyStockCountAlloc
• SkuId
• SoftReserved
• SoftReservedAlloc
• TotalFuturesQuantity
• UtcRecordDayId
• UtcRecordTimeId
• UtcRecordTimestamp
• UtcUpdateTimestamp

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

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

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

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

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

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

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

• Field API Name: std__Id__c
• Data Type: DOUBLE
• Description: Unique identifier for an inventory record snapshot.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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