---
title: "Inventory Activity"
slug: "inventory-activity-view"
description: "Snowflake data share view: inventory movement record covering physical counts, receipts, transfers, waste, and donations across all transactions."
updated: 2026-05-20T20:56:27Z
published: 2026-05-20T20:56:27Z
canonical: "docs.restaurant365.com/inventory-activity-view"
---

> ## 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 Activity

The Inventory Activity view is the inventory movement record for R365. It contains all inventory-affecting transactions, including physical counts, purchase receipts, location transfers, waste events, donations, and commissary fulfillments.

## Inventory Activity Columns

| column_name | data_type | description |
| --- | --- | --- |
| id | UUID | Unique identifier for the inventory activity line. |
| tenant_id | integer | Customer's account identifier within the R365 platform. |
| item_activity | string | Classification of the inventory movement type. Possible values: count, received, transfer_in, transfer_out, waste, donation, commissary_fulfillment_in, commissary_fulfillment_out, ar_activity. |
| name | string | The transaction number or name associated with this inventory activity. |
| is_approved | string | Indicates whether the transaction has been approved. Possible values: yes, no. |
| count_template_id | integer | Reference identifier for the inventory count template used when this activity is a physical count. Null for non-count activity types. |
| count_template_name | string | Display name of the inventory count template used when this activity is a physical count. Null for non-count activity types. |
| vendor_id | UUID | Reference identifier for the vendor or customer associated with this activity, when applicable. |
| recipe_id | UUID | Reference identifier for the recipe item linked to this inventory activity. Populated only for items classified as recipe type. |
| inventory_item_id | UUID | Unique identifier for the inventory item involved in this activity. |
| inventory_item_name | string | Display name of the inventory item involved in this activity. |
| unit_of_measure_id | UUID | Reference identifier for the unit of measure associated with this inventory activity line. |
| unit_of_measure_name | string | Display name of the unit of measure associated with this inventory activity line (e.g. each, lb, case). |
| legal_entity_id | UUID | Unique identifier for the legal entity (business unit) associated with this inventory activity. |
| legal_entity_name | string | Display name of the legal entity (business unit) associated with this inventory activity. |
| location_id | UUID | Unique identifier for the restaurant location where this inventory activity occurred. |
| location_name | string | Display name of the restaurant location where this inventory activity occurred. |
| date | date | Date on which this inventory activity was recorded or posted. |
| quantity | number | Quantity of the item involved in this activity, expressed in the item's inventory unit of measure. |
| amount | number | Monetary value associated with this inventory activity. Expressed in the customer's base currency. |