Power BI Connector for Zoho Inventory

Build 24.0.9062

PurchaseOrderBills

List Bills of purchase orders.

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

  • BillNumber supports the '=' comparison.
  • PurchaseOrderId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM PurchaseOrderBills WHERE PurchaseOrderId = '3350895000000089001'

Columns

Name Type References Description
PurchaseOrderId Long

PurchaseOrders.Id

Unique ID generated by the server for the Purchase Order.
Balance Integer Balance of the bill.
BillId [KEY] Long Id of the bill.
BillNumber [KEY] String Bill number of the bill.
Date Date Date of the bill.
DueDate Date Due date of the bill.
Status String Status of the bill.
Total Integer Total amount in the bill.

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