Retrieves bills related to purchase orders.

Table Specific Information

Select

The connector 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 connector.

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.