Excel Add-In for Zoho Books

Build 24.0.9062

BillPayments

Get the list of payments made for a bill.

Table Specific Information

Select

The 本製品 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 本製品.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062