Journals
To list, add, update and delete journals.
Table Specific Information
Select
The connector uses the Zoho Books API to process WHERE clause conditions built with the following columns and operators:
- EntryNumber supports the '=' comparison.
- Notes supports the '=' comparison.
- ReferenceNumber supports the '=' comparison.
- Total supports the '=,<,<=,>,>=' comparisons.
- Date supports the '=,<,>' comparisons.
- VendorId supports the '=' comparison.
- JournalFilter supports the '=' comparison.
- CustomerId supports the '=' comparison.
- LastModifiedTime supports the '=' comparison.
By default, the response shows the journals of the current month only.
The rest of the filter is executed client-side in the connector.
For example:
SELECT * FROM Journals WHERE Total < 1000 AND Total >= 119
SELECT * FROM Journals WHERE JournalFilter = 'JournalDate.All'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Description |
| JournalId [KEY] | String | True |
Id of a journal. | ||
| JournalType | String | False |
Type of a journal. | ||
| JournalDate | Date | False |
Date of a journal. | ||
| BcyTotal | Decimal | True |
Total Base Currency | ||
| CurrencyId | String | False |
Currencies.CurrencyId |
Currency Id of the customer's currency. | |
| CustomFields | String | False |
Custom Fields defined for Journal | ||
| EntityType | String | True |
Entity type of a journal. | ||
| EntryNumber | String | True |
Entry number of the journal. | ||
| IncludeInVatReturn | String | False |
VAT treatment for the estimates. | ||
| IsBasAdjustment | Boolean | False |
Check if Journal is created for BAS Adjustment. | ||
| Notes | String | False |
Notes of the journal. | ||
| ReferenceNumber | String | False |
Reference number of the journal. | ||
| Status | String | False |
Status of the journal | ||
| Total | Decimal | True | =,<,<=,>,>= |
Total of journals. Search by journal total. This field will be populated with a value only when the Journal Id is specified. | |
| JournalNumberPrefix | String | True |
Prefix for journal number. This field will be populated with a value only when the Journal Id is specified. | ||
| JournalNumberSuffix | String | True |
Suffix for journal number. This field will be populated with a value only when the Journal Id is specified. | ||
| CreatedTime | Datetime | True |
Time at which the journal was created. This field will be populated with a value only when the Journal Id is specified. | ||
| CurrencyCode | String | True |
Currency code of the customer's currency. This field will be populated with a value only when the Journal Id is specified. | ||
| CurrencySymbol | String | True |
Currency symbol of the customer's currency. This field will be populated with a value only when the Journal Id is specified. | ||
| ExchangeRate | Decimal | True |
Exchange rate of the currency. This field will be populated with a value only when the Journal Id is specified. | ||
| LastModifiedTime | Datetime | True |
Last Modified Time of a journal. This field will be populated with a value only when the Journal Id is specified. | ||
| LineItemTotal | Decimal | True |
Total number of line items included in a journal. This field will be populated with a value only when the Journal Id is specified. | ||
| PricePrecision | Integer | True |
The precision for the price This field will be populated with a value only when the Journal Id is specified. | ||
| ProjectId | String | True |
Projects.ProjectId |
Id of a project. This field will be populated with a value only when the Journal Id is specified. | |
| ProjectName | String | True |
Name of a project. This field will be populated with a value only when the Journal Id is specified. | ||
| ProductType | String | False |
Type of the journal. This denotes whether the journal is to be treated as goods or service. | ||
| VatTreatment | String | False |
VAT treatment for the estimates. | ||
| LineItems | String | False |
Line items of an estimate. | ||
| TaxExemptionCode | String | False |
Code of a tax exemption. | ||
| TaxExemptionType | String | False |
Type of the Tax Exemption. | ||
| CreatedById | String | True |
ID of the user who created the journal. | ||
| CreatedByName | String | True |
Name of the user who created the journal. | ||
| AvailablePayablesCredits | Decimal | True |
Available credits for payables in the journal. | ||
| AvailableReceivablesCredits | Decimal | True |
Available credits for receivables in the journal. | ||
| BillsCredited | String | True |
List of bills credited in this journal. | ||
| BranchDifference | String | True |
Branch differences in the journal entries. | ||
| Comments | String | True |
Comments on the journal. | ||
| Documents | String | True |
Documents attached to the journal. | ||
| ImportedTransactions | String | True |
List of imported transactions in the journal. | ||
| InvoicesCredited | String | True |
List of invoices credited in this journal. | ||
| IsAccrualJournal | Boolean | True |
Indicates whether this is an accrual journal. | ||
| JournalTemplateName | String | True |
Name of the template used for this journal. | ||
| Taxes | String | True |
Tax details for the journal entries. |
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 |
| Date | Date |
Date of a journal. |
| VendorId | String |
Vendor Id of a journal. |
| JournalFilter | String |
Filter journals by journal date. 使用できる値は次のとおりです。JournalDate.All, JournalDate.Today, JournalDate.ThisWeek, JournalDate.ThisMonth, JournalDate.ThisQuarter, JournalDate.ThisYear |
| CustomerId | String |
Id of a customer |