The Product Mix Report shows menu item sales by location, business date, interval, and service type. It contains the quantity and amount sold, with the menu item categories and the day part.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier for these sales |
| location_name | VARCHAR | Name of the location |
| business_date | DATE | Operational business date of the sales |
| interval_id | NUMBER(18,0) | Epoch-seconds identifier of the 15-minute interval |
| interval_number | NUMBER(12,6) | Sequential 15-minute interval within the day (1-96) |
| day_part_name | VARCHAR | Day part label, such as Breakfast, Lunch, or Dinner, as it was when the sale occurred. Later changes to the location's day part setup do not change it. |
| day_part_number | NUMBER(38,0) | Day part sort order / number |
| menu_item_id | VARCHAR | Menu item identifier |
| menu_item_name | VARCHAR | Menu item display name |
| menu_item_price | NUMBER(38,2) | Menu item's current list price |
| menu_item_category1_id | VARCHAR | Menu item's category 1 identifier ('None' bucket if uncategorized) |
| menu_item_category1_name | VARCHAR | Category 1 name, or 'None' if uncategorized |
| menu_item_category2_id | VARCHAR | Menu item's category 2 identifier ('None' bucket if uncategorized) |
| menu_item_category2_name | VARCHAR | Category 2 name, or 'None' if uncategorized |
| menu_item_category3_id | VARCHAR | Menu item's category 3 identifier ('None' bucket if uncategorized) |
| menu_item_category3_name | VARCHAR | Category 3 name, or 'None' if uncategorized |
| service_type_id | VARCHAR | Service type of the parent sales ticket |
| service_type_name | VARCHAR | Service type display name |
| quantity | NUMBER(38,5) | Sum of menu item quantity for this grain |
| amount | NUMBER(38,2) | Sum of menu item sales amount for this grain |
| interval_name | VARCHAR | Readable label for the time interval, for example 2026-02-02 00:15 to 00:29. Blank when the interval is missing. |