Excel Add-In for Wave Financial

Build 24.0.9060

SalesTaxes

List of sales taxes for the business.

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 SalesTaxes WHERE Id = 'QnVzaW5lc3M6NjE2MTYtYzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdl'
SELECT * FROM SalesTaxes WHERE BusinessId = 'QnVzaW5lc3M6NjE2MTY4NzVlMS00YzkyLTg0Y2EtNzA0ZDM4MTcyNTdlO0N1c3RvbWVyOjMyNzkyMTEz'
SELECT * FROM SalesTaxes WHERE ModifiedAt < '2020-02-26 18:02:06.171'
SELECT * FROM SalesTaxes WHERE IsArchived = true

Columns

Name Type References SupportedOperators Description
Id [KEY] String The unique identifier for the sales tax.
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