PackageLineItems
List line items of the package.
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.
- 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 |