BillPayments
Get the list of payments made for a bill.
Table Specific Information
Select
The 本製品 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 本製品.
- BillId supports the '=' comparison.
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. |