Power BI Connector for Zoho Inventory

Build 24.0.9062

Currencies

Read, Insert, Update and Delete Currencies.

Table Specific Information

Select

The 本製品 will use the Zoho Inventory API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.

  • Id supports the '=' comparison.

For example, the following queries are processed server side:

SELECT * FROM Currencies WHERE Id = '3350895000000089001'

Insert

Insert can be executed by specifying the CurrencyCode, CurrencySymbol and CurrencyFormat column. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO Currencies (CurrencyCode, CurrencySymbol, CurrencyFormat) VALUES ('ALL', 'Af', '1,234,567.89')

Update

Update can be executed by specifying the Id in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE Currencies SET CurrencyFormat = '1,234,567.89', CurrencySymbol = 'Af' WHERE Id = '3285934000000127023'

Delete

Delete can be executed by specifying the Id in the WHERE Clause For example:

DELETE FROM Currencies WHERE Id = '3350895000000089001'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

A unique ID for the currency.

CurrencyCode String False

A unique code for the currency.

CurrencyFormat String False

The format for the currency to be displayed.

CurrencyName String True

The name for the currency.

CurrencySymbol String False

A unique symbol for the currency

EffectiveDate Date True

Effective date

ExchangeRate Integer True

Exchange rate

IsBaseCurrency Boolean True

If the specified currency is the base currency of the organization or not.

PricePrecision Integer False

The precision for the price in decimals

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CurrencyFilter String

Filter currencies excluding base currency.

使用できる値は次のとおりです。Currencies.ExcludeBaseCurrency

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062