Product Mix Report

Prev Next

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(38,0)

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.