InventorySummaryReport
Generated schema file.
Table Specific Information
Select
The 本製品 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 本製品.
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
使用できる値は次のとおりです。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, CustomDate | |
| ToDate | Date | To Date | |
| FromDate | Date | From Date |