SalesOrderLineItems

List line items of sales 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 本製品.

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.

Power BI Connector for Zoho Inventory

SalesOrderLineItems

Table Specific Information

Select

Columns