RefundDuties
Lists the refunded duties as part of this refund.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the RefundId column, which supports the '=,IN' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM RefundDuties WHERE RefundId='VALUE'
Columns
| Name | Type | References | Description |
| OriginalDutyId [KEY] | String | A globally-unique ID. | |
| RefundId [KEY] | String |
Refunds.Id | A globally-unique ID. |
| OriginalDutyHarmonizedSystemCode | String | The harmonized system code of the item used in calculating the duty. | |
| OriginalDutyCountryCodeOfOrigin | String | The ISO 3166-1 alpha-2 country code of the country of origin used in calculating the duty. | |
| AmountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| AmountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| AmountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| AmountSetShopMoneyCurrencyCode | String | Currency of the money. |