StockSummaryReport
Generated schema file.
Table Specific Information
Select
The 本製品 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 本製品.
- TransactionDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- ItemName supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparison.
- ItemSku supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparison.
- WarehouseId supports the 'IN, NOT IN' comparison.
SELECT * FROM StockSummaryReport 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 |