CompositeItemsMappedItems
Read the mapped items of the Composite items.
Table Specific Information
Select
The add-in 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 add-in.
- MappedItemId supports the '=' comparison.
- CompositeItemId supports the '=' comparison.
- ItemId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM CompositeItemsMappedItems WHERE MappedItemId = '3350895000000089001' SELECT * FROM CompositeItemsMappedItems WHERE CompositeItemId = '205' SELECT * FROM CompositeItemsMappedItems WHERE ItemId = '20130805'
Columns
| Name | Type | References | Description |
| MappedItemId [KEY] | Long | Unique ID generated by the server for mapping the associated item with composite item | |
| CompositeItemId | Long | Unique ID generated by the server for the Item.This is used as an identifier. | |
| ActualAvailableStock | Integer | Stock based on Shipments and Receives minus ordered stock | |
| AvailableStock | Integer | Stock based on Shipments and Receives | |
| Description | String | Sample Description. | |
| ImageId | Long | Unique identifier generated by the server for item image | |
| ImageName | String | Name of the image | |
| ImageType | String | Type of the image | |
| IsComboProduct | Boolean | Defines whether the item is composite or not | |
| ItemId | Long |
Items.Id | Unique ID generated by the server for the Item.This is used as an identifier. |
| Name | String | Name of the composite item | |
| PurchaseDescription | String | Purchase description of the item | |
| PurchaseRate | Integer | Buying price of the item | |
| Quantity | Integer | Quantity of item associated with the composite item | |
| Rate | Integer | Selling price of the item | |
| Sku | String | Stock Keeping Unit value of the item. | |
| StockOnHand | Integer | Stock based on Invoices and Bills | |
| Unit | String | Unit of Item |