Power BI Connector for Zoho Inventory

Build 24.0.9062

PurchaseOrderLineItems

List line items of Purchase Orders.

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.
  • PurchaseOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PurchaseOrderLineItems WHERE PurchaseOrderId = '3350895000000089001'

Columns

Name Type References Description
PurchaseOrderId Long

PurchaseOrders.Id

Unique ID generated by the server for the Purchase Order.
AccountId Long Account ID of the item.
BcyRate Integer Item rate in the organization base currency.
Description String Description of the line item.
HsnOrSac String HSN or SAC Code for the Item
ImageId Long Unique ID generated by the server for the item image. This is used an identifier.
ImageName String Name of the image of the line item.
ImageType String The type (file format) of the image.
ItemId Long Unique ID generated by the server for the item. This is used as an identifier
ItemOrder Integer The order of the line items, starts from 0 by default.
ItemTotal Integer Total of line item.
LineItemId [KEY] Long Id of line item.
Name String Name of the line item.
PurchaseRate Integer Purchase Price of the line item.
Quantity Integer Quantity of the line item.
QuantityReceived Integer Quantity invoiced of the line item.
ReverseChargeTaxAmount Integer Enter reverse charge tax amount.
ReverseChargeTaxId Long Enter reverse charge tax ID.
ReverseChargeTaxName String Enter reverse charge tax name.
ReverseChargeTaxPercentage Integer Enter reverse charge tax percentage.
SalesorderItemId Long Salesorder Item Id.
TaxExemptionCode String Enter tax exemption code.
TaxRxemptionId String Enter tax exemption id
TaxId Long Unique ID generated by the server for the tax. This is used as an identifier.
TaxName String Name of the tax applied on the line item.
TaxPercentage Integer Percentage of the tax.
TaxType String Denotes the type of the tax. This can either be a single tax or a tax group.
Unit String Unit of line item.
WarehouseId Long Warehouse Id.

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