ItemDetails

List, add, update and delete details of an existing item.

Table Specific Information

Select

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

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.

Power BI Connector for Zoho Books