Power BI Connector for Zoho Inventory

Build 24.0.9062

BillLineItems

Get Line items of Bills.

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

  • BillId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM BillLineItems WHERE BillId = '3350895000000089001'

Columns

Name Type References Description
BillId Long

Bills.Id

Unique ID generated by the server.
AccountId Long Account Id.
AccountName String Account Name.
BCYRate Double BCY Rate.
CustomerId Long Customer Id.
CustomerName String Customer Name.
Description String Desciption of line item.
Discount Double Discount.
ImageName String Image Name.
ImageType String Image Type.
InvoiceId Long Invoice Id.
InvoiceNumber String Invoice Number.
IsBillable Boolean Checks whether the line item is billable or not.
IsComboProduct Boolean Check whether the line item is a combo product.
IsDropShippedItem Boolean Checks whether the item shipment has been dropped.
ItemCustomFields String Custom Fields.
ItemId Long

Items.Id

Item Id of line item.
ItemOrder Integer Order of the line item, starting from 0
ItemTotal Double Item total.
ItemType String Item type.
LineItemId [KEY] Long Unique ID generated by the server for each line item..
Name String Name of line item.
Quantity Integer Quantity of line item.
Unit String Unit of line item.
PriceBookId Long PriceBook Id.
ProjectId Long Project Id.
ProjectName String Project Name.
PurchaseOrderItemId Long Purchase Order Item Id.
Rate Integer Rate.
ReceiveItemId Long Receive Item Id.
SKU String SKU.
TaxId Long Tax Id.
WarehouseId Long Warehouse Id.
WarehouseName String Warehouse Name.

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