JDBC Driver for Zoho Inventory

Build 24.0.9060

PackageLineItems

List line items of the package.

Table Specific Information

Select

The driver 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 driver.

  • 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

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