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