SSIS Components for Shopify

Build 25.0.9434

StoreCreditAccountDebitTransactions

Debit transactions which decrease the store credit account balance.

Table-Specific Information

Select

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

  • Id supports the '=, IN' comparison operators.
  • CustomerStoreCreditAccountId supports the '=, IN' comparison operators.

For example, the following queries are processed server-side:

  SELECT * FROM StoreCreditAccountDebitTransactions WHERE Id = 'Val1'
  SELECT * FROM StoreCreditAccountDebitTransactions WHERE CustomerStoreCreditAccountId = 'Val1'

Insert

The following columns can be used to create a new record:

Amount, AmountCurrencyCode, CustomerStoreCreditAccountId

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A globally-unique ID.

Amount Decimal True

Decimal money amount.

AmountCurrencyCode String True

Currency of the money.

BalanceAfterTransactionAmount Decimal True

Decimal money amount.

BalanceAfterTransactionCurrencyCode String True

Currency of the money.

CreatedAt Datetime True

The date and time when the transaction was created.

CustomerStoreCreditAccountId String True

CustomerStoreCreditAccounts.Id

A globally-unique ID.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434