Power BI Connector for Zoho Books

Build 20.0.7654

Journals

Retrieves list of journals.

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 本製品. By default, response will be showing the journals of current month only

  • 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.
For example:
    SELECT * FROM Journals WHERE Total < 1000 AND Total >= 119

    SELECT * FROM Journals WHERE JournalFilter = 'JournalDate.All'

Columns

Name Type References SupportedOperators Description
JournalId [KEY] String Id of a journal.
JournalType String Type of a journal.
JournalDate Date Date of a journal.
BcyTotal Decimal Total Base Currency
CurrencyId String

Currencies.CurrencyId

Currency ID of the customer's currency.
CustomFields String Custom Fields defined for Journal
EntityType String Entity type of a journal.
EntryNumber String Entry number of the journal.
Notes String Notes of the journal.
ReferenceNumber String Reference number of the journal.
Status String Status of the journal
Total Decimal =,<,<=,>,>= Total of journals. Search by journal total. This field will be populated with a value only when the Journal Id is specified.
JournalNumberPrefix String Prefix for journal number. This field will be populated with a value only when the Journal Id is specified.
JournalNumberSuffix String Suffix for journal number. This field will be populated with a value only when the Journal Id is specified.
CreatedTime Datetime Time at which the journal was created. This field will be populated with a value only when the Journal Id is specified.
CurrencyCode String Currency code of the customer's currency. This field will be populated with a value only when the Journal Id is specified.
CurrencySymbol String Currency symbol of the customer's currency. This field will be populated with a value only when the Journal Id is specified.
ExchangeRate Decimal Exchange rate of the currency. This field will be populated with a value only when the Journal Id is specified.
LastModifiedTime Datetime Last Modified Time of a journal. This field will be populated with a value only when the Journal Id is specified.
LineItemTotal Decimal 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 The precision for the price This field will be populated with a value only when the Journal Id is specified.
ProjectId String

Projects.ProjectId

ID of a project. This field will be populated with a value only when the Journal Id is specified.
ProjectName String Name of a project. This field will be populated with a value only when the Journal Id is specified.

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654