Power BI Connector for Zoho Inventory

Build 24.0.9062

VendorCreditsLineItems

List line items of Vendor Credits.

Table Specific Information

Select

The 本製品 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 本製品.

  • LineItemId supports the '=' comparison.
  • VendorCreditId supports the '=' comparison.
  • ItemId supports the '=' comparison.
  • AccountId supports the '=' comparison.
  • TaxId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM VendorCreditsLineItems WHERE LineItemId = '3350895000000089001'

SELECT * FROM VendorCreditsLineItems WHERE VendorCreditId = '983872973'

Columns

Name Type References Description
VendorCreditId Long

VendorCredits.Id

ID of the Vendor Credit
ItemId String Item Id.
LineItemId [KEY] String Line Item Id.
AccountId String ID of the account, the line item is associated with
Name String Name of the line item.
HSNOrSAC String HSN Code
ReverseChargeTaxId Long ID of the Reverse Charge
WarehouseId Boolean Warehouse Id.
Description Boolean Description of the line item.
ItemOrder String Order of the line item
Quantity String Quantity of the line item.
Unit String Unit of the line item e.g. kgs, Nos.
Rate Integer Rate of the line item.
TaxId Long ID of the Tax associated with the Vendor Credit
TaxTreatmentCode String Tax Treatment Code.
Tags String Tags.
ItemCustomFields Integer Item Custom Fields.
ProjectId Long Project Id.
ProjectName String Project Name.

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