JDBC Driver for Zoho Books

Build 22.0.8479


Retrieves list of line items from vendor credits.

Table Specific Information


The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
Note: VendorCreditId is required in order to query VendorCreditLineItems.

  • VendorCreditId supports the '=' comparison.
For example:
    SELECT * FROM VendorCreditLineItems WHERE VendorCreditId = '1894545000000083308'


Name Type References SupportedOperators Description
LineItemId [KEY] String ID of a line item.
VendorCreditId String


ID of a vendor credit.
AccountId String


ID of the Bank Account.
AccountName String Name of the account.
BcyRate Decimal Rate of a Base Currency.
CustomFields String Custom Fields added for the line item
Description String Description of the vendor credit line item.
GstTreatmentCode String Treatement code of GST.
HasProductTypeMismatch Boolean Check if the product type has mismatch.
HsnOrSac String HSN Code.
ItcEligibility String Eligibility of Input Tax Credit.
ItemId String


ID of an item.
ItemOrder Integer Order of an item.
ItemTotal Decimal Total of an item.
ItemType String Type of an item.
Name String Name of a line item.
PricebookId String Id of a price book.
ProductType String Product type of vendor credit.
ProjectId String


Id of a project.
Quantity Decimal Quantity of vendor credit.
Rate Decimal Rate of vendor credit.
ReverseChargeTaxId String ID of the reverse charge tax.
Tags String Details of tags related to vendor credit line items.
TaxExemptionCode String Code of tax exemption.
TaxExemptionId String


ID of tax exemption.
TaxId String


ID of tax.
TaxName String Name of tax.
TaxPercentage Integer Percentage of tax.
TaxType String Type of tax.
Unit String Unit of line items in vendor credit.

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