OrderAdditionalFees
Lists additional fees applied to an order (for example, handling, or service).
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderAdditionalFees WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally unique Id for the additional fee. | |
| OrderId | String |
Orders.Id | A globally unique Id for the order associated with the fee. |
| Name | String | The name of the additional fee. | |
| PricePresentmentMoneyAmount | Decimal | The presentment currency amount of the fee as a decimal value. | |
| PricePresentmentMoneyCurrencyCode | String | The ISO currency code of the presentment money. | |
| PriceShopMoneyAmount | Decimal | The shop currency amount of the fee as a decimal value. | |
| PriceShopMoneyCurrencyCode | String | The ISO currency code of the shop money. |