BillPayments
Get the list of payments made for a bill.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following column and operator:
- BillId supports the '=' comparison.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM BillPayments WHERE BillId = '1894253000000085259'
Columns
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. |