Power BI Connector for Zoho Inventory

Build 24.0.9060

SalesOrderLineItems

List line items of sales orders.

Table Specific Information

Select

The connector 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 connector.

  • SalesOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM SalesOrderLineItems WHERE SalesOrderId = '3350895000000089001'

Columns

Name Type References Description
LineItemId [KEY] Long Unique ID generated by the server for each line item.
SalesOrderId Long

SalesOrders.Id

Id of the salesorder.
BcyRate Integer Item rate in the organization base currency.
Description String Description of the line item.
HsnOrSac Integer Add HSN/SAC code for your goods/services.
ImageId Long Unique ID generated by the server for the item image.
ImageName String Name of the image of the line item.
ImageType String The type (file format) of the image.
IsInvoiced Boolean Checks whether the Sales Order has been invoiced or not.
ItemId Long Unique ID generated by the server for the item.
ItemOrder Integer The order of the line items.
ItemTotal Integer Total of line item.
Name String Name of the line item.
Quantity Integer Quantity of the line item.
QuantityInvoiced Integer Quantity invoiced of the line item.
QuantityPacked Integer Quantity packed of the line item.
QuantityShipped Integer Quantity shipped of the line item.
Rate Integer Rate / Selling Price of the line item.
TaxId Long Unique ID generated by the server for the tax.
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.
Unit String Unit of line item.
WarehouseId Long Unique ID generated by the server for the ware houses.

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