ProductDefaultSalesTaxRates
Tax rates with their effective dates of application.
Table Specific Information
The 本製品 uses the Wave Financial API to process some of the filters. The 本製品 processes other filters client-side within the 本製品. 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 | 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%). |