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