InventorySummaryReport
Generated schema file.
Table Specific Information
Select
The connector will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the connector.
- 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.
SELECT * FROM InventorySummaryReport
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
使用できる値は次のとおりです。All, Active, Inactive デフォルト値は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
使用できる値は次のとおりです。AvailableStock, OutOfStock, StockLessThanZero, StockEqualToZero デフォルト値はAllです。 | |
| TransactionDate | String | Filter transaction by any transaction date.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
| ToDate | Date | To Date | |
| FromDate | Date | From Date |