Tableau Connector for Zoho Books

Build 22.0.8479

StockSummaryReport

Generated schema file.

Table Specific Information

Select

The connector 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 connector.

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • ItemName supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparison.
  • ItemSku supports the '= , != , LIKE, NOT LIKE, CONTAINS, IS NULL, IS NOT NULL' comparison.
  • WarehouseId supports the 'IN, NOT IN' comparison.
For example:
    SELECT * FROM StockSummaryReport

    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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479