OrderShippingLineDiscountAllocations
Retrieves the discounts that have been allocated onto the shipping lines of an order by discount applications.
View-Specific Information
Select
The provider uses the Shopify API to process WHERE clause conditions built with the following column and operators. The provider processes other filters client-side within the provider.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderShippingLineDiscountAllocations WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId [KEY] | String | The ID of the Order. | |
| ShippingLineId [KEY] | String | The ID of the shipping line. | |
| DiscountApplicationIndex [KEY] | Decimal | An ordered index that can be used to identify the discount application and indicate the precedence of the discount application for calculations. | |
| DiscountApplicationType | String | Discount type. | |
| DiscountApplicationTargetType | String | Discount target type. | |
| DiscountApplicationTargetSelection | String | Discount target selection. | |
| DiscountApplicationTitle | String | Discount name. | |
| DiscountApplicationValueAmount | Decimal | Discount value as a precise monetary value. | |
| DiscountApplicationValueCurrencyCode | String | Discount value currency code. | |
| DiscountApplicationValuePercentage | Float | Discount value as percentage. | |
| AllocatedAmountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| AllocatedAmountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| AllocatedAmountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| AllocatedAmountSetShopMoneyCurrencyCode | String | Currency of the money. |