CData Python Connector for Shopify

Build 23.0.8839

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

ShopifyPaymentsAccount.Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839