Power BI Connector for Zoho Books

Build 20.0.7654

CustomerPayments

Retrieves list of all the payments made by your customer.

Table Specific Information

Select

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

  • PaymentMode supports the '=' comparison.
  • Amount supports the '=,<,<=,>,>=' comparisons.
  • CustomerName supports the '=' comparison.
  • Date supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • PaymentModeFilter supports the '=' comparison.
  • Notes supports the '=' comparison.
For example:
    SELECT * FROM CustomerPayments WHERE Amount < 900 AND Amount > 50 AND ReferenceNumber = '1894553000000079879'

    SELECT * FROM CustomerPayments WHERE CustomerName = 'Harry'

    SELECT * FROM CustomerPayments WHERE CONTAINS(ReferenceNumber,'455')

Columns

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

BankAccounts.AccountId

ID of the Bank Account.
PaymentMode String Mode through which payment is made.
PaymentNumber Integer Number through which payment is made.
PaymentType String Type of the payment.
AccountName String Name of the account.
Amount Decimal =,<,<=,>,>= Amount of the customer payments.
BcyAmount Decimal Amount applied for Base Currency.
BcyRefundedAmount Decimal Refunded amount from Base Currency.
BcyUnusedAmount Decimal Unused amount from Base Currency.
CreatedTime Datetime Time at which the customer payment was created.
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.
GatewayTransactionId String ID of gateway transaction.
HasAttachment Boolean Check if the customer payment has an attachment.
LastModifiedTime Datetime The time of last modification of the customer payment.
ReferenceNumber String Reference number of a customer payment.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
PaymentModeFilter String Filter customer payments by payment mode.

使用できる値は次のとおりです。PaymentMode.All, PaymentMode.Check, PaymentMode.Cash, PaymentMode.BankTransfer, PaymentMode.Paypal, PaymentMode.CreditCard, PaymentMode.GoogleCheckout, PaymentMode.Credit, PaymentMode.Authorizenet, PaymentMode.BankRemittance, PaymentMode.Payflowpro, PaymentMode.Stripe, PaymentMode.TwoCheckout, PaymentMode.Braintree, PaymentMode.Others

Notes String Notes of customer payments.

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