Retrieves warehouse details related to items.

git a

Table Specific Information

Select

The add-in uses the Zoho Books API to process WHERE clause conditions built with the ItemId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the add-in.

For example:

    SELECT * FROM ItemWarehouses WHERE ItemId = '3255827000000081058'

    SELECT * FROM ItemWarehouses WHERE ItemId IN ('3255827000000081058', '3255827000000102354')

Columns

Name	Type	References	SupportedOperators	Description
WarehouseId	Long			The Warehouse Id.
ItemId	String	Items.ItemId		The Id of the item.
IsPrimary	Boolean			A Boolean indicating whether the item is primary.
Status	String			The Status of the item. It can be active or inactive.
WarehouseActualAvailableStock	String			The Warehouse Actual Available Stock.
WarehouseAvailableStock	String			The Warehouse Available Stock.
WarehouseName	String			The Warehouse Name.
StockOnHand	String			The Current available stock in your warehouse.