---
title: "Payments"
slug: "payments-view"
description: "Snowflake data share view: POS payment transaction record with payment method, amount, void status, and 15/30/60-minute time intervals per payment."
updated: 2026-04-29T00:10:46Z
published: 2026-04-29T00:10:46Z
canonical: "docs.restaurant365.com/payments-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.

# Payments

The Payments view is the point-of-sale payment transaction record for R365. It contains payment method, amount, and timing for all customer payments.

## Payments Columns

| column_name | data_type | description |
| --- | --- | --- |
| id | UUID | Unique identifier for the payment record. |
| sales_id | UUID | Reference to the sales transaction associated with this payment. |
| 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 payment. |
| legal_entity_name | string | Display name of the legal entity (business unit) associated with this payment. |
| location_id | UUID | Unique identifier for the restaurant location where this payment was collected. |
| location_name | string | Display name of the restaurant location where this payment was collected. |
| business_date | date | The operating day on which this payment was collected, based on the restaurant's business calendar. |
| interval_15 | timestamp | Start of the 15-minute time window in which this payment occurred. Useful for high-resolution intraday revenue reporting. |
| interval_30 | timestamp | Start of the 30-minute time window in which this payment occurred. Useful for intraday sales trend analysis. |
| interval_60 | timestamp | Start of the 60-minute (hourly) time window in which this payment occurred. Useful for hourly revenue performance reporting. |
| payment_group | string | High-level grouping of the payment method (e.g., Cash, Credit Card, Gift Card). |
| payment_type | string | Specific tender type used for this payment (e.g., Visa, Mastercard, House Account). |
| is_voided | boolean | Indicates whether this payment was voided. Voided payments should be excluded from revenue totals. |
| number_of_payments | integer | Number of individual payments represented by this record. Each row corresponds to one payment. |
| amount | number | Total amount collected for this payment. Expressed in the organization's base currency. |