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