Cc Aggr Inventory By Location DMO

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

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

• LocationId has a FOREIGNKEY relationship with the Cc Dim Location DMO Id field.
• SkuId has a FOREIGNKEY relationship with the Cc Dim Product DMO Id field.

• AvailableToFulfill
• AvailableToOrder
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• InternalOrganizationId
• KQ_LocationId
• KQ_SkuId
• LocationId
• OnHand
• RecordDate
• Reserved
• SkuId
• SoftReserved

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

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

• 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: InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• 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: LocationId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_location.

• Field API Name: OnHand__c
• Data Type: DOUBLE
• Description: Total quantity on hand at this location.

• Field API Name: RecordDate__c
• Data Type: DATEONLY
• Description: Date of the inventory record.

• Field API Name: Reserved__c
• Data Type: DOUBLE
• Description: Total quantity reserved at this location.

• 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 soft reserved at this location.