Views
      Back to home
      1. Help Center
      2. Daasity Platform | Business User Analytics
      3. Views

      View: Current Inventory Levels

      This article will help you learn about the fields available in the Current Inventory Level view, the field types, descriptions and how the fields are calculated

      Key Topics

      Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

      View Definition

      This view is linked to the [uos.inventory_levels] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.

       

      Field Name Field Type Description Source / Calculation
      Inventory Location Dimension Name from the Location table where the inventory is location location_name
      Inventory Quantity Dimension Total item inventory in the store(s) inventory_quantity
      Listing SKU Dimension The SKU in the store listing_sku
      SKU Dimension The normalized SKU across all stores sku
      Count Inventory Locations Measure Count of the unique locations where inventory is tracked COUNT(DISTINCT location_id)
      Count Item Inventory Measure Count of the unique items + inventory location combinations COUNT(DISTINCT inventory_level_id)
      Total Current Inventory Cost Value Measure Inventory quantity * sku cost SUM(inventory_quantity * product_variants.sku_cost)
      Total Current Inventory Retail Value Measure Inventory quantity * product price SUM(inventory_quantity * product_variants.price)
      Total Inventory Quantity Measure Total current inventory quantity from ALL locations SUM(inventory_quantity)

      Explores

      This view is part of the following explores:

      • Current Inventory Level

      Transformation Code

      This view is a part of the Daasity Unified Order Schema (UOS) that enables Daasity to combine different order sources into a single data model.

      Growth & Pro support the following code:

      • [0525_UOS_BAS_SHOPIFY_current_inventory_levels.sql]
      • [0553_UOS_BAS_AMAZON_current_inventory_levels.sql]
      • [0585_UOS_BAS_SKUBANA_current_inventory_levels.sql]

      Pro supports the following code if the optional code is enabled:

      • [0523_UOS_BAS_SFCC_current_inventory_levels.sql] (Salesforce Commerce Cloud)
      • [0615_UOS_PRO_LIGHTSPEED_current_inventory_levels.sql]