OrderAgreementTipSales
Lists sales attributed to agreement-based tips.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- OrderId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM OrderAgreementTipSales WHERE OrderId = 'Val1'
Columns
| Name | Type | References | Description |
| OrderId | String |
Orders.Id | The Id of the parent order associated with the agreement. |
| AgreementId | String | A globally unique Id for the agreement. | |
| Id [KEY] | String | A globally 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, in presentment currency, as a decimal value. | |
| TotalAmountPresentmentCurrencyCode | String | The ISO currency code for the presentment currency of the total sale amount. | |
| TotalAmountShopMoneyAmount | Decimal | The total sale amount after taxes and discounts, in shop currency, as a decimal value. | |
| TotalAmountShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the total sale amount. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total tax amount for the sale, in presentment currency, as a decimal value. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The ISO currency code for the presentment currency of the total tax amount. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total tax amount for the sale, in shop currency, as a decimal value. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the total tax amount. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total discount amount applied before taxes, in presentment currency, as a decimal value. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The ISO currency code for the presentment currency of the discount amount applied before taxes. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total discount amount applied before taxes, in shop currency, as a decimal value. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discount amount applied before taxes. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total discount amount applied after taxes, in presentment currency, as a decimal value. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The ISO currency code for the presentment currency of the discount amount applied after taxes. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total discount amount applied after taxes, in shop currency, as a decimal value. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The ISO currency code for the shop currency of the discount amount applied after taxes. | |
| Taxes | String | The individual taxes associated with the sale. | |
| TipSaleLineItemId | String | The Id of the tip line item associated with the sale. |