OrderTaxes
Returns all taxes applied to a specific Square order, including percentage‑based and fixed‑amount taxes, their scope, and related catalog details.
Table Specific Information
Select
The add-in uses the Square API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the add-in.
- LocationId supports the following operators: =, IN.
- OrderId supports the following operators: =, IN.
Retrieve all order taxes found in every order of your Square account:
SELECT * FROM OrderTaxes
You can retrieve all order taxes 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 | Id of the seller location where the order was placed. |
| AppliedAmount | Int64 | Actual monetary amount of tax applied to the order or line item, expressed in the smallest currency unit (for example, cents). |
| AppliedCurrency | String | The type of currency, in ISO 4217 format. |
| Name | String | Display name of the tax, as shown in receipts, invoices, or order summaries. |
| 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 | Identifier of the catalog tax object associated with this tax, if applicable. |
| CatalogVersion | Int64 | The version of the catalog object that this tax references. |
| OrderId | String | Unique identifier of the order that the tax is associated with. |