Query about loading data into GL_INTERFACE table and Currencies
Hi,
We're using R12.1.3.
We are at the initial stages of looking to create a staging table into which to enter data that will ultimately be loaded into the GL_INTERFACE table via a custom concurrent program.
If we enter Journal Lines into the GL_INTERFACE table for GBP, that's not a problem.
If we enter Journal Lines with a foreign Currency, e.g. USD or EUR - do we need to populate these columns:
- CURRENCY_CONVERSION_DATE
- USER_CURRENCY_CONVERSION_TYPE
- CURRENCY_CONVERSION_RATE
Or is it okay to leave those empty, and assume that as long as the Exchange Rates are defined for the relevant Dates and Currencies in GL, that the system would take care of the conversions?