OrderLineItemDiscountAllocations
Retrieves the discounts that have been allocated onto the line item by discount applications, not including order edits and refunds.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the OrderLineItemId 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 OrderLineItemDiscountAllocations WHERE OrderLineItemId='VALUE'
Columns
| Name | Type | References | Description |
| OrderLineItemId | String | The ID of the Order to return. | |
| 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. | |
| AllocatedAmountSetPresentmentMoneyAmount | Decimal | Decimal money amount. | |
| AllocatedAmountSetPresentmentMoneyCurrencyCode | String | Currency of the money. | |
| AllocatedAmountSetShopMoneyAmount | Decimal | Decimal money amount. | |
| AllocatedAmountSetShopMoneyCurrencyCode | String | Currency of the money. |