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