BalanceAndNetActivitySummary
List all balance and net activity summary 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 provider processes other filters client side within the provider.
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 last refresh date for merchant/partner accounting data. | |
| ReconciliationPassed | Boolean | Indicates whether the reconciliation of the merchant transaction data has passed.
The default value is true. | |
| NetActivityColumns | String | 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 | Column names for balance summary. | |
| BalanceSummaryData | String | An array containing array of strings depicting balance summaries data for each currency. |
Pseudo-Columns
Pseudo column 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 | List balances from the provided date. | |
| ToDate | Date | List balances until the provided date. |