GL_DAILY_RATES_GT
Global Temporary table to process cross rate.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
GL_DAILY_RATES_GT_PK |
FROM_CURRENCY, TO_CURRENCY, CONVERSION_DATE, CONVERSION_TYPE, MODE_FLAG |
Columns
| Name |
|---|
|
FROM_CURRENCYVARCHAR215YesOracle internal use only TO_CURRENCYVARCHAR215YesOracle internal use only CONVERSION_DATEDATEYesOracle internal use only CONVERSION_TYPEVARCHAR230YesOracle internal use only CONVERSION_RATENUMBERYesOracle internal use only INVERSE_CONVERSION_RATENUMBEROracle internal use only MODE_FLAGVARCHAR21YesOracle internal use only USED_FOR_AB_TRANSLATIONVARCHAR21User for internal processing only |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_DAILY_RATES_GT_U1 | Unique | FROM_CURRENCY, TO_CURRENCY, CONVERSION_DATE, CONVERSION_TYPE, MODE_FLAG |