Assigning Values for Currency Conversion
You can enter values for your actual foreign currency data in one of two ways. You can specify the entered amount along with a conversion rate type and date and let your General Ledger application calculate the converted amount for you. Or, you can directly specify the entered and converted amounts and not specify the conversion rate, type and date.
Do not enter values in the following columns for encumbrance and budget foreign currency data. Enter values for your actual foreign currency data only in the following columns of the GL_INTERFACE table:
System-Calculated Conversion
USER_CURRENCY_CONVERSION_TYPE: Enter a currency conversion type for your actual foreign currency transactions. Acceptable values are User, Spot, Corporate, or any other type you define in the Conversion Rate Types form. If you enter a rate type of User, then you must also enter a conversion rate in the CURRENCY_CONVERSION_ RATE column. For all other conversion types you must enter a conversion date in the CURRENCY_ CONVERSION_DATE column.
You can find a list of valid values in the USER_CURRENCY_CONVERSION_TYPE column of the Conversion Types table (GL_DAILY_ CONVERSION_TYPES.USER_CURRENCY_ CONVERSION_TYPE).
CURRENCY_CONVERSION_DATE: Enter a currency conversion date for your actual foreign currency transactions. If you enter a conversion type other than User in the USER_CURRENCY_CONVERSION_TYPE column, you must enter a value in this column. If your conversion type is User, the default value for this column is the accounting date.
CURRENCY_CONVERSION_RATE: Enter a currency conversion rate for your actual foreign currency transactions. If you enter a conversion type of User in the USER_CURRENCY_ CONVERSION_TYPE column, you must enter a value in this column. If you enter a conversion type other than USER, do not enter anything in this column.
User-Entered Conversion
ACCOUNTED_CR: Enter a converted credit amount for your actual foreign currency transactions. Enter a value for the ACCOUNTED_DR or the ACCOUNTED_CR column in a given row, but not both values in one row. You must enter a value for ENTERED_CR if you entered a value for ACCOUNTED_CR.
See Also
Understanding the GL_INTERFACE Table
Assigning Values for Accounts
Assigning Values for Additional and Conditionally Required Columns
Assigning Values to Optional Columns
Required NULL Columns in the GL_INTERFACE Table
Importing Specialized Data
About Journal Import Validation