| Internal ID |
Type |
nlapiSubmitField |
Label |
Required |
Help |
| basecurrency |
select |
false |
Base Currency |
true |
Select the base currency on which this exchange rate is based.
If you use subsidiary management and consolidation, you can select the base currency for any subsidiary to which you have access. If you do not use subsidiary management and consolidation, your base currency is shown here. |
| currencyratetype |
select |
false |
Exchange Rate Type |
true |
This field appears only when the Currency Exchange Rate Types feature is enabled. The default value is correct unless you are entering exchange rates for a different currency exchange rate type.
For information about the feature, see Currency Exchange Rate Types. |
| effectivedate |
date |
false |
Effective Date |
false |
Set the date this exchange rate becomes effective in the Effective Date field. |
| exchangerate |
currency2 |
false |
Exchange Rate |
false |
Enter an exchange rate for this currency against the base currency of this company, or if you use OneWorld, for this currency against the base currency of the root parent subsidiary.
The exchange rate is equal to the base currency amount divided by the foreign currency amount.
For example, if your company is located in Canada (base currency) and you are defining the U.S. dollar (foreign currency), and the current exchange rate is 1.02 Canadian dollars to 1.00 U.S. dollar, the Default Exchange Rate for the U.S. dollar is 1.02/1.00, or 1.02.
This rate is the basis for rates in the Currency Exchange Rates table that are used in foreign currency transactions. If you use OneWorld, this rate also is the basis for rates in the Consolidated Exchange Rates table that are used in consolidated financials. For more information, see the help topic Currency Exchange Rates. |
| externalid |
text |
false |
External ID |
false |
|
| fxsourcemethod |
text |
false |
Method |
false |
|
| lastmodifieddate |
datetime |
false |
Last Modified Date |
false |
|
| transactioncurrency |
select |
false |
Currency |
true |
Select a foreign currency in the Currency field.
For example, if you are setting the exchange rate for the Euro to your base currency, the U.S. dollar, select the name of your base currency, USA in the Base Currency field and then select Euro in the Currency field. |