PurchaseOrderBills
List Bills of purchase orders.
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.
- 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 | 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. |