OrderTaxes
The list of all taxes 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 column, while other filters are processed client side within the add-in.
Retrieve all the OrderTaxes found in every order of your Square account.
SELECT * FROM OrderTaxes
You can retrieve all order OrderTaxes from an order by specifying the OrderId.
SELECT * FROM OrderTaxes WHERE OrderId = 'TzratjkPk9rhOuLYvSXeznmVvIx5PVlZpg72GfPQGBxckDeeWNBN8yqnf11qTrg3W3AelXC1kB'
You can also use the IN operator to specify multiple OrderIds in the WHERE clause.
SELECT * FROM OrderTaxes WHERE OrderId IN ('XKKB7LD30TpfNyW3e843ziklKh4vWEvweQyL5l4ESJLH3N2XXNBN8yqnf11qTrg3W3AelXC1kB', 'pxICohrEXPDtoUitiZhG1um5uhp5WI7CRMHknbuKpaj53PXfWNBN8yqnf11qTrg3W3AelXC1kB', '6j8avtXB5fIaPZ9H12beiZP7sCSiqguGhHpwmECsEaENswJnWNBN8yqnf11qTrg3W3AelXC1kB')
Columns
| Name | Type | Description |
| Id | String | A unique ID that identifies the tax only within this order |
| LocationId | String | The Id of the location. |
| AppliedAmount | Integer | The amount of money applied by the tax in the order |
| AppliedCurrency | String | The type of currency, in ISO 4217 format |
| Name | String | The tax's name |
| Percentage | String | The percentage of the tax |
| Scope | String | Indicates the level at which the discount applies
The allowed values are OTHER_DISCOUNT_SCOPE, LINE_ITEM, ORDER. |
| Type | String | Indicates the calculation method used to apply the tax
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 tax 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. |