RefundLineItemDuties
Shows refunded duty charges applied to individual order line items.
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 RefundLineItemDuties WHERE RefundId = 'Val1'
Columns
| Name | Type | References | Description |
| RefundId | String | The globally unique identifier of the refund transaction associated with this refunded duty line item. | |
| LineItemId | String | The globally unique identifier of the original line item for which duty is being refunded. | |
| Id [KEY] | String | A globally unique identifier for the refunded duty record linked to the refund line item. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code indicating the country of origin used for the duty calculation. | |
| HarmonizedSystemCode | String | The harmonized system (HS) code used to classify the product for customs and duty calculation. | |
| PricePresentmentMoneyAmount | Decimal | The duty refund amount in the customer's presentment currency, expressed as a decimal money value. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the refunded duty amount. | |
| PriceShopMoneyAmount | Decimal | The duty refund amount in the shop's base currency, represented as a decimal money value. | |
| PriceShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency used for the refunded duty amount. |