SSIS Components for Zoho Books

Build 22.0.8509

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 '=' comparison.

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'

Insert

Insert can be executed by specifying the Name,Rate column. The columns that are not read-only can be inserted optionally. 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 True

Brand of the item.

CreatedTime Datetime True

Time at which the item was created.

Description String False

Description of an item.

HSNORSAC String False

Add HSN/SAC code for your goods/services.

ImageName String True

Name of the image.

IsTaxable Boolean False

Boolean to track the taxability of the item.

InventoryAccountId String False

ID of the stock account to which the item has to be associated with. Mandatory, if item_type is inventory.

LastModifiedTime Datetime True

The time of last modification of the item.

Manufacturer String True

Company that makes goods for sale.

Name String False

Name of an item.

PricebookRate Decimal True

Rate of pricebook.

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.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509