OrderAgreementAdjustmentSales
Retrieves a list of sales associated with agreements.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.
- OrderId supports the '=' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM OrderAgreementAdjustmentSales
SELECT * FROM OrderAgreementAdjustmentSales 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. |