---
title: "Inventory Item"
slug: "inventory-item-view"
description: "Snowflake data share view: inventory item master data with item type classification, category groupings, and purchase, inventory, and reporting UofM."
updated: 2026-04-29T00:07:27Z
published: 2026-04-29T00:07:27Z
canonical: "docs.restaurant365.com/inventory-item-view"
stale: true
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Inventory Item

The Inventory Item view is the inventory item master dataset for R365. It contains classification, category groupings, and unit of measure assignments for all ingredients and products managed in the R365 inventory system.

## Inventory Item Columns

| column_name | data_type | description |
| --- | --- | --- |
| id | UUID | Unique identifier for the inventory item. |
| tenant_id | integer | Customer's account identifier within the R365 platform. |
| item_type | string | Classification of the inventory item. Possible values: purchase, recipe, sales_only, catering_only. |
| item_category1 | string | Primary category grouping assigned to this inventory item (organization-defined). |
| item_category2 | string | Secondary category grouping assigned to this inventory item (organization-defined). |
| item_category3 | string | Tertiary category grouping assigned to this inventory item (organization-defined). |
| purchase_unit_of_measure | string | Unit of measure used when purchasing this item from a vendor (e.g., Case, Each, Pound). |
| inventory_unit_of_measure | string | Unit of measure used for tracking this item within inventory counts and activity (e.g., Each, Ounce). |
| reporting_unit_of_measure | string | Unit of measure used when reporting on this item in operational and financial reports. |