SalesTaxes
List of sales taxes for the business.
Table Specific Information
The add-in uses the Wave Financial API to process some of the filters. The add-in processes other filters client-side within the add-in. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. For example, the following queries are processed server side.SELECT
SELECT * FROM SalesTaxes WHERE Id = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl' SELECT * FROM SalesTaxes WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTY4NzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTEz' SELECT * FROM SalesTaxes WHERE ModifiedAt < '2020-02-26 18:02:06.171' SELECT * FROM SalesTaxes WHERE IsArchived = true
Columns
Name | Type | References | SupportedOperators | Description |
Id [KEY] | String | The unique identifier for the sales tax. | ||
BusinessId | String |
Businesses.id | The unique identifier for the business. | |
Name | String | Name of the tax. | ||
Abbreviation | String | A short form or code representing the sales tax. | ||
Description | String | User defined description for the sales tax. | ||
TaxNumber | String | The tax's issued identification number from a taxing authority. | ||
ShowTaxNumberOnInvoices | Bool | Display tax number beside the tax name on an invoice. | ||
Rate | Decimal | Tax rate effective on 'for' date, or current date if no parameter, as a decimal (e.g. 0.15 represents 15%). | ||
IsCompound | Bool | Is a compound tax, or stacked tax. This tax is calculated on top of the subtotal and other tax amounts. | ||
IsRecoverable | Bool | Is a recoverable tax. It is recoverable if you can deduct the tax that you as a business paid from the tax that you have collected. | ||
IsArchived | Bool | Is the sales tax hidden from view by default. | ||
CreatedAt | Datetime | When the sales tax was created. | ||
ModifiedAt | Datetime | When the sales tax was last modified. |