ItemGroupsItems
List items of Item Groups.
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.
- Id supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM ItemGroupsItems WHERE Id = '3350895000000089001'
Columns
| Name | Type | References | Description |
| GroupId | Long |
ItemGroups.Id | Id of the Item Group |
| Name | String | Name of the Item. | |
| Rate | Double | Sales price of the Item. | |
| PurchaseRate | Double | Purchase price of the Item. | |
| ReorderLevel | Double | Reorder level of the item. | |
| InitialStock | Double | The opening stock of the item. | |
| InitialStockRate | Double | The opening stock value of the item. | |
| VendorId | Long | Unique ID generated by the server for the Vendor. | |
| Sku | String | The Stock Keeeping Unit (SKU) of an item. | |
| Upc | Long | The 12 digit Unique Product Code (UPC) of the item. | |
| Ean | Long | Unique EAN value for the Item. | |
| Isbn | Long | Unique ISBN value for the Item. | |
| PartNumber | String | Part Number of the Item. | |
| AttributeOptionName1 | Long | Name of the attribute option. |