BalanceAndNetActivitySummary
Returns balance and net activity summary data for each currency within a given date range.
View-Specific Information
SELECT
The following filters are supported by the PayPal API:
- Locale
- FromDate
- ToDate
The filters only support the = operator.
The driver processes other filters client side within the driver.
For example, the following query is processed server side.
SELECT * FROM BalanceAndNetActivitySummary WHERE FromDate = '2026-02-03' AND ToDate = '2026-03-03' AND Locale = 'en_US'
Columns
| Name | Type | References | Description |
| LastRefreshDate | Date | The date when the merchant or partner accounting data was last refreshed. | |
| ReconciliationPassed | Boolean | Indicates whether the reconciliation of the merchant transaction data has passed.
The default value is true. | |
| NetActivityColumns | String | The column names for net activity data. | |
| NetActivityActivities | String | An array containing net-activity, fee, and record-type values. | |
| NetActivityCurrencies | String | The list of currencies in the net activity summary. | |
| BalanceSummaryColumns | String | The column names for the balance summary. | |
| BalanceSummaryData | String | An array containing array of strings depicting balance summaries data for each currency. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| Locale | String | The locale of the client. | |
| FromDate | Date | The start date of the date range used to filter balance records. | |
| ToDate | Date | The end date of the date range used to filter balance records. |