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' 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 本製品.
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
使用できる値は次のとおりです。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 |