Items
Retrieves list of all active items.
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 本製品.
- TaxId supports the '=' comparison.
- TaxName supports the '=' comparison.
- Description supports the '=' comparison.
- Name supports the '=' comparison.
- Rate supports the '=,<,<=,>,>=' comparisons.
- AccountId supports the '=' comparison.
- Status supports the '=' comparison.
SELECT * FROM Items WHERE Rate < 200 AND Rate > 24.9 SELECT * FROM Items WHERE Description = '16' AND Name = 'Monitor'
Columns
Name | Type | References | SupportedOperators | Description |
ItemId [KEY] | String | ID of an item. | ||
ItemName | String | Name of an item. | ||
ItemType | String | Type of item. | ||
TaxId | String |
Taxes.TaxId | Id of a tax. | |
TaxName | String | Name of tax. | ||
TaxPercentage | Integer | Tax percentage of item. | ||
AccountName | String | Name of the account | ||
Description | String | Description of an item. | ||
HasAttachment | Boolean | Check if the items has attachment. | ||
ImageDocumentId | String | ID of an image document. | ||
Name | String | Name of an item. | ||
Rate | Decimal | =,<,<=,>,>= | Price of the item. Search items by rate. | |
ReorderLevel | String | Reorder level of the item. | ||
Status | String | Status of the item.
使用できる値は次のとおりです。All, Active, Inactive |
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 | |
AccountId | String | ID of the Bank Account to which the item has to be associated with. |