InventoryValuationReport
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.
- ItemId supports the 'IN' comparison.
- Status supports the '=' comparison.
- StockAvailability supports the '=' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
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 |