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 |