Excel Add-In for Zoho Inventory

Build 24.0.9060

CompositeItemsTaxPreferences

Tax refereces of composite items..

Table Specific Information

Select

The add-in 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 add-in.

  • 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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060