InventoryValuationReport
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.
- ItemId supports the 'IN' comparison.
- Status supports the '=' comparison.
- StockAvailability supports the '=' comparison.
SELECT * FROM InventoryValuationReport SELECT * FROM InventoryValuationReport WHERE TransactionDate = 'Today' SELECT * FROM InventoryValuationReport WHERE ToDate = '2022-10-31' SELECT * FROM InventoryValuationReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31' SELECT * FROM InventoryValuationReport WHERE StockAvailability = 'AvailableStock' SELECT * FROM InventoryValuationReport WHERE ItemId IN ('5672409674565') SELECT * FROM InventoryValuationReport WHERE Status = 'Active'
Columns
Name | Type | References | SupportedOperators | Description |
AssetValue | Integer | Asset Value | ||
CategoryId | String | Category Id | ||
CategoryName | String | Category Name | ||
ItemCreatedBy | String | Item Created By | ||
ItemCreatedTime | Datetime | Item Created Time | ||
ItemDescription | String | Item Description | ||
ItemItemType | String | Item Item Type | ||
ItemLastModifiedTime | Datetime | Item Last Modified Time | ||
ItemProductType | String | Item Product Type | ||
ItemPurchaseDescription | String | Item Purchase Description | ||
ItemPurchaseRate | Integer | Item Purchase Rate | ||
ItemSalesPrice | Integer | Item Sales Price | ||
ItemSalesDescription | String | Item Sales Description | ||
ItemRate | Integer | Item Rate | ||
ItemSku | String | Item Sku | ||
ItemStatus | String | Item Status | ||
ItemUnit | String | Item Unit | ||
QuantityAvailable | Integer | Quantity Available | ||
ReorderLevel | String | Reorder Level | ||
ItemName | String | ItemName | ||
Sku | String | Sku | ||
ItemId | String | IN | ItemId | |
Status | String | = | Status
使用できる値は次のとおりです。All, Active, Inactive デフォルト値はAllです。 |
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 | |
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 |