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