Power BI Connector for Zoho Inventory

Build 24.0.9062

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

Organizations.Id

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

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