Cmdlets for Zoho Books

Build 24.0.8963

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.8963