Cmdlets for Zoho Books

Build 24.0.8963

VendorCreditLineItems

Retrieves list of line items from vendor credits.

Table Specific Information

Select

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

  • VendorCreditId supports the '=' and IN operators.

NOTE: VendorCreditId is required to query VendorCreditLineItems.

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

For example:

    SELECT * FROM VendorCreditLineItems WHERE VendorCreditId = '1894545000000083308'
	SELECT * FROM VendorCreditLineItems WHERE VendorCreditId IN (SELECT VendorCreditId FROM VendorCredits)
	SELECT * FROM VendorCreditLineItems WHERE VendorCreditId IN ('1894545000000083308','1894545000000083309')

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.
SKU String The SKU of the Line Item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963