ForexInput

Name	Data Type	Export
base	NOT_SET	—
enddate	DATE	—
future	NOT_SET	—
past	NOT_SET	—
rate	NOT_SET	—
startdate	DATE	—
symbol	NOT_SET	—

Name

Data Type

Export

Import

base

NOT_SET

—

Check mark

enddate

DATE

—

Check mark

future

NOT_SET

—

Check mark

past

NOT_SET

—

Check mark

rate

NOT_SET

—

Check mark

startdate

DATE

—

Check mark

symbol

NOT_SET

—

Check mark

Guidelines

The base currency must be one of the user-defined reporting currencies. It is not possible to set historical foreign currency exchange rates if the base currency is one of the currencies supported by OpenAir as standard. If one record in the import CSV file includes a system-supported currency as the base currency, the Integration Manager log shows "OA type ForexInput failed to import. Error Code: 837; Error Description: Not a valid account currency, You can only specify a currency currently enabled for the account. API Error: Invalid base currency specified. It must be one of user-defined currencies."

For more information about user-defined reporting currencies, see User-Defined Reporting Currencies.