Tableau Connector for Zoho Books

Build 22.0.8479

VendorCreditLineItems

Retrieves list of line items from vendor credits.

Table Specific Information

Select

The connector 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 connector.
Note: VendorCreditId is required in order to query VendorCreditLineItems.

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

Columns

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

VendorCredits.VendorCreditId

ID of a vendor credit.
AccountId String

BankAccounts.AccountId

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

Items.ItemId

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

Projects.ProjectId

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

BankRules.TaxExemptionId

ID of tax exemption.
TaxId String

Taxes.TaxId

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