Power BI Connector for Zoho Inventory

Build 24.0.9062

RetainerInvoiceListPayments

Get payments of Retainer Invoice.

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

  • RetainerInvoiceId supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM RetainerInvoiceListPayments WHERE RetainerInvoiceId = '3350895000000089001'

Columns

Name Type References Description
Amount Integer Amount
AttachmentName String Attachment Name
BankCharges Integer Bank Charges
CanSendInMail Boolean Can Send In Mail
CurrencyCode String Currency Code
CurrencyId Long Currency Id
CustomFields String Custom Fields
CustomerId Long Customer Id
CustomerName String Customer Name
Date Date Date
Description String Description
DiscountAmount Integer DiscountAmount
Documents String Documents
ExchangeRate Integer ExchangeRate
HtmlString String Html String
Invoices String Invoices
IsClientReviewSettingsEnabled Boolean Is Client Review Settings Enabled
IsPaymentDrawnDetailsRequired Boolean Is Payment Drawn Details Required
LastFourDigits String Last Four Digits
OnlineTransactionId String Online Transaction Id
Orientation String Orientation
PageHeight String Page Height
PageWidth String Page Width
PaymentId [KEY] String Payment Id
PaymentMode String Payment Mode
PaymentRefunds String Payment Refunds
ReferenceNumber String Reference Number
RetainerInvoiceRetainerInvoiceBalance Integer Retainer Invoice Balance
RetainerInvoiceRetainerInvoiceDate Date Retainer Invoice Date
RetainerInvoiceRetainerInvoiceId Long Retainer Invoice Id
RetainerInvoiceRetainerInvoiceNumber String Retainer Invoice Number
RetainerInvoiceRetainerInvoiceTotal Integer Retainer Invoice Total
RetainerInvoiceId Long

RetainerInvoices.Id

Retainer Invoice Id
TaxAmountWithheld Integer Tax Amount Withheld
TemplateId Long Template Id
TemplateName String Template Name
TemplateType String Template Type
UnusedAmount Integer Unused Amount

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