CST_CURR_CONV_RATES_GT
Global temporary table to hold conversion rates for currency conversion.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
Columns
Name |
---|
FROM_CURRENCY_CODEVARCHAR230YesIdentifies the original currency, or the currency of the transaction. TO_CURRENCY_CODEVARCHAR230YesIdentifies the target, or default currency code as specified by the ledger. CURRENCY_CONVERSION_DATEDATEYesThe date to be used to determine the exchange rates for currency conversion. CURRENCY_CONVERSION_TYPEVARCHAR230YesConversion type that should be used for currency conversion. CURRENCY_CONVERSION_RATENUMBEROptional user specified currency conversion rate. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_CURR_CONV_RATES_GT_U1 | Unique | FROM_CURRENCY_CODE, TO_CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE |