AccountTransactionsReport

Generated schema file.

Table Specific Information

Select

The 本製品 uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:

TransactionDate supports the '=' comparison.
ToDate supports the '=' comparison.
FromDate supports the '=' comparison.
CashBased supports the '=' comparison.
AccountTransactionsTransactionType supports the 'IN', 'NOT IN' comparisons.
AccountTransactionsAccountId supports the 'IN' comparison.
AccountTransactionsContactId supports the 'IN', 'NOT IN' comparisons.
AccountTransactionsProjectIds supports the 'IN', 'IS NULL', 'IS NOT NULL' comparisons.
AccountTransactionsAccountAccountType supports the '=', '!=' comparisons.
AccountTransactionsAccountAccountGroup supports the '=', '!=' comparisons.

The rest of the filter is executed client-side in the 本製品.

For example:

    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 AccountTransactionsTransactionType NOT IN ('Invoices', 'Bills')
	
    SELECT * FROM accounttransactionsreport WHERE AccountTransactionsAccountId IN ('3285934000000000373')
	
    SELECT * FROM accounttransactionsreport WHERE AccountTransactionsProjectIds IS NULL
	
    SELECT * FROM accounttransactionsreport WHERE AccountTransactionsAccountAccountType = 'Asset'
	
    SELECT * FROM accounttransactionsreport WHERE AccountTransactionsAccountAccountGroup != 'Liability'

Columns


Name	Type	References	SupportedOperators	Description
AccountTransactionsAccountAccountCode	String			Account Transactions Account Account Code
AccountTransactionsAccountName	String			Account Transactions Account Name
AccountTransactionsContactName	String			Account Transactions Contact Name
AccountTransactionsDescription	String			Account Transactions Description
AccountTransactionsCredit	Double			Account Transactions Credit
AccountTransactionsCurrencyCode	String			Account Transactions Currency Code
AccountTransactionsDate	Date			Account Transaction sDate
AccountTransactionsDebit	Decimal			Account Transactions Debit
AccountTransactionsEntityNumber	String			Account Transactions Entity Number
AccountTransactionsNetAmount	String			Account Transactions Net Amount
AccountTransactionsOffsetAccountId	String			Account Transactions Offset Account Id
AccountTransactionsOffsetAccountType	String			Account Transactions Offset Account Type
AccountTransactionsReferenceNumber	String			Account Transactions Reference Number
AccountTransactionsReferenceTransactionId	String			Account Transactions Reference transaction Id
AccountTransactionsReportingTag	String			Account Transactions Reporting Tag
AccountTransactionsTransactionDetails	String			Account Transactions Transaction Details
AccountTransactionsTransactionId	String			Account Transactions Transaction Id
AccountTransactionsFCYCredit	String			Account Transactions FCY Credit
AccountTransactionsFcyDebit	String			Account Transactions Fcy Debit
AccountTransactionsFcyNetAmount	String			Account Transactions 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
AccountTransactionsAccountAccountGroup	String		=, !=	Account Transactions 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
AccountTransactionsAccountAccountType	String		=, !=	Account Transactions 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
AccountTransactionsTransactionType	String		IN, NOT IN	AccountTransactions transaction Type 使用できる値は次のとおりです。Invoices, Bills, PaymentsMade, CreditNote, CreditNotesRefund, VendorCredits, VendorCreditsRefund, Expense, Journal, BaseCurrencyAdjustment, DebitNote, CustomerPayment, VendorPayment, PaymentRefund, RetainerPayment, InventoryAdjustmentByQuantity, InventoryAdjustmentByValue, TransferOrderTo, TransferOrderFrom, SalesWithoutInvoices, ExpenseRefund, EmployeeReimbursement
AccountTransactionsProjectIds	String		IN, IS NULL, IS NOT NULL	Account Transactions Project Ids
AccountTransactionsContactId	String		IN, NOT IN	Account Transactions Contact Id
AccountTransactionsAccountId	String		IN	Account Transactions 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, CustomDate
ToDate	Date		To Date
FromDate	Date		From Date

JDBC Driver for Zoho Books

AccountTransactionsReport

Table Specific Information

Select

Columns

Pseudo-Columns