Power BI Connector for Zoho Books

Build 20.0.7654

RetainerInvoicePayments

Get the list of payments made for a retainer invoices.

Table Specific Information

Select

The {i will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the {i.

  • RetainerInvoiceId supports the '=' comparison.
For example:
    SELECT * FROM RetainerInvoicePayments WHERE RetainerInvoiceId = '1894663000000085023'

Columns

Name Type References SupportedOperators Description
PaymentId [KEY] String Id of a payment.
RetainerInvoiceId String

RetainerInvoices.RetainerInvoiceId

ID of a retainer invoice.
PaymentMode String Mode through which payment is made.
ReferenceNumber Currency Reference number of retainer invoice payment.
Amount Integer Amount of the retainer invoice payments.
AttachmentName String Name of the attachment.
BankCharges Integer Charges of the bank.
CanSendInMail Boolean Check if the retainer invoice can be send through mail.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CustomerId String

Contacts.ContactId

ID of the customer or vendor.
CustomerName String Name of the customer or vendor.
Date Date Retainer Invoice date.
Description String Description of the retainer invoice payment.
DiscountAmount Decimal Amount given for discount.
ExchangeRate Decimal Exchange rate given for this retainer invoice.
HtmlString String HTML context of a retainer invoice.
IsClientReviewSettingsEnabled Boolean Check if the client review settings is enabled or not.
IsPaymentDrawnDetailsRequired Boolean Check if the payment drawn details is required.
LastFourDigits String It store the last four digits of customer's card details.
OnlineTransactionId String ID of online transaction.
Orientation String Orientation of the page.
PageHeight String Height of the page.
PageWidth String Width of the page.
RetainerinvceBalance Integer Total amount for retainer invoice.
RetainerInvceDate Date Date for retainer invoice.
RetainerInvceId String

RetainerInvoices.RetainerInvoiceId

ID for a retainer invoice.
RetainerInvceNumber String Number of a retainer invoice.
RetainerInvceTotal Integer Total of retainer invoice.
TaxAmountWithheld Integer Amount withheld for tax.
TemplateId String ID of a template.
TemplateName String Name of a template.
TemplateType String Type of a template.
UnusedAmount Integer Total amount which is unused.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654