CompositeItems
Read, Insert, Update and Delete the CompositeItems.
Table Specific Information
Select
The 本製品 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 本製品.
- 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 |
ID of the Organization | |
VendorName | String | False |
Name of the Vendor Associated with the Vendor Credit | |
CompositeItemsFilter | String | True |
Filter items by status 使用できる値は次のとおりです。Status.All, Status.Active, Status.Inactive, Status.Lowstock |