PackageLineItems
List line items of the package.
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.
- LineItemId supports the '=' comparison.
- PackageId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM PackageLineItems WHERE PackageId = '3350895000000089001'
Columns
| Name | Type | References | Description |
| Description | String | Description of the item in package | |
| PackageId | Long |
Packages.Id | Unique ID generated by the server of the item in package |
| IsInvoiced | Boolean | Sales order item is invoiced to the customer or not | |
| ItemId | Long | Unique ID generated by the server of the item in package | |
| ItemOrder | String | Item Order | |
| LineItemId [KEY] | Long | Unique value generated by the server for an item of sales order in package | |
| Name | String | Name of the packaged item | |
| Quantity | Integer | Number of quantity of line items in sales order | |
| Sku | String | Stock keeping unit of the item in package | |
| SoLineItemId | Long | Unique ID generated by the server for items in sales order | |
| Unit | String | Unit of the item in package |