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

SSIS Components for Zoho Books

AccountTransactionsReport

Table Specific Information

Select

Columns

Pseudo-Columns