Balances
List all non crypto balances.
Table Specific Information
Select
This view returns a list of disputes for the authenticated user.
The following filters are supported by the PayPal API:
- Currency
- AsOfTime
The filters only support the = operator.
The driver processes other filters client side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
For example, the following queries are processed server side.
- The following query retrieves details for a specific currency:
SELECT * FROM Balances WHERE Currency = 'USD'
- The following query returns details for Balance records created before the specified date time:
SELECT * FROM Balances WHERE AsOfTime = '2022-01-09 20:59:59.0'
Columns
| Name | Type | References | Description |
| Currency [KEY] | String | Currency Code of the balances listed. | |
| AccountId | String | The PayPal payer ID, which is a masked version of the PayPal account number intended for use with third parties. | |
| AvailableBalanceCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| AvailableBalanceValue | String | The value, which might be an integer or a decimal. | |
| Primary | Boolean | Optional field representing if the currency is primary currency or not. | |
| TotalBalanceCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| TotalBalanceValue | Decimal | The value, which might be:An integer or A decimal. | |
| WithheldBalanceCurrencyCode | String | The three-character ISO-4217 currency code that identifies the currency. | |
| WithheldBalanceValue | String | The value, which might be:An integer or A decimal. | |
| AsOfTime | Datetime | The requested date and time or the last date and time when the balances can be served. | |
| LastRefreshTime | Datetime | The date and time when the balances was last refreshed. |