OrderLineItemDiscountAllocations
Shows discount allocations applied to a line item, excluding edits and refunds.
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.
- OrderLineItemId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderLineItemDiscountAllocations WHERE OrderLineItemId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderLineItemId [KEY] | String | The Id of the order line item associated with the discount allocation. | |
| DiscountApplicationIndex [KEY] | Decimal | The ordered index that identifies the discount application and indicates its precedence for calculations. | |
| AllocatedAmountSetPresentmentMoneyAmount | Decimal | The allocated discount amount, in presentment currency, as a decimal value. | |
| AllocatedAmountSetPresentmentMoneyCurrencyCode | String | The ISO currency code for the presentment currency of the allocated discount amount. | |
| AllocatedAmountSetShopMoneyAmount | Decimal | The allocated discount amount, in shop currency, as a decimal value. | |
| AllocatedAmountSetShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the allocated discount amount. |