---
title: "Sales"
slug: "sales-view"
description: "Snowflake data share view: POS sales detail with quantities and revenue by location, time period, sales account, and category classification."
updated: 2026-04-29T00:13:29Z
published: 2026-04-29T00:13:29Z
canonical: "docs.restaurant365.com/sales-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.

# Sales

The Sales view is the point-of-sale sales detail dataset for R365. It contains quantities and revenue by location, time period, sales account, and category.

## Sales 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 revenue reporting. |
| interval_30 | timestamp | Start of the 30-minute time window in which this sale occurred. Useful for intraday sales trend analysis. |
| interval_60 | timestamp | Start of the 60-minute (hourly) time window in which this sale occurred. Useful for hourly revenue performance reporting. |
| sales_account_id | UUID | Unique identifier for the sales account used to classify this sale. |
| sales_account_name | string | Display name of the sales account used to classify this sale. |
| sales_category_id | UUID | Unique identifier for the sales category associated with this sale. |
| sales_category_name | string | Display name of the sales category associated with this sale. |
| is_voided | boolean | Indicates whether this sales record was voided. Voided records should be excluded from net revenue totals. |
| quantity | number | Number of units sold in this sales record. |
| amount | number | Total revenue for this sales record. Expressed in the organization's base currency. |