OrderAgreementProductSales
Retrieves a list of sales associated with agreements.
View-Specific Information
Select
The add-in uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- OrderId supports the '=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM OrderAgreementProductSales
SELECT * FROM OrderAgreementProductSales WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId | String |
Orders.Id | The parent resource of the agreement. |
| AgreementId | String | The unique ID for the agreement. | |
| Id [KEY] | String | The unique ID for the sale. | |
| ActionType | String | The type of order action that the sale represents. | |
| LineType | String | The line type associated with the sale. | |
| Quantity | Int | The number of units either ordered or intended to be returned. | |
| TotalAmountPresentmentMoneyAmount | Decimal | The total sale amount after taxes and discounts. Amount in presentment currency. Decimal money amount. | |
| TotalAmountPresentmentCurrencyCode | String | The total sale amount after taxes and discounts. Amount in presentment currency. Currency of the money. | |
| TotalAmountShopMoneyAmount | Decimal | The total sale amount after taxes and discounts. Amount in shop currency. Decimal money amount. | |
| TotalAmountShopMoneyCurrencyCode | String | The total sale amount after taxes and discounts. Amount in shop currency. Currency of the money. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total amount of taxes for the sale. Amount in presentment currency. Decimal money amount. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The total amount of taxes for the sale. Amount in presentment currency. Currency of the money. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total amount of taxes for the sale. Amount in shop currency. Decimal money amount. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The total amount of taxes for the sale. Amount in shop currency. Currency of the money. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total discounts allocated to the sale before taxes. Amount in presentment currency. Decimal money amount. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The total discounts allocated to the sale before taxes. Amount in presentment currency. Currency of the money. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total discounts allocated to the sale before taxes. Amount in shop currency. Decimal money amount. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The total discounts allocated to the sale before taxes. Amount in shop currency. Currency of the money. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total discounts allocated to the sale after taxes. Amount in presentment currency. Decimal money amount. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The total discounts allocated to the sale after taxes. Amount in presentment currency. Currency of the money. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total discounts allocated to the sale after taxes. Amount in shop currency. Decimal money amount. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The total discounts allocated to the sale after taxes. Amount in shop currency. Currency of the money. | |
| Taxes | String | The individual taxes associated with the sale. | |
| ProductSaleLineItemId | String | A sale associated with a product. The line item for the associated sale. A globally-unique ID. |