BI CVW Item Inventory – Overview

Purpose:

This view provides a summary of item inventory and rental costs, showing both the total investment in items and the cost of items currently on rent. It separates serialized rentals from bulk rentals to help understand inventory value and utilization.

What’s Included:

• Item Classification:
  

  • Category

  • Item Type

  • Item Key

  • Item Number

  • Current Store
    
    

• Financial Information:
  

  • Total Rental Cost: Sum of purchase costs for the inventory on hand.

  • Total On Rent Cost: Cost of items currently rented out, calculated from quantity on rent × price per item.
    
    

• Item Type Flag:
  

  • Either SERIALIZED RENTAL (tracked individually) or BULK RENTAL (tracked in bulk quantities).
    
    

How It Works:

• Combines purchase data (price paid for items) with active rental transactions.

• Excludes certain item types that are non-rentals.

• Aggregates by category, type, and store for summary-level reporting.
  
  

Uses:

• Analyze Utilization by item or category.  

• Track inventory value by item type and store.

• Understand which items are actively generating rental income.

• Plan purchasing or replacement budgets.

• Support financial reporting for rental assets.

POR Tables

• ItemFile 

• ItemPurchaseDetail 

• ItemType 

• ItemCategory 

• Transactions 

• TransactionItems