Cmdlets for Zoho Books

Build 24.0.9062

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.

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