ItemGroupsItems
List items of Item Groups.
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.
- 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. |