JDBC Driver for Zoho Inventory

Build 22.0.8462

CompositeItemsTaxPreferences

Tax refereces of composite items..

Table Specific Information

Select

The driver will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the driver.

  • CompositeItemId supports the '=' comparison.
  • TaxId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CompositeItemsTaxPreferences WHERE CompositeItemId = '3350895000000089001'

SELECT * FROM CompositeItemsTaxPreferences WHERE TaxId = '205'

Columns

Name Type References Description
CompositeItemId Long

CompositeItems.Id

Unique ID generated for the composite item by the server.
TaxId [KEY] Long

Taxes.Id

Unique ID generated for the taxes by the server
TaxSpecification String Tax specification of the composite item.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462