CompositeItemsBundlesLineItems
Get the line items of the bundles.
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.
- 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 | 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. |