Taxes

List, add, update and delete simple and compound taxes. Also, get the details of a simple or compound tax.

Table Specific Information

Select

The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

TaxId supports the '=' comparison.

The rest of the filter is executed client-side in the connector.

For example:

    SELECT * FROM Taxes WHERE TaxId = '1894553000000077244'

Insert

INSERT can be executed by specifying the TaxName and TaxPercentage columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.

INSERT INTO Taxes (TaxName, TAXPERCENTAGE) VALUES ('tax1', '3')

Update

UPDATE can be executed by specifying the TaxId in the WHERE Clause. The columns that are not read-only can be updated. For example:

UPDATE Taxes SET TaxName = 'TaxUpdated', TaxPercentage = '5' WHERE TaxId = '3350895000000089005'

Delete

DELETE can be executed by specifying the TaxId in the WHERE Clause For example:

DELETE FROM Taxes WHERE TaxId = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	SupportedOperators	Description
TaxId [KEY]	String	True			Id of tax.
TaxName	String	False			Name of the tax.
TaxPercentage	Integer	False			Percentage applied for tax.
TaxType	String	False			Type of tax.
TaxSpecificType	String	False			Type of tax.
TaxAuthorityId	String	False			Id of a tax authority.
TaxAuthorityName	String	False			Name of the tax authority.
TaxSpecification	String	True			Working of tax when specifying special tax options and tax methods for earnings codes.
TdsPayableAccountId	String	True	BankAccounts.AccountId		Account Id of TDS payable.
Country	String	True			Name of the country for taxes.
CountryCode	String	False			Country code for taxes.
IsDefaultTax	Boolean	False			Check if the tax is default.
IsValueAdded	Boolean	False			Check if Tax is Value Added.
IsEditable	Boolean	False			Check if the tax is editable.
PurchaseTaxExpenseAccountId	String	False			Account Id in which Purchase Tax will be Computed.
UpdateRecurringInvoice	Boolean	False			Check if recurring invoice should be updated.
UpdateRecurringExpense	Boolean	False			Check if Draft Invoices should be updated.
UpdateDraftInvoice	Boolean	False			Check if Draft Invoices should be updated.
UpdateRecurringBills	Boolean	False			Check if Subscriptions should be updated.
UpdateDraftSo	Boolean	False			Check if Subscriptions should be updated.
UpdateSubscription	Boolean	False			Check if Subscriptions should be updated.
UpdateProject	Boolean	False			Check if Projects should be updated.