RefundLineItemDuties
Lists duties attached to refunded 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 | A globally unique Id of the associated refund. | |
| LineItemId | String | A globally unique Id of the line item. | |
| Id [KEY] | String | A globally unique Id of the refund duty. | |
| CountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code of the item's country of origin used to calculate the duty. | |
| HarmonizedSystemCode | String | The harmonized system code of the item used to calculate the duty. | |
| PricePresentmentMoneyAmount | Decimal | The duty refund amount in the presentment currency, expressed as a decimal money amount. | |
| PricePresentmentMoneyCurrencyCode | String | The currency code of the duty refund amount in the presentment currency. | |
| PriceShopMoneyAmount | Decimal | The duty refund amount in the shop's currency, expressed as a decimal money amount. | |
| PriceShopMoneyCurrencyCode | String | The currency code of the duty refund amount in the shop's currency. |