CData Python Connector for Shopify

Build 23.0.8839

RefundTransactions

Retrieves the transactions associated with the resource.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the ResourceId column, which supports the '=' comparison operator.

The connector processes other filters client-side within the connector.

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

SELECT * FROM RefundTransactions WHERE ResourceId='VALUE'

Columns

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

Refunds.Id

A globally-unique ID.
PaymentId String The payment ID associated with the transaction.
ParentTransactionId String The associated parent transaction, for example the authorization of a capture.
AccountNumber String The masked account number associated with the payment method.
Gateway String The payment gateway used to process the transaction.
Kind String The kind of transaction.
Status String The status of this transaction.
Test Bool Whether the transaction is a test transaction.
AuthorizationCode String Authorization code associated with the transaction.
ErrorCode String A standardized error code, independent of the payment provider.
FormattedGateway String The human-readable payment gateway name used to process the transaction.
ManuallyCapturable Bool Whether the transaction can be manually captured.
ProcessedAt Datetime Date and time when the transaction was processed.
ReceiptJson String The transaction receipt that the payment gateway attaches to the transaction. The value of this field depends on which payment gateway processed the transaction.
SettlementCurrency String The settlement currency.
AuthorizationExpiresAt Datetime The time when the authorization expires. This field is available only to stores on a Shopify Plus plan and is populated only for Shopify Payments authorizations.
SettlementCurrencyRate Decimal The rate used when converting the transaction amount to settlement currency.
CreatedAt Datetime Date and time when the transaction was created.
CardPaymentDetailsName String The holder of the credit card.
CardPaymentDetailsBin String The issuer identification number (IIN), formerly known as bank identification number (BIN) of the customer's credit card. This is made up of the first few digits of the credit card number.
CardPaymentDetailsCompany String The name of the company that issued the customer's credit card.
CardPaymentDetailsNumber String The customer's credit card number, with most of the leading digits redacted.
CardPaymentDetailsWallet String Digital wallet used for the payment.
CardPaymentDetailsExpirationMonth Int The month in which the used credit card expires.
CardPaymentDetailsExpirationYear Int The year in which the used credit card expires.
CardPaymentDetailsAvsResultCode String The response code from the address verification system (AVS). The code is always a single letter.
CardPaymentDetailsCvvResultCode String The response code from the credit card company indicating whether the customer entered the card security code, or card verification value, correctly. The code is a single letter or empty string.
PaymentIconId String A unique ID for the image.
PaymentIconWidth Int The original width of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
PaymentIconAltText String A word or phrase to share the nature or contents of an image.
PaymentIconHeight Int The original height of the image in pixels. Returns 'null' if the image is not hosted by Shopify.
AmountSetPresentmentMoneyAmount Decimal Decimal money amount.
AmountSetPresentmentMoneyCurrencyCode String Currency of the money.
AmountSetShopMoneyAmount Decimal Decimal money amount.
AmountSetShopMoneyCurrencyCode String Currency of the money.
MaximumRefundableV2Amount Decimal Decimal money amount.
MaximumRefundableV2CurrencyCode String Currency of the money.
ShopifyPaymentsSetExtendedAuthorizationSetExtendedAuthorizationExpiresAt Datetime The time after which the extended authorization expires. After the expiry, the merchant is unable to capture the payment.
ShopifyPaymentsSetExtendedAuthorizationSetStandardAuthorizationExpiresAt Datetime The time after which capture will incur an additional fee.
ShopifyPaymentsSetRefundSetAcquirerReferenceNumber String The acquirer reference number (ARN) code generated for Visa/Mastercard transactions.
TotalUnsettledSetPresentmentMoneyAmount Decimal Decimal money amount.
TotalUnsettledSetPresentmentMoneyCurrencyCode String Currency of the money.
TotalUnsettledSetShopMoneyAmount Decimal Decimal money amount.
TotalUnsettledSetShopMoneyCurrencyCode String Currency of the money.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements, to offer a more granular control over the tuples that are returned from the data source, or as parameters in INSERT statements.

Name Type Description
Amount Decimal The amount to capture. The capture amount can't be greater than the amount of the authorized transaction.
Currency String The amount to capture. The capture amount can't be greater than the amount of the authorized transaction.

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