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