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 provider 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 provider.
- 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. |