ItemWarehouses
Get warehouse details related to items.
git a
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- ItemId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM ItemWarehouses where ItemId = '3255827000000081058'
SELECT * FROM ItemWarehouses where ItemId IN ('3255827000000081058','3255827000000102354')
Columns
| Name | Type | References | SupportedOperators | Description |
| WarehouseId | Long | Warehouse Id | ||
| ItemId | String |
Items.ItemId | ID of the item. | |
| IsPrimary | Boolean | Mention whether the item is primary or not | ||
| Status | String | Status of the item. It can be active or inactive | ||
| WarehouseActualAvailableStock | String | Warehouse Actual Available Stock | ||
| WarehouseAvailableStock | String | Warehouse Available Stock | ||
| WarehouseName | String | Warehouse Name | ||
| StockOnHand | String | Current available stock in your warehouse. |