BillPayments

Get the list of payments made for a bill.

Table Specific Information

The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:

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

For example:

    SELECT * FROM BillPayments WHERE BillId = '1894253000000085259'


Name	Type	References	SupportedOperators	Description
BillPaymentId [KEY]	String			Id of bill payment.
BillId	String	Bills.BillId		Id of a Bill.
VendorId	String			Id of the vendor the bill payments has been made.
VendorName	String			Name of the vendor the bill payments has been made.
PaymentId	String			Id of a payment.
Amount	Decimal			Amount of the bill payments.
Date	Date			Date of a bill payment.
Description	String			Description of the bill payment.
ExchangeRate	Decimal			Exchange rate of bill payments.
IsSingleBillPayment	Boolean			Check if it is single bill payment.
PaidThrough	String			Amount paid via check/cash/credit.
PaymentMode	String			Mode through which payment is made.
ReferenceNumber	String			Reference number of bill payment.
TotalPaymentAmount	Decimal			Total amount of bill payment.