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 provider uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The provider processes other filters client-side within the provider.

TransactionType supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM ShopifyPaymentsAccountPayouts
  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	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.

ADO.NET Provider for Shopify

ShopifyPaymentsAccountPayouts

View-Specific Information

Select

Columns