Retrieves bills related to purchase order.

Table Specific Information

Select

The provider uses the Zoho Books API to process WHERE clause conditions built with the BillId column, which supports '=,IN' comparisons.

The rest of the filter is executed client-side in the provider.

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		The Purchase Order Id
BillId	String	Bills.BillId	=	The Bill Id
PurchaseOrderDate	Date			The Purchase Order Date
PurchaseOrderNumber	String			The Purchase Order Number
PurchaseOrderStatus	String			The Purchase Order Status
OrderStatus	String			The Order Status
ExpectedDeliveryDate	Date			The Expected Delivery Date