ODBC Driver for Shopify

Build 24.0.9060

RefundTransactionFees

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

View-Specific Information

Select

The driver uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

  • TransactionId supports the '=,IN' comparison operators.

For example, the following queries are processed server side:

  SELECT * FROM RefundTransactionFees
  SELECT * FROM RefundTransactionFees WHERE TransactionId = 'Val1'

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 24.0.9060