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.
AssociatedTemplateId	String	True			ID of the associated template used for this item, if any.
CanBePurchased	Boolean	True			Indicates if the item can be purchased. Writable on both insert and update.
CanBeSold	Boolean	True			Indicates if the item can be sold. Writable on both insert and update.
CrmOwnerId	String	True			ID of the CRM owner associated with the item, if linked to Zoho CRM.
ImageType	String	True			MIME type or format of the item's image (e.g., 'image/png').
IntegrationReferences	String	True			Integration reference details associated with the item, in JSON format.
IsFulfillable	Boolean	True			Indicates if the item is fulfillable (e.g., stock-managed).
IsLinkedWithZohoCrm	Boolean	True			True if the item is linked with Zoho CRM.
IsTaxExpired	Boolean	True			Indicates if the tax applied to the item has expired.
OfflineCreatedDateWithTime	Datetime	True			Offline created date and time for the item, if applicable.
PriceBrackets	String	True			List of price brackets for the item, in JSON format.
PurchaseTaxInformation	String	True			Tax information applicable on purchase of this item.
TaxCountryCode	String	True			Country code related to the tax of the item.
TaxEndDate	Date	True			Date when the tax validity ends for the item.
TaxGroupsDetails	String	True			Details of tax groups applicable to the item.
TaxInformation	String	True			General tax information relevant to the item.
TaxStartDate	Date	True			Date when the tax validity starts for the item.
TaxStatus	String	True			Current tax status of the item.
TrackInventory	Boolean	True			Whether the item is tracked in inventory.
UnitId	String	True			ID of the unit of measurement associated with the item.
ZcrmProductId	String	True			Zoho CRM Product ID linked with this item, if any.
PurchaseTaxRuleId	String	False			ID of the purchase tax rule applied to the item.
SalesTaxRuleId	String	False			ID of the sales tax rule applied to the item.
SatItemKeyCode	String	False			SAT item key code associated with the item (for regional tax compliance).
UnitKeyCode	String	False			Unit key code used for categorizing the item’s unit of measure.
TaxExemptionId	String	False			ID representing any tax exemption applicable to the item.
PurchaseTaxExemptionId	String	False			ID representing any purchase tax exemption applicable to the item.

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.

SSIS Components for Zoho Books