Power BI Connector for Zoho Inventory

Build 24.0.9062

CompositeItemsBundlesLineItems

Get the line items of the bundles.

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 本製品.

  • BundleId supports the '=' comparison.
  • ItemId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CompositeItemsBundlesLineItems WHERE BundleId = '3350895000000089001'

SELECT * FROM CompositeItemsBundlesLineItems WHERE ItemId = '3350895000000089001'

Columns

Name Type References Description
BundleId Long

CompositeItemsBundles.Id

Unique ID generated by the server for the bundle
AccountId Long Unique ID generated by the server for the type of sale of this item
AccountName String Type of sale under which the composite item is sold
Description String Sample Description
ItemId Long Unique ID generated by the server for the Item
LineItemId [KEY] Long Unique ID generated by the server for mapping the associated item with composite item
Name String Name of the composite item
QuantityConsumed Integer Quantity of item to be bundled.
Rate Integer Selling price of the item
Unit String Unit of Item
WarehouseId Long Unique ID generated by the server for the Warehouse.
WarehouseName String Name of the Warehouse.

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