ShopifyPaymentsAccountPayouts
Returns all current and previous payouts made between the account and the bank account. Its avaible only in a few certain countries.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operator. The driver processes other filters client-side within the driver.
- TransactionType supports the '=' comparison operator.
For example, the following query is processed server-side:
SELECT * FROM ShopifyPaymentsAccountPayouts WHERE TransactionType = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| LegacyResourceId | String | The ID of the corresponding resource in the REST Admin API. | |
| ShopifyPaymentsAccountId | String | A globally-unique ID. | |
| Status | String | The transfer status of the payout. | |
| IssuedAt | Datetime | The exact time when the payout was issued. The payout only contains balance transactions that were available at this time. | |
| TransactionType | String | The direction of the payout. | |
| BusinessEntityId | String | The business entity associated with the payout. | |
| BankAccountId | String | A globally-unique ID. | |
| NetAmount | Decimal | Decimal money amount. | |
| NetCurrencyCode | String | Currency of the money. | |
| SummaryAdjustmentsFeeAmount | Decimal | Decimal money amount. | |
| SummaryAdjustmentsFeeCurrencyCode | String | Currency of the money. | |
| SummaryAdjustmentsGrossAmount | Decimal | Decimal money amount. | |
| SummaryAdjustmentsGrossCurrencyCode | String | Currency of the money. | |
| SummaryChargesFeeAmount | Decimal | Decimal money amount. | |
| SummaryChargesFeeCurrencyCode | String | Currency of the money. | |
| SummaryChargesGrossAmount | Decimal | Decimal money amount. | |
| SummaryChargesGrossCurrencyCode | String | Currency of the money. | |
| SummaryRefundsFeeAmount | Decimal | Decimal money amount. | |
| SummaryRefundsFeeCurrencyCode | String | Currency of the money. | |
| SummaryRefundsFeeGrossAmount | Decimal | Decimal money amount. | |
| SummaryRefundsFeeGrossCurrencyCode | String | Currency of the money. | |
| SummaryReservedFundsFeeAmount | Decimal | Decimal money amount. | |
| SummaryReservedFundsFeeCurrencyCode | String | Currency of the money. | |
| SummaryReservedFundsGrossAmount | Decimal | Decimal money amount. | |
| SummaryReservedFundsGrossCurrencyCode | String | Currency of the money. | |
| SummaryRetriedPayoutsFeeAmount | Decimal | Decimal money amount. | |
| SummaryRetriedPayoutsFeeCurrencyCode | String | Currency of the money. | |
| SummaryRetriedPayoutsGrossAmount | Decimal | Decimal money amount. | |
| SummaryRetriedPayoutsGrossCurrencyCode | String | Currency of the money. | |
| SummaryAdvanceFeesAmount | Decimal | A monetary value in decimal format, allowing for precise representation of cents or fractional currency. For example, 12. 99. | |
| SummaryAdvanceFeesCurrencyCode | String | The three-letter currency code that represents a world currency used in a store. Currency codes include standard [standard ISO 4217 codes](https: //en. wikipedia. org/wiki/ISO 4217), legacy codes, and non-standard codes. For example, USD. | |
| SummaryAdvanceGrossAmount | Decimal | A monetary value in decimal format, allowing for precise representation of cents or fractional currency. For example, 12. 99. | |
| SummaryAdvanceGrossCurrencyCode | String | The three-letter currency code that represents a world currency used in a store. Currency codes include standard [standard ISO 4217 codes](https: //en. wikipedia. org/wiki/ISO 4217), legacy codes, and non-standard codes. For example, USD. |