Power BI Connector for Zoho Inventory

Build 24.0.9062

CompositeItemsMappedItems

Read the mapped items of the Composite items.

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 本製品.

  • 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

CompositeItems.Id

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062