Retrieves bills related to vendor payments.

Table Specific Information

Select

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

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

For example:

    SELECT * FROM VendorPaymentBills WHERE PaymentId = '3255827000000099005'

    SELECT * FROM VendorPaymentBills WHERE PaymentId IN ('3255827000000101458', '3255827000000099005')

Columns

Name	Type	References	SupportedOperators	Description
BillPaymentId [KEY]	Long			The Bill Payment Id.
PaymentId	String	VendorPayments.PaymentId		The Vendor Payment Id.
AmountApplied	Integer			The Amount Applied to the bill.
BillId	String	Bills.BillId		The Bill Id.
TaxAmountWithheld	Integer			The tax amount which has been withheld.