ODBC Driver for Wave Financial

Build 23.0.8839


Default sales taxes to apply on product.

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


Name Type References SupportedOperators Description
Id [KEY] String The unique identifier for the sales tax.
ProductId [KEY] String


Unique identifier for the product.
BusinessId String


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.

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