ALEX_FX_RATE (Staging table)

Column name Data type Required Default updateable Data target Comments
CURRENCY_EKEY** VARCHAR (255) Yes* No ALCO_FX_RATE.CURRENCY_FMT_DEFN_ID Currency external key
VALID_DATE** DATETIME Yes* No ALCO_FX_RATE.VALID_DATE Date when the exchange rate is valid
FX_RATE NUMERIC (20, 10) Yes* Yes ALCO_FX_RATE.FX_RATE The exchange rate by which the amount in this currency must be multiplied to convert to the base currency.

FX_SOURCE

_EKEY

VARCHAR(255) No Yes

ALCO_FX_RATE.

FX_RATE_SOURCE_ID

The ekey of the fx rate source this exchange rate belongs to.

If null, the FX rate business process will use the system rate

source so that alco_fx_rate.fx_rate_source_id will always be

set

*System required field

** Combination of (currency_ekey, valid_date) must be unique.