OrderDiscounts
The list of all discounts associated with the order.
Table Specific Information
Select
The add-in uses the Square API to process search criteria that refer to the OrderId and LocationId, while other filters are processed client side within the add-in.
Retrieve all the OrderDiscounts found in every order of your Square account.
SELECT * FROM OrderDiscounts
You can retrieve all order OrderDiscounts from an order by specifying the OrderId.
SELECT * FROM OrderDiscounts WHERE OrderId = 'TzratjkPk9rhOuLYvSXeznmVvIx5PVlZpg72GfPQGBxckDeeWNBN8yqnf11qTrg3W3AelXC1kB'
You can also use the IN operator to specify multiple OrderIds in the WHERE clause.
SELECT * FROM OrderDiscounts WHERE OrderId IN ('XKKB7LD30TpfNyW3e843ziklKh4vWEvweQyL5l4ESJLH3N2XXNBN8yqnf11qTrg3W3AelXC1kB', 'pxICohrEXPDtoUitiZhG1um5uhp5WI7CRMHknbuKpaj53PXfWNBN8yqnf11qTrg3W3AelXC1kB', '6j8avtXB5fIaPZ9H12beiZP7sCSiqguGhHpwmECsEaENswJnWNBN8yqnf11qTrg3W3AelXC1kB')
Columns
| Name | Type | Description |
| Id | String | A unique ID that identifies the discount only within this order |
| LocationId | String | The Id of the location. |
| AppliedAmount | Integer | The amount of discount actually applied to the line item |
| AppliedCurrency | String | The type of currency, in ISO 4217 format |
| AmountMoneyAmount | Integer | The total declared monetary amount of the discount amount_money is not set for percentage-based discounts |
| AmountMoneyCurrency | String | The type of currency, in ISO 4217 format |
| Name | String | The discount's name |
| Percentage | String | The percentage of the discount |
| Scope | String | Indicates the level at which the discount applies
The allowed values are OTHER_DISCOUNT_SCOPE, LINE_ITEM, ORDER. |
| Type | String | The type of the discount
The allowed values are UNKNOWN_DISCOUNT, FIXED_PERCENTAGE, FIXED_AMOUNT, VARIABLE_PERCENTAGE, VARIABLE_AMOUNT. |
| CatalogObjectId | String | The catalog object ID |
| CatalogVersion | Int64 | The version of the catalog object that this discount references |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| OrderId | String | The order's unique ID. |