StockSummaryReport
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.
- 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 本製品.
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.
使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate | |
ToDate | Date | To Date. | |
FromDate | Date | From Date. | |
WarehouseId | String | To Date. |