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.
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 |