Power BI Connector for Zoho Inventory

Build 24.0.9062

ShipmentOrdersLineItems

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

  • ShipmentOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM ShipmentOrdersLineItems WHERE ShipmentOrderId = '3350895000000089001'

Columns

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

ShipmentOrders.Id

Unique ID generated by the server for the shipment.
BcyRate Integer Item rate in the organization base currency..
desc String desc of the line item.
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.
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 tax.
TaxType String Denotes the type of tax.
Unit String unit of line item.

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