CData Python Connector for Zoho Books

Build 20.0.7740

BankTransactions

Get all the transaction details involved in an account.

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

  • AccountId supports the '=' comparison.
  • TransactionType supports the '=' comparison.
  • Amount supports the '=' comparison.
  • Date supports the '=' comparison.
  • ReferenceNumber supports the '=' comparison.
  • Status supports the '=' comparison.
  • BankTransactionFilter supports the '=' comparison.
For example:
    SELECT * FROM BankTransactions WHERE Status = 'All'

    SELECT * FROM BankTransactions LIMIT 5

Columns

Name Type References SupportedOperators Description
TransactionId [KEY] String Id of the Transaction.
TransactionType String Transaction Type of the transaction.

使用できる値は次のとおりです。deposit, refund, transfer_fund, card_payment, sales_without_invoices, expense_refund, owner_contribution, interest_income, other_income, owner_drawings, sales_return

AccountId String

BankAccounts.AccountId

Account id for which transactions are to be listed.
AccountName String Name of the account.
AccountType String Type of the account.
Amount Decimal Start and end amount, to provide a range within which the transaction amount exist.
CurrencyCode String Currency code of the customer's currency.
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CurrencySymbol String Currency symbol of the customer's currency.
CustomerId String

Contacts.ContactId

ID of the customer or vendor.
Date Date Start and end date, to provide a range within which the transaction date exist.
DebitOrCredit String Indicates if transaction is Credit or Debit.
Description String Description of the bank transactions.
ExcludeDescription String Is the description is to be excluded.
ImportedTransactionId Long ID of the Imported Transaction.
IsOffsetaccountMatched Boolean Check if Offset Account is matched.
IsPaidViaPrintCheck Boolean Check if paid via print check.
IsRuleExist Boolean Check if rule exists.
OffsetAccountName String Name of the offset account.
Payee String Information about the payee.
PricePrecision Integer The precision for the price.
ReferenceNumber String Reference Number of the transaction.
RunningBalance String Running balance in bank.
Source String Source of the bank transaction.
Status String Transaction status wise list view.

使用できる値は次のとおりです。All, uncategorized, manually_added, matched, excluded, categorized

VendorId String ID of the vendor the bank transaction has been made. This field will be populated with a value only when the Transaction Id is specified.
VendorName String Name of the vendor the bank transaction has been made. This field will be populated with a value only when the Transaction Id is specified.
BankCharges Decimal Bank charges of bank transactions. This field will be populated with a value only when the Transaction Id is specified.
BcyTotal Decimal Total Base Currency This field will be populated with a value only when the Transaction Id is specified.
CustomerName String Name of the customer or vendor. This field will be populated with a value only when the Transaction Id is specified.
ExchangeRate Decimal Exchange rate of a bank transaction. This field will be populated with a value only when the Transaction Id is specified.
FromAccountId String

BankAccounts.AccountId

Account Id from which bank transaction was made. This field will be populated with a value only when the Transaction Id is specified.
FromAccountName String Account name from which bank transaction was made. This field will be populated with a value only when the Transaction Id is specified.
ImportedTransactions String Imported bank transations. This field will be populated with a value only when the Transaction Id is specified.
IsInclusiveTax Boolean Check if bank transaction is invlusive tax. This field will be populated with a value only when the Transaction Id is specified.
IsPreGst Boolean Check if bank transaction is pre GST. This field will be populated with a value only when the Transaction Id is specified.
PaymentMode String Mode through which payment is made. This field will be populated with a value only when the Transaction Id is specified.
SubTotal Decimal Sub total of bank transactions This field will be populated with a value only when the Transaction Id is specified.
Tags String Details of tags related to bank transactions. This field will be populated with a value only when the Transaction Id is specified.
TaxAmount Decimal Amount of tax. This field will be populated with a value only when the Transaction Id is specified.
TaxId String

Taxes.TaxId

Id of tax. This field will be populated with a value only when the Transaction Id is specified.
TaxName String Name of tax. This field will be populated with a value only when the Transaction Id is specified.
TaxPercentage Integer Percentage of tax. This field will be populated with a value only when the Transaction Id is specified.
ToAccountId String

BankAccounts.AccountId

Account ID the transaction was made to. This field will be populated with a value only when the Transaction Id is specified.
ToAccountName String Account name the transaction was made to. This field will be populated with a value only when the Transaction Id is specified.
Total Decimal Total of bank transactions. This field will be populated with a value only when the Transaction Id is specified.

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
BankTransactionFilter String Filters the transactions based on the allowed types.

使用できる値は次のとおりです。Status.All, Status.Uncategorized, Status.Categorized, Status.ManuallyAdded, Status.Excluded, Status.Matched

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740