ProductSalesReport
Generated schema file.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators: The rest of the filter is executed client-side in the connector.
- SoldDate supports the '=' comparison.
- ToDate supports the '=' comparison.
- FromDate supports the '=' comparison.
- ProductCode 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.
For example:
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. |