ODBC Driver for Shopify

Build 24.0.9060

ShopifyPaymentsAccountBalanceTransactions

A list of balance transactions associated with a Shopify Payments account balance.

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.

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

For example, the following queries are processed server side:

  SELECT * FROM ShopifyPaymentsAccountBalanceTransactions
  SELECT * FROM ShopifyPaymentsAccountBalanceTransactions WHERE ShopifyPaymentsAccountId = 'Val1'

Columns

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

ShopifyPaymentsAccount.Id

A globally-unique ID.
NetAmount Decimal The net amount contributing to the merchant's balance. Decimal money amount.
NetCurrencyCode String The net amount contributing to the merchant's balance. Currency of the money.
TransactionDate Datetime The date and time when the balance transaction was processed.

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