Power BI Connector for Zoho Inventory

Build 24.0.9062

CustomerPaymentsInvoices

Get Invoices of Customer Payments.

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.
  • CustomerPaymentId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM CustomerPaymentsInvoices WHERE InvoiceId = '3350895000000089001'

SELECT * FROM CustomerPaymentsInvoices WHERE CustomerPaymentId = '4534543100'

Columns

Name Type References Description
CustomerPaymentId String Unique ID of the payment generated by the server.
AmountApplied Integer Amount paid for the invoice.
BalanceAmount Integer Unpaid amount of the invoice.
Date Date Date on which the invoice was raised.
InvoiceAmount Integer Total amount raised for the invoice.
InvoiceId String Invoice ID of the required invoice.
InvoiceNumber String Unique ID (starts with INV) of an invoice.

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