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. 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 ProductDefaultSalesTaxRates WHERE ProductId = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y'
SELECT * FROM ProductDefaultSalesTaxRates WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTY4NzVlMSyOjMyNzkyMTEz'

Columns

Name	Type	References	SupportedOperators	Description
SalesTaxId [KEY]	String	ProductDefaultSalesTaxes.Id		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%).