TaxGroups

Read, Insert, Update and Delete Tax Groups.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

TaxGroupId supports the '=' comparison.

The rest of the filter is executed client-side in the 本製品.

For example:

    SELECT * FROM TaxGroups WHERE TaxGroupId = '3255827000000076031'

Insert

INSERT can be executed by specifying the TaxGroupName, Taxes column. 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 TaxGroups (TaxGroupName, TAXES) VALUES ('groupinsert', '3255827000000076025, 3255827000000076013, 3255827000000076007')

Update

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

UPDATE Taxgroups SET TaxGroupName = 'TaxUpdated' WHERE taxgroupid = 3255827000000077002

Delete

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

DELETE FROM TaxGroups WHERE TaxGroupId = '3255827000000077002'

Columns


Name	Type	ReadOnly	References	SupportedOperators	Description
TaxGroupId [KEY]	String	True		=	Id of the Tax Group.
TaxGroupName	String	False			Name of the tax group to be created.
TaxGroupPercentage	Double	False			Tax group percentage.
Taxes	String	False			Comma Seperated list of tax Ids that are to be associated to the tax group.