InventorySummaryReport
Generated schema file.
Table Specific Information
Select
The driver uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- TransactionDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- WarehouseId supports the '=' comparison.
- StockAvailability supports the '=' comparison.
- Status supports the '=' comparison.
- ItemId supports the 'IN' comparison.
The rest of the filter is executed client-side in the driver.
For example:
SELECT * FROM InventorySummaryReport WHERE TransactionDate = 'Today' SELECT * FROM InventorySummaryReport WHERE ToDate = '2022-10-31' SELECT * FROM InventorySummaryReport WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31' SELECT * FROM InventorySummaryReport WHERE warehouseid = '3285934000000113095' SELECT * FROM InventorySummaryReport WHERE StockAvailability = 'AvailableStock' SELECT * FROM InventorySummaryReport WHERE ItemId IN ('5672409674565') SELECT * FROM InventorySummaryReport WHERE Status = 'Active'
Columns
Name | Type | References | SupportedOperators | Description |
CategoryId | String | Category Id. | ||
CategoryName | String | Category Name. | ||
IsComboProduct | Boolean | Is Combo Product. | ||
QuantityAvailable | Double | Quantity Available. | ||
QuantityAvailableForSale | Double | Quantity AvailableForSale. | ||
QuantityDemanded | Double | Quantity Demanded. | ||
QuantityOrdered | Double | Quantity Ordered. | ||
QuantityPurchased | Double | Quantity Purchased. | ||
QuantitySold | Double | Quantity Sold. | ||
ReorderLevel | String | Reorder Level. | ||
Unit | String | Unit. | ||
ItemName | String | Item Name. | ||
Status | String | Status.
The allowed values are All, Active, Inactive. The default value is All. | ||
Sku | String | Sku. | ||
ItemId | String | Item Id. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
WarehouseId | String | Warehouse Id. | |
StockAvailability | String | Stock Availability.
The allowed values are AvailableStock, OutOfStock, StockLessThanZero, StockEqualToZero. The default value is All. | |
TransactionDate | String | Filter transaction by any transaction date.
The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear, CustomDate. | |
ToDate | Date | To Date. | |
FromDate | Date | From Date. |