JDBC Driver for Shopify

Build 23.0.8839

RefundTransactionFees

Returns the transaction fees charged on the order transaction. Only present for Shopify Payments transactions.

View-Specific Information

Select

The 本製品 uses the Shopify API to process WHERE clause conditions built with the TransactionId column, which supports the '=,IN' comparison operators.

The 本製品 processes other filters client-side within the 本製品.

For example, the following query is processed server-side:

SELECT * FROM RefundTransactionFees WHERE TransactionId='VALUE'

Columns

Name Type References Description
Id [KEY] String A globally-unique ID.
TransactionId String

RefundTransactions.Id

A globally-unique ID.
RateName String Name of the credit card rate.
FlatFeeName String Name of the credit card flat fee.
Rate Decimal Percentage charge.
Type String Name of the type of fee.
AmountAmount Decimal Decimal money amount.
AmountCurrencyCode String Currency of the money.
FlatFeeAmount Decimal Decimal money amount.
FlatFeeCurrencyCode String Currency of the money.
TaxAmountAmount Decimal Decimal money amount.
TaxAmountCurrencyCode String Currency of the money.

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