ShipmentOrdersLineItems
List line items of shipment orders..
Table Specific Information
Select
The add-in 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 add-in.
- 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 | 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. |