MuleSoft Connector for Zoho Books

Build 20.0.7654

CustomerPaymentDetails

Retrieves details of an existing payment.

Table Specific Information

Select

The connector 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 connector.
Note: PaymentId is required in order to query CustomerPaymentDetails.

  • PaymentId supports the '=' comparison.
For example:
    SELECT * FROM CustomerPaymentDetails WHERE PaymentId = '1894553000000083001'

Columns

Name Type References SupportedOperators Description
PaymentId [KEY] String

CustomerPayments.PaymentId

ID of a payment.
AccountId String

BankAccounts.AccountId

ID of the Bank Account.
AccountName String Name of the account.
AccountType String Type of the account.
Amount Decimal Amount of the customer payments.
AttachmentName String Name of the attachment.
BankCharges Decimal Charges of bank.
CanSendInMail Boolean Check if the customer payment can be send in mail.
CanSendPaymentSms Boolean Check if the customer payment can send payment SMS.
CardType String Type of card.
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 Date of a customer payment.
Description String Description of the customer payment.
DiscountAmount Decimal Total discount amount applied in customer payment.
ExchangeRate Decimal Exchange rate of the currency.
IsClientReviewSettingsEnabled Boolean Check if the client review settings is enabled or not.
IsPaymentDetailsRequired Boolean Check if the payment details is required.
IsPreGst Boolean Check if pre GST is applied.
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.
PaymentMode String Mode through which payment is made.
PaymentNumber Integer Number through which payment is made.
PaymentNumberPrefix String Prefix of the payment number.
PaymentNumberSuffix String Suffix of the payment number.
ProductDescription String Description of the product.
ReferenceNumber String Reference number of a customer payment.
SettlementStatus String Status of the settlement.
TaxAccountId String

BankAccounts.AccountId

Account ID of tax.
TaxAccountName String Account name of tax.
TaxAmountWithheld Decimal Amount withheld for tax.
TemplateId String ID of a template.
TemplateName String Name of a template.
TemplateType String Type of a template.
UnusedAmount Decimal Unused amount of the customer payment.

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