GL daily conversion rates

GL daily conversion rates

This interface lets you load the rates automatically into General Ledger.

Pre-requisites:

• Currencies
• Conversion rate Types

Interface tables:

• GL_DAILY_RATES_INTERFACE

Base tables:

• GL_DAILY_RATES
• GL_DAILY_CONVERSION_TYPES

Concurrent Program:

You do not need to run any import programs. The insert, update, or deletion of rates in GL_DAILY_RATES is done automatically by database triggers on the GL_DAILY_RATES_INTERFACE. All that is required is to develop program to populate the interface table with daily rates information.

Validations:

• Check if FROM_CURRENCY and TO_CURRENCY are valid.
• Check if USER_CONVERSION_TYPE is valid.

Important Columns:

Some important columns that need to be populated in the interface tables:

GL_DAILY_RATES_INTERFACE:

• FROM_CURRENCY
• TO_CURRENCY
• FROM_CONVERSION_DATE
• TO_CONVERSION_DATE
• USER_CONVERSION_TYPE
• CONVERSION_RATE
• MODE_FLAG (D= Delete, I = Insert, U = Update)
• INVERSE_CONVERSION_RATE
• GL'S INTERFACE TABLES