Cmdlets for Zoho Books

Build 22.0.8479

SalesByItemReport

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

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • CustomerName supports the 'Group By' comparison.
  • SalesPerson supports the 'Group By' comparison.
  • CustomerID supports the 'IN, NOT IN' comparison.
  • WaresouseID supports the 'IN, NOT IN' comparison.
  • AccountID supports the 'IN, NOT IN' comparison.
  • ItemName supports the 'IN, NOT IN, LIKE , CONTAINS , NOT LIKE' comparison.
  • ItemSku supports the '= , != , LIKE , CONTAINS , NOT LIKE , IS NULL , IS NOT NULL' comparison.
  • Unit supports the '= , != , LIKE , CONTAINS , NOT LIKE , IS NULL , IS NOT NULL' comparison.
For example:
    SELECT * FROM SalesByItemReport

    SELECT * FROM SalesByItemReport WHERE TransactionDate = 'Today'

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

    SELECT * FROM SalesByItemReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'
	
	SELECT * FROM SalesByItemReport group by customername
	
	SELECT * FROM SalesByItemReport group by salesperson
	
	SELECT * FROM SalesByItemReport where customerid in ('3285934000000152001')
	
	SELECT * FROM SalesByItemReport where warehouseid in ('3285934000000113095')
	
	SELECT * FROM SalesByItemReport where accountid in ()
	
    SELECT * FROM SalesByItemReport WHERE CONTAINS(ItemName,'BAGS')
	
	SELECT * FROM SalesByItemReport WHERE Unit LIKE 'cm%'

Columns

Name Type References SupportedOperators Description
Amount Integer Amount
AmountWithTax Integer Amount With Tax
AmountWithoutDiscount Integer Amount Without Discount
AveragePrice Integer Average Price
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
ItemId String Item Id
PreviousValues String Previous Values
QuantitySold Integer Quantity Sold
ReportingTag String Reporting Tag
GroupAmount String Group Amount
GroupTotalQuantitySold String Group Total Quantity Sold
Unit String = , != , LIKE , CONTAINS , NOT LIKE , IS NULL , IS NOT NULL Unit
ItemSku String = , != , LIKE , CONTAINS , NOT LIKE , IS NULL , IS NOT NULL Item Sku
ItemName String IN, NOT IN, LIKE , CONTAINS , NOT LIKE 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
CustomerId String Customer Id
AccountId String Account Id
WarehouseId String Warehouse Id
CustomerName String Customer Name
SalesPerson String Sales Person

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479