The Payment Summary Report shows payment totals by payment group and payment type. It contains one row for each location, business date, payment group, payment type, and voided status.
Column reference
| Column | Type | Description |
|---|---|---|
| tenant_id | NUMBER(38,0) | R365 internal tenant identifier |
| location_id | VARCHAR | Location identifier |
| location_name | VARCHAR | Name of the location |
| legal_entity_id | VARCHAR | Legal entity identifier |
| legal_entity_name | VARCHAR | Legal entity name |
| business_date | DATE | Business date the payments were collected on, as a date without a time component (YYYY-MM-DD) |
| payment_group | VARCHAR | High-level group for the payment method, such as Cash, Credit Card, or Gift Card. Blank for payment types with no group assigned, such as UberEats. |
| payment_type | VARCHAR | Specific tender type used for the payment (such as Visa, Mastercard, or House Account) |
| is_voided | BOOLEAN | True when the payments belong to a voided sale, and false otherwise. Never blank. A location, date, payment group, and payment type with both kinds of payments has two rows. Filter this column to false to exclude voided sales. |
| total_amount | NUMBER(38,2) | Sum of payment amounts for each location, business date, payment group, payment type, and voided status. |
| payment_count | NUMBER(18,0) | Number of payments for each location, business date, payment group, payment type, and voided status. |