OrderAgreementTipSales
Displays tip-related sales that are part of an agreement, such as service-based transactions.
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 unique identifier of the parent order associated with this tip-related agreement sale. |
| AgreementId | String | The unique identifier of the agreement defining the terms under which the tip-related sale occurred. | |
| Id [KEY] | String | A unique identifier for the individual sale record associated with the agreement. | |
| ActionType | String | The type of order action represented by this sale, such as payment, refund, or adjustment. | |
| LineType | String | The classification of the sale line, indicating that it pertains to a tip or gratuity charge. | |
| Quantity | Int | The total number of tip-related units or entries included in this sale, typically set to one per transaction. | |
| TotalAmountPresentmentMoneyAmount | Decimal | The total sale amount after taxes and discounts, expressed as a decimal value in the presentment currency. | |
| TotalAmountPresentmentCurrencyCode | String | The ISO 4217 currency code representing the presentment currency used to display the total sale amount to the customer. | |
| TotalAmountShopMoneyAmount | Decimal | The total sale amount after taxes and discounts, expressed as a decimal value in the shop's base currency. | |
| TotalAmountShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the total sale amount. | |
| TotalTaxAmountPresentmentMoneyAmount | Decimal | The total amount of taxes applied to the sale, expressed as a decimal value in the presentment currency. | |
| TotalTaxAmountPresentmentCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for the total tax amount. | |
| TotalTaxAmountShopMoneyAmount | Decimal | The total amount of taxes applied to the sale, expressed as a decimal value in the shop's base currency. | |
| TotalTaxAmountShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for the total tax amount. | |
| TotalDiscountAmountBeforeTaxesPresentmentMoneyAmount | Decimal | The total discounts applied before taxes, expressed as a decimal value in the presentment currency. | |
| TotalDiscountAmountBeforeTaxesPresentmentCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for discounts applied before taxes. | |
| TotalDiscountAmountBeforeTaxesShopMoneyAmount | Decimal | The total discounts applied before taxes, expressed as a decimal value in the shop's base currency. | |
| TotalDiscountAmountBeforeTaxesShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for discounts applied before taxes. | |
| TotalDiscountAmountAfterTaxesPresentmentMoneyAmount | Decimal | The total discounts applied after taxes, expressed as a decimal value in the presentment currency. | |
| TotalDiscountAmountAfterTaxesPresentmentCurrencyCode | String | The ISO 4217 currency code representing the presentment currency for discounts applied after taxes. | |
| TotalDiscountAmountAfterTaxesShopMoneyAmount | Decimal | The total discounts applied after taxes, expressed as a decimal value in the shop's base currency. | |
| TotalDiscountAmountAfterTaxesShopMoneyCurrencyCode | String | The ISO 4217 currency code representing the shop's base currency for discounts applied after taxes. | |
| Taxes | String | A list of individual tax details associated with the sale, including tax type, rate, and amount breakdowns. | |
| TipSaleLineItemId | String | A unique identifier linking this sale record to the associated tip line item within the order. |