Cmdlets for Zoho Books

Build 24.0.8963

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963