RefundDuties
Displays refunded duty amounts associated with international orders.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- RefundId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM RefundDuties WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| OriginalDutyId [KEY] | String | The globally unique identifier of the original duty charge being refunded. | |
| RefundId [KEY] | String |
Refunds.Id | The globally unique identifier of the refund transaction associated with this duty refund. |
| OriginalDutyHarmonizedSystemCode | String | The harmonized system (HS) code used to classify the item for customs and duty calculations. | |
| OriginalDutyCountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code representing the item's country of origin used in duty assessment. | |
| AmountSetPresentmentMoneyAmount | Decimal | The refunded duty amount shown in the customer's presentment currency, represented as a decimal money value. | |
| AmountSetPresentmentMoneyCurrencyCode | String | The ISO 4217 currency code for the presentment currency of the refunded duty amount. | |
| AmountSetShopMoneyAmount | Decimal | The refunded duty amount converted to the shop's base currency, represented as a decimal money value. | |
| AmountSetShopMoneyCurrencyCode | String | The ISO 4217 currency code for the shop's base currency used in the refunded duty calculation. |