CompositeItems

Read, Insert, Update and Delete the CompositeItems.

Table Specific Information

Select

The connector will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the connector.

Id supports the '=' comparison.
CreatedTime supports the '=' comparison.
LastModifiedTime supports the '=' comparison.
Name supports the '=' comparison.
PurchaseRate supports the '=' comparison.
Rate supports the '=' comparison.
ReorderLevel supports the '=' comparison.
Sku supports the '=' comparison.
Source supports the '=' comparison.
TaxName supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CompositeItems WHERE Id = '3350895000000089001'

SELECT * FROM CompositeItems WHERE CreatedTime = '2013-08-05'

SELECT * FROM CompositeItems WHERE LastModifiedTime = '2013-08-05'

SELECT * FROM CompositeItems WHERE Name = 'new'

SELECT * FROM CompositeItems WHERE PurchaseRate = '66'

SELECT * FROM CompositeItems WHERE Rate = '76'

SELECT * FROM CompositeItems WHERE ReorderLevel = '1'

SELECT * FROM CompositeItems WHERE Sku = '23'

SELECT * FROM CompositeItems WHERE Source = 'abc'

SELECT * FROM CompositeItems WHERE TaxName = 'tax'

Insert

Insert can be executed by specifying the Name, MappedItems, Sku, Rate and ItemType 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 CompositeItems (Name, ItemType, Rate, MappedItems) VALUES ('PQRstub', 'inventory', '1999', '[ {\"item_id\": 3285934000000104097, \"quantity\": 3}]')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE CompositeItems SET Name = 'test2' WHERE Id = '3285934000000136008'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM CompositeItems WHERE Id = '3350895000000089001'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Unique ID generated for the composite item by the server.
ActualAvailableStock	Integer	True		Stock based on Shipments and Receives minus ordered stock.
AvailableStock	Integer	True		Stock based on Shipments and Receives.
AssetValue	Double	True		value of the composite items based on purchase rate
CreatedTime	Datetime	True		Automatically generated time when item was created.
description	String	False		Sample description.
Ean	Long	False		European Article Number, 13 digit barcode number of the item
HsnorSac	String	False		HSN Code of the item
ImageId	Long	True		Unique identifier generated by the server for item image.
ImageName	String	True		Name of the image.
AccountId	Long	False		Unique ID generated by the server for the type of sale of this item
InventoryAccountId	Long	False		Unique ID generated by the server for the type of inventory for this item
InventoryAccountName	String	True		Name of inventory type
IsComboProduct	Boolean	False		Defines whether the item is composite or not.
IsTaxable	Boolean	True		is taxable.
InitialStock	Integer	False		Initial stock of item
InitialStockRate	Integer	False		Average purchase price of initial stock.
Isbn	Integer	False		International Standard Book Number, 13 digit unique commercial book identifier barcode of the item.
ItemType	String	False		Type of item Always inventory
LastModifiedTime	Datetime	True		last modified time.
MappedItems	String	False		Items that are associated with the composite item.
ItemTaxPreferences	String	False		Item Tax Preferences that are associated with the composite item.
CustomFields	String	False		Custom fields are used to add more information about the item
Name	String	False		Name of the composite item.
PartNumber	String	False		MPN - Manufacturing Part Number, unambiguously identifies a part design.
ProductType	String	True		product type.
Purchasedescription	String	False		Purchase desc of the item.
PurchaseRate	Integer	False		Buying price of the item.
PurchaseAccountId	Long	False		Unique ID generated by the server for the type of purchase.
PurchaseAccountName	String	True		Type of purchase under which the composite item was bought
PricebookRate	Integer	False		Price list applied on the item selling price.
Rate	Integer	False		Selling price of the item.
ReorderLevel	Integer	False		Reorder point of the item.
Sku	String	False		Stock Keeping Unit value of the item. It should be unique throughout the product.
Source	String	True		source.
Status	String	True		Status of the Item.
StockOnHand	Integer	True		Stock based on Invoices and Bills.
TaxId	Long	False	Taxes.Id	Unique ID generated by the server for the tax ..
TaxName	String	True		Name of the tax applied on selling this item.
TaxPercentage	Integer	True		Percentage at which the item is taxed.
Upc	Long	False		Unique Product Code, 12 digit unique code of the item.
Unit	String	False		Unit of the Item.
VendorId	Long	False	Taxes.Id	ID of the vendor the vendor credit is associated with.
OrganizationId	String	False	Organizations.Id	ID of the Organization
VendorName	String	False		Name of the Vendor Associated with the Vendor Credit
CompositeItemsFilter	String	True		Filter items by status The allowed values are Status.All, Status.Active, Status.Inactive, Status.Lowstock.