CST_CURR_CONV_RATES_GT

Global temporary table to hold conversion rates for currency conversion.

Details

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.

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.

Index	Uniqueness	Columns
CST_CURR_CONV_RATES_GT_U1	Unique	FROM_CURRENCY_CODE, TO_CURRENCY_CODE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_TYPE