ProductDefaultSalesTaxRates
Tax rates with their effective dates of application.
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. For example, the following queries are processed server side.SELECT
SELECT * FROM ProductDefaultSalesTaxRates WHERE ProductId = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y' SELECT * FROM ProductDefaultSalesTaxRates WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTY4NzVlMSyOjMyNzkyMTEz'
Columns
| Name | Type | References | SupportedOperators | Description |
| SalesTaxId [KEY] | String | The unique identifier for the sales tax. | ||
| ProductId [KEY] | String |
Products.Id | Unique identifier for the product. | |
| BusinessId | String |
Businesses.Id | The unique identifier for the business. | |
| Effective | Date | Date from which the sales tax rate applies. | ||
| Rate | Decimal | Tax rate applying from the effective date as a decimal (e.g. 0.15 represents 15%). |