StockSummaryReport
Generated schema file.
Table Specific Information
Select
The provider 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.
- ItemName supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparisons.
- ItemSku supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparisons.
- WarehouseId supports the 'IN, NOT IN' comparisons.
The rest of the filter is executed client-side in the provider.
For example:
SELECT * FROM StockSummaryReport WHERE TransactionDate = 'Today'
SELECT * FROM StockSummaryReport WHERE ToDate = '2022-10-31'
SELECT * FROM StockSummaryReport WHERE FromDate = '2022-10-10' AND ToDate = '2022-10-31'
SELECT * FROM StockSummaryReport WHERE ItemName IS NULL
SELECT * FROM StockSummaryReport WHERE ItemName = 'BAGS'
SELECT * FROM StockSummaryReport WHERE CONTAINS (ItemName, 'BAGS')
SELECT * FROM StockSummaryReport WHERE ItemName LIKE '%b'
SELECT * FROM StockSummaryReport WHERE ItemName NOT LIKE '%b%'
SELECT * FROM StockSummaryReport WHERE WarehouseId IN ('3285934000000113095')
Columns
| Name | Type | References | SupportedOperators | Description |
| ClosingStock | Double | Closing Stock | ||
| ItemId | String | Item Id | ||
| OpeningStock | Double | Opening Stock | ||
| PurchaseAccountName | String | Purchase Account Name | ||
| QuantityIn | Double | Quantity In | ||
| QuantityOut | Double | Quantity Out | ||
| ItemItemType | String | ItemItem Type | ||
| ItemProductType | String | Item Product Type | ||
| ItemStatus | String | Item Status | ||
| ItemUnit | String | Item Unit | ||
| ItemDescription | String | Item Description | ||
| ItemRate | String | Item Rate | ||
| ItemPurchaseDescription | String | Item Purchase Description | ||
| ItemPurchaseRate | String | Item Purchase Rate | ||
| ItemCreatedTime | Datetime | Item Created Time | ||
| ItemCreatedBy | String | Item Created By | ||
| ItemLastModitfiedTime | Datetime | Item Last Moditfied Time | ||
| ItemSku | String | = , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL | Item Sku | |
| ItemName | String | = , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL | Item Name |
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 | |
| TransactionDate | String | Filter transaction by any transaction date.
The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate. | |
| ToDate | Date | To Date | |
| FromDate | Date | From Date | |
| WarehouseId | String | To Date |