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. |