ProductDefaultSalesTaxes
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
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. |