BillPurchaseOrders
Get bills related to purchase order.
Table Specific Information
Select
The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- BillId supports the '=,IN' comparison.
The rest of the filter is executed client-side in the 本製品.
For example:
SELECT * FROM BillPurchaseOrders where billid = '3255827000000101212'
SELECT * FROM BillPurchaseOrders where billid IN ('3255827000000101212','3255827000000102354')
Columns
| Name | Type | References | SupportedOperators | Description |
| PurchaseOrderId | String |
PurchaseOrders.PurchaseorderId | Purchase Order Id | |
| BillId | String |
Bills.BillId | = | Bill Id |
| PurchaseOrderDate | Date | Purchase Order Date | ||
| PurchaseOrderNumber | String | Purchase Order Number | ||
| PurchaseOrderStatus | String | Purchase Order Status | ||
| OrderStatus | String | Order Status | ||
| ExpectedDeliveryDate | Date | Expected Delivery Date |