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