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.