ODBC Driver for Wave Financial

Build 24.0.9060

ProductDefaultSalesTaxRates

Tax rates with their effective dates of application.

Table Specific Information

The driver uses the Wave Financial API to process some of the filters. The driver processes other filters client-side within the driver. 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%).

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060