CompositeItemsBundles
Read,Insert, Update and Delete CompositeItemsBundles.
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.
- CompositeItemId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM CompositeItemsBundles WHERE Id = '3350895000000089001' SELECT * FROM CompositeItemsBundles WHERE CompositeItemId = '23350895000000089001'
Insert
Insert can be executed by specifying the ReferenceNumber, Date, Description, CompositeItemId, CompositeItemName, IsCompleted, QuantityToBundle and LineItems 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 CompositeItemsBundles (ReferenceNumber, Date, Description, CompositeItemId, CompositeItemName, IsCompleted, QuantityToBundle, LineItems) VALUES (124, '22-02-22', 'desc', 123, 'name', 'true', 12, '[ {\"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 CompositeItemsBundles SET Name = 'test2' WHERE Id = '3285934000000136008'
Delete
Delete can be executed by specifying the Id in the WHERE Clause
For example:
DELETE FROM CompositeItemsBundles WHERE Id = '3350895000000089001'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
Id of Bundle | |
IsCompleted | Boolean | False |
Denotes the status of the bundle. Currently, this has to be true since we didnt support any other status as of now. | |
CompositeItemId | Long | False |
Unique ID generated for the composite item by the server. | |
CompositeItemName | String | False |
Name of the composite item | |
CompositeItemSku | String | False |
Stock Keeping Unit value of the composite item. | |
Date | Date | False |
The date on which bundling is done | |
Description | String | False |
Sample Description. | |
LineItems | String | False |
A bundle can contain multiple line items. | |
QuantityToBundle | Integer | False |
Quantity of bundles to be bundled. | |
ReferenceNumber | String | False |
Reference number for the Bundle. |