ShopifyPaymentsAccountPayouts
Lists all payouts issued from Shopify Payments to linked bank accounts, with dates and statuses.
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 identifier for the payout record within Shopify Payments. | |
| LegacyResourceId | String | The identifier of the corresponding payout record in the REST Admin API for backward compatibility. | |
| ShopifyPaymentsAccountId | String | The globally unique identifier of the Shopify Payments account associated with this payout. | |
| Status | String | The current transfer status of the payout, such as 'scheduled', 'in_transit', or 'paid'. | |
| IssuedAt | Datetime | The exact date and time when the payout was issued. Only balance transactions available at this time are included in the payout. | |
| TransactionType | String | Indicates the direction of the payout, such as 'credit' (to the merchant) or 'debit' (withdrawal or reversal). | |
| BusinessEntityId | String | The identifier of the business entity associated with this payout record, used for tax and reporting purposes. | |
| BankAccountId | String | The globally unique identifier of the bank account where the payout funds were sent. | |
| NetAmount | Decimal | The total net payout amount after all fees and adjustments, expressed as a decimal value. | |
| NetCurrencyCode | String | The three-letter ISO currency code representing the currency of the payout (for example, USD or EUR). | |
| SummaryAdjustmentsFeeAmount | Decimal | The total adjustment-related fee deducted from the payout, expressed as a decimal money amount. | |
| SummaryAdjustmentsFeeCurrencyCode | String | The currency of the adjustment-related fee using a three-letter ISO code. | |
| SummaryAdjustmentsGrossAmount | Decimal | The total gross adjustment amount before any deductions, expressed as a decimal money value. | |
| SummaryAdjustmentsGrossCurrencyCode | String | The currency of the gross adjustment amount using a three-letter ISO code. | |
| SummaryChargesFeeAmount | Decimal | The total amount of transaction fees deducted for sales charges within this payout. | |
| SummaryChargesFeeCurrencyCode | String | The three-letter ISO currency code for the transaction fees deducted. | |
| SummaryChargesGrossAmount | Decimal | The total gross sales charge amount before any deductions, represented as a decimal money value. | |
| SummaryChargesGrossCurrencyCode | String | The three-letter ISO currency code for the gross charge amount. | |
| SummaryRefundsFeeAmount | Decimal | The total fees deducted from refunds processed within this payout. | |
| SummaryRefundsFeeCurrencyCode | String | The three-letter ISO currency code for refund-related fees. | |
| SummaryRefundsFeeGrossAmount | Decimal | The total gross refund amount before deductions, expressed as a decimal money value. | |
| SummaryRefundsFeeGrossCurrencyCode | String | The three-letter ISO currency code for gross refund amounts. | |
| SummaryReservedFundsFeeAmount | Decimal | The total amount of reserved funds fees deducted from the payout. | |
| SummaryReservedFundsFeeCurrencyCode | String | The currency of the reserved funds fee using a three-letter ISO code. | |
| SummaryReservedFundsGrossAmount | Decimal | The total gross amount of reserved funds held, before any deductions. | |
| SummaryReservedFundsGrossCurrencyCode | String | The currency of the gross reserved funds amount using a three-letter ISO code. | |
| SummaryRetriedPayoutsFeeAmount | Decimal | The total fees deducted from retried payouts included in this payout batch. | |
| SummaryRetriedPayoutsFeeCurrencyCode | String | The currency of the retried payouts fee using a three-letter ISO code. | |
| SummaryRetriedPayoutsGrossAmount | Decimal | The total gross amount for retried payouts, expressed as a decimal value. | |
| SummaryRetriedPayoutsGrossCurrencyCode | String | The currency of the gross retried payout amount using a three-letter ISO code. | |
| SummaryAdvanceFeesAmount | Decimal | The total amount of advance-related fees deducted from the payout, represented as a precise decimal money value (for example, 12.99). | |
| SummaryAdvanceFeesCurrencyCode | String | The three-letter ISO 4217 currency code representing the currency of advance-related fees (for example, USD). | |
| SummaryAdvanceGrossAmount | Decimal | The total gross value of advance-related payouts before any deductions, represented as a precise decimal money value (for example, 12.99). | |
| SummaryAdvanceGrossCurrencyCode | String | The three-letter ISO 4217 currency code representing the currency of advance-related gross payout amounts (for example, USD). |