OrderItemDiscountAllocations
Query order item discount allocations.
View-Specific Information
Select
The adapter uses the Shopify API to process WHERE clause conditions built with the following column and operator. The adapter processes other filters client-side within the adapter.
- OrderId supports the 'IN,=' comparison operators.
- OrderUpdatedAt supports the '=,<,>,<=,>=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM OrderItemDiscountAllocations
SELECT * FROM OrderItemDiscountAllocations WHERE OrderId IN (123, 456)
SELECT * FROM OrderItemDiscountAllocations WHERE OrderUpdatedAt = '2023-01-01 11:10:00'
Columns
| Name | Type | References | Description |
| LineNumber [KEY] | Long | A unique numeric identifier for the table. | |
| ItemId | Long |
OrdersItems.ItemId | The id of the order item. Only available for orders. |
| OrderId | Long |
Orders.Id | The id of the order. |
| amount | String | The Amount of the item discount allocations. | |
| ApplicationIndex | Int | The ApplicationIndex of the item discount allocations. | |
| ShopMoneyAmount | Decimal | The ShopMoneyAmount of the item discount allocations. | |
| ShopMoneyCurrencyCode | String | The ShopMoneyCurrencyCode of the item discount allocations. | |
| PresentmentMoneyAmount | Decimal | The PresentmentMoneyAmount of the item discount allocations. | |
| PresentmentMoneyCurrencyCode | String | The PresentmentMoneyCurrencyCode of the item discount allocations. | |
| OrderUpdatedAt | Datetime | The date and time when the order was last modified. |