CompositeItemsBundles
List, Insert, Update, delete CompositeItems Bundles
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.
- 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. | |
| BranchId | Long | True |
ID of the branch. | |
| BranchName | String | True |
Name of the branch. | |
| BundleComponentItems | String | True |
Component items of the bundle. | |
| CustomFieldHash | String | True |
Hash of custom fields. | |
| CustomFields | String | True |
Custom fields. | |
| IsViewAllowed | Boolean | True |
Whether viewing is allowed. | |
| LocationId | Long | True |
ID of the location. | |
| LocationName | String | True |
Name of the location. | |
| ProjectId | Long | True |
ID of the project. | |
| Locations | String | True |
Locations. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| SearchText | String |
Search assemblies by keyword. |