CData Python Connector for Zoho Books

Build 22.0.8479

ProductSalesReport

Generated schema file.

Table Specific Information

Select

The 本製品 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 本製品.

  • SoldDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • ProductCode 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.
For example:
    SELECT * FROM ProductSalesReport

    SELECT * FROM ProductSalesReport WHERE SoldDate = 'Today'

    SELECT * FROM ProductSalesReport WHERE ToDate = '2022-10-31'

    SELECT * FROM ProductSalesReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

    SELECT * FROM ProductSalesReport WHERE ProductCode LIKE 'bags%'
	
	SELECT * FROM ProductSalesReport WHERE ItemSku IS NOT NULL

Columns

Name Type References SupportedOperators Description
IsComboProduct Boolean Is Combo Product
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
ItemRate Integer Item Rate
ItemStatus String Item Status
ItemUnit String Item Unit
Margin Double Margin
ProductId String Product Id
Profit Integer Profit
QuantitySold Integer Quantity Sold
SalesPrice Integer Sales Price
SalesPricewithTax Integer Sales Price with Tax
Sku String Sku
Unit String Unit
ProductCode String = , != , LIKE , NOT LIKE, CONTAINS, IS NULL, IS NOT NULL Product Code
ItemSku String = , != , LIKE , NOT LIKE, CONTAINS, IS NULL, IS NOT NULL Item Sku

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