Get the list of payments made for a bill.
Table Specific Information
The connector will use 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 within the connector.
- BillId supports the '=' comparison.
SELECT * FROM BillPayments WHERE BillId = '1894253000000085259'
|BillPaymentId [KEY]||String||ID of bill payment.|
|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.|