Cmdlets for Zoho Books

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062