Power BI Connector for Zoho Inventory

Build 24.0.9062

BillPayments

Get payments of the bills.

Table Specific Information

Select

The 本製品 will use the Zoho Inventory 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.
  • BillPaymentId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM BillPayments WHERE BillId = '3350895000000089001'

SELECT * FROM BillPayments WHERE BillPaymentId = '3350895000000089001'

Columns

Name Type References Description
Amount Integer Amount paid for the payment.
BillId Long

Bills.Id

Unique ID generated by the server.
BillPaymentId [KEY] Long Bill payment ID.
Date Date Date of the Bill.
Description String Description for the line item.
ExchangeRate Integer Exchange rate of the currency, with respect to the base currency.
IsPaidViaPrintCheck Boolean Checks whether payment is done via check.
IsAchPayment Boolean Is Ach Payment.
IsSingleBillPayment Boolean Checks whether the payment is for single bills or multiple bills.
PaidThroughAccountId Long ID for the account through which the payment is made.
PaidThroughAccountName String Name of the account.
PaymentId Long Unique ID generated by the server.
PaymentMode String Mode of payment for the Bill.
PaymentNumber Integer Number of the payment.
ReferenceNumber String Reference number for the Bill.
Status String Status for the Bill.

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