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.
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.
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.
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.