AccountTransactionsReport
Generated schema file.
Table Specific Information
Select
The component 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' comparison.
- AccountTransactionsAccountId supports the 'IN' comparison.
- AccountTransactionsContactId supports the 'IN', 'NOT IN' comparison.
- AccountTransactionsProjectIds supports the 'IN', 'IS NULL', 'IS NOT NULL' comparison.
- AccountTransactionsAccountAccountType supports the '=', '!=' comparison.
- AccountTransactionsAccountAccountGroup supports the '=', '!=' comparison.
The rest of the filter is executed client-side in the component.
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 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 |
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
The allowed values are 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
The allowed values are 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
The allowed values are 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.
The allowed values are Today, ThisWeek, ThisMonth, ThisQuarter, ThisYear, PreviousDay, PreviousWeek, PreviousMonth, PreviousQuarter, PreviousYear and CustomDate. | |
ToDate | Date | To Date | |
FromDate | Date | From Date |