OrderTaxes
The list of all taxes associated with the order.
Table Specific Information
Select
The cmdlet 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 cmdlet.
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. |