ItemDetails
To list, add, update and delete details of an existing item.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- ItemId supports the '=' and IN operators.
NOTE: ItemId is required to query ItemDetails.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM ItemDetails WHERE ItemId = '1894553000000079049' SELECT * FROM ItemDetails WHERE ItemId IN (SELECT ItemId FROM Items) SELECT * FROM ItemDetails WHERE ItemId IN ('1894553000000079049','1894553000000079050')
Insert
INSERT can be executed by specifying the Name and Rate columns. The columns that are not read-only can be inserted optionally. The following is an example of how to insert into this table.
INSERT INTO ItemDetails (Name, Rate) VALUES ('Bottle', '500')
Update
UPDATE can be executed by specifying the ItemId in the WHERE Clause. The columns that are not read-only can be updated.
For example:
UPDATE ItemDetails SET Name = 'Bottle', Rate = '550' WHERE ItemId = '3285934000000269037'
Delete
DELETE can be executed by specifying the ItemId in the WHERE Clause
For example:
DELETE FROM ItemDetails WHERE ItemId = '3285934000000269037'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Description |
ItemId [KEY] | String | True |
Items.ItemId |
Id of an item. | |
ItemType | String | False |
Type of an item. | ||
AccountId | String | False |
BankAccounts.AccountId |
Id of the Bank Account. | |
AccountName | String | True |
Name of the account. | ||
AvataxUseCode | String | False |
Used to group like customers for exemption purposes. It is a custom value that links customers to a tax rule. | ||
AvataxTaxCode | String | False |
A tax code is a unique label used to group items together. | ||
Brand | String | False |
Brand of the item. | ||
CreatedAt | Date | True |
Date at which the item was created. | ||
CreatedTime | Datetime | True |
Time at which the item was created. | ||
DefaultPriceBrackets | String | True |
DefaultPriceBrackets. | ||
Description | String | False |
Description of an item. | ||
Documents | String | True |
Documents of an item. | ||
HSNORSAC | String | False |
Add HSN/SAC code for your goods/services. | ||
ImageName | String | True |
Name of the image. | ||
InventoryAccountId | String | False |
Id of the stock account to which the item has to be associated with. Mandatory, if item_type is inventory. | ||
IsDefaultTaxApplied | Boolean | True |
IsDefaultTaxApplied. | ||
LastModifiedTime | Datetime | True |
The time of last modification of the item. | ||
Manufacturer | String | True |
Company that makes goods for sale. | ||
MaximumOrderQuantity | Integer | True |
Maximum order quantity. | ||
MinimumOrderQuantity | Integer | True |
Minimum order quantity. | ||
Name | String | False |
Name of an item. | ||
PreferredVendors | String | True |
PreferredVendors. | ||
PricebookRate | Decimal | True |
Rate of pricebook. | ||
PricingScheme | String | True |
Scheme of price. | ||
ProductType | String | False |
Type of the product. | ||
PurchaseAccountId | String | False |
BankAccounts.AccountId |
Account Id of purchase items. | |
PurchaseAccountName | String | True |
Account name of purchase items. | ||
PurchaseDescription | String | False |
Description of purchase items. | ||
PurchaseRate | Decimal | False |
Rate of purchase items. | ||
Rate | Decimal | False |
Rate of the item. | ||
SalesChannels | String | True |
Total channels exists for sales. | ||
SalesRate | Decimal | True |
The rate of sale in the item. | ||
Sku | String | False |
Stock Keeping Unit value of item, should be unique throughout the product. | ||
Source | String | True |
Source of the item. | ||
Status | String | True |
Status of the item. | ||
Tags | String | True |
Details of tags related to items. | ||
TaxId | String | False |
Taxes.TaxId |
Id of tax. | |
TaxName | String | True |
Name of the tax. | ||
TaxPercentage | Integer | False |
Percentage applied for tax. | ||
TaxType | String | True |
Type of tax. | ||
VendorId | String | False |
Id of the vendor the expenses has been made. | ||
VendorName | String | False |
Name of the vendor the expenses has been made. | ||
Unit | String | True |
Number of quantity of item. | ||
ReorderLevel | String | False |
Reorder level of the item. | ||
InitialStock | String | False |
Opening stock of the item. | ||
InitialStockRate | String | False |
Unit price of the opening stock. | ||
ItemTaxPreferences | String | False |
Item Tax Preferences. |
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 |
IsTaxable | String |
Boolean to track the taxability of the item. |