Power BI Connector for Zoho Inventory

Build 24.0.9062

InvoiceListPayments

List Payments of Invoices.

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

  • InvoiceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM InvoiceListPayments WHERE InvoiceId = '3350895000000089001'

Columns

Name Type References Description
Amount Double Amount
Date Date Date
Description String Description
ExchangeRate Integer ExchangeRate
InvoiceId Long

Invoices.Id

Invoice Id
InvoicePaymentId [KEY] Long Invoice Payment Id
IsSingleInvoicePayment Boolean IsSingleInvoice Payment
OnlineTransactionId String OnlineTransaction Id
PaymentId String Payment Id
PaymentMode String Payment Mode
PaymentNumber Integer Payment Number
ReferenceNumber Integer Reference Number
TaxAmountWithheld Integer Tax Amount Withheld

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