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 connector uses the Shopify API to process WHERE clause conditions built with the TransactionType column, which supports the '=' comparison operator.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM ShopifyPaymentsAccountPayouts WHERE TransactionType='VALUE'
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. | |
| 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. |