ShopifyPaymentsAccountPayouts
Lists past and current payouts between the account and the bank (available only in supported countries).
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operator. The connector processes other filters client-side within the connector.
- 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 for the payout. | |
| LegacyResourceId | String | The Id of the corresponding resource in the REST Admin API. | |
| ShopifyPaymentsAccountId | String | A globally unique Id for the associated Shopify Payments account. | |
| Status | String | The current transfer status of the payout. | |
| IssuedAt | Datetime | The exact date and time when the payout was issued. Includes only balance transactions available at this time. | |
| TransactionType | String | The direction of the payout (for example, credit or debit). | |
| BusinessEntityId | String | The Id of the business entity associated with the payout. | |
| BankAccountId | String | A globally unique Id for the associated bank account. | |
| NetAmount | Decimal | The net payout amount, expressed as a decimal value. | |
| NetCurrencyCode | String | The currency code of the net payout amount. | |
| SummaryAdjustmentsFeeAmount | Decimal | The adjustment fee amount, expressed as a decimal value. | |
| SummaryAdjustmentsFeeCurrencyCode | String | The currency code of the adjustment fee amount. | |
| SummaryAdjustmentsGrossAmount | Decimal | The gross adjustment amount, expressed as a decimal value. | |
| SummaryAdjustmentsGrossCurrencyCode | String | The currency code of the gross adjustment amount. | |
| SummaryChargesFeeAmount | Decimal | The charge fee amount, expressed as a decimal value. | |
| SummaryChargesFeeCurrencyCode | String | The currency code of the charge fee amount. | |
| SummaryChargesGrossAmount | Decimal | The gross charge amount, expressed as a decimal value. | |
| SummaryChargesGrossCurrencyCode | String | The currency code of the gross charge amount. | |
| SummaryRefundsFeeAmount | Decimal | The refund fee amount, expressed as a decimal value. | |
| SummaryRefundsFeeCurrencyCode | String | The currency code of the refund fee amount. | |
| SummaryRefundsFeeGrossAmount | Decimal | The gross refund fee amount, expressed as a decimal value. | |
| SummaryRefundsFeeGrossCurrencyCode | String | The currency code of the gross refund fee amount. | |
| SummaryReservedFundsFeeAmount | Decimal | The reserved funds fee amount, expressed as a decimal value. | |
| SummaryReservedFundsFeeCurrencyCode | String | The currency code of the reserved funds fee amount. | |
| SummaryReservedFundsGrossAmount | Decimal | The gross reserved funds amount, expressed as a decimal value. | |
| SummaryReservedFundsGrossCurrencyCode | String | The currency code of the gross reserved funds amount. | |
| SummaryRetriedPayoutsFeeAmount | Decimal | The retried payouts fee amount, expressed as a decimal value. | |
| SummaryRetriedPayoutsFeeCurrencyCode | String | The currency code of the retried payouts fee amount. | |
| SummaryRetriedPayoutsGrossAmount | Decimal | The gross retried payouts amount, expressed as a decimal value. | |
| SummaryRetriedPayoutsGrossCurrencyCode | String | The currency code of the gross retried payouts amount. | |
| SummaryAdvanceFeesAmount | Decimal | The advance fee amount, expressed as a decimal value. | |
| SummaryAdvanceFeesCurrencyCode | String | The currency code of the advance fee amount, using ISO 4217 or supported legacy/non-standard codes. | |
| SummaryAdvanceGrossAmount | Decimal | The gross advance amount, expressed as a decimal value. | |
| SummaryAdvanceGrossCurrencyCode | String | The currency code of the gross advance amount, using ISO 4217 or supported legacy/non-standard codes. |