Cmdlets for Zoho Books

Build 22.0.8479

AccountTransactionsReport

Generated schema file.

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

  • TransactionDate supports the '=' comparison.
  • ToDate supports the '=' comparison.
  • FromDate supports the '=' comparison.
  • CashBased supports the '=' comparison.
  • AccountTrasactionsTransactionType supports the 'IN', 'NOT IN' comparison.
  • AccountTrasactionsAccountId supports the 'IN' comparison.
  • AccountTrasactionsContactId supports the 'IN', 'NOT IN' comparison.
  • AccountTrasactionsProjectIds supports the 'IN', 'IS NULL', 'IS NOT NULL' comparison.
  • AccountTrasactionsAccountAccountType supports the '=', '!=' comparison.
  • AccountTrasactionsAccountAccountGroup supports the '=', '!=' comparison.
For example:
    SELECT * FROM accounttransactionsreport

    SELECT * FROM accounttransactionsreport WHERE TransactionDate = 'Today'

    SELECT * FROM accounttransactionsreport WHERE ToDate = '2022-10-31'

    SELECT * FROM accounttransactionsreport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31'

    SELECT * FROM accounttransactionsreport WHERE CashBased = True
	
    SELECT * FROM accounttransactionsreport WHERE AccountTrasactionsTransactionType NOT IN ('Invoices','Bills')
	
    SELECT * FROM accounttransactionsreport WHERE AccountTrasactionsAccountId IN ('3285934000000000373')
	
    SELECT * FROM accounttransactionsreport WHERE AccountTrasactionsProjectIds IS NULL
	
    SELECT * FROM accounttransactionsreport WHERE AccountTrasactionsAccountAccountType = 'Asset'
	
    SELECT * FROM accounttransactionsreport WHERE AccountTrasactionsAccountAccountGroup != 'Liability'

Columns

Name Type References SupportedOperators Description
AccountTrasactionsAccountAccountCode String Account Trasactions Account Account Code
AccountTrasactionsAccountName String Account Trasactions Account Name
AccountTrasactionsContactName String Account Trasactions Contact Name
AccountTrasactionsDescription String Account Trasactions Description
AccountTrasactionsCredit Double Account Trasactions Credit
AccountTrasactionsCurrencyCode String Account Trasactions Currency Code
AccountTransactionsDate Date Account Transaction sDate
AccountTrasactionsDebit Decimal Account Trasactions Debit
AccountTrasactionsEntityNumber String Account Trasactions Entity Number
AccountTrasactionsNetAmount String Account Trasactions Net Amount
AccountTrasactionsOffsetAccountId String Account Trasactions Offset Account Id
AccountTrasactionsOffsetAccountType String Account Trasactions Offset Account Type
AccountTrasactionsReferenceNumber String Account Trasactions Reference Number
AccountTrasactionsReferenceTransactionId String Account Trasactions Reference Transaction Id
AccountTrasactionsReportingTag String Account Trasactions Reporting Tag
AccountTrasactionsTransactionDetails String Account Trasactions Transaction Details
AccountTrasactionsTransactionId String Account Trasactions Transaction Id
AccountTrasactionsFCYCredit String Account Trasactions FCY Credit
AccountTrasactionsFcyDebit String Account Trasactions Fcy Debit
AccountTrasactionsFcyNetAmount String Account Trasactions Fcy Net Amount
OpeningBalanceAccountCreditBalance Integer Opening Balance Account Credit Balance
OpeningBalanceCredit String Opening Balance Credit
OpeningBalanceDate String Opening Balance Date
OpeningBalanceDebit String Opening Balance Debit
OpeningBalanceFCYCredit String Opening Balance FCY Credit
OpeningBalanceFcyDebit String Opening Balance Fcy Debit
OpeningBalanceName String Opening Balance Name
ClosingBalanceCredit String Closing Balance Credit
ClosingBalanceDate String Closing Balance Date
ClosingBalanceDebit String Closing Balance Debit
ClosingBalanceFcyCredit String Closing Balance Fcy Credit
ClosingBalanceFcyDebit String Closing Balance Fcy Debit
ClosingBalanceName String Closing Balance Name
AccountTrasactionsAccountAccountGroup String =, != Account Trasactions Account Account Group

使用できる値は次のとおりです。Asset, OtherAsset, OtherCurrentAsset, Bank, Cash, FixedAsset, Liability, OtherCurrentLiability, CreditCard, LongTermLiablity, OtherLiability, Equity, Income, OtherIncome, Expense, CostOfGoodsSold, OtherExpense, AccountsReceivable, AccountsPayable, Stock, PaymentClearingAccount, PrepaidCard, OverseasTaxPayable, OutputTax, InputTax

AccountTrasactionsAccountAccountType String =, != Account Trasactions AccountAccount Type

使用できる値は次のとおりです。Asset, OtherAsset, OtherCurrentAsset, Bank, Cash, FixedAsset, Liability, OtherCurrentLiability, CreditCard, LongTermLiablity, OtherLiability, Equity, Income, OtherIncome, Expense, CostOfGoodsSold, OtherExpense, AccountsReceivable, AccountsPayable, Stock, PaymentClearingAccount, PrepaidCard, OverseasTaxPayable, OutputTax, InputTax

AccountTrasactionsTransactionType String IN, NOT IN AccountTrasactions Transaction Type

使用できる値は次のとおりです。Invoices, Bills, PaymentsMade, CreditNote, CreditNotesRefund, VendorCredits, VendorCreditsRefund, Expense, Journal, BaseCurrencyAdjustment, DebitNote, CustomerPayment, VendorPayment, PaymentRefund, RetainerPayment, InventoryAdjustmentByQuantity, InventoryAdjustmentByValue, TransferOrderTo, TransferOrderFrom, SalesWithoutInvoices, ExpenseRefund, EmployeeReimbursement

AccountTrasactionsProjectIds String IN, IS NULL, IS NOT NULL Account Trasactions Project Ids
AccountTrasactionsContactId String IN, NOT IN Account Trasactions Contact Id
AccountTrasactionsAccountId String IN Account Trasactions Account Id

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
CashBased Boolean Cash Based
TransactionDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate

ToDate Date To Date
FromDate Date From Date

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479