Retrieves bills related to vendor payments.

Table Specific Information

Select

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

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