Cmdlets for Zoho Books

Build 24.0.8963

ItemWarehouses

Retrieves 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 ItemId column, which supports '=,IN' comparisons.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963