OrderLineItemDiscountAllocations
Shows discount allocations applied to a line item, excluding edits and refunds.
View-Specific Information
Select
The 本製品 uses the Shopify API to process WHERE clause conditions built with the following column and operators. The 本製品 processes other filters client-side within the 本製品.
- 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. | |
| 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 | 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. |