JournalReport
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.
SELECT * FROM JournalReport SELECT * FROM JournalReport WHERE TransactionDate = 'Today' SELECT * FROM JournalReport WHERE ToDate = '2022-10-31' SELECT * FROM JournalReport WHERE FromDate = '2022-10-10' and ToDate = '2022-10-31' SELECT * FROM JournalReport WHERE CashBased = True
Columns
Name | Type | References | SupportedOperators | Description |
AccountTransactionsAccountId | String | Account Transactions Account Id | ||
AccountTransactionsAccountName | String | Account Transactions Account Name | ||
AccountTransactionsDebitAmount | String | Account Transactions Debit Amount | ||
AccountTransactionsCreditAmount | String | Account Transactions Credit Amount | ||
ContactId | String | Contact Id | ||
ContactName | String | Contact Name | ||
CreditFcyTotal | Integer | CreditFcyTotal | ||
CreditTotal | Integer | CreditTotal | ||
Date | String | Date | ||
DebitFcyTotal | Integer | Debit FcyTotal | ||
DebitTotal | Integer | Debit Total | ||
EntityId | String | Entity Id | ||
TransactionId | String | Transaction Id | ||
TransactionNumber | String | Transaction Number | ||
TransactionType | String | Transaction Type |
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 | Balance Type Total | |
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 |