ODBC Driver for Wave Financial

Build 24.0.9060

ProductDefaultSalesTaxes

Default sales taxes to apply on product.

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

Columns

Name Type References SupportedOperators Description
Id [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.
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 24.0.9060