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