---
title: "Product Mix"
slug: "product-mix-view"
description: "Snowflake data share view: POS sales detail with quantities and amounts sold at the menu item level by location and time period."
updated: 2026-04-29T00:11:14Z
published: 2026-04-29T00:11:14Z
canonical: "docs.restaurant365.com/product-mix-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.

# Product Mix

The Product Mix view is the point-of-sale sales detail dataset for R365. It contains quantities and amounts sold at the menu item level by location and time period.

## Product Mix Columns

| column_name | data_type | description |
| --- | --- | --- |
| id | UUID | Unique identifier for the sales detail record. |
| tenant_id | integer | Customer's account identifier within the R365 platform. |
| legal_entity_id | UUID | Unique identifier for the legal entity (business unit) associated with this sales record. |
| legal_entity_name | string | Display name of the legal entity (business unit) associated with this sales record. |
| location_id | UUID | Unique identifier for the restaurant location where this sale occurred. |
| location_name | string | Display name of the restaurant location where this sale occurred. |
| business_date | date | The operating day on which this sale was recorded, based on the restaurant's business calendar. |
| interval_15 | timestamp | Start of the 15-minute time window in which this sale occurred. Useful for high-resolution intraday sales reporting. |
| interval_30 | timestamp | Start of the 30-minute time window in which this sale occurred. Useful for intraday trend analysis. |
| interval_60 | timestamp | Start of the 60-minute (hourly) time window in which this sale occurred. Useful for hourly product performance reporting. |
| menu_item_name | string | Display name of the menu item sold. |
| is_entree | boolean | Indicates whether this menu item is classified as an entree. |
| is_voided | boolean | Indicates whether this sales line was voided. Voided records should be excluded from net sales totals. |
| quantity | number | Number of units of this menu item sold in this record. |
| amount | number | Total sales revenue for this menu item in this record. Expressed in the organization's base currency. |