PurchaseOrderBills
List Bills of purchase orders.
Table Specific Information
Select
The connector 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 connector.
- 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. |